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

Australi a, i ordered case study 1 susam and malcom. when i open the docume...

i ordered case study 1 susam and malcom. when i open the document is completely different, not the same case study an is only relivent in the usa not australia... do you have the c

Determine the classification of new issue market, Classification of New Iss...

Classification of New Issue Market New market can be classified as: (i) A market where firms go to public for the first time through initial public offering (IPO). (ii

Financial planning processes, explain the financial planning process in a p...

explain the financial planning process in a private limited company

Calculate the volume of sales to earn profit, From the following informatio...

From the following information related to XYZ Ltd.; you are required to find out (a) contribution (b) Break-even point in units (c) Margin of safety, (d) Profit             Tota

Product mix, what are the qualitative factors to be considered when decidin...

what are the qualitative factors to be considered when deciding on product mix

Rights of ordinary shareholders, Rights of Ordinary Shareholders A. Ri...

Rights of Ordinary Shareholders A. Right to vote Choose BOD Purchase/Sales of assets B. Influence decisions as: Right to residual ass

Net Income Problem:, A firm has the following accounts: What is the net inc...

A firm has the following accounts: What is the net income for the period? Net patient revenue = $1,500,000 Supply expense = $200,000 Depreciation expense = $100,000 Salaries and b

Head office and branch or subsidiary, Head Office and Branch or Subsidiary ...

Head Office and Branch or Subsidiary MNC has diverse operations set up in dissimilar geographical locations. The HQ acts like the principal and the subsidiary like an agent he

Define financial factors that influence value of a business, List and expla...

List and explain the three financial factors that influence the value of a business. Ans: The three issues that influence the value of a firm's stock price are cash flow , ti

calculate the growth rate, The Mountain Fresh Company had earnings per sha...

The Mountain Fresh Company had earnings per share (EPS) of $6.32 in 2006 and $11.48 in 2011. The company pays out 30 percent of its earnings as dividends per share (DPS), and the

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