A Production Manager Wants to Determine How Many Units of Each

question 29

Essay

A production manager wants to determine how many units of each product to produce weekly to maximize weekly profits.Production requirements for the products are shown in the following table.
$$\begin{array} { l c c c } \text { Product } & \text { Material 1(lbs.) } & \text { Material 2(lbs.) } & \text { Labor (hours) } \\ \mathrm { A } & 3 & 2 & 4 \\\mathrm {~B} & 1 & 4 & 2 \\\mathrm { C } & 5 & \text { none } & 3.5\end{array}$$
Material 1 costs $7 a pound,material 2 costs $5 a pound,and labor costs $15 per hour.Product A sells for $101 a unit,product B sells for $67 a unit,and product C sells for $97.50 a unit.Each week there are 300 pounds of material 1;400 pounds of material 2;and 200 hours of labor.Also,there is a weekly demand of 10 units of product C each week.Use Excel to formulate and solve this problem.

---

Definitions:

Glaciers/Snowpack

Masses of ice and snow that accumulate in colder climates, moving slowly over land under their own weight.

Volcanic Cinders

Small, porous pieces of pyroclastics that are ejected from a volcano during an explosive eruption.

Scoria Cone

A volcanic cone formed out of tephra (volcanic debris) and cinders that accumulate around and downwind from a volcanic vent.

Shield Volcano

A type of volcano with gently sloping sides formed by the eruption of low-viscosity lava that can flow long distances.