(a) What is the optimal allocation of production? What is the average cost/toaster of production.

(b) By how much can the cost of robots increase before we will change that production plan.

(c) How much is Red Dwarf willing to pay for more assembly room time? How many units is Red Dwarf willing to purchase at that price?

(d) How much will we save if we decide to produce only 950 toasters?

(e) A new production process is available that uses only 2 minutes of skilled labor, 10 minutes of unskilled labor, and an undetermined amount of assembly floor time. Its production cost is determined to be $10. What is the maximum assembly floor time that the process can take before it is deemed too expensive to use?

Answer:

(a)
*633.3 should be produced manually, 333.3 should be produced
semiautomatically, and 33.3 produced robotically, for an average cost
of $7.383/toaster.
*

(b)
*It can increase by $0.50.*

(c)
*Value is $0.16/minute, willing to purchase 500 at that price.*

(d)
*Objective will go down by 50(10.833).*

(e)
*Cost of $10 versus marginal cost of $10.833, leave 0.83.
Unskilled labor costs $0.0833/unit. Therefore, if the new process
takes any time at all, it will be deemed too expensive.
*

- Only 10 acres of land is suitable for shops.
- Zoning regulations require at least 1000 trees in the park. A food acre has 30 trees; a ride acre has 20 trees; while a shop acre has no trees.
- No more than 200 people can work in the park. It takes 3 people to work an acre of rides, 6 to work an acre of food, and 5 to work an acre of shops.

The resulting linear program and Solver output is attached:

MAX 150 RIDE + 200 FOOD + 300 SHOP SUBJECT TO RIDE + FOOD + SHOP <= 50 SHOP <= 10 20 RIDE + 30 FOOD >= 1000 3 RIDE + 6 FOOD + 5 SHOP <= 200 ------------------------------------------------------------------- Answer report: Target Cell (Max) Cell Name Original Value Final Value $B$5 Cost 0 9062.5 Adjustable Cells Cell Name Original Value Final Value $B$1 Ride 0 31.25 $B$2 Food 0 12.5 $B$3 Shop 0 6.25 Constraints Cell Name Cell Value Formula Status Slack $B$6 Land 50 $B$6<=$D$6 Binding 0 $B$7 ShopLim 6.25 $B$7<=$D$7 Not Binding 3.75 $B$8 Trees 1000 $B$8>=$D$8 Binding 0 $B$9 Workers 200 $B$9<=$D$9 Binding 0 ----------------------------------------------------------------------------- Sensitivity report: Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$1 Ride 31.25 0 150 83.33333333 76.6666667 $B$2 Food 12.5 0 200 115 125 $B$3 Shop 6.25 0 300 1E+30 116.666667 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$6 Land 50 143.75 50 10 16.66666667 $B$7 ShopLim 6.25 0 10 1E+30 3.75 $B$8 Trees 1000 -4.375 1000 166.66667 100 $B$9 Workers 200 31.25 200 30 50

For each of the following changes, either find the answer or state that the information is not available from the Solver output. In the latter case, state why not.

(a) What is the optimal allocation of the space? What is the profit/hour of the park?

Optimal Allocation: Profit/hour:

(b) Suppose Food only made a profit of $180/hour. What would be the optimal allocation of the park, and what would be the profit/hour of the park?

Optimal Allocation: Profit/hour:

(c) City Council wants to increase our tree requirement to 1020. How much will that cost us (in $/hour). What if they increased the tree requirement to 1200?

Increase to 1020: Increase to 1200:

(d) A construction firm is willing to convert 5 acres of land to make it suitable for shops. How much should Kennytrail be willing to pay for this conversion (in $/hour).

Maximum payment:

(e) Kennytrail is considering putting in a waterslide. Each acre of waterslide can have 2 trees and requires 4 workers. What profit/hour will the waterslide have to generate for them to consider adding it?

Minimum Profit: Reason:

(f) An adjacent parcel of land has become available. It is five acres in size. The owner wants to share in our profits. How much $/hour is Kennytrail willing to pay?

Maximum payment:

Answer each of the following questions independently of the others.

- What does the optimal diet consist of?
- If the cost of oatmeal doubled to 6 cents/serving, should it be removed from the diet?
- If the cost of chicken went down to half its current price, should it be added to the diet?
- At what price would eggs start entering the diet?
- In what range can the price of milk vary (rounding to the nearest tenth of a cent) while the current diet still remaining optimal?
- During midterms, you need a daily diet with energy content increased from 2000 kcal to 2200 kcal. What is the resulting additional cost?
- Your doctor recommends that you increase the calcium requirement in your diet from 800 mg to 1200 mg. What is the effect on total cost?
- Potatoes cost 12 cents/serving and have energy content of 300 kcal per serving, but no protein nor calcium content. Should they be part of the diet?

Answer each of the following questions independently of the others.

- What is the current total number of workers needed to staff the restaurant?
- Due to a special offer, demand on thurdays increases. As a result, 18 workers are needed instead of 16. What is the effect on the total number of workers needed to staff the restaurant?
- Assume that demand on mondays decreases: 11 workers are needed instead of 14. What is the effect on the total number of workers needed to staff the restaurant?
- Currently, 15 workers are needed on wednesdays. In what range can this number vary without changing the optimal basis?
- Currently, every worker in the restaurant is paid $1000 per month. So the objective function in the formulation can be viewed as total wage expenses (in thousand dollars). Workers have complained that Shift 4 is the least desirable shift. Management is considering increasing the wages of workers on Shift 4 to $1100. Would this change the optimal solution? What would be the effect on total wage expenses?
- Shift 1, on the other hand, is very desirable (sundays off while on duty fridays and saturdays, which are the best days for tips). Management is considering reducing the wages of workers on Shift 1 to $ 900 per month. Would this change the optimal solution? What would be the effect on total wage expenses?
- Management is considering introducing a new shift with the days off on tuesdays and sundays. Because these days are not consecutive, the wages will be $ 1200 per month. Will this increase or reduce the total wage expenses?

Mon Aug 24 15:42:04 EDT 1998