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

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

Conservative approach - financing current assets, Conservative Approach - F...

Conservative Approach - Financing Current Assets An exact similar of asset life along with the life of the funds required to finance the asset may not be possible. A firm that

Finance, the real risk-free rate of interest is 4%. inflation is expected t...

the real risk-free rate of interest is 4%. inflation is expected to be 2% this year and 4% during the next 2 years. assume that the maturity risk premium is zero. what is the yield

Cash and marketable securities management, Cash and Marketable Securities M...

Cash and Marketable Securities Management The management of marketable and cash securities is single of the key areas of working capital management. Because cash and marketabl

State the determinants of return, State the Determinants of Return T...

State the Determinants of Return Three major determinants of the rate of return expected by investor are: (i) Time preference risk-free real rate. (ii) Expected rate o

Present annuity & future annuity, John has just retired & she is running ou...

John has just retired & she is running out of cash. Her finanical planner advises her to do reverse mortage to improve her standard of living. The current market value of her self

State about the odd-lot dealer, State about the Odd-lot Dealer He/she...

State about the Odd-lot Dealer He/she specializes in buying and selling in amounts which are less than present trading units. They buy and sell odd lots, make them up into ma

Characteristics of sole proprietorship, Characteristics of Sole Proprietors...

Characteristics of Sole Proprietorship A. It caters for customers' personal attention B. Accounts do not must be audited C. Limited to such finances like: F

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.

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