Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a spreadsheet model based on the questions above. Then fill in the spreadsheet using specific value (integer, no decimal) for decision variables and formulas
Create a spreadsheet model based on the questions above. Then fill in the spreadsheet using specific value (integer, no decimal) for decision variables and formulas for constraints. A B C 1 Nowlin Plastics 2 3 Parameters 4 Manufactoring Fixed Cost 234000 5 Manufactoring Outsourcing 6 Cost per Unit 2 3 7 Selling Price 15 12 8 9 Model Manufactoring Outsourcing 10 Quantity 1 1 11 12 total profit =SUMPRODUCT(B7:C7,B10:C10)-SUMPRODUCT(B6:C6,B10:C10)-B4 13 14 constraints used available 15 Manufactoring quantity Qm <= 200000 16 outsourcing budget Co <= 300000 17 total quantity Pm >= 250000
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