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

question 24

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 profit generated?

• A) $ 876.00
• B) $ 675.50
• C) $ 480.50
• D) $ 965.00

---

Definitions:

One-Sided Hypothesis

A one-sided hypothesis test, also known as a directional hypothesis, tests the possibility of a relationship in a specific direction.

Null Hypothesis

A default hypothesis that there is no significant difference or effect, often tested against an alternative hypothesis in statistical analysis.

Two-Tail Test

A statistical test that considers both directions of a distribution to determine if there is a significant difference from the hypothesized value, useful for checking inequalities.

Null Hypothesis

A default hypothesis that there is no difference or effect, often tested to determine the likelihood of observing the sample data.