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

question 2

Multiple Choice

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 fabrication?

• A) 42.58
• B) 50.10
• C) 35.64
• D) 22.95

---

Definitions:

Semi-Annually Compounded

Pertaining to the interest calculation method where the interest is compounded and added to the principal amount twice a year.

Compounded Annually

The process of earning interest on both the initial principal and the accumulated interest from previous periods on an annual basis.

Compounded Annually

The calculation of interest on the initial principal and the interest accumulated over the previous periods once a year.

Guaranteed Investment Certificate

A secure investment that guarantees to return the principal amount plus interest at a specified rate.