When evaluating product performance, Walmart’s managers use business math to determine if/when markdowns should be used. The reasons for applying markdowns vary. Markdowns may be used to make promotional merchandise more attractive to customers, to reduce inventory of products that do not meet turn requirements, or to correct errors in product selection.Download the following spreadsheet: Example Spreadsheet Based on research, course content, and the spreadsheet data for inventory and sales performance on selected products in a Walmart store, complete the following:1. Calculate the answers for the blank (highlighted) cells in the spreadsheet.2. Assume the buyer wanted to achieve an average margin percentage of at least 64% for the six products. Was this goal achieved? Explain why or why not, and how margin percentages may have affected inventory performance.3. Assume the buyer wanted to achieve an average sell-thru percentage of 64% at full price for the six products. Was this goal achieved? Explain why or why not.4. Based on the results of your calculations and the other information in the spreadsheet, identify which products you would mark down; and explain how the markdowns would be expected to affect inventory costs, total dollar sales, and sell-thru percentages.