Total You are provided with the following Sales Budget, archases Budget and selling and administrative expenses budget for Salya World Co. for the last quarter of the year 2019 chles Badet Reglement I Cash receipt from customer's Budget Oct Nov Dec Oet Collections FreeOct Sales Fresep Sales TlOct collection New Collection From Nov. Sales From Oct Sales Total Now Cash sales Credit sales I oct. 36,000 12.000 48.000 Nov. 45,000 15.000 60.000 Der 54.000 18,000 72.000 Tecal ] 135.000 45,000 180 000 In Burchase Budo The Collections Free Dee Sales Free Nov. Sales Total Dec. collectie Total cash receipt Cash Purchases Credit Purchases Total Purchases I Oct 12,000 4000 16,000 Nov 18.000 7,000 25,000 Dec 25.000 10,000 35.000 Total ] 55.000 21.000 76.000 Requirement purchase payment Budget ( Sales & Administrative Expenses Budget Salaries Oct 8,000 4,800 Nov 9,000 3,600 Dec. 8,600 5,400 Total 25,600 13,800 Commissions 500 2,200 120 400 100 16,120 500 2.750 120 400 100 16,470 500 2.500 120 400 100 17,620 1.500 7.450 350 1.200 300 50,210 Oct. purch. Payments For Oct. Purch For Sep Purch TotalOct. Pure Pay Nor. purch. Payments For No. Purch Fee Oct. Purch Total Now. Purch. Pay Dec. purch. Payments For Dec. Purh For Nov. Purch Total De Purch Pay. Total Purchase Payments Depreciation Total Requirement Cash Badget Requirements: Assuming Salhiya world is planning to purchase new furniture for $10,000 cash during Oct. 2019. All cash expenses are paid when incurred except insurance expenses which is an expiration of prepaid. Prepare the following budgets for the last quarter of the year 2019: Beginning cash balance Cach Tips Cash available Cach 1-Collections from customers budget Assume all credit sales will be collected during the following month of sale. (Accounts Receivable at Sep 30, 2019 expected to be $10,000) For Purchases For S & Am F I For Additional Assets Total cash payments Cash balance before 2. Payments for purchases budget Assume all credit purchases will be paid during the following month of purchases (Accounts Payable at dSep 30 2019 is expected to be 55,000) 3- Cash budget assume the company wishes to maintain a minimum cash balance of $ 75,000 at the end of each month. To maintain the minimum cash balance, the company can borrow from the bank in $1,000 increments at %10 interest and the company should payback borrowed money when there an excess cash balance. (Cash balance at dec 31 2019 is expected to be $60,000) Minimum cash condition Cash Excess (Short ) . Finance Borrowint Principle payment Interest Payment Financing Effect Ending Cash Balance