Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Eagle Furniture makes wooden rustic furniture. The major bottleneck in production is the time in the wood cutting shop. The demand for the products exceeds

Eagle Furniture makes wooden rustic furniture. The major bottleneck in production is the time in the wood cutting shop. The demand for the products exceeds the current capacity. There are two major product lines: chests and nightstands. The company has to decide which product line should get priority in production. Information about the product lines is provided below.

Chest Nightstand
Selling price per unit $1400 $750
Variable cost per unit $800 $490
Required time in wood shop to produce 1 unit 0.5 hours 0.75 hours
Required time at polishing shop to produce 1 unit 1.2 hours 0.3 hours

Monthly production hours available at the wood cutting station is 400 hours. Monthly production hours available at the polishing station is 440 hours. Use linear programming and Excel Solver to determine the optimal product mix. Answer the questions below accordingly.

(a) How many chests should be produced per month to maximize the total contribution margin?

(b) How many nightstands should be produced per month to maximize the total contribution margin?

Step by Step Solution

3.40 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

To solve this problem using linear programming and Excel Solver we need to set up the objective func... 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

Global Strategy

Authors: Mike W. Peng

5th Edition

0357512367, 978-0357512364

More Books

Students also viewed these Accounting questions

Question

List one of the facultys publications in APA style.

Answered: 1 week ago

Question

Why has the FCPA not ended corruption in global business?

Answered: 1 week ago