Prepare the Sales Budget for the Quarter considering the information givenbelow$1.$ Metro Logistics, Mississauga is preparing budgets for the quarter endingNovember $302.$ Consider that the selling price is $$8$ per unit$3.$ Budgeted sales for the five months are as followsJuly $25,000$ unitsAugust $40,000$ unitsSeptember $30,000$ unitsOctober $25,000$ unitsNovember $15,000$ unitsB. Calculate the total cash collections for the quarter ending November $30$ onthe basis of the information given below:$1.$ The collection trend of Metro Logistics is as follows:$60\%$ collected in the month of sale$35\%$ collected in the month following sale$5\%$ is uncollectible$\mathrm{.}2.$ Consider that June $30$ accounts receivable balance of $$20,000$ will becollected in fullC. Prepare the Production Budget for the Quarter based on the followinginformation:$1.$ Metro Logistics wants ending inventory to be equal to $20\%$ of thefollowing month$$s budgeted sales in units$\mathrm{.}2.$ On June $30,$ units on hand were $5000$InstructionPrepare excel spreadsheets for Budgeted sales, Total cash collection andProduction budget. Use Tab for each spreadsheet.Ensure that the submitted Excel file is active and all spreadsheet calculatio