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

Acceptance rule of irr, Acceptance Rule of IRR IRR will accept a ventu...

Acceptance Rule of IRR IRR will accept a venture if its IRR is higher than or equivalent to the minimum required rate of return such is usually the cost of finance also recogn

investors are risk neutral, At t = 0, a 3-year, 7% coupon corporate bond w...

At t = 0, a 3-year, 7% coupon corporate bond with face value $1,000 is trading at a credit spread of 15%. The risk free rate is constant and equal to 4% for all maturities. The rec

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

Management of sole proprietorship, Management of Sole Proprietorship  I...

Management of Sole Proprietorship  In sole proprietorship the owner is usually in charge of day to day running of the business. If the business is large he may give some duties

THE CASE OF THE MISSING BONDS RATING, Three of these companies have bonds t...

Three of these companies have bonds that carry investment - grade ratings. The other 3 companies carry junk - bond ratings. Judging by the information in the table, which 3 compani

Calculate effective annual interest rate, 1 st bank offers you a car loa...

1 st bank offers you a car loan at an annual interest rate of 10% compounded monthly. What effective annual interest rate is the bank charging you?  Solution - Calculate

Example of conversion ratio and conversion price, Example of Conversion Rat...

Example of Conversion Ratio and Conversion Price ABC Company Ltd books as:   10.000, Sh.20 ordinary share capital 10,000, Shs.10 8% preference share c

Intro to finance, discuss the flow of fund in an open economy

discuss the flow of fund in an open economy

Explain the meaning of gross and net yield, Explain the meaning of Gross an...

Explain the meaning of Gross and Net Yield While gross yield refers to the yield realized by investor before paying taxes, net yield is what remains with him after paying th

Throughput accounting, state a case where throughput according system is re...

state a case where throughput according system is required

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