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

What is expected return, 1. Using the variance-covariance matrix (∑) and th...

1. Using the variance-covariance matrix (∑) and the expected return vector (er) given in the appendix, calculate the set of weights that correspond to the portfolio that maximizes

Tests of term structure of interest rates theories, Tests of Term Structure...

Tests of Term Structure of Interest Rates Theories Various tests have been conducted mainly in USA and they show that all the three (3) theories have some validity and therefo

Financial analysis, Financial analysis: Financial analysis (also defin...

Financial analysis: Financial analysis (also defined to as financial statement analysis or accounting analysis or Analysis of finance) defines to an assessment of the viabilit

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

What is holding period return, What is Holding Period Return/Return ...

What is Holding Period Return/Return Holding period yield (HPY) measures the total return from an investment during a given time period in which asset is held by the investo

Finance, This case has been framed in order to test the skills in evaluatin...

This case has been framed in order to test the skills in evaluating a credit request and reaching a correct decision

Blue chips and going short or long on share - stock market, Blue Chips and ...

Blue Chips and Going Short or Long on Share - Stock Market Blue Chips Are first class securities of firms that have sound share capital and are internationally

Different evaluation horizons and mbo, Different Evaluation Horizons and MB...

Different Evaluation Horizons and MBO Different Evaluation Horizons Managers might undertake projects that are profitable in short-run. Shareholders on the other hand evalu

Setting a reorder point - rop, Setting a Reorder Point - ROP  Once the...

Setting a Reorder Point - ROP  Once the order quantity has been determined, the next question to be settled is when to place the order. If an order is released and it takes th

Investment bank, Investment Bank A lending entity is engaged in all the...

Investment Bank A lending entity is engaged in all the phases of privacy offerings the including managing, underwriting, trading, and the distributing new security issues.

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