Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started