Consider the Spreadsheet for Stone Age Surfboards Provided Below -What Is the Total Number of Hours Used for Fabrication
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.
-What is the total number of hours used for fabrication?
A) 54.5
B) 30.0
C) 35.5
D) 43.8
Correct Answer:

Verified
Correct Answer:
Verified
Q4: Whenever a constraint has positive slack, the
Q5: Use the following information to answer
Q6: Explain the simplex method used by Solver.
Q7: Consider the spreadsheet for Stone Age
Q8: What are the two basic properties of
Q10: Use the following information to answer
Q11: Consider the spreadsheet for Stone Age
Q12: Infeasible problems can occur when the demand
Q13: Use the following information to answer
Q14: Consider the spreadsheet for Stone Age