Final Budget Spreadsheet . . Use your original Budget Spreadsheet and make the following changes: Add the following Line items: o Miscellaneous o Refreshments Remove the following time frames: o May o June o July Add an encumbered column o This will be a PO Encumbrance Column o This means that you will need to make sure to include this column in your total spent column for each line item Create a second sheet and title it "Expenditures" Create a third sheet and title it "Encumbrances" Create a table on each sheet that includes: o Line items o Time frame o Totals for time frame and lines items Formulas for all totals O NOTES: You can create this once and copy it to the other page You will be adding multiple expenses/encumbrances to each line item each month FOR EXAMPLE: Totals for each B D month per line item tals Apri 1 January February March $ 45.67 $ 50.65 $ 12.98 $ 2 Office Supplies 55.00 $ 72.93 34.98 $ $ 3 23.00 $ 88.43 $ 14.00 4 80.659 212.018 12.988 92.00 $ 397.64 O 000 UN 5 Totals: 31.87 90.10 7 Telephone $ $ $ 60.41 92.28 $ $ $ $ 12.68 102.78 $ $ 195.06 9 Totals: Reference each total back to your original budget (your first spreadsheet) This includes each line item every month for expenses o This includes total line items for encumbrances o Use the formula (=NameOfTheSpreadsheet!CellReference) F FOR EXAMPLE: The expense spreadsheets shows: A B The expense spreadsheet 1 total for Jan office January Feb 2 Office Supplies supplies is $80.65 and is $ 45.67 $ listed in the Expense 3 $ 34.98 $ spreadsheet cell B5. 4 88.43 $ 5 Totals: $C 80.65 212.01 $ 12.98 $ 6 7 Telephone $ 31.87 $ 90.10 8 $ 60.41 $ 12.68 9 Totals: $ 92.28 $ $ 102.78 $ The original spreadsheet will now have the same total as listed on the expense spreadsheet for Jan office supplies. =Expenses!B5 Line Item Totals 5.00 3.00 14.00 92.00 $ 397.64 $ 195.06 Select the cell of the original spreadsheet and type = A Line Items ? Office Supplies 3 Telephone Then select the spreadsheet you B D want to reference and select the January February March cell that includes the total. $80.65 $212.01 $12.94 $92.28 $0.00 $102.78 $0.00 $195.06 The encumbrance spreadsheet shows: Line Item Totals Februg Office Supplies January $ 87.65 $ 123.44 The encumbrance spreadsheet total for office supplies is $236.71 and is listed in the Encumbrance spreadsheet cell F5. 236.71 Totals: $ 211.09 $ $ 100.34 Telephone $ $ $ 88.89 39.65 128.54 $ 228.88 $ $ 100.34 $ Totals: Reference the total line items to your original spreadsheet with the formula (as highlighted) The original spreadsheet will now have the same total as listed on the expense spreadsheet for Jan office supplies. Select the cell of the original spreadsheet and type = Encumbrance!FS F Then select the spreadsheet you want to reference and select the cell that includes the total. D E February March April $212.01 $12.98 $92.00 $0.00 $102.78 $0.00 Line Item Total Emcumbrance $397.64 $236.71 $195.06 $228.88 pou.os z UMT Suppies 3 Telephone $92.28 Enter the data below under your expense and encumbrance tables Your final budget spreadsheet should include the numbers as listed (format and visual look will differ for everyone, but the numbers should be the same) line items Office Supplies Telephone Travel Copies Postage Refreshments Miscellaneous Expense Total January February March April Line Item Total Emcumbrance Total Expenses $80.65 $212.01 $12.98 $92.00 $397.64 $236.71 $634.35 $92.28 $0.00 $102.78 $0.00 $195.06 $228.88 $423.94 $120.30 $109.45 $243.88 $378.00 $851.63 $262.00 $1,113.63 $9.36 $0.00 $99.89 $65.12 $174.37 $175.67 $350.04 $10.11 $13.91 $75.18 $110.00 $209.20 $159.73 $368.93 $28.19 $35.10 $109.47 $0.00 $172.76 $38.99 $211.75 $11.11 $0.00 $8.09 $54.61 $73.81 $82.79 $156.60 $352.00 $370.47 $652.27 $699.73 $2,074.47 $1,184.77 $3,259.24 Starting Budget Current Budget $5,000.00 $1,740.76 O . . Expenditures: January Office Supplies: o $45.67 $34.98 Telephone: o $31.87 O $60.41 Travel: o $98.65 o $21.65 Copies: o $2.98 o $3.75 o $2.63 Postage o $10.11 Refreshments o $28.19 Miscellaneous o $11.11 February Office Supplies: o $50.65 o $72.93 o $88.43 Travel: o $33.59 o $21.64 o $54.22 Postage: o $5.98 March Office Supplies: o $12.98 Telephone o $90.10 o $12.68 Travel: o $65.88 o $94.23 o $23.43 o $60.34 Copies o $22.99 o $76.90 Postage o $75.18 Refreshments: o $77.83 o $31.64 Miscellaneous: o $1.77 o $3.44 o $2.88 April Office Supplies o $55.00 o $23.00 o $14.00 Travel o $378.00 Copies o $65.12 . Postage . o $7.93 Refreshments o $35.10 . o $76.00 o $34.00 Miscellaneous o $33.43 o $21.18 March Office Supplies: o $8.64 o $7.26 o $9.72 Copies: Encumbrances: January Office Supplies: o $87.65 o $123.44 Travel: o $50.33 o $77.11 Copies: o $12.45 February Telephone: o $100.34 Copies: o $33.59 O $12.65 . o $88.65 o $28.33 Postage: o $70.00 o $89.73 Miscellaneous: o $6.97 o $20.04 April . Telephone o $88.89 o $39.65 Travel o $57.68 o $76.88 Refreshments o $38.99 Miscellaneous o $55.78 c