Print Name  ___________________

                                                                                                                                              Signature   ___________________

   Budget Lab
Individual Assignment
  15  Points

Set Netscape Margins [ Left = 1; Right =. 2; Top =. 4; Bottom = .4; Select Document Title,  Page Number, Page, Black Text, Black Lines]

1] Start Microsoft Excel.  Start with Sheet 1 of the spreadsheet.

2] Set the margins on the spreadsheet to be Left 1.25", Right .5", Top 1", and Bottom 1".

    File-> Page Setup

3] Enter your name in blue 14 point bold font so that it will appear in the middle of the screen when printed. Hint [You may have to use some spaces!]

    File-> Print Preview

4] Enter red  titles from Row 3 [A3:J3] as illustrated below. Center  B3:J3.  [Budget Item, Amount, January, February, ...] Adjust the columns so that they will fit on one page. Make Columns C3:H3 about the same column width. Save the spreadsheet as Budget.xls

The extension for Excel Spreadsheets is ____________

5] Suppose you graduate and get a permanent job in San Antonio designing Web pages for the Web Master Corporation. Your contract with them will pay you $15 per hour with no overtime. You must pay all of your living expenses from only this income. Make this budget realistic. 30% of your money must go to taxes. Enter all of your major categories in black in cells A4, A5, A6, ...

6] Cells I4, I5, I6, ... shall include a formula which maintains an accurate summation of all six months of activity in a specific category. If the category in cell A4 is Rent, then I4 would contain the total amount spent on rent for the six month period.   Enter monthly the summation formulas  for each of your major categories. Record the formulas entered into each of the following cells:

 I4 Formula = ___________________________________________________________________

 I5 Formula = ___________________________________________________________________

 I6 Formula = ___________________________________________________________________

7] Cells J4, J5, J6, ... shall include a formula which maintains an accurate average of all six months of activity in a specific category. If the category in cell A5 is Electricity, then J5 would contain the average amount spent on electricity for the six month period.   Enter monthly the average formulas  for each of your major categories. Record the formulas entered into each of the following cells:

J4 Formula = ___________________________________________________________________

J5 Formula = ___________________________________________________________________

J6 Formula = ___________________________________________________________________

8] Enter a budgeted amount in column B that corresponds appropriately for each of your major categories. These items must be in currency format! Do not exceed your monthly income. Any excess shall later be placed into Savings. Don't forget to plan for the unexpected speeding ticket, medical co-pays, etc.

9] A budget is a plan. Reality is often different and difficult to predict. Enter six months of fictitious, but realistic, data for each of your major categories. Some of your categories, such as rent, may be fixed for the entire six months. Many of the categories, such as electricity, will generally change from month to month. These items must be in currency format!

10] Let  be the Next available row number  in column A. (For example, if I have used cells A4:A23 for Budget Items, my  would be 24.)

Record your next    = ________________________

Using the red font, enter the caption "Totals" in cell A. Cells B, C, D, ... , I shall include formulas which maintains an accurate summation of all expenditures in the respective column. Record the formulas entered into each of the following cells:

B Formula = ___________________________________________________________________

C Formula = ___________________________________________________________________

D Formula = ___________________________________________________________________

11] Enter cells A39:A45 and cells C41:H41 as illustrated above. Include the color of the font. Insert the current year in cell B39. Insert the hourly rate, $15, in cell B40. Let us assume that you will work every M,T,W,T,F except Jan 1. Check your calendar for this year (or next if you like). Record the number of work days in each of the six months.

12] In cell C43 shall be a calculation for the gross {total before taxes} pay if you worked all of the days in January. Record the formulas entered into each of the following cells:

C43 Formula = ___________________________________________________________________

D43 Formula = ___________________________________________________________________

E43 Formula = ___________________________________________________________________

13] Assume that your only deduction is 30% for taxes. Record the taxes in row 44.  Record the formulas entered into each of the following cells:

C44 Formula = ___________________________________________________________________

D44 Formula = ___________________________________________________________________

E44 Formula = ___________________________________________________________________

14] The take home is the gross - taxes. Record the Take home in row 45.  Record the formulas entered into each of the following cells:

C45 Formula = ___________________________________________________________________

D45 Formula = ___________________________________________________________________

E45 Formula = ___________________________________________________________________

15] Beneath the Totals in Column A above, add "Take Home" and "Savings" as illustrated above.  Transfer a copy of the calculated Take Home (from below} into row 13. Record the formulas entered into each of the following cells:

C13 Formula = ___________________________________________________________________

D13 Formula = ___________________________________________________________________

E13 Formula = ___________________________________________________________________

16] Let us put any money left over at the end of the month into savings. Take Home - Total Expenditures = Savings . Record the formulas entered into each of the following cells:

C14 Formula = ___________________________________________________________________

D14 Formula = ___________________________________________________________________

E14 Formula = ___________________________________________________________________

17] Your colors and font sizes should match those illustrated in this lab description. Print this page. Using a pen, label it with an "A" in the top right corner.

18] Increase the amount in cell C4 by $10. Print this page. Using a pen, label it with an "B" in the top right corner.

19] Decrease the amount in cell C4 by $10. Save the spreadsheet.

20] Back Up a copy of this file to another disk!


20] Those Labs labeled "Individual Assignment" are to be done separately by each individual. Using a pen,  each individual is to print  his/her name at the top of this document in the space provided and sign it.  Those Labs labeled "Team Assignment" may be done as a team or individually. Using a pen,  each individual on the team is to print print his/her name at the top of this document in the space provided and sign it. Submit only one copy of team assignments!
Include the following in your wire-band binder:

A] Divider

B] Copy of this assignment sheet. Using an ink pen, print your name and sign this lab at the top.

C] Using an ink pen, initial each and every page of this lab.

D] A copy of the printed pages A & B

D] One copy of the floppy Budget.xls.