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
monthly income $7,000 Monthly repay $911 what is the maximum I qualify for

new features of insurance?

what are the difference between receipt and payment account and income and expenditure account ?

Compute the risk premium for the stock of Omega Tools if the risk free rate is 6%, the expected market return is 12%, and Omega's stock has a beta of .8.    Ome

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

1.  Determine what is the future value of $20 a week for 10 (ten) years at 6 percent interest? Assume the first payment takes place at the end of this week. 2.  Kristina started

A manufacturing organisation has three production cost centres, the cutting department, the processing department and the finishing department, and two service cost centres, the st

I need a report on Specific Cost. Can you please assist me for Specific Cost report for about 2500 words?

Working Capital Cycle The Concept of Working Capital/Cash Operating Cycle Working capital cycle refers to period such elapses between the payment for raw materials bought

Type of Partnerships There are two main kinds of partnerships. Namely: Ordinary Partnership - An ordinary partnership is one in which all members have unlimited liability.