Use the following information to answer the following questions, using the SUMPR
ID: 2583788 • Letter: U
Question
Use the following information to answer the following questions, 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 the fabrication department 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 B C D 1 Stone Age Surfboards 2 3 Data 4 Product 5 Department Rockwell Limestone Limitation (hours) 6 Fabrication 3 4.5 75 7 Finishing 1.5 2 25 8 9 Profit/Unit $60 $75 10 11 12 Model 13 Rockwell Limestone 14 Quantity Produced 4.1 8.4 Hours Used 15 Fabrication 16 Finishing 17 18 Excess Limestone 19 Market Mixture 20 21 Total Profit 22 Profit ContributionExplanation / Answer
Total Number of Hours Used For Fabrication:
Fabrication Department has totally 15 workers, each of them works for 5 hours a day, so total hours for Fabrication Department is 75 hours a day.
3 hours are required in fabrication department for each pair of Rockwell surfboards and 4.5 hours for Limestone model.
4.1 Rockwell models are produced each day, so time taken in fabrication department is 4.1*3=12.3 hours
8.4 limestone models are produced each day, so time taken in fabrication department is 8.4*4.5=37.8 hours.
So total time taken to produce 4.1 Rockwell models and 8.4 Limestone models are 12.3+37.8=50.10 hours