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

Profitability in relation to investment, Profitability in relation to inves...

Profitability in relation to investment - Profitability Ratio a) Return on Investment (ROI) or return on total asset (ROTA) = (Net profit/ Total asset) x 100 The ratio i

Conservative approach - financing current assets, Conservative Approach - F...

Conservative Approach - Financing Current Assets An exact similar of asset life along with the life of the funds required to finance the asset may not be possible. A firm that

Valuation a d rates of return, You are called in as a financial analyst to ...

You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 13 percent, which is pai

What is bond rate, What is Bond Rate It is interest rate received on...

What is Bond Rate It is interest rate received on the face value or the par value of the bond. If a company or government issues a 10-year bond with 100$ as face value and 1

Market is in equilibrium, You are taking an investment in the common stock ...

You are taking an investment in the common stock of Crisp's Cookware. The stock is expected to pay a dividend of $2.00 a share at the end of the year (D1=2.00). The stock has a bet

Draw a bar chart, The construction of a highway is broken into 14 activitie...

The construction of a highway is broken into 14 activities as shown in the following table. Draw a bar chart of this construction project. Activity ID Desc

Define new issue market, Define New Issue Market New Issue Market OR P...

Define New Issue Market New Issue Market OR Primary Market New issue market is the segment in which new issues are made.

Requirements for raising loan, Requirements for Raising Loan Requireme...

Requirements for Raising Loan Requirements for Raising Loan are as follow: a) Subsidiaries of the company and History. b) Qualifications, ages, and names of the company's dire

Assignment, Following details are related to three companies which are iden...

Following details are related to three companies which are identical except in terms of ''''r''''. Company ABC Ltd. MNC Ltd. XYZ Ltd. Cost of capital 10% 10% 10% Earn per Share Rs

Managing financial resources, Two friends, Alan & Tim just graduated from t...

Two friends, Alan & Tim just graduated from the college. They plan to start their own business, of selling health foods for office workers. They have identified a commercial comple

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