GCU ACC 502 Topic 3 Assignment Analyzing Inventory Ratios

Inventory Turnover (IT)= (Cost of goods sold/Total Inventories)

COCA-COLA

Pepsi Co.

Coca-cola’s inventory turnover for the quarter that ended in September 2021. 

Pepsi Co. Inventory turnover for the quarter that ended in September 2021

Inventory Turnover Q Sep 2021

Inventory Turnover Q Sep 2021
Cost of Goods Sold (Q Sep 2021)
 $                    3,977.00

Cost of Goods Sold (Q Sep 2021) $  9,394.00

Total Inventories

Total Inventories

Q June 2021

 $                  3,281.00

Q June 2021
 $  5,006.00
Q September 2021
 $                  3,182.00

Q September 2021
 $  4,364.00

Total Inventories

 $                    3,231.50

Total Inventories

 $  4,685.00

Coca-cola’s Inventory Turnover
1.230697818

Pepsi’s Inventory Turnover
2.0051227

For the last Two years

CompanyYearCost of Goods soldTotal InventoriesInventory Turnover

Coca-cola2020 $                 13,433.00 $                  3,322.504.04303988

2019

4.53

Pepsi Co.2020 $                 31,797.00 $                  3,755.008.467909454

2019

9.32

Average days in Inventory= (Total Inventories/ Cost of goods sold)*days in period 

Note: My Calculations are in quarters. Thus, days in period would be; (365/4)
91.25

COCA-COLA

Pepsi Co.

Coca-cola’s average days in inventory for the three months ended in September 2021;

Pepsi’s average days in inventory for the three months ended in September 2021;

Total Inventories $  3,231.50

Total Inventories
 $  4,685.00

Cost of Goods Sold $  3,977.00

Cost of Goods Sold
 $  9,394.00

Average days in inventory
74.14493

Average days in inventory
45.50844

CompanyYearAverage days in Inventory

Coca-cola202090.278605

201980.573951

Pepsi Co.202043.103909

201939.16309