Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have done some of the problem but I am having a hard time figuring out how to get some of the numbers. If someone
I have done some of the problem but I am having a hard time figuring out how to get some of the numbers. If someone could please help!
I sep Aug. $57.000 Built tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for producte costs for the quarter follow Budgeted Sales $55.000 $11.000 Budgeted cash payments for: Direct materiais 15.360 Direct labor 3240 factory overhead 19.400 Sales are 20% cash and 80% on Credit All Credit sales are collected in the month 12640 2560 161000 12960 2640 16400 following the sale. The June 30 balance sheet indudes balances of $15,000 in cash; $44.200 In accounts recievable; and a $4,200 balance In loans payable A minimun cash balance Of $15,000 is required. Loans are obtained at the end of any month when a cash shortage OCCIS. 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 ind med and consist of Sales Commissions (10%. Of sares), Office salaries ($3,200 per month), and rent ($5,700 per month). months of July August and september Prepare a cash budget for each of the 68200 cash recepts $15000 58200 73,200 112960 2640 116,400 3240 Built tight cash budget For July August and september Beginning cash budest $15.000 55 200 Total cash available 70,200 cash payments for Direct materials 15360 Direct labor overhead 19400 Sates commissions 5,500 Interest on bank loan 42 Totam cash payments 52442 preliminary cash balance 11758 Odditional loan from bank repayment of icon to bank 11,758 ending cash balance 12640 25600 16,000 7100 5700 4660o 47200 Aug Sep loan balance July Beginning loan balance - cf month $4200 additional loan (loan repayment) Toan balance - endof month Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started