Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A furniture company manufactures desks and chairs. Each desk uses 8 units of wood, and each chair uses 6 units of wood. A desk contributes

image text in transcribed
A furniture company manufactures desks and chairs. Each desk uses 8 units of wood, and each chair uses 6 units of wood. A desk contributes $400 to profit, and a chair contributes $250. Marketing restrictions require that the number of chairs produced be at least twice the number of desks produced. There are 2000 units of wood available. The file below contains the sensitivity report. Suppose the company can acquire an additional 50 units of wood for $3,000. Based on the sensitivity report, should the company buy the 50 units of wood to increase profits? Variable Cells Cell Name $B$10 Units produced Desks $C$10 Units produced Chairs Final Reduced Value Cost 100 0 200 0 Objective Coefficient 400 250 Allowable Allowable Increase Decrease 1E+30 66.66666667 50 450 Constraints Call Name $B$14 Wood used $B$18 Chairs produced Final Value 2000 200 Shadow Price 45 -20 Constraint Allowable R.H. Side Increase 2000 1E30 03333333333 Allowable Decrease 2000 500

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

Business Accounting Volume 2

Authors: Frank Wood

4th Edition

0582413435, 978-0582413436

More Books

Students also viewed these Accounting questions