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

Proforma balance sheet, Proforma Balance Sheet This refers to the proj...

Proforma Balance Sheet This refers to the projected balance sheet at the finish of forecasting period.  The items in the proforma balance that vary with sales would be determi

Calculate the total increment prize, Prudence buys a bond in EUR when it is...

Prudence buys a bond in EUR when it issued by the French government and inflation linked.  It offers a 2% yearly coupon.  She holds it for five years.             Par value: EUR

Bank draft, what is bank draft?How it can be prepared?

what is bank draft?How it can be prepared?

Interpolation method, Interpolation method Consequently, r denote...

Interpolation method Consequently, r denotes required rate of return Consequently, r = 14 percent + (15 percent - 14 percent) x 253 .646 /253 .646 + 5.375

Income statement-balance sheet and cash flow, Looking at the income stateme...

Looking at the income statement, balance sheet and cash flow statement of the company and relating it with the non financial factors, I have the important observations as below:-

Mony and finance, mony is differnt from wealth and income

mony is differnt from wealth and income

Explain the term - giving margin money to broker, Explain the Giving Margi...

Explain the Giving Margin Money to Broker Marin  is  the  amount  of  money  which is provided  by customer to the brokers who have agreed to trade their securities. It may

What are the functions of stock exchange, What are the Functions of Stock E...

What are the Functions of Stock Exchange Main functions performed b stock exchange are as follows: (1) Providing Liquidity and Marketability to existing securities: Sto

Finance.., the nominal fee interest rate in your account is 7% your semi-an...

the nominal fee interest rate in your account is 7% your semi-annually rate of interest APY will be?

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