Using the most-likely case as the master budget, prepare two additional budgets for 2006?a worst-case and a best-case scenario. In a word document, discuss assumptions in each budget.© BrainMass Inc. brainmass.com June 3, 2020, 7:50 pm ad1c9bdddf
In the worst case scenario, we assume that there is a drought or some other severe weather conditions that prevent us from harvesting as many oranges as we would want to. Consequently numbers of oranges produced dramatically go down by 2,000,000 oranges on average. That in turn means that the number of gallons produced would go down by approximately 130,000 and 60,000 for 2 product lines respectively. That in turn would bring the amount of sales down since we cannot sell more than we actually have.
We also ...
Excel budget plus discussion in the tutorial for you.