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

Disadvantages of floatation of new shares, Disadvantages of Floatation of N...

Disadvantages of Floatation of New Shares 1. The cost of getting a quotation is high, mainly when a new issue of shares is completed and the company is small. It means that su

Management of company and directors, Management of company and Directors ...

Management of company and Directors They will consequently be interest in as: a) In generating profits efficiency of the company b) The company's capability to generate

Tax differential theory, Tax Differential Theory Advanced via Lichtenb...

Tax Differential Theory Advanced via Lichtenberger and Ramaswamy in 1979.They argued that tax rate on dividends is higher quite than tax rate on capital gains. Thus, a firm th

Partnership, Partnership Definition -Partnership may be defined as a re...

Partnership Definition -Partnership may be defined as a relationship between persons carrying on a business in common with a view of profits. In partnership business, two or mo

Venture capital, Venture Capital Venture capital is a form of investme...

Venture Capital Venture capital is a form of investment in new small risky enterprises utilized to get them started via specialists called venture capitalists. Venture capital

Acd, Struggling with your final year projects, terms paper writing, researc...

Struggling with your final year projects, terms paper writing, research paper writing, thesis writing, engineering and programming projects? Experts are available 24x7 to help you

Fiscal federalism, What are the principles of multiunit finance?

What are the principles of multiunit finance?

Draw a graph and use the supply and demand analysis, If banks expect an unu...

If banks expect an unusually large increase in withdraws from checking deposit accounts in the near future, what would happen to the federal funds rate, borrowed reserves and nonbo

Executive share options plans, Executive Share Options Plans In a shar...

Executive Share Options Plans In a share option format, selected staff can be provided a number of share alternatives, each of which that provides the holder the right after a

The return on the preferred stock, BAC is considering an issue of preferred...

BAC is considering an issue of preferred stock.  The dividends are 8.12% of the $25 par value. a.    If the present price is $26.25 per share, what is the return on the preferre

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