Answer:
2015 Cola Inc:
A/R TO 9.51
Days to collect 38.00
2014 Cola Inc:
Inventory TO 10.18
Days to collect 36
2015 Soda Co:
A/R TO 11.25
Days to collect 32
2014 Soda Co
A/RTurnover 11.28
Days to collect 32
Explanation:
2015
[tex]\frac{COGS}{Average Inventory} = $Inventory Turnover[/tex]
where:
[tex]$Average Account Receivable =(Beginning A/R + Ending A/R)/2[/tex]
Sales 39,819
ending 4,531
beginnin 3,839
[tex]$Average A/R=4531 + 3839)/2[/tex]
Avg A/R 4185
[tex]\frac{39,819}{4185} = $A/RTurnover[/tex]
A/R TO 9.514695341
[tex]\frac{365}{A/R TO} = $Days to collect[/tex]
[tex]\frac{365}{9.51469534050179} = $Days to collect[/tex]
Days on Inventory 38
2014:
[tex]\frac{35690}{3505} = $A/RTurnover[/tex]
Inventory TO 10.18259629
[tex]\frac{365}{10.1825962910128} = $Days to collect[/tex]
Days to collect 36
Soda Co:
2015
[tex]\frac{62483}{5554.5} = $A/RTurnover[/tex]
A/R TO 11.24907732
[tex]\frac{365}{11.2490773246917} = $Days to collect[/tex]
Days to collect 32
2014
[tex]\frac{47932}{4250} = $A/RTurnover[/tex]
A/RTurnover 11.27811765
[tex]\frac{365}{Inventory TO} = $Days on Inventory[/tex]
[tex]\frac{365}{11.2781176470588} = $Days to collect[/tex]
Days to collect 32