Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part 3a Now alter the management decision limiting fabrication to 480 minutes. Increase it to 600, and increase the minimum number of chairs to
Part 3a Now alter the management decision limiting fabrication to 480 minutes. Increase it to 600, and increase the minimum number of chairs to be produced Solver again and list the number of tables and chairs that should be produced. to 16. # Tables # Chairs Total Profit Part 3b found a Too many tables have been rejected by quality assurance, and the production line for tables will be slowed, increasing fabrication time to 26 minutes. However, they als way to decrease fabrication time on the chairs to 3 minutes. Use the original constraints for fabrication time (480 minutes) and the minimum tables (4) and chairs (10). Run Solver again and list the table showing the tables and chairs that should be produced. Part 1 Profit totals Volume Profit per unit Selling price of table $129.00 Selling price of chair $35.00 Materials/Fabrication Needed for a Table # Tables # Chairs Total Profit Table Chair $0.00 0 $0.00 50.00 $63.60 $17.40 Amount Metal tubing: 22 feet @ $0.10/linear foot A 22 Plastic sheet: 16 sqft @ $0.20/square foot B 16 Fabrication minutes C 15 Cost of table Materials/Fabrication 20 Needed for a Chair Metal tubing: 10 feet D Plastic sheet: 3 sqft Fabrication minutes Cost of chair E F Amount Cost Unit Total $0.10 $2.20 Metal tubing $0.20 $3.20 Plastic sheet $4.00 $60.00 $65.40 Fabrication Constraints 1200 0 700 480 A 10 $0.10 $1.00 Min number 10 3 $0.20 $0.60 Min number 4 $4.00 $16.00 $17.60
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