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

Hatch System - Stock Exchange This is an automatic system based on the assumption such when investors sell at a certain percent age below the top of the market and buys at a s

Lease Finance Leasing is a contract between one party called lessor as owner of asset and other called lessee whereas the lessee is provided the right to utilize the asset as


What is the Execution of order in the Stock Exchange When broker receives the margin money and is clear about the order received by him, he puts details in the 'order book'.

Present Value of Uneven Periodic Sum - DCF Technique As in investment decisions it is very rare to acquire even periodic returns and in most cases a company will generate a st

Measuring Business Performance Definition Financial analysis is a process via that finance identifies the company's financial performances with comparing the entities in

Find the costs of financing for two schedules of monthly payments on a 25-year mortgage. The cash value of the house today is $500,000. You are paying monthly at a fixed rate of 6%

if you won the publisher''s clearing house $10 million prize (payable as 30 pmts of $250,000 and $2.5m in yr. 30) and could invest the money at 8%, would you accept an offer of $3.

XYZ Ltd. has an average selling price of Rs.10 per unit. Its variable cost are Rs.7 , and fixed cost amount to Rs.170000. it finances all its assets by equity funds. It pays 35% ta