Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...

70.2K

Verified Solution

Question

Accounting

Built-Tight is preparing its master budget for the quarter endedSeptember 30. Budgeted sales and cash payments for product costsfor the quarter follow:

JulyAugustSeptember
Budgeted sales$64,000$80,000$48,000
Budgeted cash payments for
Direct materials16,16013,44013,760
Direct labor4,0403,3603,440
Factory overhead20,20016,80017,200


Sales are 20% cash and 80% on credit. All credit sales arecollected in the month following the sale. The June 30 balancesheet includes balances of $15,000 in cash; $45,000 in accountsreceivable; $4,500 in accounts payable; and a $5,000 balance inloans payable. A minimum cash balance of $15,000 is required. Loansare obtained at the end of any month when a cash shortage occurs.Interest is 1% per month based on the beginning-of-the-month loanbalance and is paid at each month-end. If an excess balance of cashexists, loans are repaid at the end of the month. Operatingexpenses are paid in the month incurred and consist of salescommissions (10% of sales), office salaries ($4,000 per month), andrent ($6,500 per month).

2. Prepare a cash budget for each of the monthsof July, August, and September. (Negative balances and Loanrepayment amounts (if any) should be indicated with minussign. Enter your final answers in wholedollars.)

BUILT-TIGHT
Cash Budget
For July, August, and September
JulyAugustSeptember
Beginning cash balance
Total cash available
Cash payments for:
Total cash payments
Preliminary cash balance
Additional loan from bank
Repayment of loan to bank
Ending cash balance000
.
Loan balance
JulyAugustSeptember
Loan balance - Beginning of month
Additional loan (loan repayment)
Loan balance - End ofmonth

Answer & Explanation Solved by verified expert
4.0 Ratings (801 Votes)
Answer BUILTTIGHT Cash Budget For July August and September July August September Beginning cash balance 15000 15000 25505 Cash Receipts from customers 57800 67200 73600 Total cash available 72800 82200 99105 Cash payments for Direct Materials 16160 13440 13760 Direct Labor 4040    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students