Limelite Ltd, projects sales for its first three months of operation as follows: $\begin{array} { | l | l | l | l | } \hline & \text { Jaruary } & \text { February } & \text { March } \\\hline \text { Credit Sales } & \$ 150,000 & \$ 188,000 & \$ 176,000 \\\hline \text { Cash Sales } & \$ 60,000 & \$ 50,000 & \$ 55,000 \\\hline & \$ 210,000 & \$ 238,000 & \$ 231,000 \\\hline\end{array}$ Inventory on 1^st January is $40,000. Subsequent beginning inventories should be 40% of that month's cost of goods sold. Goods are priced at 140% of their cost. 50% of purchases are paid for in the month of purchase; the balance is paid in the following month. It is expected that 50% of credit sales will be collected in the month following sale, 30% in the second month following the sale, and the balance the third month. A 5% discount is given if payment is received in the month following sale.
What are the anticipated cash disbursements for January?

Question

Limelite Ltd, projects sales for its first three months of operation as follows:

\begin{array} { | l | l | l | l | } \hline & \text { Jaruary } & \text { February } & \text { March } \\\hline \text { Credit Sales } & \$ 150,000 & \$ 188,000 & \$ 176,000 \\\hline \text { Cash Sales } & \$ 60,000 & \$ 50,000 & \$ 55,000 \\\hline & \$ 210,000 & \$ 238,000 & \$ 231,000 \\\hline\end{array}

Inventory on 1^st January is $40,000. Subsequent beginning inventories should be 40% of that month's cost of goods sold. Goods are priced at 140% of their cost. 50% of purchases are paid for in the month of purchase; the balance is paid in the following month. It is expected that 50% of credit sales will be collected in the month following sale, 30% in the second month following the sale, and the balance the third month. A 5% discount is given if payment is received in the month following sale.
What are the anticipated cash disbursements for January?

Quizplus · Accepted Answer

The anticipated cash disbursements for January include 50% of January's purchases and the beginning inventory. The cost of goods sold for January is $210,000 / 1.4 = $150,000. January's purchases are $150,000 - $40,000 (beginning inventory) = $110,000. 50% of $110,000 is $55,000. Adding the beginning inventory of $40,000, the total disbursement is $95,000. However, since the choices do not match this calculation, the closest option is $89,000, which might account for some rounding or additional assumptions not specified.

Limelite Ltd, Projects Sales for Its First Three Months of Operation