Excel Office Budget Exercise

Using the following information create a 4 month spreadsheet for an office (Title V, K-6 school, small business, etc.) Create totals for major categories and make your spreadsheet look good. Create (1) a summary column keeping totals for each position and expenses (2) rows with a summary for each month and the monthly average, (3) a last column that forecasts the total cost for a year if the same costs for each of the 4 following quarters are the same as the first quarter (4) highlight important items using your formatting skills, (5) size the columns appropriate for the data, (6) format the data as currency.

HINT: Create the major portion of the spreadsheet first, then create the part that calculates expenses that may vary each month. You can then connect the monthly expense summary to the main part of the spreadsheet plus you have a major part working if you cant get the rest to work.

(the numbers are made up and do not represent real values)

Positions Pay

Director $5500 month

Secretary/Mgr $4188 month

Secretary $1895 month

Assistants $6.75 per hour (limited to 20 hours per week)

Of course the director and secretaries work every month for the same amount.

The student assistant hours will vary with need:

Jan 4 weeks 20 hours per week each for 2 assistants

Feb 3 weeks 20 hours per week each for 2 assistants

Mar 5 weeks 20 hours per week each for 2 assistants

April 4 weeks 20 hours per week each for 2 assistants

Monthly expenses::

Jan: Digital Still Camera $119.99, rechargeable batteries and charger $19.76, 2 digital movie cameras @ $599 each, digital recording tape $23.50, box of printer paper @ $55

Feb: Digital Still Camera $119.99

Mar: Multifunction Printer $399, Photo printing paper 100 pack @ $24.99

April: Ink jet cartridge @ 36.45