Use Excel formulas to complete the calculations and then answer the short-answer questions in the following spreadsheet: Inventory Analysis at Walmart Click for more options Hint: When calculating retail price {RP} based on cost {C} and markup percentage {M%} on RP, use the Cost Complement formula we have discussed previously in class: RP = [(C)/(100% - M%)] x 100

A B D E F G H K M N 0 R Inventory Analysis at Walmart 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 cells that are highlighted in yellow. Express dollar amounts to the nearest penny and percentage answers to the nearest tenth. (7 points) Line Div Retail 1 2 2 3 4 Vendor Acme Acme Acme 1.78 1.89 2.12 Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers 5 Acme Acme Acme Item# 665780 665781 665782 665783 665784 665785 665786 665787 665788 665789 Description Phillips Head Small 4" Phillips Head Medium 4" Phillips Head Large 6 Phillips Head Extra Large 7" Regular Head Small 4" Regular Head Medium 4" Regular Head Large 6 Regular Head Extra Large 7" 6-in-1 Racheting Screwdriver Screwdriver Assortment Pack Cost $ $ $