Using the spreadsheet skills that she used to collect all her suppliers contact details, Anita will create a new spreadsheet to record the number of videos and DVDs each supplier has delivered and the amount that each delivery has cost.
The video store needs to know:
- how many videos and DVDS have been received from each supplier;
- how much each video and DVD costs;
- how much it all costs in total.
Can you help Anita create a new Stock Monitoring spreadsheet using the following headings?
- Supplier
- Price
- No. of Videos
- No. of DVDs
- Stock
- Cost
| Ìý |
A |
B |
C |
D |
E |
F |
|---|
| 1 |
Supplier |
Price £ |
No. of Videos |
No. of DVDs |
Stock |
Cost |
|---|
| 2 |
Paramount |
Ìý |
Ìý |
Ìý |
Ìý |
Ìý |
|---|
| 3 |
Universal |
Ìý |
Ìý |
Ìý |
Ìý |
Ìý |
|---|
| 4 |
Buena Vista |
Ìý |
Ìý |
Ìý |
Ìý |
Ìý |
|---|
| 5 |
New Line |
Ìý |
Ìý |
Ìý |
Ìý |
Ìý |
|---|
| 6 |
Total |
Ìý |
Ìý |
Ìý |
Ìý |
Ìý |
|---|
If
you are unable to view the Flash movie above, click here for a non-Flash
alternative.
Go to the next screen to see how Anita calculates her costs.
|
