Question

Use the following information to prepare the September cash budget for PTO Manufacturing Co. The 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.

  1. Beginning cash balance, September 1, $41,000.
  2. Budgeted cash receipts from sales in September, $264,000.
  3. Raw materials are purchased on account. Purchase amounts are: August (actual), $77,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 purchase.
  4. Budgeted cash payments for direct labor in September, $34,000.
  5. Budgeted depreciation expense for September, $4,000.
  6. Other cash expenses budgeted for September, $60,000.
  7. Accrued income taxes payable in September, $10,500.
  8. Bank loan interest payable in September, $1,800
PTO MANUFACTURING COMPANY
Cash Budget
For Month Ended September 30
Beginning cash balance $41,000selected answer correct
Cash receipts from sales 264,000selected answer correct
Total cash available $305,000
Cash payments for:
Direct materials 91,800selected answer incorrect
Direct labor 31,000selected answer incorrect
Other expenses 56,000selected answer incorrect
Accrued taxes 10,700selected answer incorrect
Interest on bank loan 1,700selected answer incorrect
Total cash payments 191,200
Ending cash balance $113,800

Homework Answers

Answer #1
PTO MANUFACTURING COMPANY
Cash Budget
For Month Ended September 30
Beginning cash balance $41,000
Cash receipts from sales 264,000
Total cash available $305,000
Cash payments for:

Direct materials

August - 77000 * 35% = 26950

september - 108000*65% = 70200

97150

Direct labor 34000
Other expenses 60000
Accrued taxes 10500
Interest on bank loan 1800
Total cash payments 203450
Ending cash balance 101550

NOTE !

1. DEPRECIATION

deperciation is a non- cash expense . Therefore depreciation does not fit into cash budget, which tracks all real cash inflows and outflows.

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
Use the following information to prepare the July cash budget for Acco Co. It should show...
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: $65,000. 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), $1,880,000; June...
Required information Problem 20-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions...
Required information Problem 20-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions displayed below.] Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 64,000 $ 80,000 $ 48,000 Budgeted cash payments for Direct materials 16,160 13,440 13,760 Direct labor 4,040 3,360 3,440 Factory overhead 20,200 16,800 17,200 Sales are 20% cash and 80% on...
Exercise 20-25A Merchandising: Preparing a cash budget LO P4 Use the following information to prepare the...
Exercise 20-25A Merchandising: Preparing a cash budget LO P4 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: $72,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...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 62,500 $ 78,500 $ 49,500 Budgeted cash payments for Direct materials 16,460 13,740 14,060 Direct labor 4,340 3,660 3,740 Factory overhead 20,500 17,100 17,500 Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 60,000 $ 76,000 $ 52,000 Budgeted cash payments for Direct materials 16,960 14,240 14,560 Direct labor 4,840 4,160 4,240 Factory overhead 21,000 17,600 18,000 Sales are 30% cash and 70% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes...
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs for the quarter follow. July August September Budgeted sales $ 59,500 $ 75,500 $ 52,500 Budgeted cash payments for Direct materials 17,060 14,340 14,660 Direct labor 4,940 4,260 4,340 Factory overhead 21,100 17,700 18,100 Sales are 30% cash and 70% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600 Total cash available Preliminary cash balance Ending cash balance Loan balance Loan balance - Beginning of month $0 Additional loan (loan repayment) Loan balance - End of month Karim Corp. requires a minimum $8,200 cash balance. If necessary, loans are taken to meet this requirement at a cost of 1% interest per month (paid monthly). Any excess cash is used to repay loans at...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from sales: 24% is collected in the month of sale, 50% in the next month, and 26% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,548,000; June (actual), $1,080,000; and July (budgeted), $1,260,000. Payments on merchandise purchases: 48% in the month of purchase and 52% in the month following purchase. Purchases amounts are: June...
C. The Sun Pacific Company budgeted the following sales: July​​200,000 August​​210,000 September​190,000 Sales in May were...
C. The Sun Pacific Company budgeted the following sales: July​​200,000 August​​210,000 September​190,000 Sales in May were 190,000 and in June 180,000. 60% of sales are cash, 30% of sales are to be collected the next month, and the remaining 10% in 2 months. Budgeted purchases of the required materials for production are: July​​100,000 August​​105,000 September​95,000 Purchases in June were 90,000. 70% of purchases are cash and 30% should be paid the next month. Direct Labor is 35% of purchases Selling...
At the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for...
At the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $8,560 Purchase season football tickets in September 120 Additional entertainment for each month 300 Pay fall semester...