Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show all equations. A drug company produces six different products at its plant. Relevant details are shown on the Problem 4 worksheet. On that

Please show all equations.

image text in transcribedimage text in transcribed
A drug company produces six different products at its plant. Relevant details are shown on the Problem 4 worksheet. On that worksheet, note that production of each product requires labor and raw material. The problem is to formulate and use an optimization model to determine a production mix (e.g., how many pounds to produce of each product) that maximizes profit when 4,500 hours of labor and 1,350 pounds of raw material are available. Display the profit to two decimal places. The Changing Cells are not to be integer-constrained, and negative production should be ruled out. 2. [4 points] Assign appropriate range names to the cell with the objective function the range of and any other cells/ranges that will be used in the solver dialog box. There should be no cells in the Solver without range names. 3. [8 points]Formulate the model by entering the formulas for profit, labor used and raw material used. 4. [5 points] Use Solver to determine the production schedule that maximizes the total profit under the resources constraints. Create a Scenario named "Optimal" with these values for the input cells 5. [5 points] Now assume that at least 50 pounds of each drug must be made. Add this constraint and use Solver to determine the production schedule that maximizes the total profit in this case. Create another scenario -"Optimal50" with the values found by solver for the production quantities as the values of the inputs/changing cells. 6. [8 points] Generate a scenario summary report showing for each of the two scenarios the resulting profit and the amount of each resource (labor and raw material) used. Move the scenario summary report to the right of Problem 4 worksheet. Make sure that there are no cell addresses in your report.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Accounting for Decision Making and Control

Authors: Jerold Zimmerman

8th edition

978-0078025747

More Books

Students also viewed these Economics questions