accounting operations

profilehardydemarri18
CH13InventoryValuationSummary12.31.26.xlsx
Home>Business & Finance homework help>Accounting homework help>accounting operations

Inventory Valuation Detail

Raincross Auto Detailing (Ashanti Hardy)
Inventory Valuation Detail
June 2021 - December 2026
Date Transaction Type Num Name Qty Rate FIFO Cost Qty On Hand Asset Value
Dry Towels
11/30/2026 Inventory Starting Value START 0 5.25 0.00 0.00 0.00
12/04/2026 Bill GLJ Car Detail Supplies 20 5.25 105.00 20.00 105.00
12/07/2026 Invoice 26-118 Annette Helsper -1 5.25 -5.25 19.00 99.75
12/08/2026 Invoice 26-119 Skye Simpson -1 5.25 -5.25 18.00 94.50
12/08/2026 Invoice 26-121 Cynthia Swan -1 5.25 -5.25 17.00 89.25
12/09/2026 Invoice 26-122 Dan Thomas -1 5.25 -5.25 16.00 84.00
12/10/2026 Invoice 26-126 Scott Johnie -1 5.25 -5.25 15.00 78.75
12/11/2026 Invoice 26-128 Kimmy Lear -1 5.25 -5.25 14.00 73.50
12/14/2026 Inventory Qty Adjust 11 -5 5.25 -26.25 9.00 47.25
12/17/2026 Invoice 26-141 Steven Sims -1 5.25 -5.25 8.00 42.00
12/21/2026 Invoice 26-149 Carlos Espinosa -1 5.25 -5.25 7.00 36.75
12/22/2026 Invoice 26-151 Mary Crofoot -1 5.25 -5.25 6.00 31.50
Total for Dry Towels 6 $31.50 6 $31.50
Glass Polish
11/30/2026 Inventory Starting Value START 0 2.59 0.00 0.00 0.00
12/04/2026 Bill Patsy's Automotive Supplies 25 2.59 64.75 25.00 64.75
12/08/2026 Invoice 26-121 Cynthia Swan -1 2.59 -2.59 24.00 62.16
12/11/2026 Invoice 26-128 Kimmy Lear -1 2.59 -2.59 23.00 59.57
12/15/2026 Invoice 26-137 Becky Craig -1 2.59 -2.59 22.00 56.98
12/18/2026 Bill Patsy's Automotive Supplies 10 2.59 25.90 32.00 82.88
12/22/2026 Invoice 26-151 Mary Crofoot -1 2.59 -2.59 31.00 80.29
12/30/2026 Inventory Qty Adjust 12 -1 2.59 -2.59 30.00 77.70
Total for Glass Polish 30 $77.70 30 $77.70
Interior Cleaner
11/30/2026 Inventory Starting Value START 0 3.89 0.00 0.00 0.00
12/04/2026 Bill Patsy's Automotive Supplies 25 3.89 97.25 25.00 97.25
12/07/2026 Invoice 26-118 Annette Helsper -1 3.89 -3.89 24.00 93.36
12/08/2026 Invoice 26-119 Skye Simpson -1 3.89 -3.89 23.00 89.47
12/10/2026 Invoice 26-126 Scott Johnie -1 3.89 -3.89 22.00 85.58
12/17/2026 Invoice 26-141 Steven Sims -1 3.89 -3.89 21.00 81.69
12/18/2026 Bill Patsy's Automotive Supplies 10 3.89 38.90 31.00 120.59
12/18/2026 Invoice 26-146 Larry James -1 3.89 -3.89 30.00 116.70
12/21/2026 Invoice 26-149 Carlos Espinosa -1 3.89 -3.89 29.00 112.81
Total for Interior Cleaner 29 $112.81 29 $112.81
Leather Conditioner
11/30/2026 Inventory Starting Value START 0 6.27 0.00 0.00 0.00
12/07/2026 Bill Rosey & Girls Auto Supply 10 6.27 62.70 10.00 62.70
12/09/2026 Invoice 26-122 Dan Thomas -1 6.27 -6.27 9.00 56.43
12/10/2026 Invoice 26-126 Scott Johnie -1 6.27 -6.27 8.00 50.16
12/11/2026 Invoice 26-128 Kimmy Lear -1 6.27 -6.27 7.00 43.89
12/11/2026 Invoice 26-130 Stacey Byrne -1 6.27 -6.27 6.00 37.62
12/17/2026 Invoice 26-142 Amber Williams -1 6.27 -6.27 5.00 31.35
12/21/2026 Invoice 26-148 Seth David -1 6.27 -6.27 4.00 25.08
12/30/2026 Inventory Qty Adjust 12 -3 6.27 -18.81 1.00 6.27
Total for Leather Conditioner 1 $6.27 1 $6.27
Paste Wax
11/30/2026 Inventory Starting Value START 0 7.25 0.00 0.00 0.00
12/07/2026 Bill Rosey & Girls Auto Supply 15 7.25 108.75 15.00 108.75
12/10/2026 Invoice 26-126 Scott Johnie -1 7.25 -7.25 14.00 101.50
12/11/2026 Invoice 26-128 Kimmy Lear -1 7.25 -7.25 13.00 94.25
12/30/2026 Inventory Qty Adjust 12 -3 7.25 -21.75 10.00 72.50
Total for Paste Wax 10 $72.50 10 $72.50
Rubbing Compound
11/30/2026 Inventory Starting Value START 0 5.03 0.00 0.00 0.00
12/07/2026 Bill Rosey & Girls Auto Supply 15 5.03 75.45 15.00 75.45
12/09/2026 Invoice 26-122 Dan Thomas -1 5.03 -5.03 14.00 70.42
12/11/2026 Invoice 26-130 Stacey Byrne -1 5.03 -5.03 13.00 65.39
12/18/2026 Invoice 26-146 Larry James -1 5.03 -5.03 12.00 60.36
12/30/2026 Inventory Qty Adjust 12 -2 5.03 -10.06 10.00 50.30
Total for Rubbing Compound 10 $50.30 10 $50.30
Vinyl Rubber Dressing
11/30/2026 Inventory Starting Value START 0 3.55 0.00 0.00 0.00
12/07/2026 Bill Rosey & Girls Auto Supply 15 3.55 53.25 15.00 53.25
12/09/2026 Invoice 26-122 Dan Thomas -1 3.55 -3.55 14.00 49.70
12/09/2026 Invoice 26-125 John McNay -1 3.55 -3.55 13.00 46.15
12/15/2026 Invoice 26-137 Becky Craig -1 3.55 -3.55 12.00 42.60
12/21/2026 Invoice 26-148 Seth David -1 3.55 -3.55 11.00 39.05
Total for Vinyl Rubber Dressing 11 $39.05 11 $39.05
Wash Mitts
11/30/2026 Inventory Starting Value START 0 7.00 0.00 0.00 0.00
12/04/2026 Bill GLJ Car Detail Supplies 20 7.00 140.00 20.00 140.00
12/07/2026 Invoice 26-117 Sean Murphy -1 7.00 -7.00 19.00 133.00
12/07/2026 Invoice 26-118 Annette Helsper -1 7.00 -7.00 18.00 126.00
12/08/2026 Invoice 26-121 Cynthia Swan -1 7.00 -7.00 17.00 119.00
12/14/2026 Inventory Qty Adjust 11 -5 7.00 -35.00 12.00 84.00
12/17/2026 Invoice 26-141 Steven Sims -1 7.00 -7.00 11.00 77.00
12/18/2026 Invoice 26-146 Larry James -1 7.00 -7.00 10.00 70.00
12/22/2026 Invoice 26-151 Mary Crofoot -1 7.00 -7.00 9.00 63.00
Total for Wash Mitts 9 $63.00 9 $63.00
Wheel Rim Polish
11/30/2026 Inventory Starting Value START 0 4.50 0.00 0.00 0.00
12/07/2026 Bill Rosey & Girls Auto Supply 10 4.50 45.00 10.00 45.00
12/15/2026 Invoice 26-137 Becky Craig -1 4.50 -4.50 9.00 40.50
12/16/2026 Credit Memo 26-140 Becky Craig 1 4.50 4.50 10.00 45.00
12/17/2026 Invoice 26-141 Steven Sims -1 4.50 -4.50 9.00 40.50
Total for Wheel Rim Polish 9 $40.50 9 $40.50
Window Cleaner
11/30/2026 Inventory Starting Value START 0 1.75 0.00 0.00 0.00
12/04/2026 Bill Patsy's Automotive Supplies 30 1.75 52.50 30.00 52.50
12/07/2026 Invoice 26-117 Sean Murphy -1 1.75 -1.75 29.00 50.75
12/07/2026 Invoice 26-118 Annette Helsper -1 1.75 -1.75 28.00 49.00
12/08/2026 Invoice 26-121 Cynthia Swan -1 1.75 -1.75 27.00 47.25
12/17/2026 Invoice 26-141 Steven Sims -1 1.75 -1.75 26.00 45.50
12/18/2026 Bill Patsy's Automotive Supplies 15 1.75 26.25 41.00 71.75
12/22/2026 Invoice 26-151 Mary Crofoot -1 1.75 -1.75 40.00 70.00
12/30/2026 Inventory Qty Adjust 12 -10 1.75 -17.50 30.00 52.50
Total for Window Cleaner 30 $52.50 30 $52.50
Saturday, Jun 12, 2021 08:51:13 PM GMT-7