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

Accounts payable turnover ratio, Accounts Payable Turnover Ratio Ratio...

Accounts Payable Turnover Ratio Ratio for Account Payable Turnover is as Follow: Creditors/accounts payable turnover = Annual credit purchases /Average creditors

Debenture finance, Debenture Finance A type of long term debt raised a...

Debenture Finance A type of long term debt raised after a company sells debenture certificates to the holder and raises finance in return. The term debenture has its source fr

Example of quantity discounts, Example of Quantity Discounts Consider ...

Example of Quantity Discounts Consider illustration one and suppose that a quantity discount of 5 percent is given whether a minimum 200 units is ordered. Required Fin

Revenue Reserves - Retained Earnings, Revenue Reserves - Retained Earnings ...

Revenue Reserves - Retained Earnings These are undistributed earnings.  Those reserves are retained for the given reasons like: A. To create up for the fall in profits so a

Calculate the ex-right stock price, DIY Inc. plans to raise $200,000 with a...

DIY Inc. plans to raise $200,000 with a right offering. The current stock price is $100 and there are 80,000 shares outstanding.  a. If DIY sets the subscription price to be $80

Compound interest and compound amount.., a debt off Rs1000 with interest at...

a debt off Rs1000 with interest at 10% compounded quarterly will be repaid by payments Rs. 200 at the end of 3 months and three equal payments at the end of 6 9 and 12 months. find

Operations research, A paper mill produces two grades of paper viz., X and ...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

capm model is not suitable in an international setting, Why do several cri...

Why do several critics say the CAPM model is not suitable in an international setting? Please describe a way that the CAPM model could be adapted for international applications.

IS-LM, After read all the available information carefully, prepare a two pa...

After read all the available information carefully, prepare a two page (double-spaced) essay and answer the following questions: Assume that we have the following data: C=100+0.50Y

Formation of sole proprietorship business, Formation of Sole Proprietorship...

Formation of Sole Proprietorship Business When an individual plans to start a business, his or her main objective is to earn profit but there are a number of factors to take in

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