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

Describe the accruals-based financial statements, On 1 January 2008, a youn...

On 1 January 2008, a young artist called Michelangelo signed a contract with a charity named Art Angels, which supports young artists to do large projects. The agreement requires M

Calculate the monthly payment - annual percentage rate, You have just taken...

You have just taken out a $220,000 loan for your house at an APR of 7.5% and a 30-year term. Payments are to be made monthly . Two years from now, you refinance at an APR of 5.5%

Important points for capital market authority, Important Points for Capital...

Important Points for Capital Market Authority Apart from the above roles, CMA can assume the given steps to encourage progress of stock exchanges in US or other countries.

Compute appropriate net present value, Imagine Joy is the project coordinat...

Imagine Joy is the project coordinator in a company where four projects are running concurrently. He's employed you as the senior business analyst to perform some financial calcula

Hull-white model, Hull-White model As an extension of the Vasicek model...

Hull-White model As an extension of the Vasicek model, Hull-White model (1990) assumed that the short interest rate process follows the mean-reverting stochastic differential e

Gross requirements of mrp system, Gross requirements of MRP System Acc...

Gross requirements of MRP System Accumulation of demand for this item from all sources independent and dependent. For instance, customer orders, spare part requirements, repla

Advantagesand Disadvantages of IRR, Advantagesand Disadvantages of IRR ...

Advantagesand Disadvantages of IRR Advantages of IRR It seems time value of money It seems cash flows over the whole life of the project. It is compatible along

Student, evaluate the importance of leverage in financial management of a s...

evaluate the importance of leverage in financial management of a small scale company

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

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