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.
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
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
