what formula would I ise to solve this?

EXAMPLE SPREADSHEET SKU numbers, unit costs, retail pricing, and other numbers in the spreadsheet are fictitious and are not intended to represent actual data related to actual Walmart products a) Calculate the answers for the blank (highlighted) cells in the spreadsheet below. ( 5 points) Pertinent Information and Sales Results at Full Price After 1 Month of Sales b) Assume the buyer wanted to achieve a margin percentage of at least 64% for the six products. Was this goal achieved? Explain why or why not, and how marin nereentaee mav have afferted inventnry nerfinmanra. I nnintel c) 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. ( 3 points) d) 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. (4 points)