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

Hatch system - stock exchange, Hatch System - Stock Exchange This is a...

Hatch System - Stock Exchange This is an automatic system based on the assumption such when investors sell at a certain percent age below the top of the market and buys at a s

Advantages of floatation of new shares, Advantages of Floatation of New Sha...

Advantages of Floatation of New Shares 1. It facilitates the matter of securities to increase new finance, creation a company less dependent on retained earnings and banks.

Management of inventories, Management of Inventories Manufacturing fir...

Management of Inventories Manufacturing firms contains three major kinds of inventories as: Work-in-progress Finished goods inventory Raw materials The firm

Market segmentation theory, Market Segmentation Theory This theory sta...

Market Segmentation Theory This theory states as the main investors lenders and borrowers are confined to a particular segment of the market and will not change even whether t

Advantage of joint stock companies, Advantage of Joint Stock Companies ...

Advantage of Joint Stock Companies The company can own assets and incur liabilities on its own accord. Perpetual existence as or going to relate that allows the compan

Example of miller-orr model, Example of Miller-Orr Model XYZ's managem...

Example of Miller-Orr Model XYZ's management has put the minimum cash balance to be equivalent to Sh.10, 000. The standard deviation of daily cash flow is of Sh.2, 500 and the

Broker - stock market, Broker - Stock Market 1. A dealer on the ...

Broker - Stock Market 1. A dealer on the market who that sells and buys securities on behalf of the public investors. 2. And he is an agent of investors 3. He is t

What do you understand by reinsurance, Question 1: (a) (i) What are A...

Question 1: (a) (i) What are Asset shares? (ii) State the purpose of calculating Asset shares. (b) Outline the five uses of policy Asset shares? (c) Lif

capm model is not suitable in an international setting, Why do several cri...

Why do several critics say the CAPM model is not suitable in an international setting? Please describe a way that the CAPM model could be adapted for international applications.

[email protected], 1-Suppose you deposit $ 5 000 in the bank. How much c...

1-Suppose you deposit $ 5 000 in the bank. How much can you raise after 10 years when discount rate is 5% for the first four years and then rises to 7% annually? 2 -A used car co

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