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

Significance of cost of finance, Significance of Cost of Finance The...

Significance of Cost of Finance The cost of capital is Significance since of its application in the following areas as: i) Long-term investment decisions - In capital b

Financial analysis , You are required to select any one company of your cho...

You are required to select any one company of your choice which is listed on either Dubai Financial Market (DFM) or Abu Dhabi Securities Market (ADSM). Send me an email giving at l

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?

Advantages of floatation of new shares, Advantages of Floatation of New Sha...

Advantages of Floatation of New Shares 1. It facilitates the matter of securities to increase new finance, creation a company less dependent on retained earnings and banks.

Present value concept - discounted cash flow techniques, Present Value Conc...

Present Value Concept - Discounted Cash Flow Techniques This perception acknowledges the fact which a shilling losses value along with time and as that if it is to be compared

Homework, the two problems below (P1 and P2). Five marks each. Part marks w...

the two problems below (P1 and P2). Five marks each. Part marks will be allocated, but if you have the incorrect answer then you cannot expect to get more than half marks. Project

Circle the new equilibrium if there is an increase in price, a.  In the acc...

a.  In the accompanying diagram (which represents the market for chocolate candy bars), the initial equilibrium is at the intersection of S1 and D1. Circle the new equilibrium if t

Interest rates, why borrow from a country with a high interest rate instead...

why borrow from a country with a high interest rate instead of a country with a low interest rate

estimate the price of the bond, Stardusts has 1 debt issue outstanding.  T...

Stardusts has 1 debt issue outstanding.  The debt matures on August 15, 2017, and has a 6.25% coupon.  Coupons are paid semiannually.  The bond is priced to yield 1.61% compound se

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