Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Referring to table below, Total Number of boxes is 861, total number of items 380260 and total amount for shipping, custom, etc. is $16,216.61. The
Referring to table below, Total Number of boxes is 861, total number of items 380260 and total amount for shipping, custom, etc. is $16,216.61. The last column labelled "Unit Price" is the cost per item. Therefore, Item 1 total cost of item $0.06 * 250 (quantity within box) would be $15.80 as shown in separate column attached. With this information, how does one calculate shipping cost for each item? Meaning how is $16,216.61 split and added to each item to find final total cost?
EXAMPLE ON CONTAINER COST DETAILS | ||||||
PRODUCTS | TOTAL # OF | QUANTITY PER BOX | QUANTITY | CONTAINER /MIS | UNIT PRICE | |
BOXES | UNITS | TOTAL UNITS | COST $$ | |||
Item 1 | 84 | 250 | 21000 | $8,279.20 | $0.06 | |
Item 2 | 105 | 200 | 21000 | $5,437.41 | $0.08 | |
Item 3 | 252 | 230 | 57960 | $1,700.00 | $0.07 | |
Item 4 | 40 | 1000 | 40000 | $800.00 | $0.03 | |
Item 5 | 20 | 1000 | 20000 | $0.03 | ||
Item 6 | 40 | 1000 | 40000 | $0.04 | ||
Item 7 | 15 | 1000 | 15000 | $0.04 | ||
Item 8 | 8 | 1000 | 8000 | $0.03 | ||
Item 9 | 8 | 1000 | 8000 | $0.03 | ||
Item 10 | 9 | 1000 | 9000 | $0.04 | ||
Item 11 | 8 | 1000 | 8000 | $0.04 | ||
Item 12 | 30 | 500 | 15000 | $0.06 | ||
Item 13 | 30 | 500 | 15000 | $0.06 | ||
Item 14 | 20 | 500 | 10000 | $0.07 | ||
Item 15 | 20 | 500 | 10000 | $0.06 | ||
Item 16 | 20 | 500 | 10000 | $0.06 | ||
Item 17 | 19 | 500 | 9500 | $0.07 | ||
Item 18 | 22 | 1000 | 22000 | $0.02 | ||
Item 19 | 22 | 1000 | 22000 | $0.02 | ||
Item 20 | 10 | 300 | 3000 | $0.07 | ||
Item 21 | 79 | 200 | 15800 | $0.12 | ||
861 | 380260 | $16,216.61 |
$15.80 |
$15.80 |
$16.38 |
$30.00 |
$31.00 |
$35.00 |
$38.00 |
$30.00 |
$31.00 |
$35.00 |
$38.00 |
$28.00 |
$30.50 |
$36.50 |
$28.00 |
$30.50 |
$36.50 |
$24.50 |
$24.50 |
$21.00 |
$23.20 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started