Solution
CULLUMBER COMPANY | ||
Cash Budget | ||
For the Two months ended February 28, 2022 | ||
January | February | |
Beginning Cash Balance | $ 57,200.00 | $ 30,700.00 |
Add: Cash receipts | ||
Collection from customers | $ 82,000.00 | $ 137,800.00 |
Cash from sale of investment | $ 14,000.00 | |
Total cash receipts | $ 96,000.00 | $ 137,800.00 |
Cash Availaible | $ 153,200.00 | $ 168,500.00 |
Less: Cash Payments | ||
Payment to supplier | $ 44,800.00 | $ 52,400.00 |
Payment for wages | $ 36,400.00 | $ 42,400.00 |
Payment for administrative expenses | $ 24,500.00 | $ 32,200.00 |
Payment for Selling expenses | $ 16,800.00 | $ 20,200.00 |
Total Cash Payments | $ 122,500.00 | $ 147,200.00 |
Ending Cash Balance Before Financing | $ 30,700.00 | $ 21,300.00 |
Financing | ||
Borrowing | $ 5,700.00 | |
Repayments | ||
Ending Cash Balance | $ 30,700.00 | $ 27,000.00 |
Cullumber Company expects to have a cash balance of $57,200 on January 1, 2022. These are the relevant monthly budget d...
Pharoah Company expects to have a cash balance of $101,200 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022. 1. Collections from customers: January $156,200, February $321,200. 2. Payments to suppliers: January $88,000, February $165,000. 3. Wages: January $66,000, February $88,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $46,200, February $52,800. These costs include depreciation of $2,200 per month. All other costs are paid as...
Cullumber Company expects to have a cash balance of $ 65,150 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $ 90,150, February $ 165,150. 2. Payments to suppliers: January $ 59,150, February $ 94,150. 3. Wages: January $ 31,120, February $ 41,120. Wages are paid in the month they are incurred. 4. Administrative expenses: January $ 22,120, February $ 25,120. These costs include depreciation of...
Sandhill Company expects to have a cash balance of $119,600 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022. 1. Collections from customers: January $184,600. February $379,600. 2. Payments to suppliers: January $104,000. February $195,000. 3. Wages: January $78,000. February $104,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $54,600. February $62,400. These costs include depreciation of $2,600 per month. All other costs are paid as...
Sunland Company expects to have a cash balance of $59,800 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022. 1. Collections from customers: January $92,300, February $189,800. 2. Payments to suppliers: January $52,000, February $97,500. 3. Wages: January $39,000, February $52,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $27,300, February $31,200. These costs include depreciation of $1,300 per month. All other costs are paid as...
Blossom Company expects to have a cash balance of $78,200 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022 Collections from customers: January $120,700, February $248,200. 1. Payments to suppliers: January $68,000, February $127,500. 2. Wages: January $51,000, February $68,000. Wages are paid in the month they are incurred. 3. Administrative expenses: January $35,700, February $40,800. These costs include depreciation of $1,700 per month. All other costs are paid as 4....
Exercise 22-14 (Video) Cullumber Company expects to have a cash balance of $56,250 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $106,250, February $187,500. Payments for direct materials: January $62,500, February $93,750. Direct labor: January $37,500, February $56,250. Wages are paid in the month they are incurred. Manufacturing overhead: January $26,250, February $31,250. These costs include depreciation of $1,875 per month. All other overhead costs are...
3. Martin Company expects to have a cash balance of $136,500 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows: • Collections from customers: January $243,200, February $430,900. • Payments for direct materials: January $154,400, February $236,400 • Direct labor: January $89,700, February $136,000. Wages are paid in the month they are incurred. • Manufacturing overhead: January $62,400, February $74,900. These costs include depreciation of $5,000 per month. All other overhead...
Flounder Company expects to have a cash balance of $52,470 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $99,110, February $174,900. Payments for direct materials: January $58,300, February $87,450. Direct labor: January $34,980, February $52,470. Wages are paid in the month they are incurred. Manufacturing overhead: January $24,486, February $29,150. These costs include depreciation of $1,749 per month. All other overhead costs are paid as incurred....
Danner Company expects to have a cash balance of $46,350 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $87,550, February $154,500. Payments for direct materials: January $51,500, February $77,250. Direct labor: January $30,900, February $46,350. Wages are paid in the month they are incurred. Manufacturing overhead: January $21,630, February $25,750. These costs include depreciation of $1,545 per month. All other overhead costs are paid as incurred....
Danner Company expects to have a cash balance of $58,005 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $109,565, February $193,350. Payments for direct materials: January $64,450, February $96,675. Direct labor: January $38,670, February $58,005. Wages are paid in the month they are incurred. Manufacturing overhead: January $27,069, February $32,225. These costs include depreciation of $1,933 per month. All other overhead costs are paid as incurred....