Solution
Blossom company | ||
Cash Budget | ||
For the Two months ended February 28, 2022 | ||
January | February | |
Beginning Cash Balance | $ 78,200.00 | $ 40,800.00 |
Add: Cash receipts | ||
Collection from customers | $ 120,700.00 | $ 248,200.00 |
Cash from sale of investment | $ 20,400.00 | |
Total cash receipts | $ 141,100.00 | $ 248,200.00 |
Cash Avalaible | $ 219,300.00 | $ 289,000.00 |
Less: Cash Payments | ||
Payment to supplier | $ 68,000.00 | $ 127,500.00 |
Payment for wages | $ 51,000.00 | $ 68,000.00 |
Payment for administrative expenses | $ 34,000.00 | $ 39,100.00 |
Payment for Selling expenses | $ 25,500.00 | $ 34,000.00 |
Total Cash Payments | $ 178,500.00 | $ 268,600.00 |
Ending Cash Balance Before Financing | $ 40,800.00 | $ 20,400.00 |
Financing | ||
Borrowing | $ 13,600.00 | |
Repayments | ||
Ending Cash Balance | $ 40,800.00 | $ 34,000.00 |
Blossom Company expects to have a cash balance of $78,200 on January 1, 2022. These are...
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...
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...
Exercise 7-14 Blossom Company expects to have a cash balance of $57,600 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017 1. Collections from customers: January $82,600, February $157,600 2. Payments to suppliers: January $51,600, February $86,600. 3. Wages: January $31,580, February $41,580. Wages are paid in the month they are incurred 4. Administrative expenses: January $22,580, February $25,580. These costs include depreciation of $1,000 per month. All other costs are...
Cullumber Company expects to have a cash balance of $57,200 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $82,000, February $137,800 2. Payments to suppliers: January $44,800, February $52,400 3. Wages: January $36,400, February $42,400. Wages are paid in the month they are incurred. 4. Administrative expenses: January $26,400, February $34,100. These costs include depreciation of $1,900 per month. All other costs are paid as...
Question 12 Sherdan Company expects to have a cash balance of $57,800 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $84,900, February $131,100 2. Payments to suppliers: January $49, 300, February $51,700 3. Wages: January $35,700, February $41,700. Wages are paid in the month they are incurred. 4. Administrative expenses: January $25,700, February $34,700. These costs include depreciation of $2,500 per month. All other costs...
Need Help! Carla Vista Company expects to have a cash balance of $115,000 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022. 1. Collections from customers: January $177,500, February $365,000. 2. Payments to suppliers: January $100,000, February $187,500. 3. Wages: January $75,000, February $100,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $52,500, February $60,000. These costs include depreciation of $2,500 per month. All other costs...
Exercise 216 Holcomb Company expects to have a cash balance of $43,000 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $85,000, February $132,000 2. Payments to suppliers: January $40,000, February $50,000 * Wages: January $34,000, February $40,000. Wages are paid in the month they are incurred. Administrative expenses: January $24,000, February $31,000. These costs include depreciation of $1,000 per month. All other costs are paid...
E7.17 (LO 4), AP Rigley Company expects to have a cash balance of $46,000 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022. Prepare a cash budget for two months. 1. Collections from customers: January $71,000 and February $146,000. 2. Payments to suppliers: January $40,000 and February $75,000. 3. Wages: January $30,000 and February $40,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $21,000 and February...
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...