Desert Valley Brewery Ltd. Case Solution And Analysis, HBR Case Study Solution & Analysis of Harvard Case Studies

Desert Valley Brewery Ltd.Case Solution

Situation

The Desert Valley Brewery is about to start its commercial business soon. It has planned the operations and budgets for such operations. However there were certain uncertainties which might affect the budgeted results. The sensitivity analysis will provide the estimation and the expected effects on the profitability of the business. This analysis will help to identify the impact of such uncertain events and its effect on the profit or contribution margin so that necessary measures can be taken to mitigates such risk.

Risk factors

There were two factors that are uncertain and might fluctuate in future. The fluctuation will affect the contribution margin. First one is the raw material cost. The raw material cost is expected to be either higher or lower than anticipated in the budget. These raw materials include malting barley and wheat grain. It is more likely that the cost of these raw materials would go higher and will negatively impact the profit of the company.

Sensitivity Analysis for change in Raw Material Prices

It is indicated in the case that malting barley prices fluctuates between 20-30% over the prior year prices. Thus to make a sensitivity analysis we will use this threshold. We assume that the prices might either be increases by average 25% or be decrease by 25%. Thus using this analysis is made to identify the impact of such price change on the profitability of the company. Thus the prices of wheat and malting barley are increased to see what changes have been made. As per the analysis the increase in price decrease the profitability of the company. The increase in prices decrease the profit to 12.5%, 12.2% and 12.2% as a percentage of sales as compared to the budgeted percentages of 14.4%, 14.1% and 14.2% for year 2002,2003 and 2004.

Sensitivity analysis is made assuming the event if prices of wheat and barley goes down by 25%. In this event the profit of the company increases as the raw material or variable production cost decreases. As per this analysis the profit increases in same ratio as it was decreased due to the increased prices. Thus profit for the year 2002, 2003 and 2004 increases to 16.2%, 16% and 16.1% as a percentage of sales.

The overall analysis shows that the profitability is moderately sensitive to the prices of raw materials that are wheat and malting barley. The sensitivity is not that high such if it make the company to make loss or make its business suffer. One way to mitigate this risk is to make future fixed contract with the supplier, with the primary agreement to provide the raw materials at the fixed prices up to specified date. This will mitigate the risk of rising prices of raw material. However this will limit the company to get benefits from the decreased prices in future. However increase is more likely to occur, this option is best therefore for risk mitigation.

Sensitivity Analysis for change in Sales volume

As per the case, the beer market is in declining trend and the numbers of beer consumers are decreasing. But for relevant analysis we consider the data gathered from the six microbrewers that represent their startup operations. The data gathered represent the actual volume sales in the first year as compared to the budgeted sales volume. This shows that the volume is fluctuating in between the 20%-30%. While using the graph table and the available information on the six microbrewers, the average change is calculated to be 25%.

The sensitivity analysis performed for identifying how sensitive is net profit and contribution from the change in the sales volume. Thus an increase of sales volume is assumed to analyze the impact of increased volume, with 25% increase above the budgeted volume. The decrease of sales volume is assumed to analyze the impact of decreased volume, by decreasing the budgeted volume by 25%..................

This is just a sample partial case solution. Please place the order on the website to order your own originally done case solution.