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

Liquidity preference theory, Liquidity Preference Theory This theory s...

Liquidity Preference Theory This theory states that short term bonds are extremely favorable than long term bonds for two (2) purposes. 1. Investors usually prefer short te

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

Working Capital, AsStudents will analyze and synthesize the financial repor...

AsStudents will analyze and synthesize the financial reports of an organization of their choice and present their findings in a PowerPoint presentation (with completed Notes sectio

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

Explain about the new issue market, Explain about the New Issue Market OR P...

Explain about the New Issue Market OR Primary Market New issue market is the segment in which new issues are made. In new issue market, new issues may be made in 3 ways name

Foreign trade balance, Foreign Trade Balance If the Government buys or...

Foreign Trade Balance If the Government buys or imports much more than it sells or exports there will be a trade deficit such will require financing.The most important source

Dividend cover ratio, Dividend Cover Ratio Dividend cover = EPS/ DPS =...

Dividend Cover Ratio Dividend cover = EPS/ DPS = Earning to ordinary shares/Dividend paid       This signifies the number of times dividend can be paid from earnin

Risk adjusted discounting rate – methods of computing cost, Risk Adjusted D...

Risk Adjusted Discounting Rate - Methods of Computing Cost of Capital This method is used to establish the discounting rate to be used for a provided project. The cost of capi

Mortgage payment, Mr. and Mrs. smith are considering the purchase of a hous...

Mr. and Mrs. smith are considering the purchase of a house. They can afford to make  a mortgage payment of $750 per month. If the current mortgage interest rate is 9% with monthly

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