Calculate the cells that are highlighted in yellow in the Item Sales Report: Express dollar amounts...

 

Transcribed Image Text:

Calculate 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 Average Cost > Total Cost/number of line items Average Retail > Total Retail/number of line items Markup %> (Retail Cost)/Cost Example: (4.00-1.78)/1.78 = 1.25% Average Markup > Total Markup/10 (number of line items) Margin %> (Retail - Cost)/ Retail Example: (4.00-1.78)/4.00 = 55.5% Average Margin Total Margin/10 (number of line items) % Total On-Hand Sell Thru % % Total Sales On-Hand / Total On-Hand LW Sales in Units/Beginning Week - on Hand MTD Sales in Units/Total MTD Sales in Units Example 788/6473 Item Sales Report Buyer: Small tools Region: Southeast Week Ending: July Beginning Week 2 Week 3 Week 4- Week On % Total Line Div Dept Class Vendor Item Description Cost Retail Markup % Margin % Hand on Hand On Order Basic Stock Item % Sell Thru LW Sales Sales in Sales in Sales in MTD Sales % Total in Units Units Units Units in Units Sales MTD Sales $ 1 Screw Drivers 25 Vulcan 665780 Phillips Head Small 4" $ 1.78 $ 4.00 125% 55.5% 788 12.2% 66 Y 4.1% 32 53 55 140 7.3% $ 543 2 Screw Drivers 25 1 Vulcan 665781 Phillips Head Medium 4" $ 1.89 $ 4.00 112% 52.8% 1187 18.3% OY 33 0 54 2.8% $ 210 3 Screw Drivers 25 1 Vulcan 665782 Phillips Head Large 6" $ 2.12 $ 112% 52.9% 8.1 % 47 Y 12.8% 44 35 42 188 9.7% $ 821 4 Screw Drivers 25 1 Vulcan 665783 Phillips Head Extra Large 7" $ 2.25 $ 4.50 100% 50.0% 478 7.4% 4 Y 0.6% 3 5 3 9 20 1.0 % $ 87 5 Screw Drivers 25 1 Vulcan 665784 Regular Head Small 4" $ 4.00 125% 55.5% 899 13.9% 43 Y 34 12 119 6.2% $ 462 6 Screw Drivers 25 Vulcan 665785 Regular Head Medium 4" $ 1.89 $ 4.00 112% 52.8% 623 9.6% 1 Y 1.9% 12 23 65 120 220 11.4 % $ 854 Screw Drivers 25 Vulcan 665786 Regular Head Large 6 2.12 $ 4.50 112% 52.9% 898 13.9% 76 Y 2.4% 22 54 65 184 9.5% $ 803 8 Screw Drivers 25 1 Vulcan 665787 Regular Head Extra Large 7" $ 2.25 $ 4.50 100% 50.0% 300 4.6% 33 Y 10.7% 32 23 76 66 197 10.2% $ 860 9 Screw Drivers 25 1 Vulcan 665788 6-in-1 Racheting Screwdriver $ 3.46 $ 9.00 160% 61.6% 433 6.7% 21 N 18.0% 78 57 77 95 307 15.9% $ 2,680 10 Screw Drivers 25 1 Vulcan 665789 Screwdriver Assortment Pack $ 5.55 $ 19.00 242% 70.8% 345 5.3% 1500 N 29.6% 102 110 134 154 500 25.9% $ 9,215 TOTALS $ 25.09 $ 62.00 1300% 554.6% 6473 1791 6.2% 403 453 532 541 1929 $ 16,534 AVERAGES $ 2.51 $ 6.20 130% 55.5% Calculate 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 Average Cost > Total Cost/number of line items Average Retail > Total Retail/number of line items Markup %> (Retail Cost)/Cost Example: (4.00-1.78)/1.78 = 1.25% Average Markup > Total Markup/10 (number of line items) Margin %> (Retail - Cost)/ Retail Example: (4.00-1.78)/4.00 = 55.5% Average Margin Total Margin/10 (number of line items) % Total On-Hand Sell Thru % % Total Sales On-Hand / Total On-Hand LW Sales in Units/Beginning Week - on Hand MTD Sales in Units/Total MTD Sales in Units Example 788/6473 Item Sales Report Buyer: Small tools Region: Southeast Week Ending: July Beginning Week 2 Week 3 Week 4- Week On % Total Line Div Dept Class Vendor Item Description Cost Retail Markup % Margin % Hand on Hand On Order Basic Stock Item % Sell Thru LW Sales Sales in Sales in Sales in MTD Sales % Total in Units Units Units Units in Units Sales MTD Sales $ 1 Screw Drivers 25 Vulcan 665780 Phillips Head Small 4" $ 1.78 $ 4.00 125% 55.5% 788 12.2% 66 Y 4.1% 32 53 55 140 7.3% $ 543 2 Screw Drivers 25 1 Vulcan 665781 Phillips Head Medium 4" $ 1.89 $ 4.00 112% 52.8% 1187 18.3% OY 33 0 54 2.8% $ 210 3 Screw Drivers 25 1 Vulcan 665782 Phillips Head Large 6" $ 2.12 $ 112% 52.9% 8.1 % 47 Y 12.8% 44 35 42 188 9.7% $ 821 4 Screw Drivers 25 1 Vulcan 665783 Phillips Head Extra Large 7" $ 2.25 $ 4.50 100% 50.0% 478 7.4% 4 Y 0.6% 3 5 3 9 20 1.0 % $ 87 5 Screw Drivers 25 1 Vulcan 665784 Regular Head Small 4" $ 4.00 125% 55.5% 899 13.9% 43 Y 34 12 119 6.2% $ 462 6 Screw Drivers 25 Vulcan 665785 Regular Head Medium 4" $ 1.89 $ 4.00 112% 52.8% 623 9.6% 1 Y 1.9% 12 23 65 120 220 11.4 % $ 854 Screw Drivers 25 Vulcan 665786 Regular Head Large 6 2.12 $ 4.50 112% 52.9% 898 13.9% 76 Y 2.4% 22 54 65 184 9.5% $ 803 8 Screw Drivers 25 1 Vulcan 665787 Regular Head Extra Large 7" $ 2.25 $ 4.50 100% 50.0% 300 4.6% 33 Y 10.7% 32 23 76 66 197 10.2% $ 860 9 Screw Drivers 25 1 Vulcan 665788 6-in-1 Racheting Screwdriver $ 3.46 $ 9.00 160% 61.6% 433 6.7% 21 N 18.0% 78 57 77 95 307 15.9% $ 2,680 10 Screw Drivers 25 1 Vulcan 665789 Screwdriver Assortment Pack $ 5.55 $ 19.00 242% 70.8% 345 5.3% 1500 N 29.6% 102 110 134 154 500 25.9% $ 9,215 TOTALS $ 25.09 $ 62.00 1300% 554.6% 6473 1791 6.2% 403 453 532 541 1929 $ 16,534 AVERAGES $ 2.51 $ 6.20 130% 55.5%