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

Business finance and financial management, Business Finance and Financial M...

Business Finance and Financial Management Business finance is the process through which a financial manager or accountant gives finance for business use as and whenever it i

List three career opportunities in the field of finance, List and describe ...

List and describe the three career opportunities in the field of finance. Finance has three major career paths that are financial management, financial markets and institutions

Mm dividend irrelevance theory, MM Dividend Irrelevance Theory Such wa...

MM Dividend Irrelevance Theory Such was advanced via Modigliani and Miller in 1961.  The theory asserts to a firm's dividend policy has no effect on cost of capital and on its

Nash equilibrium, Suppose that two players are playing the following game. ...

Suppose that two players are playing the following game.  Player A can choose either Top or Bottom, and Player B can choose either Left or Right.  The payoffs are given in the foll

Example of payback period method, Example of Payback Period Method Sup...

Example of Payback Period Method Suppose a project costs Sh.80,000 and will produce the following cash inflows as:                                  Cash inflows      Accumu

Types of partners, Types of Partners 1. General Partners -Unlimited ac...

Types of Partners 1. General Partners -Unlimited active and liability in participation in partnership activities. 2. Limited partners - Limited liability in the management of

Strike price and putable bond, Analysis of the bond issue (a) Show that...

Analysis of the bond issue (a) Show that the price of the bond is equal to that of a portfolio which contains i) a long position in an option-free but otherwise identical co

Should the short-run effects on eps influence the ch, A firm has a $100 mil...

A firm has a $100 million capital budget. It is considering two project, each costing $100 million. Project A has an IRR of 20%; has an NPV of $9 million; and will be terminated af

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