Open the Excel Software Program and type the following information in.

October Sales
(Enter a date stamp here)
Item Name Number of Units Sold Cost Per Unit Sale Price Per Unit Total Cost Total Sale Price Profit Donation
Binder 500 4 7        
Bookbag 350 5 10        
Calender 300 3 8        
Notebook 400 1 2        
Shirt 800 4 6        
Schedule 876 1 2        
Total        
Percentage of Donation 3%            

1. Format the page as the above form.
2. Enter a date stamp in the second row.
3. Calculate total cost, total sale price, profit, and donation for each item.
    Note: TOTAL COST = COST PER UNIT * NUMBER OF UNITS SOLD
                  TOTAL SALE PRICE = SALE PRICE PER UNIT * NUMBER OF UNITS SOLD
                  Profit = Total Sale Price - Total Cost
             Donation = Percentage of Donation * Profit  
             (You have to use F4 to fix the address of Percentage of Donation)
4. Hold the special corner and drag down to fill the whole column.
5. Use AutoSum button to calculate the grant totals in the row 10.

You will have the following results so far.

October Sales
10/24/2007 13:59
Item Name Number of Units Sold Cost Per Unit Sale Price Per Unit Total Cost Total Sale Price Profit Donation
Binder 500 $4 $7 $2,000 $3,500 $1,500 $45.00
Bookbag 350 $5 $10 $1,750 $3,500 $1,750 $52.50
Calender 300 $3 $8 $900 $2,400 $1,500 $45.00
Notebook 400 $1 $2 $400 $800 $400 $12.00
Shirt 800 $4 $6 $3,200 $4,800 $1,600 $48.00
Schedule 876 $1 $2 $876 $1,752 $876 $26.28
Total $9,126 $16,752 $7,626 $228.78
Percentage of Donation 3%            

Copy the current page to the next sheet and show formula there as bellow.

October Sales
=NOW()
Item Name Number of Units Sold Cost Per Unit Sale Price Per Unit Total Cost Total Sale Price Profit Donation
Binder 500 4 7 =C4*B4 =D4*B4 =F4-E4 =G4*$B$11
Bookbag 350 5 10 =C5*B5 =D5*B5 =F5-E5 =G5*$B$11
Calender 300 3 8 =C6*B6 =D6*B6 =F6-E6 =G6*$B$11
Notebook 400 1 2 =C7*B7 =D7*B7 =F7-E7 =G7*$B$11
Shirt 800 4 6 =C8*B8 =D8*B8 =F8-E8 =G8*$B$11
Schedule 876 1 2 =C9*B9 =D9*B9 =F9-E9 =G9*$B$11
Total =SUM(E4:E9) =SUM(F4:F9) =SUM(G4:G9) =SUM(H4:H9)
Percentage of Donation 0.03            

Can you rename each page (sheet)?

Create a bar chart and pie chart as bellow.

What-If Analysis

1. What is the total of profits now?   ___________________
2. If change the sale price per unit of notebook to $3, what will be the total of profits?  _________________
3. If we would like to get $8,000 in total of profits, how much sale price per unit should be set for Shirt?  ______________