Management/Tuck Shop

From Farset Labs
Jump to: navigation, search

Management

Tuck Shop Purchase of Regular Stock

Purchases of regular stock from Makro, Tesco, etc, must be recorded accurately to ensure that the tuck shop proceeds are accurately calculated.

Tuck Shop Finance Form

Note: The tuck shop spreadsheet can only handle one purchase per day. If two or more have been performed, you will need to backdate some to ensure uniqueness


Tuck Shop Purchase of Club Mate Stock

Before Club Mate can be placed in the fridge, it must be 'purchased' from Farset, thereby removing it from the spreadsheet that records the number of full boxes available for sale.


Firstly, the number of crates purchased should be entered into the Club Mate form, to subtract the stock from the system

Club Mate Stock Form


Next, the box itself should be removed and clearly marked as being tuck shop stock, to prevent future confusion.


Finally, the tuck shop form should be filled in, with the vendor set as 'Club Mate'. Be sure to enter the COST PRICE, and not the retail price of the Club Mate crate.

Tuck Shop Finance Form

Note: The tuck shop spreadsheet can only handle one purchase per day. If two or more have been performed, you will need to backdate some to ensure uniqueness


Tuck Shop Cash Recording

Every week, the tuck shop donations tin must be emptied and counted. The cash count must be entered into the tuck shop spreadsheet via the entry form.

Tuck Shop Finance Form

The counted cash should be stored in the cash box in the safe, and deposited during the next bank run.


Using the Club Mate spreadsheet (Drive / Admin / Management / Stock Tracker)

GREEN tabs are for working out the profit margin for a pallet order of Club Mate

YELLOW tabs store the responses from the buy-in form

ORANGE tabs filter these responses to produce an order. Orange cells can be used to mark how much stock is being bought to store on site.

RED tabs handle the responses from the purchase form, and calculate the current stock level. Once an order has been placed, you will need to enter the number of boxes to be stored on site as a new column in the 'Current Stock' tab


Using the Tuck Shop spreadsheet (Drive / Admin / Tuck Shop Financials)

Abandon hope all ye who enter here.

The first four tabs make do the numbers and responses to process the ££. Don't touch them lest they break.

The BLUE tab filters the nonsense from the previous pages. A new line appears when a new month begins. The last two columns need to have their formulae copied into these new lines, to make the graphs update on the last tab.

The GREEN tab shows the beautiful graphs and statistics.