Find out maximum demand for medium model , Finance Basics

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.

Posted Date: 3/18/2013 4:18:37 AM | Location : United States







Related Discussions:- Find out maximum demand for medium model , Assignment Help, Ask Question on Find out maximum demand for medium model , Get Answer, Expert's Help, Find out maximum demand for medium model Discussions

Write discussion on Find out maximum demand for medium model
Your posts are moderated
Related Questions
Use the concepts of marginal cost and marginal revenue to derive an optimal capital budget for Company X, which has identified 7 possible investment projects and determined its cos

The scope of supply chain management  Supply chain management includes the determination of suppliers; distributors, distribution channels and warehousing; manufacturing infor

give an introduction about stock exchage in india,,includig BSE

Agency Relationship between Auditors and Shareholders Shareholders appoint auditors as per the provisions of Section 159(1)-(6) of the Companies Act. The auditors are believed

Suggestion regarding Credit limit. Should it be approved or not, what should be the amount of credit limit that electronics give to Booth Plastics.

Shareholders and Creditors Shareholders And Creditors or bond or debenture holders Bondholders are lenders or providers of long term debt capital.  Usually they will provi

Define the term Public Issues - Floating New Issues Under this method, issuing company directly offers to general public/institutions a fixed number of shares

Profit maximization - Objectives of Business Entity Conventionally, this was considered to be the main goal of the firm. Profit maximization refers to getting the highest poss

Earnings Method or Earning Basis Valuation By using the earning valuation method, a company will employ its P/E ratio to value its shares. P/E    =  MV/E MV    =   E x P

Bates, inc. pays a dividend of $1.25 and is currently selling for $36.95. If investors require a 12% return on their investment, what growth rate would Bates Inc. have to provide t