Please help me with this 3 Following are Arbor Cos budgeted

Please help me with this

3. Following are Arbor Co.\'s budgeted levels for 4th quarter Sales Purchases Expenses October 7,000 4,000 $ November December 9,000 12,000 5,000 7.000 900 700 800 * Sales are 10% cash, 90% credit, credit sales are collected 40% in month of sale 60% in month following sale Purchases are all credit, paid 20% month of purchase, 80% month following purchase *Expenses are paid in cash each month A. What are the company\'s expected cash collections during November? B. What are the company\'s expected cash disbursements during November? C. What is the company\'s expected November 30th balance in Accounts Receivable? D. What is the company\'s expecte Dember 31st balance in Accounts Payable?

Solution

a) Cash collection during november = (9000*10%+9000*90%*40%+7000*90%*60%) = 7920

b) Cash disbursement during november = (5000*20%+4000*80%+700) = 4900

c) Account receivable november 30 balance = 9000*90%*60% = 4860

d) Account payable balance december 31 = 7000*80% = 5600