Question: 2. Solve the linear programming model formulated in the previous problem for the Wisham family farm using Excel. (a) Are there any extra (slack) resources

2. Solve the linear programming model formulated

2. Solve the linear programming model formulated in the previous problem for the Wisham family farm using Excel. (a) Are there any extra (slack) resources available? (b) If the Wisham family could obtain additional resources, which one would be of most value to them? Assume that each additional pound of unshelled pecans and each additional hour of baking and packing time cost the same. How much would they be willing to pay for this resource? Why? (c) If the family could obtain an additional 500 pounds of pecans or 30 hours of oven time, which should they choose? (d) The family is thinking about buying a bigger oven for $3,000. If they do so, they could make a batch of 5 pies or a batch of 3 dozen cookies at one time. Should they buy the oven? Explain your answer and base your decision on one year's sales only. 2. Solve the linear programming model formulated in the previous problem for the Wisham family farm using Excel. (a) Are there any extra (slack) resources available? (b) If the Wisham family could obtain additional resources, which one would be of most value to them? Assume that each additional pound of unshelled pecans and each additional hour of baking and packing time cost the same. How much would they be willing to pay for this resource? Why? (c) If the family could obtain an additional 500 pounds of pecans or 30 hours of oven time, which should they choose? (d) The family is thinking about buying a bigger oven for $3,000. If they do so, they could make a batch of 5 pies or a batch of 3 dozen cookies at one time. Should they buy the oven? Explain your answer and base your decision on one year's sales only

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Please submit your formulation and excel files. The Hongs family owns 410 acres of farmland in Waimea on which they grow corn and tobacco. Each acre of corn costs $105 to plant, cultivate, and...

The Hongs family owns 4 1 0 acres of farmland in Waimea on which they grow corn and tobacco. Each acre of corn costs $ 1 0 5 to plant, cultivate, and harvest; each acre of tobacco costs $ 2 1 0 . The...

1 . The Hongs family owns 4 1 0 acres of farmland in Waimea on which they grow corn and tobacco. Each acre of corn costs $ 1 0 5 to plant, cultivate, and harvest; each acre of tobacco costs $ 2 1 0 ....

Solve the linear programming model formulated in Problem 59 for the Wisham family farm using the computer. a. Are there any extra (slack) resources available? b. If the Wisham family could obtain...

Solve the linear programming model formulated in Problem 61 for the Wisham family farm using the computer. a. Are there any extra (slack) resources available? b. If the Wisham family could obtain...

1: Directions: 1) Read the entire selection below 2) Answer the questionssee additional notes below.... Selection: Bradley's Food Stand John Bradley is a senior at Tech, and he's investigating...

Please submit your formulation and excel files. The Hongs family owns 4 1 0 acres of farmland in Waimea on which they grow corn and tobacco. Each acre of corn costs $ 1 0 5 to plant, cultivate, and...

Delph Company uses a job-order costing system and has two manufacturing departmentsMolding and Fabrication. The company provided the following estimates at the beginning of the year: During the year,...

What rule of thumb do business analysts recommend for making the decision to buy or custom-build software?What other factors affect this decision?

Which of the following statements is true? In service department cost allocations, soles dollars should be used as an allocation base whenever possible. For performance evaluation purposes, variable...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...