8-16 a. Calculate purchases, gross margin, inventory turn days, accounts receivable turn days,
and accounts payable turn days for the years ended 20x2, 20x3, 20x4, 20x5.
(000s omitted for all)
-Purchases 20x2 $2,993 ($1,327 – 1,025 + 2,691)
20x3 $2,171 ($1,099 – 1,327 + 2,399)
20x4 $1,999 ($1,003 – 1,099 + 2,095)
20x5 $1,883 ($1,027 – 1,003 + 1,859)
-Gross Margin 20x2 52% ($5,638 – 2,691 / 5,638)
20x3 48% ($4,623 – 2,399 / 4,623)
20x4 48% ($4,022 – 2,095 / 4,022)
20x5 52% ($3,905 – 1,859 / 3,905)
-Inventory turn days 20x2 179.99 ($1,327 / 2,691 * 365)
20x3 167.21 ($1,099 / 2,399 * 365)
20x4 174.75 ($1,003 / 2,095 * 365)
20x5 201.64 ($1,027 / 1,859 * 365)
-Accounts receivable turn days 20x2 70.38 ($5,638 / [837 + 1,335] / 2 = 5.19, 365/5.19)
20x3 96.05 ($4,623 / [$1,335 + 1,121] / 2 = 3.8, 365/3.8 )
20x4 94.56 ($4,022 / [1,121 + 962] / 2 = 3.86, 365/3.86)
20x5 83.33 ($3,905 / [962 + 822] / 2 = 4.38, 365/4.38)
-Accounts payable turn days 20x2 33.18 ($2,993 / [164 + 380] / 2 = 11, 365/11)
20x3 50.84 ($2,171 / [380 + 225] / 2 = 7.18, 365/7.18)
20x4 38.87 ($1,999 / [225 + 201] / 2 = 9.39, 365/9.39)
20x5 36.43 ($1,883 / [201 + 175] / 2 = 10.02, 365/10.02)
b. Describe the trends identified by performing analytical procedures in the gross operating
cycle, the net operating cycle, and gross margin.
Gross operating cycle 20x2 250.37 (179.99 + 70.38)
20x3 263.26 (167.21 + 96.05)
20x4 269.31 (174.75 + 94.56)
20x5 284.97 (201.64 + 83.33)
There is an upward trend in the gross operating cycle; this shows operations are not being run efficiently in regards to managing working capital.
Net operating cycle 20x2 217.19 (250.37 – 33.18)
20x3 212.42 (263.26 – 50.84)
20x4 230.44 (269.31 –...