Illustrate what is optimal solution

Assignment Help Operation Management

Reference no: EM1376505

Q. A furniture manufacturer makes two types of tables (Nation also contemporary) using three types of machines. Time requisite to make tables on each machine is given in subsequent table.

Total Machine Time
Machine Nation Contemporary Available per Week
Router1.5 2.0 1,000
Salsoer3.0 4.5 2,000
Polisher2.5 1.5 1,500

Nation tables sell for $350 also contemporary tables sell for $450. Management has determined which at least 20% of table made should be Nation also at least 30% should be contemporary. Elucidate how many of each table should company make if it wants to maximize its revenue?

Formulate an LP model for this problem

Create a spreadsheet model for this problem using solver. Illustrate what is optimal solution?
Elucidate how will spreadsheet model differ from 25 types of tables also 15 machine processes involved in manufacturing them?

Reference no: EM1376505

Questions Cloud

Illustrate what is standard deviation of above-below median : Illustrate what is standard deviation of above/below median runs. Illustrate what can analyst conclude given this information.

Analyze this data using an appropriate control chart : Each week a sample of 100 residents is questioned on their feelings towards project. Results to date are shown below. Analyze this data using an appropriate control chart with a 5% risk of Type I error.

Economic influence impact on business : Determine which presidential candidate will be best for corporate America. In other words which candidate poses the greater risk to businesses.

Establish three-sigma mean also range limits : Four samples of three observations each have been taken, with actual measurements (in centimetres) shown below. Establish three-sigma mean also range limits.

Illustrate what is optimal solution : Illustrate what is optimal solution. Elucidate how will spreadsheet model differ from 25 types of tables also 15 machine processes involved in manufacturing them.

Question based on heuristics : Heuristics are generally identified as rules of thumb that we use when creating decisions. We evaluate data we already know, events we have already experienced,

Determine depreciation expense of the press : Determine depreciation expense of the press using both US GAAP and IFRS - Expected future undiscounted cash flows from operating press

Federal income tax purposes : Thelma thus selld the property to Paul (an unrelated party) for $65,000. On the next day, Paul sells the property to Sandy for the same amount. Is Thelma's realized loss of $55,000 deductible? Describe.

Determine the rule changes and non wage issues : The National Hockey League locked out its gamers in a yearlong battle in the union and the owners. There were monetary issues as well as non monetary issues that affected the lockout.

User Account

All Pages