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:

Unemployed

describes individuals who are capable of working and are actively seeking employment but are unable to find a job.

Uninsured

Individuals or entities that do not have insurance coverage, either by choice or due to ineligibility.

Health Insurance

A type of insurance coverage that pays for an insured individual's medical and surgical expenses.

Health Care Market

The aggregate of all public and private organizations, conditions, and interactions related to the production and consumption of health care services.