User Account

All Pages

What is the optimal solution

Assignment Help Business Management
Reference no: EM132794515

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: EM132794515

Questions Cloud

How does artwork engage with issues of domestic labor : How does this artwork engage with issues of domestic labor, specifically in relation to women and invisible/gendered work? What expectations and stereotypes.
What amount of cash did union pay for interest in year : Tesla Corporation borrowed $60,000 from the bank on November 1, Year 1. What amount of cash did Union pay for interest in year 1
What is the process time of the system : 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
Who created each work of architecture or sculpture : Who created each work of architecture or sculpture? Who commissioned its creation? What historical events or social or cultural influences affected the creation
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
What does the term normal balance mean : Describe how to calculate the Cash account? How is this process different for a Liability or Owner's Equity Account? What does the term normal balance mean
What is the optimal solution : -Formulate an LP model for this problem. -Implement your model in a spreadsheet and solve it.
What obstacles during the great depression people face : What obstacles during the Great Depression and the war years did people of color face that Eleanor Roosevelt could help with? The response must be typed.
What is Andy filing status : Andy, age 55, is a widower who maintains a home for himself and his 22-year-old son who attends college full-timE. What is Andy filing status

Reviews

Write a Review

Business Management Questions & Answers

  Relationship between a company compensation

Can someone please summarize and explain the relationship between a company's compensation plans and a company's performance appraisal processes

  Vehicles to make a right turn at a specific point

In Alice programming environment how do you get will and tires to rotate while the vehicle moves then how can you get all the vehicles to make a right turn at a specific point?

  What challenges and rewards of leading

What challenges and rewards of leading a co-op did Monique Leroux face and how did she deal with them?

  Develop and test a user-defined aggregate to calculate

Develop and test a user-defined aggregate to calculate n factorial {n!), where n is an integer.

  Evaluate shoprite holding key resources

Critically evaluate Shoprite Holding Key resources based on Human, Financial and core competence. And how those will add value to the company.

  Case during the systems analysis phase

Explain the purpose of a requirements analysis and a use case during the systems analysis phase?

  Vehicles class to instantiate three objects making

Write a Use Vehicles class to instantiate three objects making use of proper overloaded class constructors: one object of the Vehicle class, one object of the PassengerCar class and one object of the Truck class. When doing so, accept the user inp..

  Define indirect price discrimination

Define indirect price discrimination. Show one technique and explain why the firm would use that technique.

  National patient safety foundation

What are the most frequent safety issues with regards to National Patient Safety Foundation )NPSF)? Please explain in detail.

  Why is a check endorsement necessary

Discuss several guidelines that should be followed when accepting checks from patients. Why is a check endorsement necessary?

  What is the mission of the corporation?

What is the mission of the Corporation?

  Engages in foreign direct investment

There are five reasons that help to explain why a company engages in foreign direct investment, FDI. They includes: proprietary assets and natural resources

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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