Question

Nadia Company expects to have a cash balance of $44,800 on January 1, 2020. Nadia has...

Nadia Company expects to have a cash balance of $44,800 on January 1, 2020. Nadia has budgeted the following for the first two months of the year 2020:

1. Collections from customers: January $90,900; February $109,300.
2. Payments to suppliers: January $39,900; February $49,500.
3. Direct labour: January $29,700; February $35,300. Wages are paid in the month they are incurred.
4. Manufacturing overhead: January $25,000; February $30,200. Overhead costs are paid as incurred.
5. Selling and administrative expenses: January $15,900; February $22,000. These costs do not include depreciation and they are paid as incurred.
6. Sales of investments in January are expected to realize $10,100 in cash. Nadia Company wants to keep a minimum monthly cash balance of $20,000.


Prepare a cash budget for January and February.

NADIA COMPANY
Cash Budget
For 2020
January February

Ending cash balanceCash receiptsTotal cash availableTotal receiptsCash disbursementsBeginning cash balanceFinancing borrowing needsTotal disbursementsExcess of cash over cash disbursements

$ $

AddLess

:

Ending cash balanceBeginning cash balanceCash receiptsTotal cash availableExcess of cash over cash disbursementsFinancing borrowing needsTotal receipts

    Collections from customers    Manufacturing overhead    Purchase of land    Sale of investments    Payment to suppliers    Labour    Collection of notes receivable    Selling and administrative expenses    Purchase of equipment    

    Payment to suppliers    Manufacturing overhead    Sale of investments    Collection of notes receivable    Selling and administrative expenses    Purchase of land    Purchase of equipment    Labour    Collections from customers    

    Financing borrowing needs    Ending cash balance    Beginning cash balance    Excess of cash over cash disbursements    Cash receipts    Total receipts    Total cash available    

AddLess

:

Total cash availableTotal disbursementsEnding cash balanceFinancing borrowing needsExcess of cash over cash disbursementsBeginning cash balanceCash disbursements

    Collection of notes receivable    Sale of investments    Payment to suppliers    Purchase of land    Labour    Collections from customers    Manufacturing overhead    Purchase of equipment    Selling and administrative expenses    

    Selling and administrative expenses    Manufacturing overhead    Purchase of land    Purchase of equipment    Collection of notes receivable    Collections from customers    Sale of investments    Payment to suppliers    Labour    

    Collection of notes receivable    Purchase of equipment    Payment to suppliers    Selling and administrative expenses    Collections from customers    Manufacturing overhead    Labour    Purchase of land    Sale of investments    

    Sale of investments    Purchase of equipment    Labour    Selling and administrative expenses    Payment to suppliers    Manufacturing overhead    Collections from customers    Collection of notes receivable    Purchase of land    

Beginning cash balanceTotal disbursementsCash receiptsCash disbursementsExcess of cash over cash disbursementsTotal receiptsEnding cash balanceTotal cash availableFinancing borrowing needs

Cash receiptsTotal receiptsTotal cash availableCash disbursementsFinancing borrowing needsExcess of cash over cash disbursementsTotal disbursementsBeginning cash balanceEnding cash balance

Total receiptsTotal cash availableCash disbursementsEnding cash balanceCash receiptsTotal disbursementsBeginning cash balanceFinancing borrowing needsExcess of cash over cash disbursements

