What is the answer to the boxed question?

6a) The beginning of June cash balance is expected to be $ 40,000 6b) Based on expectations and past experience, the budgeting committee believes that the following cash inflows, cash receipts, and cash sources is expected to be as follows: * Cash deposits (advances) made by customers placing orders $ * Cash sales, customers paying cash for drums $ * Balance of amounts owed by customers for completed drums $ * Payments by retailers who are making installments, Acc / Rec. S * Tax refund, Federal income tax * Sale of old wood-sanding machines 3,000 27,500 15,620 65,200 1,560 250 $ 6c) Based on expectations and past experience, the budget committee believes that the following cash outflows, cash disbursements, and cash uses will be as follows: * Payroll costs * Employer's portion of payroll taxes * Health insurance * Accident compensation insurance * Employee pizza party * Payment for raw materials purchased on account, accounts / pay * Monthly electric bill * Payment of office lease * Warehouse lease * Purchase new air-compressor and factory tools * Advertising and marketing expenditures * Tax expense payments * Factory supplies 13,600 3,680 1,450 356 500 18,900 1,247 1,500 450 3,597 2,500 4,500 1,680 6d) Not only does ADC budget cash each month, but the company has a standing cash policy that the ending monthly cash balance should never be less than $25,000, and if the ending monthly cash balance is more than $60,000, ADC management invests the excess cash in safe short-term investments. Currently, the balance in the short-term investments is $10,000, and this amount can be made available for operations if the cash balance falls below $25,000. 6e) ADC has a revolving credit line with a local bank. The credit line was set-up with the bank to ensure that ADC would always have access to operating cash on an as-needed basis. Currently, ADC has a loan balance of $5,000 and needs to pay-off the balance if possible. In the event that ADC is short on cash at the end of the month, ADC can borrow up to an additional $25,000 (grand total: $30,000). 161) Use the above information to create a cash budget in good format