Use the following information to prepare the September cash budget for PTO Co. The following information relates to expected cash receipts and cash payments for the month ended September 30. Beginning cash balance, September 1, $42,000. Budgeted cash receipts from sales in September, $263,000. Raw materials are purchased on account. Purchase amounts are August (actual), $70,000, and September (budgeted), $103,000. Payments for direct materials are made as follows: 65% in the month of purchase and 35% in the month following purchase. Budgeted cash payments for direct labor in September, $36,000. Budgeted depreciation expense for September, $3,300. Other cash expenses budgeted for September, $54,000. Accrued income taxes payable in September, $10,800. Bank loan interest payable in September, $1,500.
PTO Co. Cash Budget For The Month of September |
|
September | |
Beginning cash balance | $42,000 |
Add: Receipts | |
Cash receipts | 263,000 |
Total receipts | 305,000 |
Less: Payments | |
Purchases of direct material(70,000*35%+103,000*65%) | 91,450 |
Direct labor | 36,000 |
Other expenses | 54,000 |
Income tax | 10,800 |
Bank loan interest | 1,500 |
Total payments | 193,750 |
Ending cash balance (305,000-193,750) | $111,250 |
Use the following information to prepare the September cash budget for PTO Co. The following information...
Use the following information to prepare the September cash budget for PTO Co. The following information relates to expected cash receipts and cash payments for the month ended September 30. Beginning cash balance, September 1, $47,000. Budgeted cash receipts from sales in September, $258,000. Raw materials are purchased on account. Purchase amounts are August (actual), $76,000, and September (budgeted), $108,000. Payments for direct materials are made as follows: 65% in the month of purchase and 35% in the month following...
Use the following information to prepare the September cash budget for PTO Manufacturing Co. The following information relates to expected cash receipts and cash payments for the month ended September 30. Beginning cash balance, September 1, $40,000. Budgeted cash receipts from sales in September, $255,000. Raw materials are purchased on account. Purchase amounts are: August (actual), $80,000; and September (budgeted), $110,000. Payments for direct materials are made as follows: 65% in the month of purchase and 35% in the month...
Use the following information to prepare the September cash budget for PTO Manufacturing Co. The following information relates to expected cash receipts and cash payments for the month ended September 30. Beginning cash balance, September 1, $44,000. Budgeted cash receipts from sales in September, $262,000. Raw materials are purchased on account. Purchase amounts are: August (actual), $72,000, and September (budgeted), $100,000. Payments for direct materials are made as follows: 65% in the month of purchase and 35% in the month...
Use the following information to prepare the September cash budget for PTO Co. The following information relates to expected cash receipts and cash payments for the month ended September 30. a. Beginning cash balance, September 1, $42,000. b. Budgeted cash receipts from sales in September, $255,000. c. Raw materials are purchased on account. Purchase amounts are August (actual), $77,000, and September (budgeted) $107,000. Payments for direct materials are made as follows: 65% in the month of purchase and 35% in...
Check my w Use the following information to prepare the September cash budget for PTO Manufacturing Co. The following information expected cash receipts and cash payments for the month ended September 30 relates to a. Beginning cash balance, September 1, $47000 b. Budgesed cash receipts from sales in September $264000 c. Raw materials are purchased on account Purchase amounts are: August (actuat $78.000, and September 216 are: August (ectual 100,000 Payments for direct materials are made as d. Budgeted cash...
Jasper Company has sales on account and for cash. Specifically, 59% of its sales are on account and 41% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $516,000 for April, $526,000 for May, and $551,000 for June. The beginning balance of Accounts Receivable is $298,300 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April May June 41% Cash sales Sales on...
Use the following information to prepare the July cash budget for Acco Co. It should show expected cash receipts and cash payments for the month and the cash balance expected on July 31. a. Beginning cash balance on July 1: $70,000. b. Cash receipts from sales: 25% is collected in the month of sale, 50% in the next month, and 25% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual)....
Use the following information to prepare the July cash budget for Acco Co. It should show expected cash receipts and cash payments for the month and the cash balance expected on July 31. Beginning cash balance on July 1: $50,000. Cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,720,000; June...
Use the following information to prepare the July cash budget for Acco Co. It should show expected cash receipts and cash payments for the month and the cash balance expected on July 31. a. Beginning cash balance on July 1: $68,000 b. Cash receipts from sales: 35% is collected in the month of sale, 50% in the next month and 15% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual)...
Use the following information to prepare the July cash budget for Acco Co. It should show expected cash receipts and cash payments for the month and the cash balance expected on July 31. Beginning cash balance on July 1: $67,000. Cash receipts from sales: 40% is collected in the month of sale, 50% in the next month, and 10% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are May (actual), $1,770,000; June...