Exercise 15
Design a Budgeting Worksheet for Merchandising
Star Events will be merchandising a number of products in conjunction with its forthcoming Triathlon championship.
The product lines, each of which is especially embroidered with the events logo, are:
| Item | Cost Price |
| Polo Shirt |
20.00
|
| Competition Singlet |
15.93
|
| Competition Shorts |
14.95
|
| Training Shorts |
10.95
|
| Training Shirt |
13.85
|
| Sports Bag |
20.30
|
| Towel |
15.65
|
The organisation plans to purchase 100 items of each for merchandising at a markup of 25%.
Design a worksheet that will:
|
(a)
|
Allow the total profit on merchandising to be calculated.
|
|
(b)
|
Allow the sales quantity of each item to be changed
(from the starting point of 50) if necessary.
|
|
(c)
|
Allow the markup on each item to be changed (from
a starting point of 25%) if required.
|
|
(d)
|
Allow for sizing (except for sports bag) to be registered
on the worksheet. The organisation does not know what sizes it requires
at this point but when the worksheet should have this flexibility.
Therefore assume the sizes required for each item will be X small
20, small 20, medium 20, large 20, XL 20.
|