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
Book Value and Market to book value per share Book value per share (BVPS)  = Net worth Equity/No. of ordinary shares It is called also liquidity ratio that show

The following information pertains to Fairways Driving Range, Inc.: The company is considering operating a new driving range facility in Sanford, FL. In order to do so, they will

Explain the meaning of Gross and Net Yield While gross yield refers to the yield realized by investor before paying taxes, net yield is what remains with him after paying th

Different Evaluation Horizons and MBO Different Evaluation Horizons Managers might undertake projects that are profitable in short-run. Shareholders on the other hand evalu

Business Ethics - Objectives of Business Entity Connected to the question of social responsibility is the matter of business ethics.  Ethics are explained as the "standards of

Asset Based Valuation - Example K and K Company Limited is planning to absorb three other companies so as to realize its sales records of Sh.500, 000 per annum.  Its accountan

The Mountain Fresh Company had earnings per share (EPS) of $6.32 in 2006 and $11.48 in 2011. The company pays out 30 percent of its earnings as dividends per share (DPS), and the

Leverage and Coverage Ratios   (The data for interest coverage are in I-Metrix's liquidity ratios section.  The others listed in this table are in the leverage ratios section

what will happen to the loss on account of premium redemption of debenture through sinking fund? Where do i close this account to?

Ask quQUESTION 1 1. In the ratio test used to determine whether a qualified plan is nondiscriminatory, what is the minimum percentage of nonhighly compensated employees who must be