Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Management

Authors: Richard L Daft, Dorothy Marcic

6th Edition

9780324581782, 324581785, 978-0324568387

More Books

Students also viewed these General Management questions