Excel05_SteveStombaugh_2

Excel05_SteveStombaugh_2 - CaseGrader Office 2007 Excel...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
CaseGrader Office 2007 Excel Case 05: FLMC Budget Author Steve Stombaugh Note: Do not edit this sheet. If your name does not appear in cell  B4, please download a new copy of the start file from the  cgoffice07.course.com web site.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
DO NOT DELETE--> 4DAFF9555FD54F3F
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
879ifkk4000ki09k8k rsdud!rsnlaztfg
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Steve Stombaugh
Background image of page 6
Salaries Health insurance Life insurance Disability insurance Retirement $0.00 $20,000.00 $40,000.00 $60,000.00 $80,000.00 $100,000.00 $120,000.00 $140,000.00 $160,000.00 Employee Costs - 2010 Expenses
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Facilities Maintenance Transportation $0.00 $5,000.00 $10,000.00 $15,000.00 $20,000.00 $25,000.00 $30,000.00 Column B Column C
Background image of page 8
Finger Lakes Music Camp 2010 Operating Summary Annual Costs Actual Budget Difference Enrollment Growth Facilities $28,495.80  $27,300.00  $1,195.80  Maintenance $3,925.57  $3,900.00  $25.57  Transportation $4,774.00  $4,200.00  $574.00  Subtotal $37,195.37 $35,400.00 $1,795.37  Employees Salaries $152,656.00  $132,000.00  $20,656.00  Health insurance $61,958.40  $54,900.00  $7,058.40  Life insurance $11,468.76  $11,400.00  $68.76  Disability insurance $8,448.00  $8,400.00  $48.00  Retirement $9,751.80  $8,400.00  $1,351.80  Subtotal $244,282.96 $215,100.00 $29,182.96  Program Changes Visual arts $16,384.00  $16,383.96  $0.04  Receration $5,957.80  $5,957.76  $0.04  Subtotal $22,341.80 $22,341.72 $0.08  Educational Materials Daily supplies
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/07/2008 for the course BUSA 207 taught by Professor Otto during the Spring '08 term at Grove City.

Page1 / 26

Excel05_SteveStombaugh_2 - CaseGrader Office 2007 Excel...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online