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

Estimate the coupon rate and promised rate on bond, Petroleo Brasileiro (PB...

Petroleo Brasileiro (PBR) has just issued 1M one year bonds. Each bond hasa face value of1,000 Reais. Owners of the bonds are entitled to receive $R 1000 back at the end of the yea

Explain about the monetary role of banks, Explain about the monetary role o...

Explain about the monetary role of banks. The Monetary Role of Banks: • A bank is a financial intermediary. • Bank reserves are the currency banks hold within their va

Example of eoq assumptions, Example of EOQ Assumptions ABC Ltd require...

Example of EOQ Assumptions ABC Ltd requires 2,000 units of a component in its manufacturing method in the coming year that costs of Sh.50 each. The items are obtainable locall

AGENCY, explain any four actions or transactions by shareholders that could...

explain any four actions or transactions by shareholders that could be harmful to the interests of debt holders (sources of conflict). estion #Minimum 100 words accepted#

Agency theory - finance, Agency Theory The agency problem between mana...

Agency Theory The agency problem between managers and shareholders can be resolved via paying high dividends. If retention is low, managers are necessary to increase additiona

Decision Analysis, 2 Questions QUESTION #1 LAPTOP SELECTION Jonna is in ...

2 Questions QUESTION #1 LAPTOP SELECTION Jonna is in market to buy a new laptop. Six different machines are under consideration. All laptops are essentially the same, but they v

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

Maximum price of uniformed bonds, Say that a buyer of bonds values good bon...

Say that a buyer of bonds values good bonds at $500 and values bad bonds at $250. Sellers of both good and bad bonds value them at $350. If the fraction of good sellers and bad s

What are the financial intermediaries, What are the financial intermediarie...

What are the financial intermediaries? Financial Intermediaries: a. Mutual funds b. Pension funds c. Life insurance companies d. Banks

Net Income Problem:, A firm has the following accounts: What is the net inc...

A firm has the following accounts: What is the net income for the period? Net patient revenue = $1,500,000 Supply expense = $200,000 Depreciation expense = $100,000 Salaries and b

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