Practice Excel Intermediate Spreadsheet

							Office Supplies      $    1,600          103,603.50
Rent & Utilities     $    5,900   2.0%
Salaries             $   12,600   2.5%
COGS                 $   80,000   3.0%
                                  3.5%
Total Budget         $  100,100   4.0%
Increase for 2000          3.5%   4.5%
Fiscal 2000 Budget   103,603.50   5.0%
                                  5.5%
                                  6.0%
Fiscal 99 Budget     $ 125,000.00
Increase for 2000           3.50%
Fiscal 2000 Budget   $ 129,375.00
Increase for 2001           5.00%
Fiscal '01 Budget    $ 135,843.75
ID         Candy     Cost
     100   Snicker's $    0.45
     200   M&M's     $    0.65   Prod. # Candy   Price
     300   Hershey's $    0.50
     400   Kit Kat   $    0.55
     500   Twix      $    0.60