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

Describe the duties of the financial manager, Describe the duties of the fi...

Describe the duties of the financial manager in a business firm? Financial managers calculate the firm's performance, define what the financial consequences will be if the firm

Solutions - shareholders and management conflict, Solutions - Shareholders ...

Solutions - Shareholders and Management Conflict Conflicts between management and shareholders may be resolved as follows like: 1. Pegging or attaching managerial compens

Tarniwala and dealer in non-cleared securities, Tarniwala and Dealer in N...

Tarniwala and Dealer in Non-cleared Securities Tarniwala: He/she is a specialist or jobber in selected shares. He/she makes market i.e. provide continuity to dealings. They

What are depository institutions, What are depository institutions? Dep...

What are depository institutions? Depository institutions: intermediaries along with an important proportion of their funds derived through customer deposits as consists of: co

what is their average aggregate inventory value, 1. The Marlin Company ope...

1. The Marlin Company operates 50 weeks a year, and its cost of goods sold last year was $1,500,000. The firm carries six items in inventory: three raw materials, two work-in-proce

#title.ASF, Ask questioAustralian’s Speleological App Projectn #Minimum 100...

Ask questioAustralian’s Speleological App Projectn #Minimum 100 words accepted#

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

Asset based valuation - example, Asset Based Valuation - Example K and...

Asset Based Valuation - Example K and K Company Limited is planning to absorb three other companies so as to realize its sales records of Sh.500, 000 per annum.  Its accountan

Cost of redeemable debentures and preference shares, Cost of Redeemable Deb...

Cost of Redeemable Debentures and Preference Shares Redeemable fixed return securities have an exact maturity period.  The cost of those securities is called redemption yield

Computation of payback period method, Computation of Payback Period Method ...

Computation of Payback Period Method 1. Under uniform annual incremental cash inflows - if the venture or an asset generates uniform cash inflows then the payback period (PB

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