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

Uncertainty and safety stocks, Uncertainty and Safety Stocks Usually r...

Uncertainty and Safety Stocks Usually requirements may not be certain and thus the firm holds safety stock to safeguard stock out cases.The safety stock guards against delays

Traditional business of deposit taking and lending, Question 1: i) Disc...

Question 1: i) Discuss  the main risks facing a retail bank in its traditional business of deposit taking and lending? ii) How can a bank manage the risks related to credit

Define new issue market, Define New Issue Market New Issue Market OR P...

Define New Issue Market New Issue Market OR Primary Market New issue market is the segment in which new issues are made.

Rights of ordinary shareholders, Rights of Ordinary Shareholders A. Ri...

Rights of Ordinary Shareholders A. Right to vote Choose BOD Purchase/Sales of assets B. Influence decisions as: Right to residual ass

Contracting cost - agency costs, Contracting Cost - Agency Costs These...

Contracting Cost - Agency Costs These are costs acquired in devising the contract between the shareholders and managers. The contract is drawn to ensure management act in t

Traditional approach of financial management, traditional financial managem...

traditional financial management are concerned with raising funds and optimum utilisation.do you agree?explain.

Foreign trade balance, Foreign Trade Balance If the Government buys or...

Foreign Trade Balance If the Government buys or imports much more than it sells or exports there will be a trade deficit such will require financing.The most important source

Solutions - shareholders and management conflict, Solutions - Shareholders ...

Solutions - Shareholders and Management Conflict Conflicts between management and shareholders may be resolved as follows like: 1. Pegging or attaching managerial compens

Cash deficit and cash surplus, What is cash deficit?And what is cash surplu...

What is cash deficit?And what is cash surplus?Describe each of them in detail.

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