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
Acceptance Rule of IRR IRR will accept a venture if its IRR is higher than or equivalent to the minimum required rate of return such is usually the cost of finance also recogn

Advantages of Floatation of New Shares 1. It facilitates the matter of securities to increase new finance, creation a company less dependent on retained earnings and banks.

evaluate the source of finance for a business project

Ask questioSay that a buyer of bonds values good bonds at $500 and values bad bonds at $250. Sellers of both good and bad bonds value them at $350. If the fraction of good sellers

The Balance Sheet of Bharat Machinery Ltd., as on December 31, 2009 and 2010 are as follows:  Items Dec. 31, 2009 Rs. Dec. 31, 2010 Rs.

A City has determined that building a new water distribution system using a new source of water would have an annual costs of $5,750,000 and annual net benefits of $4,250,000. The

1.  Suppose you would like to buy a house and you decided you can pay 3500 per month for 30 years.  Your bank has approved you for a 30-year fixed rate mortgage loan at a quoted AP

"Managerial leadership considers that the focus of school leaders ought to be on functions, tasks and behaviours and if these functions are carried out competently the work of othe

What do you mean listing of securities? Explain. Listing of Securities: Listing means admission of the securities to dealings on a recognized stock exchange. Securities of an

The following is the existing capital structure of Company XYZ Ltd. Ordinary shares at Shs.10 par 1,000,000 Retained 800,000 12% preference shares Shs.10 par 400,000 16% loan Shs.1