Cost Accounting: Assessment of Controls
SHAWN QIAN
PentaUpdatedBOM2-28-19.xlsxRaw Materials
| PENTA - COST OF GOODS SOLD | Inventory Valuation 2/26/19 | |||||||||
| Product F-1010 | Item (Inventory Count) | Quick Books | 2/27/2019 Physical Count | Cost | ||||||
| 500mL (4-6 PACK) | ||||||||||
| PER BOTTLE | PER 24 PACK | |||||||||
| BOTTLE | $0.09260 | $2.22240 | Penta BNB- 1.0L | PENTABNB1LTR | 1,274 | $0.66500 | ||||
| CAP | $0.00975 | $0.23400 | Penta BNB-.5L | PENTABNB5LTR | 1,722 | $0.71000 | ||||
| LABEL | $0.02242 | $0.53808 | Penta BNB- 12oz | PENTABNB12OZ | 2,196 | $0.60000 | ||||
| BOX | $0.05992 | $0.71900 | Penta BNB-700ml | PENTABNB7ML | 1,688 | $0.66800 | ||||
| SHRINK WRAP | $0.00020 | $0.02863 | .5LTR Box | PENTABOXSLEEK5LTR24PK | 9,478 | $0.53600 | ||||
| CO-PACK FEE | $0.15750 | $1.89000 | 1.0LTR Box | PENTABOXSLEEK1LTR12PK | 3,696 | $0.53000 | ||||
| PENTA WATER (Inc. in CO-PACK Fees) | ||||||||||
| PALLET | $0.00521 | $0.12500 | ||||||||
| PALLET WRAP | $0.00300 | $0.07203 | 700ml 24pk. Tray | PENTATRAY700ML | 3,980 | $0.26000 | ||||
| $0.35060 | $5.82914 | 12oz 24pk. Tray | TRAY12OZ24 | 11,100 | $0.19000 | |||||
| Hospitality Tray | TRAYHOSP1.0L | 7,700 | $0.24500 | |||||||
| FREIGHT IN | $0.01000 | $0.12 | 6pk. Box | PENTABOXSLEEK6PACK | 977 | $0.89600 | ||||
| TOTAL W/FREIGHT IN | $0.36060 | $5.94914 | Rings | PENTA6PKRINGS | 208 | $0.11900 | ||||
| Product F-1020 | PENTABOTSLEEK.7LTR | 3,955 | $0.10784 | |||||||
| 500mL 12 PACK | PENTABOTSLEEK1LTR | 38,487 | $0.13094 | |||||||
| PER BOTTLE | PER 12 PACK | PREFORM21GRAM1810 | 743,424 | |||||||
| BOTTLE | $0.09260 | $1.11120 | ||||||||
| CAP | $0.00975 | $0.11700 | Purple Cap | PENTACAP28MMPURPLEALCOA | 3,016,000 | $0.00975 | ||||
| LABEL | $0.02242 | $0.26904 | CAP26MMBLKCAP | 302,500 | ||||||
| BOX | $0.05992 | $0.71900 | CAPPENTA12OZCAP | 17,740 | ||||||
| SHRINK WRAP | $0.00020 | $0.02863 | ||||||||
| CO-PACK FEE | $0.15750 | $1.89000 | 1.0LTR Label | PENTALBL1.0LTRSLEEVES | 479,017 | |||||
| PENTA WATER (Inc. in CO-PACK Fees) | .5LTR Label | PENTALBL16.9SLEEVE | 11,772 | $0.02242 | ||||||
| PALLET | $0.00521 | $0.12500 | 12oz. Label | PENTLBL12OZLABEL | 242,617 | |||||
| PALLET WRAP | $0.00300 | $0.07203 | Hospitality Label | PENTALBL1.0LTRHOSP.SLEEVE | 20,740 | |||||
| $0.35060 | $4.33190 | |||||||||
| FREIGHT IN | $0.01000 | $0.12 | ||||||||
| TOTAL W/FREIGHT IN | $0.36060 | $4.45190 | ||||||||
| Product F-1030 | ||||||||||
| 500mL 24 PACK | ||||||||||
| PER BOTTLE | PER CASE | |||||||||
| BOTTLE | $0.09260 | $2.22240 | ||||||||
| CAP | $0.00975 | $0.23400 | ||||||||
| LABEL | $0.02242 | $0.53808 | ||||||||
| BOX | $0.02138 | $0.51300 | ||||||||
| SHRINK WRAP | $0.00205 | $0.04908 | ||||||||
| CO-PACK FEE | $0.07875 | $1.89000 | ||||||||
| PENTA WATER (Inc. in CO-PACK Fees) | ||||||||||
| PALLET | $0.00521 | $0.12500 | ||||||||
| PALLET WRAP | $0.00300 | $0.07203 | ||||||||
| $0.23515 | $5.64359 | |||||||||
| FREIGHT IN | $0.01000 | $0.24000 | ||||||||
| TOTAL W/FREIGHT IN | $0.24515 | $5.88359 | ||||||||
| Product F-1050 | ||||||||||
| 750mL 24 PACK | ||||||||||
| PER BOTTLE | PER CASE | |||||||||
| BOTTLE | $0.10784 | $2.58816 | ||||||||
| CAP | $0.00975 | $0.23400 | ||||||||
| LABEL | $0.02574 | $0.61776 | ||||||||
| BOX | $0.01108 | $0.26599 | ||||||||
| SHRINK WRAP | $0.00205 | $0.04908 | ||||||||
| CO-PACK FEE | $0.07875 | $1.89000 | ||||||||
| PENTA WATER (Inc. in CO-PACK Fees) | ||||||||||
| PALLET | $0.00625 | $0.15000 | ||||||||
| PALLET WRAP | $0.00300 | $0.07203 | ||||||||
| $0.24446 | $5.86702 | |||||||||
| FREIGHT IN | $0.01000 | $0.24000 | ||||||||
| TOTAL W/FREIGHT IN | $0.25446 | $6.10702 | ||||||||
| Product F-1040 | ||||||||||
| 1 LITER 12 PACK | ||||||||||
| PER BOTTLE | PER CASE | |||||||||
| BOTTLE | $0.11350 | $1.36200 | ||||||||
| CAP | $0.00975 | $0.11700 | ||||||||
| LABEL | $0.03338 | $0.40056 | ||||||||
| BOX | $0.04467 | $0.53600 | ||||||||
| SHRINK WRAP | $0.00409 | $0.04908 | ||||||||
| CO-PACK FEE | $0.15750 | $1.89000 | ||||||||
| PENTA WATER (Inc. in CO-PACK Fees) | ||||||||||
| PALLET | $0.00059 | $0.12500 | ||||||||
| PALLET WRAP | $0.00600 | $0.07203 | ||||||||
| $0.36948 | $4.55167 | |||||||||
| FREIGHT IN | $0.01000 | $0.12000 | ||||||||
| TOTAL W/FREIGHT IN | $0.37948 | $4.67167 | ||||||||
Build of Materials
| Product F-1010 | |||
| Cases per Pallet: | 60 | ||
| 500mL (4-6 Pack's) | |||
| PER BOTTLE | PER 4-6 PACK's (Case) | ||
| PENTABOTSLEEK.5LTR | $0.09260 | $2.22240 | |
| PENTAPURPCAPNOV | $0.00975 | $0.23400 | |
| PENTALBL16SLEEVE6PK | $0.02650 | $0.63600 | |
| PENTA6PKRINGS | $0.11900 | $0.47600 | |
| PENTABOXSLEEK6PACK | $0.03525 | $0.84600 | |
| SHRINK WRAP | $0.00020 | $0.02863 | |
| CO-PACK FEE | $0.07875 | $1.89000 | |
| PENTA WATER (Inc. in CO-PACK Fees) | |||
| PALLET | $0.00521 | $0.12500 | |
| PALLET WRAP | $0.00300 | $0.07203 | |
| $0.37026 | $6.53006 | ||
| FREIGHT IN | $0.01000 | $0.12 | |
| TOTAL W/FREIGHT IN | $0.38026 | $6.65006 | |
| Product F-1012 | |||
| Cases per Pallet: | 60 | ||
| 500mL (4-6 PACK)w/Overpack | |||
| Product F-1010 | $6.53006 | ||
| PENTABNB5LTR | $0.71000 | ||
| $7.24006 | |||
| FREIGHT IN | $0.01000 | $0.12 | |
| TOTAL W/FREIGHT IN | $0.01000 | $7.36006 | |
| Product F-1020 | |||
| Cases per Pallet: | 120 | ||
| 500mL 12 Pack | |||
| PER BOTTLE | PER 12 PACK | ||
| PENTABOTSLEEK.5LTR | $0.09260 | $1.11120 | |
| PENTAPURPCAPNOV | $0.00975 | $0.11700 | |
| PENTALBL16.9SLEEVE | $0.02242 | $0.26904 | |
| PENTABOXSLEEK5LTR12PK | $0.05992 | $0.71900 | |
| SHRINK WRAP | $0.00020 | $0.02863 | |
| CO-PACK FEE | $0.15750 | $1.89000 | |
| PENTA WATER (Inc. in CO-PACK Fees) | |||
| PALLET | $0.01042 | $0.12500 | |
| PALLET WRAP | $0.00600 | $0.07203 | |
| $0.35881 | $4.33190 | ||
| FREIGHT IN | $0.01000 | $0.12 | |
| TOTAL W/FREIGHT IN | $0.36881 | $4.45190 | |
| Product F-1022 | |||
| Cases per Pallet: | 120 | ||
| 500mL 12 Pack w/Overpack | |||
| Product F-1020 | $4.33190 | ||
| PENTABNB5LTR | $0.71000 | ||
| $5.04190 | |||
| FREIGHT IN | $0.01000 | $0.12 | |
| TOTAL W/FREIGHT IN | $0.01000 | $5.16190 | |
| Product F-1030 | |||
| Cases per Pallet: | 60 | ||
| 500mL 24 Pack | |||
| PER BOTTLE | PER CASE | ||
| PENTABOTSLEEK.5LTR | $0.09260 | $2.22240 | |
| PENTAPURPCAPNOV | $0.00975 | $0.23400 | |
| PENTALBL16.9SLEEVE | $0.02242 | $0.53808 | |
| PENTABOXSLEEK5LTR24PK | $0.02138 | $0.51300 | |
| SHRINK WRAP | $0.00205 | $0.04908 | |
| CO-PACK FEE | $0.07875 | $1.89000 | |
| PENTA WATER (Inc. in CO-PACK Fees) | |||
| PALLET | $0.00521 | $0.12500 | |
| PALLET WRAP | $0.00300 | $0.07203 | |
| $0.23515 | $5.64359 | ||
| FREIGHT IN | $0.01000 | $0.24000 | |
| TOTAL W/FREIGHT IN | $0.24515 | $5.88359 | |
| Product F-1032 | |||
| Cases per Pallet: | 60 | ||
| 500mL 24 Pack w/Overpack | |||
| Product F-1030 | $5.64359 | ||
| PENTABNB5LTR | $0.71000 | ||
| $6.35359 | |||
| FREIGHT IN | $0.01000 | $0.12 | |
| TOTAL W/FREIGHT IN | $0.01000 | $6.47359 | |
| Product F-1040 | |||
| Cases per Pallet: | 60 | ||
| 1 Liter 12 Pack | |||
| PER BOTTLE | PER CASE | ||
| PENTABOTSLEEK1LTR | $0.13094 | $1.57128 | |
| PENTAPURPCAPNOV | $0.00975 | $0.11700 | |
| PENTALBL1.0LTRSLEEVES | $0.03338 | $0.40056 | |
| PENTABOXSLEEK1LTR12PK | $0.04467 | $0.53600 | |
| SHRINK WRAP | $0.00409 | $0.04908 | |
| CO-PACK FEE | $0.15750 | $1.89000 | |
| PENTA WATER (Inc. in CO-PACK Fees) | |||
| PALLET | $0.00059 | $0.12500 | |
| PALLET WRAP | $0.00600 | $0.07203 | |
| $0.38692 | $4.76095 | ||
| FREIGHT IN | $0.01000 | $0.12000 | |
| TOTAL W/FREIGHT IN | $0.39692 | $4.88095 | |
| Product F-1042 | |||
| Cases per Pallet: | 60 | ||
| 1 Liter 12 Pack w/Overpack | |||
| Product F-1040 | $4.76095 | ||
| PENTABNB1LTR | $0.66500 | ||
| $5.42595 | |||
| FREIGHT IN | $0.01000 | $0.12 | |
| TOTAL W/FREIGHT IN | $0.01000 | $5.54595 | |
| Product F-1050 | |||
| Cases per Pallet: | 50 | ||
| 750mL 24 PACK | |||
| PER BOTTLE | PER CASE | ||
| PENTABOTSLEEK.7LTR | $0.10784 | $2.58816 | |
| PENTAPURPCAPNOV | $0.00975 | $0.23400 | |
| PENTALBL700SLEEVE | $0.02574 | $0.61776 | |
| PENTATRAY700ML | $0.02217 | $0.26600 | |
| SHRINK WRAP | $0.00205 | $0.04908 | |
| CO-PACK FEE | $0.07875 | $1.89000 | |
| PENTA WATER (Inc. in CO-PACK Fees) | |||
| PALLET | $0.00625 | $0.15000 | |
| PALLET WRAP | $0.00300 | $0.07203 | |
| $0.25554 | $5.86703 | ||
| FREIGHT IN | $0.01000 | $0.24000 | |
| TOTAL W/FREIGHT IN | $0.26554 | $6.10703 | |
| Product F-1052 | |||
| Cases per Pallet: | 50 | ||
| 750mL 24 Pack w/Overpack | |||
| Product F-1050 | $5.86703 | ||
| PENTABNB7ML | $0.66800 | ||
| $6.53503 | |||
| FREIGHT IN | $0.01000 | $0.12 | |
| TOTAL W/FREIGHT IN | $0.01000 | $6.65503 | |
Finished Goods
| Products | |||||||||||
| F-1010 | F-1012 | F-1020 | F-1022 | F-1030 | F-1032 | F-1040 | F-1042 | F-1050 | F-1052 | ||
| 2018 | |||||||||||
| CA | 660 | 1,307 | 34,359 | 18,960 | 3,959 | ||||||
| MO | 540 | 679 | 113 | 364 | 1,039 | 445 | |||||
| PA | 180 | 204 | 4 | 91 | 138 | 338 | |||||
| GA | 453 | 85 | 240 | 989 | 597 | 389 | |||||
| Counts: | 1,833 | 289 | 1,551 | 0 | 36,118 | 113 | 20,059 | 1,039 | 5,131 | 0 | |
| Value: | $11,969.60 | $2,092.38 | $6,718.78 | $0.00 | $203,835.18 | $717.96 | $95,499.90 | $5,637.56 | $30,103.73 | ||
| Total: | $356,575.08 | ||||||||||
| 2017 | |||||||||||
| CA | 1,111 | 4 | 1,154 | 14,891 | 3,696 | 5,469 | |||||
| MO | 96 | 164 | 1,233 | 1,220 | |||||||
| PA | 72 | 223 | 1 | 1,255 | 1,300 | 278 | |||||
| GA | 199 | 89 | 3,338 | 2,711 | 200 | ||||||
| Counts: | 1,382 | 412 | 1,319 | 0 | 20,717 | 0 | 8,927 | 0 | 5,947 | ||
| Value: | $9,024.54 | $2,982.90 | $5,713.78 | $0.00 | $116,918.25 | $0.00 | $42,501.00 | $0.00 | $34,891.23 | ||
| Total: | $212,031.71 | ||||||||||
| Cost: | $6.53006 | $7.24006 | $4.33190 | $5.04190 | $5.64359 | $6.35359 | $4.76095 | $5.42595 | $5.86703 | ||
