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. \(\begin{array}{|c|c|c|c|c|}
\hline & \text { A } & \text { B } & \text { C } & \text { D } \
\hline 1 & \text { Stone Age Surfboards } & & & \
\hline 2 & & & & \\hline 3 & \text { Data } && \
\hline 4 & & &{\text { Product }} & \
\hline 5 & \text { Department } & \text { Rockwell } & \text { Limestone } & \text { Limitation (hours) } \
\hline 6 & \text { Fabrication } & 3 & 4.5 & 75 \
\hline 7 & \text { Finishing } & 1.5 & 2 & 25 \
\hline 8 & & & & \\hline 9 & \text { Profit/Unit } & \$ 60.00 & \$ 75.00 \
\hline 10 & & & \
\hline 11 & & & \
\hline 12 & \text { Model } & & \
\hline 13 & & \text { Rockwell } & \text { Limestone } \\hline 14 & \text { Quantity Produced } & 4.1 & 8.4 & \text { Hours Used } \
\hline 15 & \text { Fabrication } & & & \
\hline 16 & \text { Finishing } & & & \
\hline 17 & & & & \
\hline 18 & & & & \text { Excess Limestone } \\hline 19 & \text { Market Mixture } & & & \
\hline 20 & & & & \
\hline 21 & & & & \text { Total Profit } \
\hline 22 & \text { Profit Contribution } & & & \
\hline
\end{array}\)
-What is the total number of hours used for the finishing operation?
A) 42.58
B) 50.10
C) 35.64
D) 22.95

Question

Quizplus · Accepted Answer

The Answer of 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. \(\begin{array}{|c|c|c|c|c|}
\hline & \text { A } & \text { B } & \text { C } & \text { D } \
\hline 1 & \text { Stone Age Surfboards } & & & \
\hline 2 & & & & \\hline 3 & \text { Data } && \
\hline 4 & & &{\text { Product }} & \
\hline 5 & \text { Department } & \text { Rockwell } & \text { Limestone } & \text { Limitation (hours) } \
\hline 6 & \text { Fabrication } & 3 & 4.5 & 75 \
\hline 7 & \text { Finishing } & 1.5 & 2 & 25 \
\hline 8 & & & & \\hline 9 & \text { Profit/Unit } & \$ 60.00 & \$ 75.00 \
\hline 10 & & & \
\hline 11 & & & \
\hline 12 & \text { Model } & & \
\hline 13 & & \text { Rockwell } & \text { Limestone } \\hline 14 & \text { Quantity Produced } & 4.1 & 8.4 & \text { Hours Used } \
\hline 15 & \text { Fabrication } & & & \
\hline 16 & \text { Finishing } & & & \
\hline 17 & & & & \
\hline 18 & & & & \text { Excess Limestone } \\hline 19 & \text { Market Mixture } & & & \
\hline 20 & & & & \
\hline 21 & & & & \text { Total Profit } \
\hline 22 & \text { Profit Contribution } & & & \
\hline
\end{array}\)
-What is the total number of hours used for the finishing operation?
A) 42.58
B) 50.10
C) 35.64
D) 22.95

Use the Following Information to Answer the Following Question(s), Using