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
Suppose that two players are playing the following game.  Player A can choose either Top or Bottom, and Player B can choose either Left or Right.  The payoffs are given in the foll

Terms used in Capital Market Authority 1. ACCOUNTS fourteen (14) days durations into that the stock exchange trading calendar is divided. 2. ACCOUNTS DAY - Sixth or sev

explain the financial planning process in a private limited company

Internal finance can avoid the agency costs of debt and equity finance. In practice it is the most important source of funding.   (a)  Discuss potential problems of internal finan

Advantages of Central Depository System or CDS 1. It shortens the registration procedure in the stock exchange that is high speed of registering shareholders. 2. It improve

Benefits Ordinary Share Capital - Financing Benefits of using ordinary share capital in the financing They facilitate projects particularly long-term projects since they

Following the Initial Public Offering (IPO), the shares of Rosetta Stone, the language instruction company, jumped almost 44 percent from an initial price of $18 to $25.55 in late-

Creditors Trade - Measuring Business Performance Creditors Trade These are interested in the company's capability to meet their short-term obligations as and whenever the

Constant amount per share or fixed D.P.S. 1. The DPS is fixed in total amount of irrespective of the earnings level. These generate certainty and are consequently preferred vi

Shareholders and Creditors Shareholders And Creditors or bond or debenture holders Bondholders are lenders or providers of long term debt capital.  Usually they will provi