Consider the Spreadsheet for Stone Age Surfboards Provided Below -What Is the Value of Slack Obtained from the Answer
Multiple Choice
Consider the spreadsheet for Stone Age Surfboards provided below. Use this data to answer the following questions) , 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 value of slack obtained from the answer report?
A) 46.78
B) 38.46
C) 59.24
D) 23.85
Correct Answer:

Verified
Correct Answer:
Verified
Q1: Use the following information to answer
Q2: Which of the following best defines objective
Q3: Use the table below to answer
Q5: Explain the simplex method used by Solver.
Q6: What are the Excel functions to avoid
Q7: Use the table below to answer
Q8: Use the following information to answer the
Q9: Use the following information to answer the
Q10: A constraint function is a function of
Q11: Consider the spreadsheet for Stone Age