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

Inventory Analysis at Walmart Exam SKU numbers, unit costs, retail pricing and other numbers in the spreadsheet are fictitious and are a) Calculate the cells that are highlighted in yellow. Express dollar amounts to the nearest penny and percentage answers to the nearest tenth. Line Mart 1 2 3 4 5 6 7 Div Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Vendor Acme Acme Acme Acme Acme Acme Acme 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 5 S $ $ S $ $ $ $ $ Retail 1.78 1.89 2.12 2.25 1.78 1.89 2.12 2.25 3.46 5.55S 8 9 10 18.88 TOTALS H s at Walmart Example Spreadsheet Jeet are fictitious and are not intended to represent actual data related to actual Walmart products s to the nearest tenth. (7 points) Retail 9 2 5 8 9 2 S 6 55 Margin 55.5% 52.8% 52.9% 50.0% 55.5% 52.8% 52.9% 50.0% 61.4% 70.6% Beginning Week 1 Week 2 Week 3. Week 4- Week-On Sell Thru Sales in Sales in Sales in Sales in MTD Sales Hand On Order X Units Units Units Units in Units MTD Sales $ 178 66 18.0% 32 53 55 33 118 0 17.8% 21 33 64 0 200 47 33.5% 67 44 35 42 47 4 6.4% 3 5 3 9 89 43 38.2% 34 51 22 12 62 1 19.4% 12 23 65 120 89 76 24.7% 22 54 65 43 150 33 21.3% 32 23 76 66 333 21 23.4% 78 57 77 95 345 1500 29.6% 102 110 134 154 500 $ 9,438.78 IN WINGIDA UNI 18.88 1611 1791 403 453 596 574 Inventory Analysis at Walmart Exam SKU numbers, unit costs, retail pricing and other numbers in the spreadsheet are fictitious and are a) Calculate the cells that are highlighted in yellow. Express dollar amounts to the nearest penny and percentage answers to the nearest tenth. Line Mart 1 2 3 4 5 6 7 Div Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Vendor Acme Acme Acme Acme Acme Acme Acme 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 5 S $ $ S $ $ $ $ $ Retail 1.78 1.89 2.12 2.25 1.78 1.89 2.12 2.25 3.46 5.55S 8 9 10 18.88 TOTALS H s at Walmart Example Spreadsheet Jeet are fictitious and are not intended to represent actual data related to actual Walmart products s to the nearest tenth. (7 points) Retail 9 2 5 8 9 2 S 6 55 Margin 55.5% 52.8% 52.9% 50.0% 55.5% 52.8% 52.9% 50.0% 61.4% 70.6% Beginning Week 1 Week 2 Week 3. Week 4- Week-On Sell Thru Sales in Sales in Sales in Sales in MTD Sales Hand On Order X Units Units Units Units in Units MTD Sales $ 178 66 18.0% 32 53 55 33 118 0 17.8% 21 33 64 0 200 47 33.5% 67 44 35 42 47 4 6.4% 3 5 3 9 89 43 38.2% 34 51 22 12 62 1 19.4% 12 23 65 120 89 76 24.7% 22 54 65 43 150 33 21.3% 32 23 76 66 333 21 23.4% 78 57 77 95 345 1500 29.6% 102 110 134 154 500 $ 9,438.78 IN WINGIDA UNI 18.88 1611 1791 403 453 596 574