Examlex

Solved

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.  A  B  C  D 1 Stone Age Surfboards 23 Data 4 Product 5 Department  Rockwell  Limestone  Limitation (hours)  6 Fabrication 34.5757 Finishing 1.522589 Profit/Unit $60.00$75.00101112 Model 13 Rockwell  Limestone 14 Quantity Produced 4.18.4 Hours Used 15 Fabrication 16 Finishing 1718 Excess Limestone 19 Market Mixture 2021 Total Profit 22 Profit Contribution \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?


Definitions:

CVD

Cardiovascular disease, a class of diseases that involve the heart or blood vessels, including coronary artery disease and stroke.

Serum Cholesterol Levels

The amount of cholesterol present in the blood, which is a significant indicator of heart health and risk of cardiovascular diseases.

Heart Disease

A variety of disorders impacting the heart, such as diseases of the blood vessels, issues with heart rhythm, and congenital heart anomalies.

HDL

High-density lipoprotein, a type of cholesterol often referred to as "good" cholesterol because it helps remove other forms of cholesterol from the bloodstream.

Related Questions