Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A furniture company produces 5 different products (A, B, C, D, and E). Each product requires certain amount of linear wood, glue, stain, and production

A furniture company produces 5 different products (A, B, C, D, and E). Each product requires certain amount of linear wood, glue, stain, and production hours (exact amount required can be found in columns 2 - 6). The detailed requirement can be found in the table below. In addition, top management believes in diversification and requires you to produce at least one of each product. However, company has limited resources available on weekly basis, and it cannot procure any additional resources. Company limits can be found in the last column of the table.

A

B

C

D

E

Resource availability

(per week)

Wood (linear m.)

11

17

5

12

21

200

Glue (liters)

2

3

1

4

6

60

Staining (liters)

3

1

1

6

8

50

Working hours

3

4

2

5

6

80

Profit ($)

40

70

30

80

100

Using MS EXCEL where you run solver

  1. What is the optimal manufacturing strategy?
  2. What is the total profit of you proposed strategy?

Consider a possibility to obtain a decimal solution since production can start this week and end during the next one.

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

Automation Production Systems and Computer Integrated Manufacturing

Authors: Mikell P.Groover

3rd edition

132393212, 978-0132393218

More Books

Students also viewed these Mathematics questions

Question

How do you think this problem should be treated?

Answered: 1 week ago

Question

What is beacon marketing? What are digital wallets?

Answered: 1 week ago

Question

=+Do you find that those conditions are met?

Answered: 1 week ago