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

Ros - return on sales-profit margin , ROS - Return on Sales (Profit Margin)...

ROS - Return on Sales (Profit Margin) The Average of the industry ROS was 5.18% for 2004, 4.41% for 2005, and 7.20% for 2006. The chart showed that ROS has been declined f

Estimate the present value of benefits, (a) A couple has just celebrated th...

(a) A couple has just celebrated their 25th wedding anniversary. What is the probability of them celebrating their 50th wedding anniversary, if the husband is aged exactly 50, his

Management of account receivable, Management of Account Receivable In ...

Management of Account Receivable In order to keep current customers and attract new ones, most firms find it necessary to offer credit. Accounts receivable represents the exte

Gordeon''s Model, what is the price of the share net sales Rs.120lakhs ne...

what is the price of the share net sales Rs.120lakhs net profit margin 12.5% no. of equity shares 25,000 cost of equity shares 12% retention ratio 40% rate of interest(ROI) 16%

Compute the risk premium for the stock, Compute the risk premium for the st...

Compute the risk premium for the stock of Omega Tools if the risk free rate is 6%, the expected market return is 12%, and Omega's stock has a beta of .8.    Ome

Assets, thew amount of money investedin a retirement fund is an example of

thew amount of money investedin a retirement fund is an example of

Draw a graph and use the supply and demand analysis, If banks expect an unu...

If banks expect an unusually large increase in withdraws from checking deposit accounts in the near future, what would happen to the federal funds rate, borrowed reserves and nonbo

Joint stock companies - types of business organisations, Joint Stock Compan...

Joint Stock Companies - Types of Business Organisations Initiators contribute to the capital support of those companies via the purchase of shares of those companies. These co

What is the execution of order in the stock exchange, What is the Execution...

What is the Execution of order in the Stock Exchange When broker receives the margin money and is clear about the order received by him, he puts details in the 'order book'.

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