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

P/E ratio, How are earnings calculated for the Pe ratio?

How are earnings calculated for the Pe ratio?

Explain credit risk and counterparty risk, Your boss has worked in banking ...

Your boss has worked in banking for many years, and has specialised during his career in lending to large and medium-sized companies. He must attend a meeting in a few days' time t

Finance, Pls help with this + provide references > Briefly outline the mos...

Pls help with this + provide references > Briefly outline the most recent balance of payments experience for China and comment on whether the balance of payments situation will ha

Required Return.., Valuing Preferred Stock Gest, Inc has an issue of prefer...

Valuing Preferred Stock Gest, Inc has an issue of preferred stock outstanding that pays a $4.50 dividend every year in perpetuity. If this issue currently sells for for $79.85 per

Example of net present value method, Example of Net Present Value Method ...

Example of Net Present Value Method Cost of investment = 100,000/=, Interest rate = 10percent, Inflows year 1 = 80,000/= Year 2 = 50,000/= NPV   = 80,000 / 1.1 + 5

Determination of the coupon rate, The partners are still unhappy about one ...

The partners are still unhappy about one of the features of your analysis, namely your assumption that the coupon rate of the bond is equal to 6% per annum. Their thinking is that

Find out total amount of sales, Imagine Joy is the sales manager in a compu...

Imagine Joy is the sales manager in a computer retail company and has summarized for each sales transaction the following information: Sales person Date of sales Uni

investors are risk neutral, At t = 0, a 3-year, 7% coupon corporate bond w...

At t = 0, a 3-year, 7% coupon corporate bond with face value $1,000 is trading at a credit spread of 15%. The risk free rate is constant and equal to 4% for all maturities. The rec

Business activity cycle, Business Activity Cycle The interest rates al...

Business Activity Cycle The interest rates also depend on business cycles as above. Because the economy moves in the four (4) business cycles, such interest rates will shift l

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