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. B D 1 July $64,000 August $80,000 September 2 Budgeted sales 3 Budgeted cash payments for Direct materials Direct labor Factory overhead $48,000 4 16,160 4,040 20,200 13,440 3,360 16,800 13,760 3,440 17,200 5 6 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
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
![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.
A
B
1
July
August
$80,000
September
$48,000
2 Budgeted sales
3 Budgeted cash payments for
Direct materials
Direct labor
Factory overhead
$64,000
4
16,160
4,040
20,200
13,440
3,360
16,800
13,760
3,440
17,200
6
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.)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F161df2c1-bb06-4c0f-8b58-eaaff21098e2%2F328227ff-f482-4745-b1f3-435608335591%2F635igj5_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)