Use the following information to answer the following question(s) , using the SUMPRODUCT function.
Stone Age Surfboards is a small manufacturer of two types of popular high-tide surfboards, the Rockwell and the Limestone models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 15 skilled workers, each of whom works 5 hours per day. The finishing department has 5 workers, who also work a 5-hour shift. Each pair of Rockwell surfboards requires 3 labor hours in the fabrication department and 1.5 labor hours in finishing. The Limestone model requires 4.5 labor-hours in fabrication and 2 labor-hours in finishing. The company operates 6 days a week. It makes a per-unit profit of $60 on the Rockwell model and $75 on the Limestone model. Approximately 4.1 Rockwell models and 8.4 Limestone models are produced per day.
-What is the total number of hours used for fabrication?
A) 42.58
B) 50.10
C) 35.64
D) 22.95
Correct Answer:
Verified
Q2: Consider the spreadsheet for Stone Age
Q3: Consider the spreadsheet for Stone Age
Q4: Consider the spreadsheet for Stone Age
Q5: Consider the spreadsheet for Stone Age
Q6: Consider the spreadsheet for Stone Age
Q7: Consider the spreadsheet for Stone Age
Q8: Consider the spreadsheet for Stone Age
Q9: Which of the following best defines decision
Q10: Consider the spreadsheet for Stone Age
Q11: Which of the following best defines objective
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents