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

Factors that influence the cost of finance, Factors that Influence the Cost...

Factors that Influence the Cost of Finance 1. Terms of reference - if short term, the cost is generally low and vice versa. 2. Economic conditions prevailing - If a com

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

Solution to the agency conflict, Solution to the Agency Conflict The g...

Solution to the Agency Conflict The government can acquire the following actions to protect itself and its interests. 1. Acquire monitoring costs E.g. the gover

Maintain highest degree of accuracy, How can you maintain highest degree of...

How can you maintain highest degree of accuracy in reporting? For maintaining the highest degree of accuracy in reporting, we need to use the same chart of accounts being used

Estimate the present value of benefits, (a) A couple has just celebrated th...

(a) A couple has just celebrated their 25th wedding anniversary. What is the probability of them celebrating their 50th wedding anniversary, if the husband is aged exactly 50, his

Cost of debentures, Do you guys provide Cost of Debentures assignment help....

Do you guys provide Cost of Debentures assignment help. I need writing a report on Cost of Debentures and it is about 2000 words. Let me know. I need to buy your solution.

Secondary markets - financial markets, Secondary Markets - Financial Market...

Secondary Markets - Financial Markets Economic Benefits or Role of Secondary Markets in the Economy are as: 1. It provides people a chance to buy shares therefore distribut

Reasons for why ordinary share capital is attractive, Reasons for why Ordin...

Reasons for why Ordinary Share Capital is Attractive Reasons for why ordinary share capital is attractive despite to be risky Shares are used as securities for loans as

Production, Pick a product of your choice and identify the stages of produc...

Pick a product of your choice and identify the stages of production

Present value concept - discounted cash flow techniques, Present Value Conc...

Present Value Concept - Discounted Cash Flow Techniques This perception acknowledges the fact which a shilling losses value along with time and as that if it is to be compared

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