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

please show what needs to be input into excel please show what needs to be input into excel A manager wants

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!