The question is in the attached excel file. Please prepare a cash receipts budget for July, August, and September. And then provide cash budget for each months of July, August, September. (Round in...

Sheet2
Sheet3
    Week 6 DQ #2
    for this assignment please explain the initial problem and the initial assumptions, then provide a complete answer. Explain your work in detail atleast 5 references are required for this assignment. One should be the textbook as the source of data.
        In table below all given numbers are in black letters, all the found numbers in red
        July    August    September
    Sales    $ 63,400    $ 80,600    $ 48,600
    Budgeted cash payments
    Direct Materials    $ 12,480    $ 9,900    $ 10,140
    Direct Labor    $ 10,400    $ 8,250    $ 8,450
    Factory Overhead    $ 18,720    $ 14,850    $ 15,210
    Proforma statement of cash flows
    Initial Cash    $ 12,900    $ 12,600    $ 19,220
    Accounts Payable    $ 5,100    $ - 0    $ - 0
    Accounts Recievable    $ 47,000    $ 64,480    $ 38,880
    Loan Payable    $ 2,600    $ 7,386    $ - 0
    The cash flow from operating activities
    Cash received for previous month sales     $ 47,000    $ 50,720    $ 64,480
    Cash received for current month sales    $ 12,680    $ 16,120    $ 9,720
    Sales commission     $ 6,340    $ 8,060    $ 4,860
    Office salaries    $ 4,600    $ 4,600    $ 4,600
    Rent    $ 7,100    $ 7,100    $ 7,100
    Direct Materials    $ 12,480    $ 9,900    $ 10,140
    Direct Labor    $ 10,400    $ 8,250    $ 8,450
    Factory Overhead    $ 18,720    $ 14,850    $ 15,210
    Cash Flow from operating activities     $ 40    $ ...