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

Financial markets, what are the main function of the derivative market

what are the main function of the derivative market

Stocks valuation, Supersoftware, Inc. earns a total of $200 million each ye...

Supersoftware, Inc. earns a total of $200 million each year to pay out to their 20 million shareholders. They are in a very competitive business and have found it a struggle to com

Calculate the average daily stock cost, Question: Unsatisfactory contro...

Question: Unsatisfactory control of spare parts in a particular mechanical workshop is resulting in high carrying costs for some items and high stock-out costs for others. A st

Book value and market to book value per share, Book Value and Market to boo...

Book Value and Market to book value per share Book value per share (BVPS)  = Net worth Equity/No. of ordinary shares It is called also liquidity ratio that show

Estate Planning, Paper on Estate Planning (3–5 pages) Evaluate the tools c...

Paper on Estate Planning (3–5 pages) Evaluate the tools commonly used in estate planning, including trusts, life insurance, and annuities. Compare the tools as to how they would a

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

Return on the annuity, An insurance company offers you and end of year annu...

An insurance company offers you and end of year annuity of $48,000 per year for the next 20 years. They claim your return on the annuity is 9%. What is the most you would be willin

Taxes, ADan lives in Duncan, a small town in Arizona. Because of a rare blo...

ADan lives in Duncan, a small town in Arizona. Because of a rare blood disease, Dan is required to take special medical treatments once a month. The closest place these treatments

Concepts in accounting, J inherited 30000 & decides to open a hair salon.ma...

J inherited 30000 & decides to open a hair salon.make arrangements 1/4/1016 commits 10000 to the business Opens an a/c under j hair salon What will be the amount under capital in

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