Document Sample

```					                        Suki's Skateboard Shop and Snow School Spreadsheet
Suki's Skateboard Shop Revenue
Product                   Price    Unit Sales           Profit

Elbow Pads                                  £15.00                   12
Knee Pads                                   £15.00                   15
Standard Skateboard                         £35.00                   42
Super Skateboard                            £75.00                   26
Replacement Wheels                          £16.00                    6
Shoe Laces                                   £1.50                   65
Belt                                         £8.00                   34
Key Ring                                     £3.50                   50
Stickers                                     £1.25                  105
DVD                                         £15.00                   37
Total Profit
Name:

What If Questions

1     On which product does Suki make the most Profit?
2     On which product does Suki make the least Profit?
3     What happens to the profit for elbow pads if price increases to £20 per unit? Write down the new profit.
4     What happens to profit if the number of replacement wheels sold increases to 30? Write down the new profit.
5     What happens to the profit for stickers if the cost per pack increases to £1.60? Write down the new profit.
Insert a row between shoe laces and belt and type in the product column Trousers, price £30 and unit sales 10.
6     What is the new total profit?

Now add two more columns to the spreadsheet - label these Cost and Profit

7      Which product makes the most profit?
8      Which product makes the least profit?
9      If the unit sales of shoe laces decreases to 40 what is the new profit figure for shoe laces?
10     If the price of the knee pads increases to £20 what is the new profit figure?
Creating Charts

Use the spreadsheet to produce the following charts. Copy and paste your charts
on the Chart Report document - task 9

Pie chart showing the total of Elbow Pads, Knee Pads, Standard Skateboard
1 and Super Skateboard
2 Column chart showing all products and totals
3 Column chart showing products and unit sales

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 79 posted: 5/4/2011 language: English pages: 3