The cash budget shows a significant deficiency in both January and February.
Crane Company Cash Budget for 2022
January 2022
Item Amount
Cash balance, January 1 $62,400
Receipts:
Sales collections (50% of December 2021 sales) $166,400
Collection of December 31, 2021, notes receivable $15,600
Total receipts $182,000
Disbursements:
Purchases of direct materials (60% of December 2021 purchases) $62,400
Direct labor $93,600
Manufacturing overhead $72,800
Selling and administrative expenses $81,120
Cash dividend $0
Total disbursements $309,920
Excess (deficiency) of cash ($127,920)
February 2022
Item Amount
Cash balance, February 1 (deficiency) ($127,920)
Receipts:
Sales collections (50% of January 2022 sales + 30% of December 2021 sales) $260,880
Proceeds from sale of securities $6,240
Total receipts $267,120
Disbursements:
Purchases of direct materials (40% of December 2021 purchases + 60% of January 2022 purchases) $41,600
Direct labor $104,000
Manufacturing overhead $78,000
Selling and administrative expenses $87,360
Cash dividend $6,240
Total disbursements $317,200
Excess (deficiency) of cash ($49,080)
Analysis:
The cash budget shows a significant deficiency in both January and February.
The company needs to take action to improve its cash flow, such as:
Reducing its inventory of direct materials.
Negotiating better payment terms with suppliers.
Collecting receivables more quickly.
Delaying non-essential expenditures.