Consider the Spreadsheet for Stone Age Surfboards Provided Below -If the Unit Profit on Both Graystone and Lava Surfboards
Multiple Choice
Consider the spreadsheet for Stone Age Surfboards provided below. Use this data to answer the following question(s) , using the Standard Solver.
Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom works
9.25 hours per day. The finishing department has 5 workers, each of whom works a 6-hour shift per day. Each pair of Graystone surfboards requires 2.5 labor hours in the fabrication department and 2 labor hours in finishing. The Lava model requires 4.2 labor-hours in fabrication and 3.6 labor-hours in finishing. The company operates 6 days a week. It makes a per unit profit of $40 on the Graystone model and $60 on the Lava model. The company anticipates selling at least twice as many Lava models as Graystone models.
-If the unit profit on both Graystone and Lava surfboards is increased by $10, what is the shadow price for the finishing hours used?
A) -4.35
B) 8.33
C) 20.65
D) 32.46
Correct Answer:

Verified
Correct Answer:
Verified
Q6: Explain the simplex method used by Solver.
Q7: Consider the spreadsheet for Stone Age
Q8: What are the two basic properties of
Q9: Consider the spreadsheet for Stone Age
Q10: Use the following information to answer
Q12: Infeasible problems can occur when the demand
Q13: Use the following information to answer
Q14: Consider the spreadsheet for Stone Age
Q15: Consider the spreadsheet for Stone Age
Q16: A constraint function is a function of