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 profit generated?
A) $ 876.00
B) $ 675.50
C) $ 480.50
D) $ 965.00
Correct Answer:
Verified
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
Q13: Consider the spreadsheet for Stone Age
Q14: Use the following information to answer
Q15: Consider the spreadsheet for Stone Age
Q16: Consider the spreadsheet for Stone Age
Q17: Consider the spreadsheet for Stone Age
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