question by entering your answers in the tabs below. Required A Required B Complete the schedule of cash receipts by filling in the missing amounts. July August September Sales Budget Cash sales 70,000 $ 84,000 2$ 86,000 Sales on account 84,000 99,000 122,600 Total budgeted sales $154,000 $ 183,000 $ 208,600 Schedule of Cash Receipts Current cash sales Plus: Collections from accounts receivable Total budgeted collections $ 320,000 $ 168,000 $ 2$ 185,000

Castor Incorporated is preparing its master budget. Budgeted sales and cash payments for merchandise purchases for the next three months follow. April $ 30,000 June Budgeted Sales Cash payments for merchandise purchases May $ 42,000 $ 26,000 24,200 14,800 13,500 Sales are 80% cash and 20% on credit. Sales in March were $26,000. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $14,000 in cash and $4,000 in loans payable. A minimum cash balance of $14,000 is required. Loans are obtained at the end of any month when the preliminary cash balance is below $12,000. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If a preliminary cash balance above $12,000 at month-end exists, loans are repaid from the excess. Expenses are paid in the month incurred and include sales commissions (10% of sales), shipping (4% of sales), office salaries ($7,000 per month), and rent ($5,000 per…

Please do not give solution in image format thanku

(Use cells A4 to D7 and A10 to B30 from the given information in screenshot 1, as well as A3 to C34 from the Schedules and Cash Budget in screenshot 2 to complete this question.)  Please provide me with the formulas needed to complete each cell that has a yellow background. thank you