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. **attached image chart -Budgeted Sales on July $64,000 / August $80,000 / September $48,000 -Budgeted Cash Payments for Direct Materials on July $16,160 / August $13,440 / September $13,760 Direct Labor on July $4,040 / August $3,360 / September $3,440 Factory Overhead on July $20,200 / August $16,800 / September $17,200 Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $45,000 in accounts receivable; $4,500 in accounts payable; and a $5,000 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,000 per month), and rent ($6,500 per month). Prepare a cash budget for each of the months of July, August, and September. (Round amounts to the dollar.)

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter13: Budgeting And Standard Costs

Section: Chapter Questions

Problem 13.2.4P: Budgeted income statement and supporting budgets The budget director of Jupiter Helmets Inc., with...

See similar textbooks

Related questions

Question

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.

**attached image chart

-Budgeted Sales on July $64,000 / August $80,000 / September $48,000

-Budgeted Cash Payments for

Direct Materials on July $16,160 / August $13,440 / September $13,760

Direct Labor on July $4,040 / August $3,360 / September $3,440

Factory Overhead on July $20,200 / August $16,800 / September $17,200

Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $45,000 in accounts receivable; $4,500 in accounts payable; and a $5,000 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,000 per month), and rent ($6,500 per month).

Prepare a cash budget for each of the months of July, August, and September. (Round amounts to the dollar.)

123456
2 Budgeted sales
3 Budgeted cash payments for
Direct materials
Direct labor
Factory overhead
B
July
$64,000
16,160
4,040
20,200
August
$80,000
13,440
3,360
16,800
D
September
$48,000
13,760
3,440
17,200

Definition Definition Estimate of an organization's cash flow for a future period. A cash budget forecasts future cash receipts and payments from various sources for a fiscal year. A cash budget can be created once a month or once a week to determine the organization's cash position and ensure its performance in relation to the budget. It aids in determining whether the company has enough cash and cash equivalents to meet its operational needs in the future.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here