•  
  • Open the Excel file to the tab labeled Observations
  • In Text Box 1, identify at least three merchandise items that require action and explain why
  • In Text Box 2, develop and defend at least three recommended action steps to maximize sales and/or minimize liabilities for the merchandise items
  • In Text Box 3, indicate what additional data or information would have been helpful to you in your analysis

SSIGNMENT 3.2 WORKSHEET Item Sales Report Buyer: Small tools Region: Southeast Week Ending: Beginning % Total July Week- on Basic Stock ne Div Dept Class Vendor Item # Description Cost Retail Markup % Margin % On Hand Hand On Order Item % Week 2-Week 3-Week 4- Sell Thru LW Sales Sales in Sales in Sales in in Units Units Units Units 1 Screw Drivers 25 1 Vulcan 665780 Phillips Head Small 4" $ 1.78 $ 4.00 125% 55.5% 788 12.2% 66 Y 4.1% 32 53 55 0 2 Screw Drivers 25 1 Vulcan 665781 Phillips Head Medium 4" $ 1.89 $ 4.00 52.8% 1187 21 33 0 0 3 Screw Drivers 25 1 Vulcan 665782 Phillips Head Large 6" $ 2.12 $ 4.50 112% 52.9% 522 8.1% 47 Y 67 44 35 42 4 Screw Drivers 25 1 Vulcan 665783 Phillips Head Extra Large 7" $ 2.25 $ 4.50 100% 478 7.4% 4 Y 0.6% 5 3 9 5 Screw Drivers 25 1 Vulcan 665784 Regular Head Small 4" $ 1.78 $ 4.00 125% 55.5% 899 43 Y 3.8% 34 51 22 12 6 Screw Drivers 25 7 Screw Drivers 25 1 8 Screw Drivers 25 1 Vulcan Vulcan 1 Vulcan 665785 Regular Head Medium 4" $ 1.89 $ 4.00 52.8% 623 9.6% 1 Y 12 23 65 120 665786 Regular Head Large 6" $ 2.12 $ 4.50 112% 898 13.9% 76 Y 2.4% 22 54 65 43 9 Screw Drivers 25 10 Screw Drivers 25 1 Vulcan 1 Vulcan 665787 665788 665789 Regular Head Extra Large 7" $ 2.25 $ 4.50 100% 50.0% 300 4.6% 33 Y 10.7% 32 23 76 66 6-in-1 Racheting Screwdriver $ Screwdriver Assortment Pack $ 3.46 $ 9.00 61.6% 433 21 N 78 57 77 95 5.55 $ 19.00 242% 345 5.3% 1500 N 29.6% 102 110 134 154 OTALS 6473 1791 6.2% 403 453 532 541 VERAGES alculate the cells that are highlighted in yellow in the Item Sales Report: Express dollar amounts to the nearest penny and percentage answers to the nearest tenth _verage Cost > Total Cost/number of line items Item Sales Report Observations +