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

Illustrates the roles of money, Illustrates the roles of money? Roles...

Illustrates the roles of money? Roles of Money: a. A medium of exchange An asset which individuals obtain for the intention of trading quite than for their own consump

Finc310, •How did the stock market indices react to these changes? •How di...

•How did the stock market indices react to these changes? •How did long-term U.S. Treasury bond yields react to these changes? •What happens to borrowers, savers, investors, and

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

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

Example of miller-orr model, Example of Miller-Orr Model XYZ's managem...

Example of Miller-Orr Model XYZ's management has put the minimum cash balance to be equivalent to Sh.10, 000. The standard deviation of daily cash flow is of Sh.2, 500 and the

CH 4 Problems, Homework Chapter 4 A mortgage loan in the amount of $100,000...

Homework Chapter 4 A mortgage loan in the amount of $100,000 is made at 12% interest for 20 years. Payments are to be monthly in each part of this problem. a. What will monthly

Fixed Exchange vs Flexible Exchange Rate, Critize the flexible exchange rat...

Critize the flexible exchange rate regime from the viewpoint of the proponents of the fixed exchange rate regime

Commercial banks - banking institutions, Commercial Banks - Banking Institu...

Commercial Banks - Banking Institutions These are financial institutions such accept deposits of money from the universal public, safeguard the deposits and create them availa

State the classification of new issue market, State the Classification of N...

State the Classification of New Issue Market New market can be categorized as: (i) A market where firms go to the public for the first time through initial public offerin

The return on the preferred stock, BAC is considering an issue of preferred...

BAC is considering an issue of preferred stock.  The dividends are 8.12% of the $25 par value. a.    If the present price is $26.25 per share, what is the return on the preferre

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