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

Advantage and disadvantage of sole proprietorship, Advantage and Disadvanta...

Advantage and Disadvantage of Sole Proprietorship Advantage of Sole Proprietorship High supervision of employees Income motivate owner Sole trade mostly ski

internal rate of return, Internal Rate of Return, I am looking for assignm...

Internal Rate of Return, I am looking for assignment help on the topic Internal Rate of Return. It would be great if anyone help me.

Future value of single or multiple cash flows, Do your experts provide Futu...

Do your experts provide Future Value of Single or Multiple Cash Flows assignment help? I need urgent help in my college assignment.

Calculate the percentage of equity of firm sells, Consider an economy with ...

Consider an economy with three dates {t=0, 1, 2}. A firm has assets in place that generate an output (profit) of either 40 in state L or 160 in state H at t=2. Bothe states equally

Investment options - bond yields, John has just inherited $50,000 from his ...

John has just inherited $50,000 from his Uncle Ted. John is currently studying his Bachelor of Accounting degree at CQUniversity part-time and has three (3) years of study remainin

Financial statement, Review the budget below and answer the questions follo...

Review the budget below and answer the questions following the budget. FINANCIAL ACCOUNTING—STATEMENT OF REVENUE AND EXPENSES Statement of Revenue and Expenses for Group Practice f

Role of stock exchange in economic development, Role of Stock Exchange in E...

Role of Stock Exchange in Economic Development The Roles of Stock Exchange in Economic Development are as follow: 1. Raising Capital for Businesses The Stock Exchange

Rajendra kumar, whom do you think rajendra should eat with and why

whom do you think rajendra should eat with and why

The cfo estimates, Klose Outfitters Inc. believes that its optimal capital ...

Klose Outfitters Inc. believes that its optimal capital structure having of 60% common equity and 40% debt, and its tax rate is 40%. Klose have raise additional capital to fund its

Working Capital, AsStudents will analyze and synthesize the financial repor...

AsStudents will analyze and synthesize the financial reports of an organization of their choice and present their findings in a PowerPoint presentation (with completed Notes sectio

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