ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Please make a copy. Go to File > Make a copy.
2
 TouchBistro's Restaurant Order Guide Template
3
Instructions:
4
1. Fill out the top section, which includes the vendor, shipping, and billing details.
5
2. Fill out the PO number and Updated Date.
6
3. Fill out the Category column by using the drop down to select the category your item falls under.
7
4. Fill out the Product Code column with the code or number for the designated item.
8
5. Fill out the Product Name column with the name of the product.
9
6. Fill out the Par column with the amount you need of the item on hand at all times.
10
7. Fill out the Quantity On Hand column with the amount of the item you already have on hand in your inventory.
11
8. Fill out the Quantity to Order column with the quantity of the item you need to order from the vendor.
12
9. Fill out the Unit column with the unit that you order that item in (i.e. lbs, oz, etc.)
13
10. Fill out the Unit Price column with how much each unit will cost for the item.
14
11. Calculate the Total Price by multiplying what you inputted in the Quantity to Order column by the price you filled out in the Unit Price column.
15
12. Fill out the Delivery Day for the item by selecting one of the days in the drop down menu.
16
13. Use the Additional Notes column for any notes that you would like to include.
17
14. Repeat steps 3 - 12 for each additional item.
18
15. Duplicate the sheet "Vendor" to create a new sheet for each vendor your restaurant is ordering from.
19
20
NOTE: You can add more options for "Category" by right clicking one of the examples already listed and selecting the "Edit button".
You'll then see an option for "Add another item," which allows you to add more category options.
Once you finish making your edits you can select "Done".
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100