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

Determining the rules for resolving conflict, Instructions: Read the Herzbe...

Instructions: Read the Herzberg findings related to extrinsic and intrinsic factors driving job satisfaction, dissatisfaction and motivation. To what extent should employers feel r

Working capital, #question.component.of working capital

#question.component.of working capital

Clientele effect theory, Clientele Effect Theory Advance via Richardso...

Clientele Effect Theory Advance via Richardson Petit in 1977.It stated such different types of groups of shareholders or clientele have different type of preferences for divid

Valuation, (Interest-rate risk) Philadelphia Electric has many bonds tradin...

(Interest-rate risk) Philadelphia Electric has many bonds trading on the New York Stock Exchange. Suppose PhilEl''s bonds have identical coupon rates of 9.125% but that one issue m

PERDIEM CLAIM, how to make a perdiem claim format to maintain the records o...

how to make a perdiem claim format to maintain the records of staff

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

Parties include in central depository system, Parties include In Central De...

Parties include In Central Depository System 1. Government As like for the motive of attracting foreign supporting and investors the infrastructure of capital markets.

What is nominal and real return, What is Nominal and Real Return Whi...

What is Nominal and Real Return While nominal return is the return in nominal rupees, real return is equal to the nominal return adjusted for changes in prices i.e. rate of

Example of capital asset pricing model, Example of Capital Asset Pricing Mo...

Example of Capital Asset Pricing Model KK Ltd is an all equity firm whose Beta factor is 1.2, the interest rate on T. bills is currently at 8.5% and the market rate of return

Differences between qualitative and quantitative research, Problem: (a)...

Problem: (a) Describe why a critical analysis of the following is important while reading a research article: (i) The author, (ii) The date of publication. (b) What do

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