Question 1: (10%)

A retailer knows the annual demand for one of its product is 500,000 units, the ordering

costs are £40 per order and the average carrying cost per unit is 110 pence. You are

required to:

1. Determine the Economic Order Quantity, the number of orders per year and the

reorder period given the data above.

2. Produce sensitivity analysis assuming a change of up to 7.5% up or down on each

of the factors individually and on all factors simultaneously.

3. Make a final recommendation to the board of the company, as to the number of

units it should include in each order.

Question 2: (20%)

On the 5th of March 2009, the Bank of England (BoE) lowered its main interest rate to

0.5%, the lowest on record since the Bank has published rates in 1970, which still

remains unchanged. As a consequence of this low level of rates, HSBC’s Lifetime

Tracker Standard mortgage rate stands at 4.39%. Avery Bradley is about to buy a house

in the countryside which costs £500,000 and is taking out a 20-year repayment mortgage

for 75% of the acquisition value of the house. Avery is nevertheless worried about the

recent news that interest rates might be about to increase and has asked you to assess his

ability to pay, in case the BoE does indeed increase its interest rate, as his maximum

monthly payment cannot exceed £2,600. You are required to:

1. Calculate the monthly payment Avery will need to meet under current conditions.

2. Assess the effect on Avery’s monthly payments for each quarter percentage point

increase in the BoE rate, up to 4%age points and identify at which rate Avery

would no longer be able to make the monthly payment.

3. Determine the shortest length (to the nearest month) of mortgage Avery could

take out if he wanted his monthly payment to be exactly the maximum he could

afford (based on current mortgage assumptions).

Question 3: (25%)

The sales manager for an electronics retailer is trying to determine the sales mix that

maximises the profit for one of its product lines. This product line is sold in three levels

of content: Basic, Medium and High, which sell for £90, £140 and £220 respectively. The

different levels of content of the product use the following inputs:

The costs for the inputs are £15 per hour for Labour and £5, £2 and £1 per unit for Direct

Material, Packaging and Other Materials, respectively. The company is also faced with a

maximum demand of 5,000 units for the basic model, 4,000 for the medium and 3,000 for

the high.

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

microwave ovens product line.

2. How would your answer change if the following happened:

a. Price for the Premium model could be increased to£250;

b. Maximum available Direct Material could be increased to 50,000; OR

c. Labour cost was increased to £20 per hour.

3. Explain the reasons for the different answers in part 2c above.

4. Write a report with a recommended production and marketing plan for the

company.

Question 4: (10%)

Allen plc., a sports apparel manufacturer with a cost of capital of 11.25%, is looking to

reduce costs in its manufacturing activities and is considering opening a new facture in

one of two countries. Allen is able to raise £2,100,000, which it believes will be enough

to build and equip the factory in either country, so it needs to choose between the two

investments, which are expected to generate the following cash flows:

Make a recommendation to Allen, plc. as to which project it should implement,

including an indication of whether that decision should be different in case the cost of

capital changes in the near future.

Question 5: (25%)

The table on the next page represents data for the profits, sales, size and number of

product lines sold by the 20 branches of a retailing company. You have been asked to

analyse the data, using the Data Analysis tool in Excel, and make recommendations,

including answering the following questions.

1. Summarise the distribution of profits of the twenty branches and comment on the

results?

2. Is there evidence that the average number of lines stocked per store is

significantly different from 78?

3. If you divide the branches in two groups with, one of branches with sales above

£150,000, and the other with sales below that value, is there a significant

difference between the profits of the groups?

4. Based on this sample, provide a 99% confidence interval, and comment on the

outcome, for the profits of the twenty branches.

5. Is there evidence of association between the profit and the other variables?

6. Develop three regression models to predict the profit based upon each of the

other factors (variables) individually. Which of these is best? What are the

limitations of your best model? How can you improve this analysis?

Read less