Problem 6.
The operations manager for a large law office must choose between two different
copiers to lease. A regular copier, which costs $8 per hour to lease, can complete a
copying job in 6 minutes, on average. On average, a high-speed copier, which leases
for $16 per hour, can complete a copying job in 3 minutes. In a workday of 8 hours,
56 copying jobs can be expected. The time of the employees tasked with copying is
valued at $10 per hour.
NOTE: In part 35 you MUST provide a copy of your Excel calculations for
problem D to receive credit for this problem. You are also reminded to
submit all of your computer files for this problem with your completed
exam to the “Final Exam” link on Bb. Failure to provide either of these
deliverables will result in this problem NOT being scored.
29. For a regular copier, in new lines entered below this part, state the number of
employees that can be expected to be at the copier, both waiting on the line and
using the machine.
30. On an hourly basis, in new lines entered below this part, state the total cost
of the regular copier.
31. For a high-speed copier, in new lines entered below this part, state the total
number employees that can be expected to be at the copier, both those waiting on
the line and those using the machine.
32. On an hourly basis, in new lines entered below this part, state the total cost
of the high-speed copier.
33. a. On the basis of total hourly cost, in new lines entered below this part,
state which copier, the regular model or the high-speed model, should be
selected by the operations manager chose. Explain why.
b. For the copier selected in the above part, in new lines entered below
this part, state the amount of that is saved in an 8-hour workday.
34. a. In new lines entered below this part, state what had to be assumed to
calculate how long the copying jobs take.
b. In new lines entered below this part, state what had to be assumed to
calculate how many employees need to use a copier at any given time.
35. In a space created below this part, you must present HERE a copy of your
Excel spreadsheet for problem D.
Problem 7.
The Pioneer Software Company has developed software for organizing and playing
music on a computer. The software contains a number of unique features that have
been patented so the company’s future has looked bright.
However, it appears that a number of the patented features were copied in similar
software developed by the Raider Digital Company, a huge software company with
annual sales revenue in excess of $1 billion. The executives of Pioneer Software are
distressed that Raider Digital has stolen their ideas; they fear that Raider’s marketing
power is likely to enable it to capture the market and drive Pioneer out of business.
In response, Pioneer has filed a lawsuit against Raider for patent infringement.
With attorney fees and other expenses, the cost of going to trial (win or lose) is
expected to be $1 million. Pioneer feels that it has a 60% chance of winning the case,
in which case it would receive $5 million in damages. If Pioneer loses the case, it gets
nothing. Moreover, if Pioneer loses the case, there is a 50% chance that the judge
would also order Pioneer to pay for court expenses and lawyer fees for Raider (an
additional $1 million cost).
Raider has countered by offering Pioneer $1.5 million to settle this case out of
court.
Using decision tree analysis, determine in the steps below what Pioneer Software
Company should do.
NOTE: In parts 36 and 38 you MUST provide a copies of decision tree and
of your Excel calculations, respectively, for problem E to be graded. You are
also reminded to submit all of your computer files for this problem with
your completed exam to the “Final Exam” link on Bb. Failure to provide
any of these deliverables will result in this problem NOT being graded.
36. Draw the decision tree for this problem and annotate it with the expected
monetary values where appropriate.
In a space created below this part, you must present HERE a copy of your
fully-annotated decision tree.
37. a. In new lines entered below this part, state the decision that the Pioneer
Software Company should make.
b. In new lines entered below this part, briefly state the criterion that was
used to arrive at this decision.
38. In a space created below this part, you must present HERE a copy of your
Excel calculations for problem E.
· AND submit all of your computer files for this problem with your
completed exam to the “Final Exam” link on Bb. Include in the filename/tab
name “Prob E.”
Problem 12
XYX Manufacturing produces high-end aircraft parts. Their Landing Gear Shop has
four machines to make precision airfoil parts: a metal lathe, a turning machine, a
milling machine, and a radial drill. This shop has six machine machinists, most of
them are certified to work on all the machines and have demonstrated that they
perform better on some machines than on others. The Landing Gear has been tasked
with a big job that requires all four machines. The times required by the machinists to
perform the required work on each machine is given in the table below.

Note that Machinist 3 has not yet been certified on the turning machine. As a result,
the shop manager will not assign this machinist to that machine.
The shop scheduler needs to schedule a machinist to each machine to produce parts in
the least total time.
NOTE: In part 43 you MUST provide your Excel file or Lingo input and
output files for problem F to receive credit for this problem. You are also
reminded to submit all of your computer files for this problem with your
completed exam to the “Final Exam” link on Bb. Failure to provide any of
these deliverables will result in this problem NOT being scored.
39.In new lines entered below, formulate and state the full and complete
mathematical representation of this situation; include specific definitions of all the
model variables.
40.In lines entered below, (1) state the specific class of problem this is and (2)
state the specific type of problem this is within that class. Include an explanation
of why.
41.In new lines entered below, state the optimal assignment of a machinist to
each machine.
42.In new lines entered below, state the combined time in minutes expected to
produce a part using all four machines with the assigned operators.
43.In a space created below this part, you must present HERE a copy of your
computer input and output screens for problem F.
AND submit all of your computer files for this problem with your completed exam