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

Average rate of return - down payment, 1.  Determine what is the future val...

1.  Determine what is the future value of $20 a week for 10 (ten) years at 6 percent interest? Assume the first payment takes place at the end of this week. 2.  Kristina started

Analysis, Inventories turnover 8 times 4 times Re...

Inventories turnover 8 times 4 times Receivable days 63 days 40 days

OPTION, DEFINE THE TERM OPTION IN DETAIL?

DEFINE THE TERM OPTION IN DETAIL?

Find out weighted average cost of capital, Mermaid Coffee Corporation (MCC)...

Mermaid Coffee Corporation (MCC) has 1,000,000 shares of stock currently trading at $42 per share. The company has issued 20,000 bonds, each with market value $928.59 and yield to

Limitations of ratio, Limitations of Ratio Ratios have weaknesses as f...

Limitations of Ratio Ratios have weaknesses as following like: 1. They avoid the size of the firm being compared as in cross-sectional analysis; the firm being compared m

Computation of payback period method, Computation of Payback Period Method ...

Computation of Payback Period Method 1. Under uniform annual incremental cash inflows - if the venture or an asset generates uniform cash inflows then the payback period (PB

Public finance, models of solving externalities in 1) external sector 2)pr...

models of solving externalities in 1) external sector 2)private sector

Stocks valuation, Supersoftware, Inc. earns a total of $200 million each ye...

Supersoftware, Inc. earns a total of $200 million each year to pay out to their 20 million shareholders. They are in a very competitive business and have found it a struggle to com

Memo 1, Mr. de Ville, the owner of Tasman Ian de Ville Holdings Ltd. (TIDH)...

Mr. de Ville, the owner of Tasman Ian de Ville Holdings Ltd. (TIDH) has asked you to evaluate five investment projects. TIDH has a $10,000,000 investment budget, an investment hurd

Debt finance in us of small companies, Debt Finance in US of Small Companie...

Debt Finance in US of Small Companies Why It CAN Be Difficult For Small Companies to Raise Debt Finance in US Lack of safety avoidances of finances available

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