Consider the following list of Stock Keeping Units (SKU) and their associated demands and unit cost.
SKU | Annual Demand | Unit Cost |
11 R | 250 | 250 |
22 S | 50 | 90 |
33 T | 10 | 70 |
44 U | 125 | 150 |
55 V | 125 | 100 |
Calculate the total dollar volume for the above SKUs.
Ans
The dollar volume for a stock keeping unit (SKU) is obtained by multiplying annual demand with unit cost. The total dollar volume is sum of the dollar volume of all SKU's.
Annual demand | Unit cost | dollar value | ||
11 | R | 250 | 250 | 62500 |
22 | S | 50 | 90 | 4500 |
33 | T | 10 | 70 | 700 |
44 | U | 125 | 150 | 18750 |
55 | V | 125 | 100 | 12500 |
total | 98950 |
the formuls is shown below:
F | G | H | I | J |
Annual demand | Unit cost | dollar value | ||
11 | R | 250 | 250 | =H8*I8 |
22 | S | 50 | 90 | =H9*I9 |
33 | T | 10 | 70 | =H10*I10 |
44 | U | 125 | 150 | =H11*I11 |
55 | V | 125 | 100 | =H12*I12 |
total | =J8+J9+J10+J11+J12 |
Get Answers For Free
Most questions answered within 1 hours.