complete bottom up approach!! Prepare a budget, Total Revenue

ottom-Up Approach Bottom-Up Volume Budget Q2 03 04 01 FY ales Volume 1000 strutora Distributor Distributor Total 01 100 50 45 195 Last Year Actual Volume Q2 03 04 250 200 08 92 65 120 120 70 456 492 233 >> Volume planning FY 728 293 355 1,376 Growth 7.0% 5.5% 120% -100.0% Bottom-Up Revenue Budget 02 03 04 Revenue 000 Sales Volume Last Year Actual Revenue Q2 03 04 480 233 01 FY 6 FY 1.370 Growth -100.0% 195 130 White Hats Red Hats 304 152 320 164 150 70 917 455 >> Mix planning 65. 36 White Hats Red Hats 667 333 66.7% 33 34 667% 3399 667 333 66.7% 33.35 66 333 06 333 657 333 3334 3334 Prce White Hats Price Red 10 10 10 10 10 10 10 10 10 11 10 11 10 11 10 11 10 11 66 >> Pricing 10 105 Revenue White Hats Revenue Red Hats 1,300 650 3.040 1.520 3.280 1.640 1,653 777 3,173 4,587 Total Revenue 1,960 4.560 4.920 2.330 13.760 -100.0% ottom-Up Approach Bottom-Up Volume Budget Q2 03 04 01 FY ales Volume 1000 strutora Distributor Distributor Total 01 100 50 45 195 Last Year Actual Volume Q2 03 04 250 200 08 92 65 120 120 70 456 492 233 >> Volume planning FY 728 293 355 1,376 Growth 7.0% 5.5% 120% -100.0% Bottom-Up Revenue Budget 02 03 04 Revenue 000 Sales Volume Last Year Actual Revenue Q2 03 04 480 233 01 FY 6 FY 1.370 Growth -100.0% 195 130 White Hats Red Hats 304 152 320 164 150 70 917 455 >> Mix planning 65. 36 White Hats Red Hats 667 333 66.7% 33 34 667% 3399 667 333 66.7% 33.35 66 333 06 333 657 333 3334 3334 Prce White Hats Price Red 10 10 10 10 10 10 10 10 10 11 10 11 10 11 10 11 10 11 66 >> Pricing 10 105 Revenue White Hats Revenue Red Hats 1,300 650 3.040 1.520 3.280 1.640 1,653 777 3,173 4,587 Total Revenue 1,960 4.560 4.920 2.330 13.760 -100.0%