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.

Question

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.

Quizplus · Accepted Answer

The Answer of 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.

A Production Manager Wants to Determine How Many Units of Each