Differences

This shows you the differences between two versions of the page.

module_guides:shop_reconciliation:daily_shops_control_sheet [2010/01/06 10:22] (current)
jane created
Line 1: Line 1:
 +====== The Shop Control Sheet ======
 + 
 +
 +=====  Key Points =====
 +
 +
 +  * This is a two part document, top copy white, bottom copy pink.  You will receive both parts in you shop wallet each day.
 +  * The Shop Control Sheet is filled in during the day and must be completed by the end of each day  ( as per the following instructions ).
 +  *You must leave the top copy each evening in your shop wallet, ready for collection by the driver the following morning.
 +  * You retain the bottom pink copy for your records, to use when adjusting your order and to note special orders
 +
 +The top centre section of the Shop Control Sheet should be used to write cash and other details.
 +
 +===== Explanation of Shop Control Sheet  (Column Headings) =====
 +
 +
 +====Columns ====
 +
 +
 +=== 1. Product ===
 +
 +The products description
 +=== 2. Product Reference Number ===
 +
 +The products number
 +=== 3. Opening Stock ===
 +
 +This column may be used for the computer to print  your Today's Total Order. (Including Special Orders)
 +If nothing is printed in this column you may use it to write in the previous days closing stock. 
 +=== 4. Del 1  (Delivery 1) (For your use) ===
 +
 +Your 1st delivery received figure should be written here. (actual  quantity of each product received)
 +=== 5. Del 2  (Delivery 2) (For your use) ===
 +
 +Your 2nd delivery received figure should be written here. (actual  of each product received)
 +=== 6. Del 3 / Transfers In  (Delivery 3 / Transferred In) (For your use) ===
 +Seasonal or special deliveries should be entered here. Also any products that are transferred into your shop from another shop. 
 +Transfers should be ringed and you must note at the bottom of the sheet details of the shop who transferred the products to you, the transfer note you received with the goods should be clipped to the Shop Control Sheet and returned to the bakery in your Shop Wallet.
 +=== 7. Available to Sell (For your use) ===
 +
 +May be used to write the Available to sell for each product for your own information.  This may be calculated as follows:- Opening stock , plus deliveries 1, 2, 3 + products transferred in  ( Columns 3 + 4 + 5 + 6  = 7 )
 +=== 8. Transferred Out (For your use) ===
 +
 +Product that are transferred from your shop to another shop should be written in this column.  You must also record these transfers on the official Transfer Notes retaining one copy and sending the top copy to the receiving shop. Record at the bottom of the sheet which shop/s transfers out were made to
 +=== 9. Reference ===
 +
 +This is again a note of the product reference number which is printed multiple times to avoid mistakes in selecting products.
 +=== 10. Credits (For your use) ===
 +
 +This is where you record any product which has been taken off sale for a specific reason for which you will require credit such as :-
 +^Product^Reason  Code^
 +|Samples|5|
 +|Complaints  or / Replacements|6|
 +|Damaged  Products|7|
 +|Sub Standard Products|8|
 +
 +These are the only codes which will be accepted.
 +
 +Write the total quantity of the product requiring credit in the quantity column  and the reason code in the reason column  referring to the code list above.
 +=== 11. Returns (For your use) ===
 +
 +This column is to record your daily waste/returns, write the quantity for each product (Do not value).
 +=== 12. Closing Stock (For your use) ===
 +
 +This is the quantity of good closing stock which you intend to sell tomorrow.  Remember ALL Closing stock will need to be written on the next days opening stock column  (Column 3 ).
 +It is especially important that all Saturdays closing stock figures are transferred to the following Mondays opening Stock column  (Column 3 )
 +=== 13. Sell Out Times (For your use) ===
 +
 +This column is for your information when deciding your order for this day next week. You should record the sell out time for your products in this column.
 +=== 14. Sold (For your use) ===
 +
 +This column is for your information.  Your sold figure can be arrived at by taking your available to sell figure, minus any transfers out , less credits, returns, and minus your closing stock  7 - (8 + 10.1 + 11 + 12) = 14
 +=== 15. Suggested Order (Computer Printed) ===
 +
 +Your suggested order is for "This Day" next week, it is normally (Not Christmas etc) based on the todays order (excluding any Special Orders) and will include any amendments you have rung through to the office during the week. 
 +Note:- There is no Standing Order - Your next weeks order will be based on your this weeks normal order.
 +=== 16. 36 Hour Amend / New Order (For your use) ===
 +
 +Any changes to the suggested order must be made in this column.  Only write in this column where you wish to change the suggested quantity.  Write the actual quantity you required (DO NOT WRITE PLUS OR MINUS)
 +Where you are ordering a "Special Order" it is important that you write the quantity required for the special order separately from your normal order, this special order can then be treated differently by the office as it is not a repeating order.  Ring Special Orders for identification purposes and write them in the Late Adjust column.
 +=== 17. Late Adjustments / or Special Orders (For your use) ===
 +
 +As you retain the Pink bottom copy of this sheet, for your own information you should continue to write details of any special orders or adjustments telephoned to the office -  again ring Special Orders for identification purposes
 +=== 18. Product Reference Number ===
 +
 +This is again a note of the product reference number which is printed multiple times to avoid mistakes in selecting products.
 +=== 19. Coffee Shop Transfers  (where applicable) (For your use) ===
 +
 +You should enter the total quantity of each product transferred to the Coffee Shop.
 +=== 20. Multiple  (Minimum order quantity) ===
 +
 +In this column the computer will print the Order Multiple - e.g. If there are 40 units on a board and you are allowed to order by the quarter board - 10 would be printed in this column - you can then order any multiple of 10, you would not however be allowed to order say  for example 15 or 37 as these are not multiples of 10.
 +=== 21. Product Description ===
 +
 +Product Name
 +
 +=== Delivery / Credits  - Information Columns ===
 +
 +This section is on the extreme right hand side of the Shop Control Sheet
 +The information provided shows what you have ordered for each of the past three weeks and how much credit you have received.
 +
 +Credit quantity will include returns, samples, customer complaints and transfers out.  The credit figure may be deducted from the order to obtain your net sale. 
 +
 +This information is provided to assist you, together with today's sales  information from left hand side of this sheet, to decide your order for this day next week. 
 +
 +You must decide order for this day next week TODAY the completed top white copy must be placed in you wallet ready to be returned to the office with your first delivery tomorrow.
 +
 +**Important**
 +
 +Any errors or omissions to your shop control sheet should be crossed through and re-written in any of the blank lines at the bottom of the sheet
 +
Search
Contact Info
an image
Hawkins Bakery Computer Services
The Bakery
Shepton Beauchamp
Ilminster
Somerset
TA19 0LW
Email: sales@bakerycomputing.com

Phone: +44 1460 240600