La Reina de Oriente, S.A., a company that sells sausages, knows that it pays its suppliers 10 times a year. To determine the average collection period it is known that the annual sales of the company were $5'183,220.00, of which 70% are on credit and the average balance of customers is $382,982.37, that is to say it is necessary to calculate the turnover of accounts receivable; and the average age of inventory is based on the inventory turnover, whose data to calculate it as the previous one are: Average inventory 153,192.95 and its annual cost of sales amounts to $1'002,716.78. The company spends about $12.5 million in operating cycle investments. It plans to make modifications to its policies so that it can reduce its PPC by 5 days, and its EPI by one (before converting it to days). Negotiations with your supplier to extend payment terms have not been successful. With these data you have to calculate: 5) The operating cycle. 6) The cash conversion cycle. 7) Cash turnover.
CC2) La Reina de Oriente, S.A., a company that sells sausages, knows that it pays its suppliers 10 times a year. To determine the average collection period it is known that the annual sales of the company were $5'183,220.00, of which 70% are on credit and the average balance of customers is $382,982.37, that is to say it is necessary to calculate the turnover of accounts receivable; and the average age of inventory is based on the inventory turnover, whose data to calculate it as the previous one are: Average inventory 153,192.95 and its annual cost of sales amounts to $1'002,716.78. The company spends about $12.5 million in operating cycle investments.
It plans to make modifications to its policies so that it can reduce its PPC by 5 days, and its EPI by one (before converting it to days). Negotiations with your supplier to extend payment terms have not been successful. With these data you have to calculate:
5) The operating cycle.
6) The cash conversion cycle.
7) Cash turnover.
8) The minimum cash balance.
9) Re-calculate the Operating Cycle, the CCE, RC and SMC by introducing the proposed changes.
10) Calculate the
Note:
In the image, this is the original exercise, it is in Spanish, but it is easy to understand.
Very important Note:
It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.
please... understand the context of the exercise in Spanish, it is easy to understand.
Step by step
Solved in 3 steps with 2 images
