Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. operations management
  3. show step by step spreadsheet model a furniture ma

SHOW STEP BY STEP SPREADSHEET MODEL A furniture manufacturer produces two types of tables – country and...

70.2K

Verified Solution

Question

Operations Management

SHOW STEP BY STEP SPREADSHEET MODEL

A furniture manufacturer produces two types of tables – countryand contemporary – using three types of machines. The time requiredto produce the tables on each machine is given in the followingtable:

Machine

Country

Contemporary

Total Machine Time

Available Per Week

Router

2.5

3.0

1,000

Sander

3.5

5.5

2,000

Polisher

2.0

1.0

1,500

Country tables sell for $395 and contemporary tables sell for$515.   Management has determined that at least 25% ofthe tables made should be country and at least 38% should becontemporary. How many of each type of table should the companymanufacture if it wants to maximize its revenue?

  1. Formulate an LP model for this problem
  2. Create the spreadsheet model and use Solver to solve theproblem.

Answer & Explanation Solved by verified expert
4.1 Ratings (835 Votes)
Letx1 number of country tables to make and x2 number ofcontemporary tables to    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Geometry
1.2K views

Theorem 111. Dilations preserve angle measure. Specifically, if noncollinear points A, B and C go...

Biology
1.2K views

Explain the mechanism by which the signaling by the Epinephrine receptor is amplified inside the cell....

General Management
1.2K views

The marketing strategy of corporate naming rights for sports venues is a fairly recent strategy in...

Biology
1.2K views

hat is the common name of the specimen

Physics
1.2K views

26 In the given figure F 200 N m 20 kg m 25 kg g...

Accounting
1.2K views

Assume that your ending inventory is composed of 99 equivalent units of materials and 69...

Accounting
1.2K views

Comparativo bataoce theets for 2021 and 2020, s staternent of income for 2021 , and...

Accounting
1.2K views

Compute and interpret the contribution margin ratio using the following data: sales, $5,000; total variable...

Accounting
1.2K views

The materials price variance should be computed: Multiple Choice when materials are purchased. when materials...

Accounting
1.2K views

help pls Duluth Ranch, Incorporated purchased a machine on January 1, 2021....

Accounting
1.2K views

44. Michelle purchased 2,000 shares of Stone Corporation for $13,200. This year, Stone declared a...

Accounting
1.2K views

Vaughn Manufacturing produced 280000 units in 132000 direct labor hours. Production for the period was...