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

Necessity of risk adjusted hurdle rates for companies, Discuss the necessit...

Discuss the necessity of risk adjusted hurdle rates for companies with diverse lines of business. Every company invests in new projects based on the expectation of earnings

Concentration banking, Concentration Banking Firms along with regional...

Concentration Banking Firms along with regional sales outlets can designate specific of these as regional collection centre. Customers during these areas are necessitated to r

Partnerships - types of business organisations, Partnerships - Types of B...

Partnerships - Types of Business Organisations Defination "The relationship, that exists with persons carrying on a business in common by a view of profit." Formati

the trade-off theory of capital structure, Please describe the trade-off t...

Please describe the trade-off theory of capital structure and how it vary from the Modigliani and Miller theorem with taxes.

Private limited companies, Private Limited Companies These are NOT per...

Private Limited Companies These are NOT permitted to advertise their shares so like to attract public money and so that they sell their shares privately as recognized as priva

Sources of funds - finance, Sources of Funds - Finance Venture capital...

Sources of Funds - Finance Venture capital, with combining risk financing along with marketing assistance and management, could become an effective instrument in fostering dev

Capital budgeting, Definition of 'Capital Budgeting': The process in w...

Definition of 'Capital Budgeting': The process in which a business calculates whether projects such as building a new plant or investing in a long-term risk are worth pursuing

Motgage Broker Assgnment, ollowing a personal introduction, and before you ...

ollowing a personal introduction, and before you begin gathering information about the clients’ existing financial situation or needs, there are certain disclosures you are require

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

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