Explore BrainMass
Share

# Sensitivity Analysis: Weather Prediction

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Consider the following problem:

The Smith family annual reunion is to be held on the first Saturday in May. There is a probability of cool or rainy weather on that day. The family has reserved free space at a local park for their event. For an additional charge, one of the pavilions that will provide shelter can be rented. If the weather is bad and the shelter is not rented, then the event may need to be canceled and family members will have spent the money for travel and preparations needlessly. Should the family spend the extra money to rent the shelter, even though it may not be needed?

Perform a sensitivity analysis for the above problem. Include the following details in your paper:

•One parameter sensitivity analysis

•Identify how the best alternative and expected payoff change as the variable changes

#### Solution Preview

A sensitivity analysis attempts to identify variables which may affect the final outcome of a given situation. In this case, the most visible variable is the weather. Because there is a probability of inclement weather, the question becomes: Should the family rent a pavilion in order to accommodate family and guest should the weather, in fact, make the event open to potential cancellation at the last minute?

Looked at another way, should the family rent the pavilion as an added benefit for the event? For example, it could be available for allowing some of the elder members of the family to rest in shady circumstances. Or it could be available as a place to store and serve food, as well ...

#### Solution Summary

This attempts to provide guidance for a situation which has both direct and indirect costs associated, as well has potential investment opportunities involved a apart of the solution.

\$2.19

## Pepsi: probabilities, sensitivity analysis, decision tree

Please construct the decision tree for the problem attached, insert the probabilities and values as given in the scenario (make sure to include in the tree the possibility that the one-month forecast is favourable or not), roll back the tree, and determine the course of action that PEPSI should take.

Perform a sensitivity analysis on the probabilities of there being a significant increase in demand or not.

Describe each step of the analysis (including the sensitivity analysis), and the conclusions you have reached as a result of this analysis: include graphs and tables.

Identify advantages and limitations of this Decision Tree as a method for making decisions. Suggest potential means for overcoming any weaknesses.

PEPSI , a manufacturer of soft drinks, sells directly to restaurants, bars and public houses with sales representing about 20% of the local soft-drinks market. The company sells its products in bottles and cans, but chiefly in kegs to be served in draught form.

In the financial year 2009/10 the company achieved excellent results. The value of sales increased by 28% to £60 million and pre-tax profits of £6 million represented an increase of 55% on the previous year. Much of the company's success was based on sales of draught drinks. The number of outlets selling PEPSI?s product had increased substantially over recent years and the upward trend in sales had been accelerating.

The growth in draught soft-drink sales had, however, created some problems for the company's managers. In particular, there was concern that in the coming August, when sales reached a seasonal peak, there might not be enough kegs available to meet demand. Kegs are 45 litres, stainless steel containers in which the drinks are supplied to customers. After use, empty kegs are returned to the factory where they are inspected for damage, cleaned and refilled. In 2010, PEPSI owned about 100,000 kegs, but in view of the expansion of sales, it was felt by some managers that this stock should be increased.

In January 2011, the recently formed Keg Steering Committee met to consider the position for the coming summer. This committee consisted of managers from the Operations, Accounting, Sales and Marketing departments. John Fleetwood, the Operations Manager, put forward a proposal that 4000 new kegs should be ordered immediately from the manufacturer in Birmingham so that they would be available in time for the peak summer demand (the manufacturer would only supply in batches of 1000 kegs).

Dave Mitchell, the accountant was less sure. At £50 per keg, this would amount to an expenditure of £200,000 and there was no certainty that all these kegs would be needed. However, Fleetwood pointed out that, even if they were not needed this year, the kegs might be required in the following year.

"In that case," retorted Mitchell, "We'll have tied up £200,000 for a year unnecessarily. Given a 5% rate of interest, that would cost us £10,000."

At this point, Sally Martin, the Marketing Manager, intervened. "Surely there are intermediate positions. We could presumably order any number of batches from 0 to 4.
What we need is some estimate of the likely levels of demand in August and the consequences of having a given number of kegs available to meet these levels of demand."

Richard Skills, the Sales Manager, pointed out that the sales forecasts were really only reliable one month ahead, partly because this was linked to the long-range weather forecast. In hot, dry summers, sales rocketed. "Perhaps we should delay our decision until July when we'll get the August forecast," he said.

"If we do that," replied Fleetwood, "it may be too late. Other brewers might be placing orders with the keg manufacturers and I reckon there would be a 10% chance that they could not get the kegs produced for us in time for August. Surely you must have some idea of what sales are likely to do. After all, your reps are constantly touring the country, talking to people in the trade."

Skills were silent for a few moments. "Well, if you really twist my arm, the best I can say is this. I reckon there's about a 70% chance that sales in August this year will be significantly up on August last year, in other words, by at least 5% and a 30% chance that we will see no significant increase. But remember, this is only a very rough estimate."

Martin turned to Mitchell. "OK, can we do some calculations on what the consequences are of having different numbers of kegs available for August assuming first no significant increase in sales, and secondly an increase of at least 5%?"

Mitchell was sceptical, but under pressure, he agreed to do some rough calculations. For simplicity, he assumed that:
i) either 0, 2000 or 4000 kegs would be ordered;
ii) if it was needed, each new keg would make only one journey in August thereby supplying 45 litres to customers and earning a contribution of £8;
iii) if sales increase by at least 5% then at least 4000 kegs could be used in August;
iv) the only costs are those resulting from tying-up the capital expenditure on the kegs (at 5% interest rate) until they will be needed the following year, for example, to replace worn-out kegs.

[Calculate Mitchell?s figures for change in profit on the basis of his assumptions given above]

"I still think it might be worth delaying our decision until we get the August sales forecast," said Skills, "even if that does mean taking a risk that the kegs will not be available."