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

What are the financial intermediaries, What are the financial intermediarie...

What are the financial intermediaries? Financial Intermediaries: a. Mutual funds b. Pension funds c. Life insurance companies d. Banks

Monitoring costs - agency costs, Monitoring Costs - Agency Costs This ...

Monitoring Costs - Agency Costs This is incurred to prevent undesirable managerial actions. They are meant to ensure that both parties live to the spirit of agency contract. T

Capital market authority (cma), Capital Market Authority (CMA) Was est...

Capital Market Authority (CMA) Was established in 1990 with an Act of Parliament to assist, in creation of a conducive environment, for growth and development of capital marke

Profit maximization - objectives of business entity, Profit maximization - ...

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

Political and technological factor - investment decisions, Political Factor...

Political Factors and Technological Factors - Investment Decisions i) Political factors - Under conditions of political uncertainty, that decisions cannot be completed as it

Define the process of opening an account with broker, Define the process of...

Define the process of Opening an Account with Broker After a broker has been selected, the investor has to place an order on the broker. The broker will open an account in t

Calculate the current ratio, For each of the financial statement ratios lis...

For each of the financial statement ratios listed below calculate the ratio for the current year and for the prior year. (Note that in most textbooks, some of the ratios call for a

Methods of analyzing investment, Methods of Analyzing Investment Capit...

Methods of Analyzing Investment Capital Budgeting Methods There are two process of analyzing the viability of such investment as: a) Traditional process Pay

In 1899, If the winner’s prize increases at the same rate (8.43%), what wil...

If the winner’s prize increases at the same rate (8.43%), what will it be in 2041?

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