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

Example of baumol's model, Example of Baumol's Model ABC Ltd. creates ...

Example of Baumol's Model ABC Ltd. creates cash payments of Shs.10, 000 per week.  The interest rate at marketable securities is 12 percent and every moment the company sells

Optimal Capital Budgeting, Capital Corporation, which has a target capital ...

Capital Corporation, which has a target capital structure of 40 percent debt and 60 percent common equity, is evaluating an expansion project with an 8.5 percent IRR. The project c

Leverage or gearing ratios, Leverage or Gearing Ratios Leverage or gea...

Leverage or Gearing Ratios Leverage or gearing ratios are as follow: a) Debt ratio = Total debts/Total assets Whereas total debt = fixed charge capital + liabilities.

Computing the real rate & flat tax, Quetion1: You are earning 5.2 percent ...

Quetion1: You are earning 5.2 percent on a certificate of deposit. Inflation is running 3.5 percent. What is the real rate of return on your investment? Question2: Search for

Illustrate the advantages of underwriting, Illustrate the Advantages of Und...

Illustrate the Advantages of Underwriting Underwriting presumes great significance as it offers the below benefits to the issuing company: (i) Issuing company is relied f

Development of lease finance in middle asia, Development of Lease Finance i...

Development of Lease Finance in Middle Asia Reasons Why Lease Finance Is Not Well Developed In Middle Asia 1. Lease charges are generally prohibitive that is the cost

IRR, How to compute the IRR of data

How to compute the IRR of data

Finance Assignment, I have an assignment for my finance class. The company ...

I have an assignment for my finance class. The company that i have FOR industry analysis is COSTCO WHOLESALES CORP THAT ITS STOCK IS IN DISCOUNT AND VARIETY StORES INDUSTRY. I need

Overdraft finance, Overdraft Finance This finance is perfect to need a...

Overdraft Finance This finance is perfect to need as bridging finance in sense such should be required to solve the company's short term liquidity problems in specific those o

State the classification of new issue market, State the Classification of N...

State the Classification of New Issue Market New market can be categorized as: (i) A market where firms go to the public for the first time through initial public offerin

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