$ $

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Nadia Company expects to have a cash balance of $44,800 on January 1, 2020. Nadia has...
Nadia Company expects to have a cash balance of $44,800 on January 1, 2020. Nadia has budgeted the following for the first two months of the year 2020: 1. Collections from customers: January $90,700; February $109,500. 2. Payments to suppliers: January $39,900; February $49,700. 3. Direct labour: January $30,300; February $35,100. Wages are paid in the month they are incurred. 4. Manufacturing overhead: January $25,200; February $30,200. Overhead costs are paid as incurred. 5. Selling and administrative expenses: January $16,100;...
Nadia Company expects to have a cash balance of $44,800 on January 1, 2020. Nadia has...
Nadia Company expects to have a cash balance of $44,800 on January 1, 2020. Nadia has budgeted the following for the first two months of the year 2020: 1. Collections from customers: January $90,900; February $109,300. 2. Payments to suppliers: January $39,900; February $49,500. 3. Direct labour: January $29,700; February $35,300. Wages are paid in the month they are incurred. 4. Manufacturing overhead: January $25,000; February $30,200. Overhead costs are paid as incurred. 5. Selling and administrative expenses: January $15,900;...
Nadia Company expects to have a cash balance of $45,300 on January 1, 2020. Nadia has...
Nadia Company expects to have a cash balance of $45,300 on January 1, 2020. Nadia has budgeted the following for the first two months of the year 2020: 1. Collections from customers: January $89,300; February $110,500. 2. Payments to suppliers: January $39,700; February $50,000. 3. Direct labour: January $29,700; February $35,000. Wages are paid in the month they are incurred. 4. Manufacturing overhead: January $25,200; February $30,100. Overhead costs are paid as incurred. 5. Selling and administrative expenses: January $16,100;...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $ 432,000 $ 480,000 Direct materials purchases 144,000 150,000 Direct labor 108,000 120,000 Manufacturing overhead 84,000 90,000 Selling and administrative expenses 94,800 102,000 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct...
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Prepare a cash budget for 2 months. Collections from customers: January $85,000, February $150,000. Payments for direct materials: January $50,000, February $75,000. Direct labor: January $30,000, February $45,000.Wages are paid in the month they are incurred. Manufacturing overhead: January $21,000, February $25,000. These costs include depreciation of $1,500 per month. All other...
Danner Company expects to have a cash balance of $46,800 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $46,800 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $88,400, February $156,000. Payments for direct materials: January $52,000, February $78,000. Direct labor: January $31,200, February $46,800. Wages are paid in the month they are incurred. Manufacturing overhead: January $21,840, February $26,000. These costs include depreciation of $1,560 per month. All other overhead costs are paid as incurred....
Wildhorse Company expects to have a cash balance of $59,100 on January 1, 2022. These are...
Wildhorse Company expects to have a cash balance of $59,100 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $80,400, February $136,000 2. Payments to suppliers: January $46,400, February $52,100 3. Wages: January $36,100, February $42,100. Wages are paid in the month they are incurred. 4. Administrative expenses: January $26,100, February $31,600. These costs include depreciation of $3,000 per month. All other costs are paid as...
Oriole Company expects to have a cash balance of $57,550 on January 1, 2017. These are...
Oriole Company expects to have a cash balance of $57,550 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $82,550, February $157,550. 2. Payments to suppliers: January $51,550, February $86,550. 3. Wages: January $30,850, February $40,850. Wages are paid in the month they are incurred. 4. Administrative expenses: January $21,850, February $24,850. These costs include depreciation of $1,000 per month. All other costs are paid as...
Ivanhoe Company expects to have a cash balance of $56,450 on January 1, 2017. These are...
Ivanhoe Company expects to have a cash balance of $56,450 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $81,450, February $156,450. 2. Payments to suppliers: January $50,450, February $85,450. 3. Wages: January $31,980, February $41,980. Wages are paid in the month they are incurred. 4. Administrative expenses: January $22,980, February $25,980. These costs include depreciation of $1,000 per month. All other costs are paid as...
Sunland Company expects to have a cash balance of $62,450 on January 1, 2017. These are...
Sunland Company expects to have a cash balance of $62,450 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $87,450, February $162,450. 2. Payments to suppliers: January $56,450, February $91,450. 3. Wages: January $31,370, February $41,370. Wages are paid in the month they are incurred. 4. Administrative expenses: January $22,370, February $25,370. These costs include depreciation of $1,000 per month. All other costs are paid as...