A company that manufactures electrical appliances is looking at one of its lines (washing machines), where it offers three different levels of specification: Basic which sells for £250, Medium which sells for £450 and Luxury which sells for £700. The production of each machine goes through four different stages and you have been provided with the following data table:

Process\Machine	Basic	Medium	Luxury	Cost per hour	Max. Available
Forming	1.5 hours	3 hours	7 hours	£5.50	6,500 hours
Machining	5 hours	8 hours	14 hours	£7.50	18,000 hours
Assembly	2.5 hours	4.5 hours	8 hours	£9.50	8,500 hours
Testing	2 hours	2 hours	2 ½ hours	£12.00	5,200 hours

The marketing department has also done some market research and believes demand for each of the models is limited to 1,450 units of the basic model, 900 of the medium and 750 of the luxury. You are required to:

1. Formulate this problem as a linear program and use Excel's Solver to arrive at a solution, identifying what is the maximum profit the company can achieve in the washing machine product line.

2. How would your answer change if the following happened:

a. Maximum demand for Medium model was 1,000; OR

b. Maximum available Assembly hours were 9,500.

3. Write a report with a recommended production and marketing plan for the company.

Posted Date: 3/18/2013 4:18:37 AM | Location : United States

Ask an Expert

Related Discussions:- Find out maximum demand for medium model , Assignment Help, Ask Question on Find out maximum demand for medium model , Get Answer, Expert's Help, Find out maximum demand for medium model Discussions

Write discussion on Find out maximum demand for medium model
Your posts are moderated

Write your message here..

Related Questions

Mutual fund, investment procedure of mutual fund investment procedure of mutual fund

Role of stock exchange in economic development, Role of Stock Exchange in E... Role of Stock Exchange in Economic Development The Roles of Stock Exchange in Economic Development are as follow: 1. Raising Capital for Businesses The Stock Exchange

Financial performance analysis, given profit margin 7%, total asset turnove... given profit margin 7%, total asset turnover is 1.94, Return on equity is 23.7%, what is the debt equity ratio

The importance of tax, Discuss business taxes and their importance in finan... Discuss business taxes and their importance in financial decisions

PERDIEM CLAIM, how to make a perdiem claim format to maintain the records o... how to make a perdiem claim format to maintain the records of staff

Net cash flow, Assignment: Mr. Ali wants to start “Rent-A-Car” business. He... Assignment: Mr. Ali wants to start “Rent-A-Car” business. He wants to start this business with at least 20 cars. He estimates that the required investment for the business is Rs.

Development of plastic money in middle asia, Development of Plastic Money i... Development of Plastic Money in Middle Asia Motive behind the Fast Development of This Finance (Plastic Money) In Middle Asia a) High incidences of fraud via dishonest empl

Disadvantage of joint stock companies, Disadvantage of Joint Stock Companie... Disadvantage of Joint Stock Companies Difficult to reconstruct the capital Many formalities in forming the company Heavy initial capital outlay. Loss of secrec

Advantage of joint stock companies, Advantage of Joint Stock Companies ... Advantage of Joint Stock Companies The company can own assets and incur liabilities on its own accord. Perpetual existence as or going to relate that allows the compan

Determine the critical path and the expected completion, The information in... The information in the table below is available for a large fund-raising project. a. Determine the critical path and the expected completion time of the project. b. Plot the