Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

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

An Introduction to Analysis

Authors: William R. Wade

4th edition

132296381, 978-0132296380

More Books

Students also viewed these Mathematics questions

Question

Please make it fast 6 4 1 . .

Answered: 1 week ago