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,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; February $22,200. These costs do not include depreciation and they are paid as incurred.
6. Sales of investments in January are expected to realize $9,900 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

Cash disbursementsTotal cash availableBeginning cash balanceEnding cash balanceTotal disbursementsFinancing borrowing needsExcess of cash over cash disbursementsCash receiptsTotal receipts

$ $

AddLess

:

Ending cash balanceCash receiptsFinancing borrowing needsTotal receiptsTotal cash availableBeginning cash balanceExcess of cash over cash disbursements

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

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

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

AddLess

:

Total cash availableExcess of cash over cash disbursementsEnding cash balanceCash disbursementsBeginning cash balanceTotal disbursementsFinancing borrowing needs

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

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

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

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

Excess of cash over cash disbursementsTotal cash availableCash disbursementsFinancing borrowing needsTotal disbursementsEnding cash balanceBeginning cash balanceCash receiptsTotal receipts

Excess of cash over cash disbursementsBeginning cash balanceEnding cash balanceTotal receiptsCash receiptsTotal cash availableCash disbursementsTotal disbursementsFinancing borrowing needs

Financing borrowing needsTotal cash availableCash receiptsExcess of cash over cash disbursementsTotal disbursementsBeginning cash balanceTotal receiptsEnding cash balanceCash disbursements

$ $

Homework Answers

Answer #1

Answer-

NADIA COMPANY
CASH BUDGET
PARTICULARS JANUARY FEBRUARY
$ $
Beginning cash balance (A) 44800 33900
Add- Budgeted cash receipts
Collection from customers 90700 109500
Sale of investments 9900 0
Total cash available for use (B) 145400 143400
Less- Cash Payments
Payment to suppliers 39900 49700
Direct labor 30300 35100
Manufacturing overhead 25200 30200
Selling & Administrative costs excliuding depreciation 16100 22200
Total cash payments (C) 111500 137200
Cash surplus/ (Deficit) (D=A+B-C) 33900 6200
Financing:-
Add-Borrowings 0 13800
Less-Repayments 0 0
Budgeted ending cash balance 33900 20000
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,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 $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;...
Danner Company expects to have a cash balance of $55,800 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $55,800 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $105,400, February $186,000. Payments for direct materials: January $62,000, February $93,000. Direct labor: January $37,200, February $55,800. Wages are paid in the month they are incurred. Manufacturing overhead: January $26,040, February $31,000. These costs include depreciation of $1,860 per month. All other overhead costs are paid as incurred....
Danner Company expects to have a cash balance of $ 45,450 on January 1, 2020. Relevant...
Danner Company expects to have a cash balance of $ 45,450 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $ 85,850, February $ 151,500. Payments for direct materials: January $ 50,500, February $ 75,750. Direct labor: January $ 30,300, February $ 45,450. Wages are paid in the month they are incurred. Manufacturing overhead: January $ 21,210, February $ 25,250. These costs include depreciation of $ 1,515...
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...
Wildhorse Company expects to have a cash balance of $63,300 on January 1, 2017. These are...
Wildhorse Company expects to have a cash balance of $63,300 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $88,300, February $163,300. 2. Payments to suppliers: January $57,300, February $92,300. 3. Wages: January $31,740, February $41,740. Wages are paid in the month they are incurred. 4. Administrative expenses: January $22,740, February $25,740. These costs include depreciation of $1,000 per month. All other costs are paid as...