Find out maximum demand for medium model , Finance Basics

Assignment Help:

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.


Related Discussions:- Find out maximum demand for medium model

Example of dividend basis valuation, Example of Dividend Basis Valuatio...

Example of Dividend Basis Valuation Company Laxmi Synthetics pays a dividend of 10% on its Sh.60 par value ordinary shares.  This company uses a discount rate of 15%.  A

Cash management techniques, Cash Management Techniques The basic strat...

Cash Management Techniques The basic strategies that must be employed via the business firm in managing its cash are as: i) To pay account payables as behind as possible wi

Non-linear Break Even Analysis, International Data Systems information on r...

International Data Systems information on revenue and costs is only relevant up to a sales volume of 100,000 units. After 100,000 units, the market becomes saturated and the price

Advantagesand Disadvantages of IRR, Advantagesand Disadvantages of IRR ...

Advantagesand Disadvantages of IRR Advantages of IRR It seems time value of money It seems cash flows over the whole life of the project. It is compatible along

Explain the term - giving margin money to broker, Explain the Giving Margi...

Explain the Giving Margin Money to Broker Marin  is  the  amount  of  money  which is provided  by customer to the brokers who have agreed to trade their securities. It may

Debenture finance, Debenture Finance A type of long term debt raised a...

Debenture Finance A type of long term debt raised after a company sells debenture certificates to the holder and raises finance in return. The term debenture has its source fr

Time value of money problems, if you won the publisher''s clearing house $1...

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.

Setting a reorder point - rop, Setting a Reorder Point - ROP  Once the...

Setting a Reorder Point - ROP  Once the order quantity has been determined, the next question to be settled is when to place the order. If an order is released and it takes th

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd