What is the optimal solution

Assignment Help Finance Basics
Reference no: EM132798608

A furniture manufacturer produces two types of tables (country and contemporary) using three types of machines. The time required to produce the tables on each machine is given in the following table.

Country tables sell for $350 and contemporary tables sell for $450. Management has determined that at least 20% of the tables made should be country and at least 30% should be contemporary. How many of each type of table should the company produce if it wants to maximize its revenue?

Machine Country Contemporary Total Machine Time Available per Week

Router 1.5 2.0 1,000

Sander 3.0 4.5 2,000

Polisher 2.5 1.5 1,500

1. Formulate an LP model for this problem.

2. Use Excel spreadsheet model for this problem and solve it using Excel Solver add in.

3. What is the optimal solution?

4. How will your spreadsheet model differ if there are 25 types of tables and 15 machine processes involved in manufacturing them?

Reference no: EM132798608

Questions Cloud

Describe a typical fast-food restaurant : Why does the ratio of labor cost to food cost differ between fast food and fine dining restaurants? Describe a typical fast-food restaurant's labor
Organizations achieve a competitive advantage : 1. Identify how changes in the external environment may affect the Operations Management (OM) strategy for a company. For example, what impact are the following
What is the bottleneck time of work cell : The three-station work cell illustrated in Figure S7.7 has a product that must go through one of the two machines at station 1 (they are parallel) before procee
How much will you have when you start your business : If the account earns 9% compounded annually, how much will you have when you start your business 12 years from now
What is the optimal solution : A furniture manufacturer produces two types of tables (country and contemporary) using three types of machines. The time required to produce the tables on each
Formulate an lp model for problem : Aire-Co produces home dehumidifiers at two different plants in Atlanta and Phoenix. The per unit cost of production in Atlanta and Phoenix is $400 and $360, res
Unit 04 Database Design and Development Assignment : Unit 04 Database Design and Development Assignment Help and Solution, HND in Computing - Assessment Writing Service - Data base system for the SmartMovers
Compute the income or loss from continuing operations : Net income (after tax) is $3,600. Income tax rate is 40%. Compute the income or loss from continuing operations before income taxes
Determine the optimal solution using excel solver : A company makes three products, and it has three machines available. The LP problem is formulated as below. Max Z: 4x1+ 4x2+ 7x3

Reviews

Write a Review

Finance Basics Questions & Answers

  Compute the expected rate of return for lauren

Compute the expected rate of return for Lauren Labs and the correlation between Lauren and Sophie share.

  What market forces cause increase in corporate bond yields

When stock market volatility is high, corporate bond yields tend to increase. - What market forces cause the increase in corporate bond yields under these conditions?

  What are monthly payments

1. Three years ago you took out a 30-year amortizing loan. The loan has a 6% APR with monthly payments (and monthly compounding). a) What are your monthly payments if your current loan balance is $368; 600?

  Why maximize current value of firm stock is appropriate goal

Explain why maximizing the current value of the firm's stock is the appropriate goal for management. State how this can impact the firm's financial decisions.

  Operating and a cash budget

What is the relationship between an operating and a cash budget?

  Relationship between beta and stock price

Why the security with the lower beta will have a higher stock price?

  Create the right environment for trainees to transfer

Discuss how an organization can create the right environment for trainees to transfer learning back unto the job.

  It requires an initial investment of 470 million and has a

beacon products co. is examining a new project. it requires an initial investment of 470 million and has a npv of 0.26

  If the discount rate is 8 what is the pv of these future

mike polanski is 30 years of age and his salary next year will be 40000. mike forecasts that his salary will increase

  Competitive strategy choices in strategic compensation

When looking at competitive strategy choices in strategic compensation what's a company that uses a lowest cost strategy and one that uses a differentiation

  How much will your purchasing power increase

An invesment offers to pay you 12% over the next year. You expect inflation to be 2.5% over that same year. How much will your purchasing power increase if you make this investment?

  What is the current value of one share of this stock

The company just paid its annual dividend in the amount of $1.20 per share. What is the current value of one share of this stock if the required rate of return is 9.25 percent?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd