Budgeting

Illustration 14.15 from page 537 of Chapter 14 is reproduced below. Open the spreadsheet to see the calculations used to produce this table. This will help you to appreciate how the figures were calculated for the reduction in sales volumes of 10%

Calculations for Illustration 14.15 (XLS)

Illustration 14.15 Anna: budgeted cash inflows and outflows for January, February and March assuming a 10% fall in the number of products sold while keeping selling prices the same