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

Cbk - monetary policy, CBK - Monetary Policy The money supply in the e...

CBK - Monetary Policy The money supply in the economy has a main effect on both the rate of inflation and the level of economic activity. The level of money supply is controll

Debentures of middle asia, Debentures of Middle Asia Reasons behind Un...

Debentures of Middle Asia Reasons behind Unpopularity of Debentures of middle Asia's Financial Market as: i)Their par price is an extremely high value and as such they are

Hi, continous time finaince expert

continous time finaince expert

Determinants of Interest rate, What are the factors that affect the interes...

What are the factors that affect the interest rate and how?

Determaine the dol and business risk, From the following selected operating...

From the following selected operating date, determaine the DOL. Which company has the greater amount of business risk? Why? Particulars A Ltd

Future value of single or multiple cash flows, Do your experts provide Futu...

Do your experts provide Future Value of Single or Multiple Cash Flows assignment help? I need urgent help in my college assignment.

Financial analysis , You are required to select any one company of your cho...

You are required to select any one company of your choice which is listed on either Dubai Financial Market (DFM) or Abu Dhabi Securities Market (ADSM). Send me an email giving at l

Mony and finance, mony is differnt from wealth and income

mony is differnt from wealth and income

Dividend yield or gordon''s model, Dividend yield or Gordon's Model Th...

Dividend yield or Gordon's Model This model is used to determine the cost of various capital components in particular: Cost of equity - K e Cost of preferenc

Find out maximum demand for medium model , A company that manufactures elec...

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

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