Question

Consider the following list of Stock Keeping Units (SKU) and their associated demands and unit cost....

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.

Homework Answers

Answer #1

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
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Date Transaction # of Units Unit Cost Total Cost 1/1 Beg Balance 150 $30 $4,500 1/24...
Date Transaction # of Units Unit Cost Total Cost 1/1 Beg Balance 150 $30 $4,500 1/24 Purchase 70 33 2,310 2/22 Sale (100) - - 3/7 Purchase 90 35 3,150 4/10 Purchase 140 36 5,040 6/11 Sale (100) - - 9/28 Purchase 50 38 1,900 12/4 Sale (100) - - What is the cost of goods sold under a FIFO periodic inventory system? $10,500 $9,610 $7,290 $6,150 What is the ending inventory under a LIFO periodic inventory system? $10,500 $9,610...
Consider the all-units quantity discount schedule below. Price Bracket Quantity Ordered Price Per Unit EOQ at...
Consider the all-units quantity discount schedule below. Price Bracket Quantity Ordered Price Per Unit EOQ at that Price 1 1-1999 $100 3,454 2 2000-3999 $90 3,647 3 4000-5999 $80 3,860 4 6000-7999 $70 4,067 5 8000+ $60 4,510 If you want to take advantage of the price discount in Price Bracket 2, given the required order quantity and calculated EOQ at that price, what is the Total Annual Cost (holding, setup, and purchasing) following the optimal order quantity in that...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of a specific product in the past three years. Quarter Year 1 2 3 4 2015 350 254 176 228 2016 367 258 169 236 2017 342 250 166 228 Predict demand in quarter 1 and quarter 2 of 2018, given that the demand forecast for the whole year is a total of 1,040 units. Question 6: DRP (8 p) A central DC supplies a...
Let’s consinder a mortgage application using HMDA (The Home Mortgage Disclosure Act). Here is a sample...
Let’s consinder a mortgage application using HMDA (The Home Mortgage Disclosure Act). Here is a sample from 30 mortgage applications: ID loanamt income hprice 1 109 63 155 2 185 137 264 3 121 53 128 4 125 78 125 5 119 37 149 6 153 65 171 7 380 188 484 8 100 58 125 9 110 78 158 10 41 31 116.5 11 115 54 128 12 248 117 280 13 126 60 157.5 14 260 192 325...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Royal Furniture...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Royal Furniture Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for February is summarized as follows: a. Estimated sales of King and Prince chairs for February by sales territory: Northern Domestic:   King 610 units at $780 per unit   Prince 750 units at $550 per unit Southern Domestic:   King 340 units at...
Pat.# Before After 1 195 125 To the left is 2 datasets measured for a sample...
Pat.# Before After 1 195 125 To the left is 2 datasets measured for a sample of 107 patients with the high cholesterol level before and after taking medication. Obtain the following for both sets: 2 208 164 3 254 152 1- the mean, mode and median 4 226 144 5 290 212 2- the variance and standard deviation 6 239 171 7 216 164 3- First, second and third quartiles 8 286 200 9 243 190 10 217 130...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 36 $150 $5,400 8 Purchase 72 180 12,960 11 Sale 48 500 24,000 30 Sale 30 500 15,000 May 8 Purchase 60 200 12,000 10 Sale 36 500 18,000 19 Sale 18 500 9,000 28 Purchase 60 220 13,200 June 5 Sale...
A loan made on March 14 is due September 13 of the following year. Find the...
A loan made on March 14 is due September 13 of the following year. Find the exact time for the loan in a​ non-leap year and a leap year. days. The exact time in a​ non-leap year is ? days The exact time in a leap year is ? days. Data Table Sequential Numbers for Dates of the Year Day of Month Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. 1 1 32 60 91 121...
On 1 July 2019, Entity A entered into the Contract X with a customer, Entity B,...
On 1 July 2019, Entity A entered into the Contract X with a customer, Entity B, to sell Product A for $300 per unit. If Entity B purchases more than 1,000 units of Product A in a 12-month period, Contract X specifies that the price will be reduced to $250 per unit. Entity B agreed to settle all outstanding amount of Contract X in July 2020 when both Entities agreed with the total units of sales on 30 June 2020....
Total utility can be objectively measured in numbers that indicate usefulness or benefit to the consumer....
Total utility can be objectively measured in numbers that indicate usefulness or benefit to the consumer. ____ 2. Consumers should purchase quantities of a good to the point where MU > P. ____ 3. Voluntary exchange requires that there must be mutual gain. ____ 4. Points along a budget line represent the maximum combinations of two commodities that a consumer can afford. ____ 5. The budget line represents a consumer's preferences for a commodity. ____ 6. A change in consumer...