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

Traditional business of deposit taking and lending, Question 1: i) Disc...

Question 1: i) Discuss  the main risks facing a retail bank in its traditional business of deposit taking and lending? ii) How can a bank manage the risks related to credit

Liquidity ratios - ratio analysis, Liquidity Ratios - Ratio Analysis I...

Liquidity Ratios - Ratio Analysis It also identified as working capital ratios.  They show capability of the firm to meet its short term maturing financial obligation/recent l

Materials management - supply chain management, Materials Management - Supp...

Materials Management - Supply Chain Management Materials management was once a task undertaken without the assistance of computers. Today it is unthinkable as the speed of cal

Agency relationship between auditors and shareholders, Agency Relationship ...

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

Blue chips and going short or long on share - stock market, Blue Chips and ...

Blue Chips and Going Short or Long on Share - Stock Market Blue Chips Are first class securities of firms that have sound share capital and are internationally

Inventory management - supply chain management, Inventory Management - Supp...

Inventory Management - Supply Chain Management Determination of the best ordering policy in a manufacturing organisation In a manufacturing organisation, procurement may ha

Development of lease finance in middle asia, Development of Lease Finance i...

Development of Lease Finance in Middle Asia Reasons Why Lease Finance Is Not Well Developed In Middle Asia 1. Lease charges are generally prohibitive that is the cost

Sole proprietorship, Sole Proprietorship Definition - A sole proprietor...

Sole Proprietorship Definition - A sole proprietorship or sole tradership is the oldest and simplest form of business. It is that type of business organization where one person

Som120 project, Frequency distribution for amount charged with starting poi...

Frequency distribution for amount charged with starting point 1800, class width 1000. For income use starting point 20 and class width of 10.

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