Ask Question
23 December, 13:01

Cullumber Company expects to have a cash balance of $138,000 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022. 1. Collections from customers: January $213,000, February $438,000. 2. Payments to suppliers: January $120,000, February $225,000. 3. Wages: January $90,000, February $120,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $63,000, February $72,000. These costs include depreciation of $3,000 per month. All other costs are paid as incurred. 5. Selling expenses: January $45,000, February $60,000. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize $36,000 in cash. Cullumber Company has a line of credit at a local bank that enables it to borrow up to $75,000. The company wants to maintain a minimum monthly cash balance of $60,000.

+4
Answers (1)
  1. 23 December, 13:09
    0
    Answer and Explanation:

    The preparation of cash budget is shown below:-

    Cash Budget

    January February

    Beginning cash balance $1,38,000 $72,000

    Add: Receipts:-

    Collections from customers$2,13,000 $4,38,000

    Sale of marketable securities$36,000 $-

    Total receipts $2,49,000 $4,38,000

    Total available cash $3,87,000 $5,10,000

    Less: Disbursements

    Direct materials $1,20,000 $2,25,000

    Direct labor $90,000 $1,20,000

    Selling and administrative

    expenses $1,05,000 $1,29,000

    Total disbursements $3,15,000 $4,74,000

    Excess

    (deficiency of available cash

    over cash disbursements) $72,000 $36,000

    Financing:

    Add: Borrowings $ - $24,000

    Ending cash balance $72,000 $60,000
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Cullumber Company expects to have a cash balance of $138,000 on January 1, 2022. These are the relevant monthly budget data for the first ...” in 📗 Business if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers