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

Price - sales of goods, Price - Sales of Goods Like where section 10 p...

Price - Sales of Goods Like where section 10 provides such the price for goods may like fixed by like: (i) Contract; and one is (ii) The manner provided within the contr

FASB, FASB Assignment

FASB Assignment

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

Buying shares of a company, Buying Shares of a Company Factors should ...

Buying Shares of a Company Factors should be refer when Buying Shares of a Company 1. Economic situation of the country and other non-economic factors as like unfavorable c

#title. EM13545112., Define benefit plan for the employee participants

Define benefit plan for the employee participants

Determine the firms eps, The operating income of H Ltd amounts to Rs. 18600...

The operating income of H Ltd amounts to Rs. 186000. It pays 35% tax on its income. Its capital structure consists of the following: 14% Debentures

Shareholders and creditors, Shareholders and Creditors Shareholders A...

Shareholders and Creditors Shareholders And Creditors or bond or debenture holders Bondholders are lenders or providers of long term debt capital.  Usually they will provi

the trade-off theory of capital structure, Please describe the trade-off t...

Please describe the trade-off theory of capital structure and how it vary from the Modigliani and Miller theorem with taxes.

Setting of optimal cash balance, Setting of Optimal Cash Balance Cash ...

Setting of Optimal Cash Balance Cash is often identified like a non-earning asset since holding cash quite than a revenue-generating asset includes a cost in form of foregone

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