Calculate the cells that are highlighted in yellow in the Item Sales Report: Express dollar amounts...
Fantastic news! We've Found the answer you've been seeking!
Question:
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%
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Think about the impact that e-commerce and more flexible networks of organisations has had on the way international business is conducted. How has it created new complexities in the relationships...
-
What is a relative bid? Why is it important for the collection of bidding history information?
-
Write the structure for a. 3-hydroxyhexanoic acid b. 2-iodo-2-methyloctanoic acid c. 2-butynoic acid d. 5-ethyl-6-oxoheptanoic acid
-
What is the law of the excluded middle? Argue against the need for this law.
-
Georgia Supply Corporation, a merchandising firm, prepared the following trial balance as of October 1: Georgia Supply engaged in the following transactions during October 2011. The company records...
-
1. If astronauts could travel at v = 0.950c, we on Earth would say it takes 4.42 years to reach Alpha Centauri, which is 4.20 light-years away. The astronauts disagree. a. How much time do the...
-
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine...
-
Oil and gas is regulated in order to: Group of answer choices A. Protect the resource B. Reduce financial gain C. Prevent waste of the resource A and B A and C
-
Cross-cultural team norms and diversity can be negative as there will be a lot of clashes over old ideals and cultural expectations is this true? or can diversity in a team get along as there are...
-
A stock has had returns of 27 percent, 14 percent, -14 percent over the last three years, respectively. What is the geometric mean return for this stock? (Enter your answers as a percentage rounded...
-
Two physical pendulums (not simple pendulums) are made from meter sticks that are suspended from the ceiling at one end. The sticks are uniform and are identical in all respects, except that one is...
-
3) A flat coil is wrapped with 200 turns of very thin wire on a square frame with sides 18 cm long. A uniform magnetic field is applied perpendicular to the plane of the coil. If the field changes...
-
Two billiard balls with the same mass m move towards one another. Ball one moves in the positive x-direction with a speed of v1i, and ball two moves in the negative x direction with a speed of v2i....
-
Research "Leadership Success and Failure," and write a paper on the topic. Many leaders across industry, government, entertainment and humanitarianism have discussed their success and have shared...
-
Reduction in sales All of the above 29. Belt of an electric motor is broken, it needs a. Corrective maintenance b. Scheduled maintenance c. Preventive maintenance d. Timely maintenance. 30. The...
-
Clausius-Clayperon equation is applicable to (a) Solid-vapour (b) Solid-liquid (c) Liquid-vapour (d) All of these.
-
The reaction \(A(\mathrm{l}) ightarrow R(\mathrm{~g})\) is allowed to reach equilibrium condition in an autoclave. At equilibrium there are two phases - one a pure liquid phase of \(A\) and the other...
-
The equilibrium constant for the reaction \(\mathrm{N}_{2}(\mathrm{~g})+3 \mathrm{H}_{2}(\mathrm{~g}) ightarrow 2 \mathrm{NH}_{3}\) is 0.1084 . Under the same conditions, the equilibrium constant for...
Study smarter with the SolutionInn App