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

policies decided by the proprietor, Some of the policies decided by the pr...

Some of the policies decided by the proprietor are: 1) Time of operating the business 2) Promotion through advertising or special offers 3) Dealing with suppliers and cus

Fixed Exchange vs Flexible Exchange Rate, Critize the flexible exchange rat...

Critize the flexible exchange rate regime from the viewpoint of the proponents of the fixed exchange rate regime

Dividend policy, Charleston Industrial revised its dividend policy and deci...

Charleston Industrial revised its dividend policy and decided that it wants to maintain a retained earnings account of $1 million. The company''s retained earnings account at the e

Explain about commercial banks in depository institutions, Explain about co...

Explain about commercial banks in depository institutions. Commercial banks: Commercial banks accept deposits or liabilities to create loans or assets and to buy governme

Payback period method - traditional methods, Payback Period Method - Tradit...

Payback Period Method - Traditional Methods This method gauges the viability of a venture via taking the outflows and inflows over time to ascertain how soon a venture can pay

Unadjusted, $1,000 of insurance had not been used up by January 31. $325 of...

$1,000 of insurance had not been used up by January 31. $325 of insurance had been used up in January

C.O.L.A., What are some good examples of C.O.L.A?

What are some good examples of C.O.L.A?

Working capital cycle, Working Capital Cycle The Concept of Working C...

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

Importance of interest rates, Importance of Interest Rates These are o...

Importance of Interest Rates These are of a specifically relevance to a finance manager since: i) They measure the cost of borrowing. ii) Interest rates in a country influen

How are financial trades made on an organized exchange, How are financial t...

How are financial trades made on an organized exchange? Ans: Each exchange-listed security is traded at a fixed location on the trading floor known as the post. The trading is

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