QUESTION

Text
Image


Q2: Cool-bike Industries manufactures boys and girls bicycles in both 20 -inch and 26-inch models. Each week it must produce at least 200 girl models and 200 boy models. The following table gives the unit profit and the number of minutes required for production and assembly for each model. \begin{tabular}{|c|c|c|c|} \hline Bicycle & Unit Profit & Production Minutes & Assembly Minutes \\ \hline 20 -inches girls & $\$ 27$ & 12 & 6 \\ \hline 20 -inches boys & $\$ 32$ & 12 & 9 \\ \hline 26 -inches girls & $\$ 38$ & 9 & 12 \\ \hline 26 -inches boys & $\$ 51$ & 9 & 18 \\ \hline \end{tabular} The Production and assembly areas run two (eight-hour) shifts per day, five days per week. This week there are 500 tires available for 20 -inch models and 800 tires available for 26-inch models. Determine Cool-bike's optimal schedule for the week. What profit will it realize for the week?

solve using excel solver

Public Answer

OMWEHJ The First Answerer