Lannister Company wishes to forecast its cash receipts and cash disbursements for the first quarter of 2020 The following data have been assembled a Actual sales for November and December of 2019 and forecasted sales data for the first four months of 2020 are as follows November (actual) December (actual) January (estimate) February (estimate) March (estimate) April (estimate) $450,000 750,000 150,000 75,000 300,000 500,000 Lannister pays for 20 of its inventory purchases in the month of the purchase An additional 70 is paid for in the month following the purchase The remaining 10 is paid for in the second month following the purchase Inventory purchases in November and December were $330,000 and $110,000, respectively Cash collections of sales are made according to the following pattern 10 of sales are collected in the month of sale 30 of sales are collected in the month following sale 55 of sales are collected in the second month following sale 5 of sales are never collected On average, cost of goods sold is 75 of sales Lannister started implementing an ending inventory policy in 2020 that there should be enough inventory at the end of the month to meet the sales needs for the following month On January 1, Lannister's inventory level is $100,000 Note Inventory is reported at its COST, not its retail selling price Questions Budgeted sales in March ($300,000) are higher than in January ($150,000) and February ($75,000) Calculate the budgeted net cash flows in January, February and March Why is the budgeted net cash flow in March is much worse than in January or February Compute the budgeted difference between cash receipts and cash disbursements for January, February, and March using the following worst case and best case sales scenarios Worst Case Best Case November (actual) $450,000 $450,000 December (actual) 750,000 750,000 January (estimate) 90,000 300,000 February (estimate) 50,000 180,000 March (estimate) 200,000 700,000 April (estimate) 300,000 1,000,000 3 Comment on the differences in budgeted cash amounts in the worst case, middle case (based on the numbers in (a) above), and best case scenarios

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 29, 2024

Lannister Company wishes to forecast its cash receipts and cash disbursements for the first quarter of 2020. The following data have been assembled:

a. Actual sales for November and December of 2019 and forecasted sales data for the first

four months of 2020 are as follows: November (actual)

December (actual) January (estimate) February (estimate) March (estimate) April (estimate)

$450,000 750,000 150,000

75,000 300,000 500,000

Lannister pays for 20% of its inventory purchases in the month of the purchase. An additional 70% is paid for in the month following the purchase. The remaining 10% is paid for in the second month following the purchase. Inventory purchases in November and December were $330,000 and $110,000, respectively.
Cash collections of sales are made according to the following pattern: 10% of sales are collected in the month of sale
30% of sales are collected in the month following sale
55% of sales are collected in the second month following sale
5% of sales are never collected
On average, cost of goods sold is 75% of sales.
Lannister started implementing an ending inventory policy in 2020 that there should be
enough inventory at the end of the month to meet the sales needs for the following month. On January 1, Lannister's inventory level is $100,000. Note: Inventory is reported at its COST, not its retail selling price.

Questions:

Budgeted sales in March ($300,000) are higher than in January ($150,000) and February ($75,000). Calculate the budgeted net cash flows in January, February and March. Why is the budgeted net cash flow in March is much worse than in January or February?
Compute the budgeted difference between cash receipts and cash disbursements for January, February, and March using the following worst-case and best-case sales scenarios.

Worst-Case. Best-Case

November (actual) $450,000 $450,000

December (actual) 750,000 750,000

January (estimate) 90,000 300,000

February (estimate) 50,000 180,000

March (estimate) 200,000 700,000

April (estimate) 300,000 1,000,000

3. Comment on the differences in budgeted cash amounts in the worst case, middle case (based on the numbers in (a) above), and best case scenarios.