Basketball Budget Spreadsheet Activity Page 
 
1.  Suppose you are helping create the budget for a youth basketball team. Most of the budget has been finalized, but the team needs your help deciding how to spend the remaining $95.00. Refer to the data table below to find out more about the budget. There are ten total players on the team, and the total budget is $1,000, which includes the finalized budget  items below and leaves money for other budget items. 
 
Finalized Budget Items
Item 	Amount per Player	
Basketball Uniform  	$23.00 	
Basketball Camp  	$50.00 	
End-of-season Party  	$17.50 	
r Player 
2.  Since the team still has $95.00 left in their $1,000 budget, they brainstormed ways to best spend the money. Choose one or more of the suggestions below, but make sure not to exceed $95.00. The donation to the literacy program amount was not decided, so if you choose that option, you will need to decide upon an amount. 
 
Ideas for How to Spend Remaining Budget
Items	Amount per Player	
Custom Tee-shirts  	$9.00 	
Custom Water Bottles  	$4.50 	
Donation to Literacy Program  Amount	undecided	
Caricature Drawings of All Players  	$7.00 	

3.  Complete the data table below. Fill in the totals for the finalized budget items, and also fill in the additional items you selected to complete the rest of the budget (see Model). Use the following space to complete your calculations: 
 
Ideas for How to Spend Remaining Budget
Item	Amount per Player	Total Amount	
Basketball Uniform  	$23.00   	     	
Basketball Camp  	$50.00	     	
End-of-season Party  	$17.50	     	
     	     	     	
     	     	     	

4.  Now input the information from your data table into a spreadsheet. (See sample). Type whole numbers for your amounts, and then use the currency button to change them to currency.  
 
5.  At the end of the ‘Item’ column, type “Total” and use the sum tool to fill in the totals in the appropriate column. Highlight that entire row with a color of your choice. 

6.  Center all the data in your spreadsheet, and make the labels bold.  
 
7.  Save as “Last First Basketball” and you will be graded at the end of class.