| Beginning cash balance | 11980 |
| Add Cash receipt | 59020 |
| Total available cash | 71000 |
| Less:- cash disbursement | 66600 |
| Excess of avialable cash over disbursement | 4400 |
| Add:- Financing needed | 4090 |
| Ending cash balance | 8490 |
| Hi mate, |
| I would be grateful to you if you can provide a thumbs up and write one beautiful comment. It will improve my rating and let me continue my journey here. |
| In case of doubt, please comment. I will consider myself fortunate if I can help you. |
| All the best for your bright future. |
This helped so much I am doing the same problem just different numbers and its nice to have a step by step guided way to get the answer
The following information is available for Sheridan Company for the month of January: expected cash receipts $59.07...
The following information is available for Kingbird Company for the month of January: expected cash receipts $60,430, expected cash disbursements $66,450, and cash balance on January 1, $12,360. Management wishes to maintain a minimum cash balance of $7,730 Prepare a basic cash budget for the month of January KINGBIRD COMPANY Cash Budget For the Month of January
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 $52,965 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $100,045, February $176,550. Payments for direct materials: January $58,850, February $88,275. Direct labor: January $35,310, February $52,965. Wages are paid in the month they are incurred. Manufacturing overhead: January $24,717, February $29,425. These costs include depreciation of $1,765 per month. All other overhead costs are paid as incurred....
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...
Johnson Company expects to have a cash balance of $51,300 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows: Collections from customers: January $96,900, February $171,000 Payments for direct materials: January $57,000, February $85,500 Direct Labor: January $34,200, February $51,300. Wages are paid in the month they are incurred. Manufacturing overhead: January $23,940, February $28,500. These costs include depreciation of $1,710 per month. All other overhead costs are paid as incurred....
Accounting Help. Pls Multiple Part Question.
Current Attempt in Progress Sunland Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $432,000 Direct materials purchases 135,000 $388,800 129,600 97,200 75,600 Direct labor Manufacturing overhead 108,000 81,000 91,800 Selling and administrative expenses 85,320 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...
Prepare Cash Budget For 3 Months Windsor Corporation expects the following cash receipts and disbursements during the first quarter of 2016 (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1, 2016) January February March Cash receipts $420,000 $430,000 $390,000 Cash disbursements 380,000 510,000 410,000 The expected cash balance at January 1, 2016, is $65,000. Windsor wants to maintain a cash balance at the end of each month of at least $50,000. Short-term borrowings at 1%...
Derby Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are: January February Sales $350,000 $400,000 Direct materials purchases 110,000 120,000 Direct labor 85,000 115,000 Manufacturing overhead 60,000 75,000 Selling and administrative expenses 75,000 80,000 All sales are on account. Collections are expected to be: 60% in the month of sale, 25% in the first month following the sale, and 15% in the second month following the sale. As to cash payments (disbursements): 30% of direct materials...
Sarasota Company expects to have a cash balance of $59,985 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $113,305, February $199,950. Payments for direct materials: January $66,650, February $99,975 Direct labor: January $39,990, February $59,985. Wages are paid in the month they are incurred. Manufacturing overhead: January $27,993, February $33,325. These costs include depreciation of $1,999 per month. All other overhead costs are paid as incurred...
Indigo Company expects to have a cash balance of $45,810 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $86,530, February $152,700. Payments for direct materials: January $50,900, February $76,350 Direct labor: January $30,540, February $45,810. Wages are paid in the month they are incurred. Manufacturing overhead: January $21,378, February $25,450. These costs include depreciation of $1,527 per month. All other overhead costs are paid as incurred...