Find out maximum demand for medium model , Finance Basics

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







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
Related Questions
investment procedure of mutual fund

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

given profit margin 7%, total asset turnover is 1.94, Return on equity is 23.7%, what is the debt equity ratio

Discuss business taxes and their importance in financial decisions

how to make a perdiem claim format to maintain the records of staff

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 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 Difficult to reconstruct the capital Many formalities in forming the company Heavy initial capital outlay. Loss of secrec

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

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