Question: please show what needs to be input into excel A manager wants to know how many units of each product to produce on a daily
A manager wants to know how many units of each product to produce on a daily basis in order to achieve the highest contribution to profit. Production requirements for the products are shown in the following table. Product A sells for $80 a unit, product B sells for $90 a unit, and product C sells for $70 a unit. Available resources each day are 200 pounds of material 1; 300 pounds of material 2; and 150 hours of labor. The manager must satisfy certain output requirements. The output of product A should not be more than 1/3rd of the total number of units produced; the ratio of product A to units of product B should be 3 to 2 ; and there is a standing order for 5 units of product A each day. Formulate a linear programming model for this problem, and then solve it using Excel Solver. Attach your Excel worksheet as an Excel file (not just a screenshot). (Please note that the model must be linear, that is, there must be no multiplication or division of decision variables.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
