. The Finance officer of Your Natural Romance Co asked for a CASH BUDGET given the following data: October November December Sales $320,000 $370,000 $400,000 Operating Costs 132,000 164,000 210,000 Selling and Administrative Expenses 80,000 92,000 102,000 Capital Expenses 240,000 Among the sales figures, only 90% are treated as receivables, with the other value as down payment. Six tenths of the receivables are collected in the following month and the rest a month further. Semiannual depreciation costs $144,000. Of the remaining operating costs, 80% will be paid in the month they are incurred and the rest, a month after. Current assets as of October 1 include cash of $84,000, marketable securities of $50,000 and accounts receivable of $396,000 ($300,000 from September sales and $96,000 from August Sales). Sales on account in August and September were $240,000 and $300,000 respectively. Current liabilities as of October 1 include $26,000 of accounts payable in September for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax of $48,000 will be made in November. The quarterly dividend is expected to be declared in November and paid in December. Management wishes to maintain a minimum cash balance of $80,000. INSTRUCTION: 1. Construct a schedule of collection, schedule of payments and cash budget for the three months mentioned. Put the corresponding notes as may be applicable (Note A, Note B, etc) Use excel