Question: QUESTION 3 Consider the spreadsheet for Stone Age Surfboards provided below. Use this data to answer the following question(s), using the Standard Solver. Stone Age
QUESTION 3
-
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 12-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. What will be the total profit contribution from Lava surfboards?
$391.30
$357.27
$782.61
$421.48
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
