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

Rajendra kumar, whom do you think rajendra should eat with and why whom do you think rajendra should eat with and why

Calculate operating leverage of tax rate, A firm has sales of Rs. 10,00,000... A firm has sales of Rs. 10,00,000. Variable cost is 70%, total cost is Rs.9,00,000 and Debt of Rs. 5,00,000 at 10% rate of interest. If tax rate is 40% calculate:

Analysis, Inventories turnover 8 times 4 times Re... Inventories turnover 8 times 4 times Receivable days 63 days 40 days

Types of stock markets, Types of Stock Markets 1. Over the Counter or... Types of Stock Markets 1. Over the Counter or OTC and Organised Exchange market This is whereas the selling and buying of securities is done through sellers and buyers ar

Find the required return, Marbela Corporation's stock had a required return... Marbela Corporation's stock had a required return of 12.75% last year, when the risk-free rate was 6.4% and the market risk premium was 5.5%.  Now suppose the market risk premium d

Calculate the firms wacc, The Genesis operations management team, nearing c... The Genesis operations management team, nearing completion of its agreement with Sensible Essentials, was asked by senior management to present a capital plan for the operating exp

Factors affecting share prices, Factors Affecting Share Prices The ent... Factors Affecting Share Prices The entire sorts of influences affect share prices. These influences involves as: 1. The current profit record of the company particularly th

Prepare financial analysis of a company, Using the data provided in Appendi... Using the data provided in Appendix 1 prepare an analysis for the attention of the directors of Meridian Ltd. The analysis should highlight the strategic differences between the co

Sources of funds - finance, Sources of Funds - Finance Venture capital... Sources of Funds - Finance Venture capital, with combining risk financing along with marketing assistance and management, could become an effective instrument in fostering dev

Significant features of partnership, Significant Features of Partnership ... Significant Features of Partnership 1) The capital is contributed by the partners and no appeal is made to the public. 2) Like the sole proprietorship, a partnership has a l