Product 1 is complete. First, review the computations for products 1.
Second, do the same procedures for all other products.
Value Cost of Goods sold first: quantity sold x average cost. Then value ending inventory at total available cost less the cost of goods sold.
Shows formulas
s
As of December 2019 Invehtory Report: Periodic Average Cost December YTD Average Item# Description Quantity Cost for 1 Total Cost Sales 1 138 112 Price 12.65 13.25 13.10 13.29 204 $ 39.99 Sales $ 112,611.84 250 150 120 375 450 240 285 330 225 13.74 $ $ $ $ $ $ $ $ $ $ $ 126 Natural Hair Oil 9-Jan 8-Feb 17-Mar 30-Apr 31-May 30-Jun 31-Jul 31-Aug 30-Sep 31-Oct 30-Nov Dec Online Sales 5-Dec WK ended 12-Dec WK ended 19-Dec WK ended 31-Dec 12/20-12/31 $ $ $ $ $ $ $ $ $ $ $ $ 3,162.50 1,987.50 1,572.00 4,983.75 6,183.00 3,333.60 3,978.60 4,702.50 3,069.00 2,361.60 3,042.00 CGS $ 13.89 13.96 14.25 13.64 13.12 13.52 39,607.82 267 303 328 198 204 242 207 314 14.07 2,816 Units 444 14.07 Units Inventory 180 $ 6,244.98 $ 225 26 150 $ $ 17.50 17.79 $ $ 2,625.00 1,334.25 8 85 75 80 17.25 $ $ $ 17.10 125 3260 $ $ 1,380.00 2,137.50 45,852.80 115 $ 45,852.80 $ 14.07 65 3,260 Average Cost 2,816 444 Ending Inventory Sales Cost for 1 Total Cost 2 8.74 8.54 8.10 122 189 172 212 Price $ 8.25 Sales 19.99 8.36 $ $ $ $ $ $ $ $ $ $ $ 8.19 $ $ $ $ $ $ $ $ $ $ $ 201 213 Quantity 410 Hair Conditioner 9-Jan 200 8-Feb 150 17-Mar 150 30-Apr 300 31-May 275 30-Jun 300 31-Jul 350 31-Aug 350 30-Sep 325 31-Oct 325 30-Nov 285 Dec Online Sales 5-Dec Wk 100 12-Dec Wk 80 19-Dec WK 75 31-Dec WK 75 3,340 1,748.00 1,281.00 1,215.00 2,475.00 2,299.00 2,457.00 2,782.50 2,842.00 2,528.50 2,769.00 2,436.75 7.95 CGS 8.12 7.78 8.52 8.55 289 297 329 349 362 42 12 Inventory 10.25 $ $ $ $ $ 1,025.00 825.60 10.32 80 10.49 60 $ 10.10 $ $ $ 786.75 757.50 28,228.60 Average Cost 137 3,066 Ending Inventory nventory Cost for 1 Total Cost Sales Quantity 196 Rose Anti-wrinkle Cream 3 80 75 150 $ $ $ $ $ 22.75 22.50 22.64 22.32 22.68 26 52 155 109 $ Price Terms 125 $ $ Sales 125 $ $ 64 $ 49.99 125 21.94 $ 129 is in 1,820.00 1,687.50 3,396.00 2,790.00 2,835.00 2,742.50 2,730.00 3,250.50 3,851.75 3,864.00 3,276.00 125 $ 135 CGS 21.84 21.67 150 $ 9-Jan 8-Feb 17-Mar 30-Apr 31-May 30-Jun 31-Jul 31-Aug 30-Sep 31-Oct 30-Nov Dec Online Sales 5-Dec WK 12-Dec Wk 19-Dec Wk 31-Dec Wk 157 is in 175 22.01 $ 182 175 $ 22.08 194 Inventory $ $ 150 $ 21.84 136 23 100 $ 75 $ $ $ 24.60 24.90 24.40 $ $ 2,460.00 1,867.50 976.00 1,248.00 38,794.75 12 53 50 40 50 $ 24.96 58 Average Cost $ $ 1,720 1,535 Ending Inventory Cost for 1 Total Cost Sales 4 $ $ $ $ 88 104 128 Price $ 164 Sales 49.99 157 $ $ $ $ $ $ $ $ $ $ $ Quantity 221 Acai Orchard Moisturizer 9-Jan 175 8-Feb 150 17-Mar 125 30-Apr 100 31-May 180 30-Jun 180 31-Jul 180 31-Aug 180 30-Sep 225 31-Oct 225 30-Nov 250 Dec Online Sales 5-Dec WK 200 12-Dec Wk 150 16.79 16.95 17.10 17.35 17.32 17.42 17.59 17.10 16.78 16.89 16.64 $ $ 2,938.25 2,542.50 2,137.50 1,735.00 3,117.60 3,135.60 3,166.20 3,078.00 3,775.50 3,800.25 4,160.00 186 202 CGS $ $ 214 186 $ $ $ 199 Inventory 203 19 20 19.50 $ $ $ $ 3,900.00 2,973.00 19.82 47 19-Dec WK 50 $ 20.10 $ 57 31-Dec WK 85 $ 19.65 1,005.00 1,670.25 43,134.65 74 $ $ Average Cost 2,455 2,048 Ending Inventory Quantity Cost for 1 Total Cost Sales 5 300 300 300 3.25 3.34 3.49 3.55 $ $ $ 196 228 264 Price $ 237 Sales $ 9.99 300 325 $ 3.46 3.12 330 $ $ $ $ $ $ $ $ $ $ $ 81 Tooth Paste 9-Jan 8-Feb 17-Mar 30-Apr 31-May 30-Jun 31-Jul 31-Aug 30-Sep 31-Oct 30-Nov Dec All Online Sales 5-Dec Wk 12-Dec WK $ 975.00 1,002.00 1,047.00 1,065.00 1,124.50 1,029.60 1,130.50 1,207.50 1,225.00 1,260.00 1,348.00 350 3.23 $ CGS 350 3.45 $ 266 248 312 303 400 385 408 $ 350 350 3.50 3.60 $ Inventory 400 3.37 $ 31 200 25 $ $ 5.29 5.51 $ $ 1,058.00 551.00 100 112 19-Dec WK 75 $ 5.42 $ 406.50 125 31-Dec WK 75 $ 5.34 $ 400.50 109 Average Cost 4,105 $ 14,830.10 3,649 Ending Inventory Total Available $ 170,840.90 Total Ending Inventory $ 6,244.98 Total Cost of Goods Sold $ 164,595.92
