Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please fill in the table with correct answers i will NOT have enough time to work this out on my own, and also calculate the

please fill in the table with correct answers i will NOT have enough time to work this out on my own, and also calculate the total profit.
image text in transcribed
image text in transcribed
12 square feet, respectively. Sales forecasts indicate that if available, 900,1,200, and 750 units of the large, medium, and small sizes, respectively, would be sold per day. At each plant, some employees will need to be laid off unless most of the plant's excess production capacity can be used to produce the new product. To avoid layoffs if possible, management has decided that the plants should use the same percentage of their excess capacity to produce the new product. Management wishes to know how much of each of the sizes should be produced by each of the plants to maximize profit. Click here for the Excel Data File Formulate and solve a linear programming model for this mixed problem on a spreadsheet. a. Determine the amount of each of the sizes to be produced by each of the plants. Note: Round your answers to 2 decimal places. If nothing is produced, enter " 0 ". b. Determine the total profit. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline A & B & C & D & E & F & G & H & 1 & 1 & k \\ \hline & Large & Medium & Small & & & & & & & \\ \hline Unit Profit & $420 & $360 & $300 & & & & & & & \\ \hline & & & & & & & & & & \\ \hline Space Required & 20 & 15 & 12 & & & & & & & \\ \hline \multicolumn{11}{|l|}{ (sq.ft. per unit) } \\ \hline & & & & & & & & Space & & Space \\ \hline & & & & & & Capacity & & Required & & Avalable \\ \hline & & I & E & & & 750 & & 0 &

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

Auditing Markets Products And Marketing

Authors: David Parmerlee

1st Edition

0658001337, 978-0658001338

More Books

Students also viewed these Accounting questions