Excel Spreadsheet Budget Samples

Document Sample
Excel Spreadsheet Budget Samples Powered By Docstoc
					Sample Excel Spreadsheet Workout 2 Scope: Evaluate and explore how MS-Excel can and should be used as a budgeting tool Purpose: Illustrate some important utilities within Excel for use in ensuring proper rounding, etc. Project Period: 07/01/2001-06/30/2003 Requested Shared Effort Effort Personnel Costs Principal Investigator Technical Support - Research Technician Graduate Research Assistant Associated Fringe Benefits Total Personnel Costs Equipment Materials and Supplies Travel Other Direct Costs Courier Service and Page Charges Non-capitalized Software Honrarium for Sensory Panelists Graduate Tuition Total Direct Costs Modified Total Direct Costs Indirect Costs Total Project Costs 3% 25% 50% Rate Year 1 Requested Shared 3,310 10,000 13,000 2,300 28,610 17,000 8,000 2,500 2,500 1,000 4,200 2,413 66,223 46,810 21,767 87,990 Year 2 Requested 3,476 10,500 13,650 2,415 30,041 8,000 3,000 1,500 3,600 2,534 48,675 46,141 21,456 70,131

0% 110,327 0% 40,000 0% 26,000 23%

46.5%

Year 2 Shared

Total Requested 6,786 20,500 26,650 4,715 58,651 17,000 16,000 5,500 4,000 1,000 7,800 4,947 114,898 92,951 43,223 158,121

Total Shared -

Total Project 6,786 20,500 26,650 4,715 58,651 17,000 16,000 5,500 4,000 1,000 7,800 4,947 114,898 92,951 43,223 158,121

Inflation 105% 105% 105%

Check Figures

105%

43,223 158,121


				
DOCUMENT INFO
Shared By:
Stats:
views:779
posted:11/6/2008
language:English
pages:2