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

The importance of tax, Discuss business taxes and their importance in finan...

Discuss business taxes and their importance in financial decisions

Tests of term structure of interest rates theories, Tests of Term Structure...

Tests of Term Structure of Interest Rates Theories Various tests have been conducted mainly in USA and they show that all the three (3) theories have some validity and therefo

Functions of central depository system or cds, Functions of Central Deposit...

Functions of Central Depository System or CDS 1. Immobilization of securities that is removal of physical movement of securities. 2. Dematerialization that is removal of ph

Option Pricing, Show that for any constant 0=a=1, C(aK1 + (1-a)K2) = aC(K1)...

Show that for any constant 0=a=1, C(aK1 + (1-a)K2) = aC(K1) + (1-a)C(K2) where C(k) is the European option price with strike K. All the options in this question are assumed to be

Mgmt640, Monroe, Inc., is evaluating a project. The company uses a 13.8 per...

Monroe, Inc., is evaluating a project. The company uses a 13.8 percent discount rate for this project. Cost and cash flows are shown in the table. What is the NPV of the project?

Explain the method of offer of sale, Explain the method of Offer of Sale ...

Explain the method of Offer of Sale Method of offer of sale consists in outright sale of securities through intermediary of issue houses or share brokers. In other words, sh

Discuss capital budgeting techniques, Discuss capital budgeting technique...

Discuss capital budgeting techniques including : the Payback Rule, IRR, NPV, and the Profitability Index. Be sure to discuss the advantages and disadvantages of each one.  Di

Relationship among money, Relationships and interactions among money, bond,...

Relationships and interactions among money, bond, stock and mortgage markets

Stock exchange market, Stock Exchange Market The Idea and improvemen...

Stock Exchange Market The Idea and improvement of a Stock Exchange Stock exchange also identified as stock markets are special "market places" whereas already held bond

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