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. | 
