ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
INSTRUCTIONS
2
3
4
RETAIL PRODUCT COSTING SHEET
5
6
INTRODUCTION
7
This sheet is used for the sole purpose of creating costings for Jacinto & Lirio's own products. Browse through the sheets to see the different products Jacinto & Lirio provides.
8
9
10
11
PROCEDURES
12
1. For new product, duplicate the FORMAT sheet then rename it as the name of the new product.
13
2. It is IMPORTANT to fill in the required details on the upper left table AND to insert the IMAGE of the item
14
3. Only fill in the cells that are EMPTY. DO NOT change nor edit the formulas.
15
4. Input the quantity of the product to be made in Cell F18. There are notes in some cells for you to know what to put
16
5. To find the cost for manufacturing the product, refer to the PRODUCT TEAM COSTING gsheet then apply the function =IMPORTRANGE("link","'name of sheet'!cellnumber") on cell F20. You must do the import range for new manufacturing costs including the date of costing
17
6. WH TOP COAT or WH raw Material Coat rows can be removed IF and ONLY IF they are not part of the product
18
7. IF they are included in the product, use the upper right hand table on the sheet to provide the required length of the WH. It will automatically calculate the price for the WH of 1 product. MAKE SURE TO ADD 1" ON ALL SIDES FOR EXTRA ALLOWANCE
19
8. Choose either LOGO EMBOSS or LOGO ENGRAVE for the product then remove the other as only one type is needed for the inclusion of the company logo
20
9. Refer to Corporate Catalog for the item code
21
10. Refer to the links below for your references in creating the costing of a product
22
IMPORTANT LINKS
23
PRODUCT TEAMS COSTING
24
Laser Engraving Costing
25
VIDEO TUTORIAL
26
Retail Costing
27
Teams Costing
28
29
NOTE:
30
1. All Marikina MLC & Malabon production prices given by Mr. Neco or Ms. Anne are non vat
31
2. For Marikina - LT, same price regardless of quantity
32
3. If quantity of 1k and above, default value chain and delivery will be Php 1.00 at a minimum. Depending on the size of the item, if needed bigger trucks for bigger quantities, price of delivery may be adjusted to more than P1 each
33
4. For hyacinth consumption, if exterior is all hyacinth you can combine front and back if one cutting lang since whole outside is hyacinth. Combine front and back size including estimated spine size then add 1" cutting and folding allowance around
34
5. When adding or inserting another rows and column please always check the summary (because all the tabs will adjust, so as the importranged of the corporate prices in the summary)
35
36
37
38
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
101