Shipping Costs Your company has several distributors in Guam that service all of your...

Question

Shipping Costs									Your company has several distributors in Guam that service all of your customers on the island. You have been shipping items in parcel shipments based on the requisitions from the distributors, but your Boss thinks that you can improve your operations by opening a warehouse in Agana and pre-stocking items for delivery.						In order to do a complete cost-savings analysis of the options, you are going to need the current costs per item for parcel shipping so you can compare the costs to the bulk shipping that you are planning to do.						You have good forecasts of the item demand for the out-years, and you want to estimate the shipping cost savings based on item quantity and shipping cost per unit item.						Unfortunately, your data on current shipping costs for parcel shipments is maintained at the shipment level—you only have the quantities of each item shipped and the total cost of the shipments. What’s worse, the shipments generally have different quantities of different items.						The Excel file “Shipping Costs” (on Canvas) contains the data from the most recent 339 shipments for 35 of the items you ship.						Calculate the shipping cost per item for each item in your inventory to report to your Boss. Include any uncertainty you may have with your conclusions.						HINT: Some of these shipments might have been unusual—overnight or rush orders—that may cause you some problems with the data.							Sheet1 	Order Number	Item Number	Quantity	ShipCost 	655791	689162	4	248.06 	655791	748169	4	248.06 	3219625	920171	5	247.73 	527474	239192	1	244.76 	527474	473199	7	244.76 	527474	748169	4	244.76 	3235609	568164	2	240.17 	3235609	748169	3	240.17 	3235609	920171	2	240.17 	3008067	574145	20	238.62 	3008067	873139	40	238.62 	3071589	574145	20	238.62 	3071589	873139	40	238.62 	3130648	748169	10	238.62 	3204811	574145	20	238.62 	3204811	873139	40	238.62 	3011468	481790	2	238.55 	3011468	568164	4	238.55 	3011468	748169	1	238.55 	3011468	920171	2	238.55 	389843	473199	5	237.91 	389843	748169	4	237.91 	389843	920171	2	237.91 	1125282	107197	2	232.02 	1125282	142184	20	232.02 	1125282	568164	4	232.02 	1125282	834185	2	232.02 	1125282	894187	2	232.02 	1752724	239192	4	231.72 	1752724	473199	4	231.72 	609553	481790	2	229.29 	609553	107197	2	229.29 	609553	337131	2	229.29 	609553	574145	2	229.29 	609553	894187	8	229.29 	609553	920171	3	229.29 	1824673	497138	1	228 	1824673	568164	2	228 	1824673	748169	4	228 	3131250	568164	3	227.56 	3131250	748169	3	227.56 	1477115	748169	6	221.6 	1477115	873139	6	221.6 	2610044	239192	1	220.14 	2610044	473199	3	220.14 	2610044	748169	2	220.14 	1125121	568164	6	219.36 	1125121	748169	1	219.36 	1125121	920171	1	219.36 	1330541	239192	1	215.47 	1330541	568164	3	215.47 	1330541	748169	2	215.47 	2873698	107197	4	215 	2873698	873139	40	215 	3221108	107197	4	213.81 	3221108	834185	8	213.81 	3221108	894187	8	213.81 	1480389	779191	20	213 	1691885	748169	4	209.87 	1691885	920171	1	209.87 	2082053	920171	4	209 	2385723	239192	1	207 	2385723	473199	4	207 	2385723	748169	1	207 	2385723	920171	1	207 	2385679	920171	4	206 	1570966	748169	5	205.02 	2278608	568164	2	205 	2278608	748169	2	205 	2278608	920171	2	205 	2691061	891630	1	205 	2691061	239192	2	205 	2691061	473199	5	205 	2691061	748169	1	205 	187663	748169	5	202.75 	187663	920171	1	202.75 	2772665	473199	4	201.92 	2772665	748169	3	201.92 	3046385	473199	4	201.92 	3046385	748169	3	201.92 	3131145	473199	4	201.92 	3131145	748169	3	201.92 	2995532	107197	1	200.21 	2995532	473199	4	200.21 	2995532	748169	2	200.21 	668357	748169	6	199.87 	1621080	748169	6	199.87 	2687898	891630	1	199 	2687898	568164	2	199 	2687898	748169	2	199 	2687898	920171	1	199 	1967843	251350	25	198 	1967843	748169	3	198 	1967843	873139	4	198 	2279164	473199	4	198 	2279164	748169	3	198 	3008185	920171	5	195.57 	1193625	107197	1	195.54 	1193625	235200	1	195.54 	1193625	568164	3	195.54 	1193625	748169	1	195.54 	1193625	894187	2	195.54 	1193625	904203	1	195.54 	1125698	473199	4	195.53 	1125698	920171	3	195.53 	390351	568164	5	194.38 	390351	748169	1	194.38 	390351	920171	1	194.38 	187424	748169	5	191.53 	187424	873139	8	191.53 	1897407	568164	3	190 	1897407	748169	3	190 	2838992	107197	3	189.66 	2838992	834185	3	189.66 	2838992	894187	5	189.66 	458978	568164	2	188.97 	458978	748169	2	188.97 	458978	920171	2	188.97 	1264818	568164	2	186.08 	1264818	748169	3	186.08 	1264818	920171	1	186.08 	2924060	568164	3	183.26 	2924060	748169	2	183.26 	2478638	748169	3	182 	2478638	920171	1	182 	2688637	239192	2	182 	2688637	748169	2	182 	318015	107197	1	181.58 	318015	568164	6	181.58 	1438340	568164	2	181.42 	1438340	748169	3	181.42 	1995408	337131	1	181 	1995408	497138	1	181 	1995408	568164	2	181 	1995408	748169	2	181 	1125212	920171	5	180.99 	1693103	920171	5	180.99 	3070110	107197	2	180.96 	3070110	574145	3	180.96 	3070110	834185	2	180.96 	3070110	873139	4	180.96 	3070110	894187	2	180.96 	2585218	748169	3	180 	2585218	920171	1	180 	2719144	107197	1	180 	2719144	235200	1	180 	2719144	834185	1	180 	2719144	894187	2	180 	2719144	904203	1	180 	2719144	941190	1	180 	915726	142184	10	179.08 	915726	689162	2	179.08 	915726	748169	3	179.08 	914768	107197	3	178.44 	914768	438200	1	178.44 	914768	894187	5	178.44 	930145	138179	4	177.86 	930145	568164	1	177.86 	930145	748169	3	177.86 	930145	920171	1	177.86 	1353733	568164	3	177.74 	1353733	748169	2	177.74 	1353733	920171	1	177.74 	2125017	251350	10	177 	2125017	941920	1	177 	2125017	138179	10	177 	2125017	568164	3	177 	2125017	748169	1	177 	688273	473199	2	176.71 	688273	748169	4	176.71 	2995893	473199	3	175.84 	2995893	748169	1	175.84 	2995893	6239990	1	175.84 	2148947	748169	4	175 	2148947	873139	10	175 	2305371	473199	3	175 	2305371	748169	3	175 	1799816	568164	2	174 	1799816	748169	1	174 	1799816	920171	2	174 	2360344	748169	4	174 	2872356	107197	2	172 	2872356	235200	2	172 	2872356	894187	3	172 	2872356	904203	1	172 	2983690	107197	3	169.75 	2983690	894187	5	169.75 	309125	107197	3	169.67 	309125	438200	1	169.67 	309125	894187	4	169.67 	436388	568164	3	169.62 	436388	748169	2	169.62 	2517378	568164	4	168 	2517378	748169	1	168 	2529198	239192	2	168 	2529198	473199	3	168 	2529198	748169	2	168 	1080854	239192	2	167.6 	1080854	473199	3	167.6 	2827077	107197	1	167.34 	2827077	473199	4	167.34 	2827077	920171	1	167.34 	1967507	568164	2	167 	1967507	748169	2	167 	1967507	920171	1	167 	2122686	568164	2	167 	2122686	748169	2	167 	2122686	920171	1	167 	239653	568164	1	166.88 	239653	748169	1	166.88 	239653	920171	3	166.88 	2069472	920171	4	166 	2921820	473199	4	165.92 	2921820	748169	2	165.92 	1252899	473199	3	165.13 	1252899	748169	3	165.13 	2784057	568164	2	165.06 	2784057	748169	2	165.06 	2784057	920171	1	165.06 	3219070	748169	4	163.73 	3219070	873139	4	163.73 	3235644	107197	4	160.28 	3020685	107197	2	160.08 	3020685	235200	1	160.08 	3020685	894187	8	160.08 	3020685	904203	1	160.08 	2849501	473199	2	158.07 	2849501	748169	2	158.07 	2849501	920171	1	158.07 	679575	142184	5	156.99 	679575	920171	3	156.99 	1678485	239192	1	156.44 	1678485	473199	4	156.44 	1678485	748169	1	156.44 	2386360	239192	1	154 	2386360	568164	2	154 	2386360	748169	1	154 	2319395	894187	8	153 	1113739	239192	2	150.12 	1113739	568164	2	150.12 	3048145	568164	3	147.02 	3048145	748169	1	147.02 	3048145	920171	2	147.02 	1853595	107197	1	145 	1853595	568164	1	145 	1853595	894187	2	145 	1853595	920171	1	145 	1194274	920171	4	144.79 	2045690	748169	4	144 	2304890	138179	5	144 	2304890	568164	2	144 	2304890	873139	2	144 	2304890	920171	1	144 	2660693	568164	3	144 	2660693	920171	2	144 	3069321	473199	2	143.26 	3069321	748169	2	143.26 	3235402	473199	2	143.26 	3235402	748169	2	143.26 	3130761	107197	1	142.9 	3130761	235200	1	142.9 	3130761	568164	2	142.9 	3130761	894187	1	142.9 	3130761	904203	1	142.9 	540173	473199	5	141.98 	540173	748169	1	141.98 	688630	568164	3	141.55 	688630	748169	2	141.55 	1993426	568164	5	141 	1993426	873139	20	141 	3069836	473199	6	140.91 	1047661	568164	2	140.42 	1047661	748169	2	140.42 	2786033	568164	1	138.08 	2786033	748169	2	138.08 	2786033	920171	1	138.08 	2408740	568164	1	138 	2408740	748169	2	138 	2408740	920171	1	138 	339051	250183	1	137.45 	339051	473199	2	137.45 	339051	748169	1	137.45 	2479630	568164	1	133 	2479630	748169	3	133 	2784746	748169	3	132.9 	3240237	748169	3	132.9 	1251104	473199	2	132.6 	1251104	748169	2	132.6 	2837457	473199	3	131.53 	2837457	920171	1	131.53 	2985149	337131	1	130.4 	2985149	497138	1	130.4 	2985149	920171	1	130.4 	2985149	927139	1	130.4 	2471761	473199	1	129 	2471761	920171	2	129 	2477991	473199	4	128 	2477991	748169	2	128 	1870282	568164	2	127 	1870282	748169	2	127 	2972596	568164	2	125.95 	2972596	748169	2	125.95 	1994111	239192	2	125 	1994111	473199	2	125 	1060195	568164	5	124.88 	306505	748169	5	124.61 	1225223	138179	10	124.55 	1225223	748169	2	124.55 	1225223	920171	1	124.55 	2467846	568164	2	124 	2467846	748169	2	124 	3070440	107197	2	123.53 	3070440	894187	8	123.53 	254677	748169	3	123.01 	1115994	748169	3	123.01 	1264087	748169	3	123.01 	2292281	239192	2	123 	2292281	473199	2	123 	2293199	920171	3	123 	993142	107197	3	122.06 	993142	894187	3	122.06 	2661571	568164	2	122 	2661571	748169	2	122 	1251774	568164	1	120.91 	1251774	920171	2	120.91 	3253566	107197	1	120.75 	3253566	568164	1	120.75 	3253566	748169	1	120.75 	3253566	894187	2	120.75 	156110	891630	1	120.45 	156110	568164	5	120.45 	2230450	473199	2	119 	2230450	748169	2	119 	1767746	107197	1	118 	1767746	894187	1	118 	1767746	920171	1	118 	2628043	473199	2	116 	2628043	748169	2	116 	2872535	473199	2	116 	2872535	748169	2	116 	3238164	473199	1	115.93 	3238164	748169	2	115.93 	2094345	568164	4	115 	2094345	920171	1	115 	1863913	748169	2	114 	1863913	894187	1	114 	2082577	239192	2	114 	2082577	748169	1	114 	775677	107197	1	112.29 	775677	574145	1	112.29 	775677	748169	1	112.29 	775677	834185	1	112.29 	775677	894187	1	112.29 	1083641	107197	2	111.26 	1083641	894187	4	111.26 	1838987	239192	1	110 	1838987	473199	3	110 	960207	568164	1	109.89 	960207	748169	2	109.89 	960207	873139	4	109.89 	926978	568164	3	109.15 	926978	748169	1	109.15 	926978	920171	1	109.15 	1618225	920171	3	108.59 	198164	568164	3	108.24 	198164	748169	1	108.24 	282886	568164	3	108.24 	282886	748169	1	108.24 	1124896	568164	3	108.24 	1124896	748169	1	108.24 	1581355	568164	3	108.24 	1581355	748169	1	108.24 	1871105	748169	3	108 	2044066	748169	3	108 	2147343	748169	3	108 	2216777	748169	3	108 	2528855	473199	4	108 	2467209	568164	2	106 	2467209	748169	1	106 	929294	568164	3	105.42 	929294	894187	1	105.42 	929294	968190	1	105.42 	2150470	107197	1	105 	2150470	235200	1	105 	2150470	834185	1	105 	2150470	894187	3	105 	2150470	904203	1	105 	376892	138179	2	103.49 	376892	139184	2	103.49 	376892	142184	2	103.49 	376892	473199	1	103.49 	376892	920171	1	103.49 	687865	107197	1	103.41 	687865	834185	1	103.41 	687865	894187	2	103.41 	687865	920171	1	103.41 	186780	568164	4	103.34 	186780	920171	1	103.34 	2758715	107197	2	102.87 	2758715	894187	4	102.87 	881212	748169	2	102.82 	881212	920171	1	102.82 	1799680	891630	1	101 	1799680	568164	1	101 	1799680	748169	1	101 	2202624	473199	3	100 	2202624	497138	1	100 	2069987	568164	1	99 	2069987	748169	2	99 	3007009	473199	2	98.96 	3007009	748169	1	98.96 	3146848	473199	2	98.96 	3146848	748169	1	98.96 	3117529	873139	4	98 	3117529	920171	2	98 	2785190	568164	3	97.36 	2785190	873139	2	97.36 	2360404	568164	1	97 	2360404	748169	2	97 	2530464	239192	1	97 	2530464	473199	1	97 	2530464	748169	1	97 	2291575	748169	1	95 	2291575	920171	1	95 	863494	107197	1	93.85 	863494	894187	4	93.85 	863494	3072990	1	93.85 	2995887	568164	2	93.07 	2995887	920171	1	93.07 	1278614	239192	2	91.71 	1640202	920171	2	91.71 	585083	568164	1	91.6 	585083	748169	2	91.6 	618793	568164	1	91.6 	618793	748169	2	91.6 	3019904	568164	2	90.43 	3019904	873139	6	90.43 	2851670	748169	2	88.6 	2984729	748169	2	88.6 	3019094	748169	2	88.6 	3204385	748169	2	88.6 	1146339	574145	2	87.58 	1146339	873139	4	87.58 	1146339	920171	1	87.58 	2453996	574145	2	87 	2453996	748169	2	87 	2453996	873139	4	87 	1477051	473199	4	86.94 	2059777	689162	4	86.86 	1183121	568164	2	86.16 	1183121	920171	1	86.16 	1298189	568164	2	86.15 	1298189	920171	1	86.15 	3093058	574145	1	85.2 	3093058	748169	1	85.2 	3093058	873139	2	85.2 	3146794	574145	1	85.2 	3146794	748169	1	85.2 	3146794	873139	2	85.2 	1428170	107197	1	85.03 	1428170	235200	2	85.03 	1428170	574145	4	85.03 	1428170	894187	1	85.03 	1428170	904203	1	85.03 	2330131	138179	2	84 	2330131	139184	2	84 	2330131	142184	3	84 	2330131	473199	1	84 	2330131	920171	1	84 	504551	340141	1	83.43 	504551	568164	2	83.43 	504551	873139	2	83.43 	646329	568164	2	83.26 	646329	748169	1	83.26 	790208	568164	2	83.26 	790208	748169	1	83.26 	859642	568164	2	83.26 	859642	748169	1	83.26 	1895390	748169	3	82 	1968597	748169	3	82 	2798126	473199	3	81.64 	2798126	748169	1	81.64 	654320	107197	1	80.81 	654320	834185	1	80.81 	654320	894187	2	80.81 	3069415	142184	4	80.7 	3069415	473199	1	80.7 	3069415	920171	1	80.7 	2231408	235200	1	79 	2231408	894187	3	79 	2231408	904203	1	79 	2478589	568164	3	79 	2901467	920171	2	78.23 	2923592	920171	2	78.23 	3145641	138179	5	76.09 	3145641	139184	5	76.09 	3145641	141184	2	76.09 	3145641	473199	1	76.09 	3204203	568164	1	75.85 	3204203	748169	1	75.85 	747997	473199	3	75.56 	747997	748169	1	75.56 	2771117	748169	1	75.11 	2771117	6239990	1	75.11 	3059458	748169	1	75.11 	3059458	920171	1	75.11 	2279669	239192	1	75 	2279669	748169	1	75 	892377	139184	5	74.68 	892377	779191	1	74.68 	892377	920171	1	74.68 	470412	107197	2	74.17 	2598248	568164	1	74 	2598248	748169	1	74 	1910620	748169	2	73 	2950097	107197	1	72.62 	2950097	834185	1	72.62 	2950097	894187	2	72.62 	3175798	107197	1	72.62 	3175798	834185	1	72.62 	3175798	894187	2	72.62 	2797416	574145	2	72.6 	2797416	920171	1	72.6 	1048148	920171	2	72.39 	1464254	920171	2	72.39 	1630937	920171	2	72.39 	2983098	748169	2	71.98 	3145355	748169	2	71.98 	317305	568164	1	70.21 	317305	748169	1	70.21 	1069585	568164	1	70.21 	1069585	748169	1	70.21 	1192834	568164	1	70.21 	1192834	748169	1	70.21 	2746139	748169	2	70 	1437532	748169	1	69.51 	1437532	920171	1	69.51 	1057390	568164	1	67.06 	1057390	801113	1	67.06 	1057390	873139	2	67.06 	914042	748169	2	66.62 	1628730	748169	2	66.62 	2409267	239192	1	66 	2409267	473199	2	66 	666068	107197	1	65.23 	666068	574145	1	65.23 	666068	894187	1	65.23 	3205975	142184	3	64.21 	3205975	748169	1	64.21 	2910647	473199	2	63.39 	2910647	748169	1	63.39 	1860091	239192	1	63 	1860091	473199	1	63 	2136845	568164	1	63 	2136845	748169	1	63 	2386066	239192	1	62 	2386066	473199	1	62 	2687896	138179	4	62 	2687896	139184	4	62 	2687896	920171	1	62 	1390599	568164	1	61.17 	1390599	920171	1	61.17 	2837851	473199	1	59.47 	2837851	748169	1	59.47 	305213	568164	2	58.41 	273549	568164	1	58.29 	273549	748169	1	58.29 	980317	568164	1	58.29 	980317	748169	1	58.29 	1181844	568164	1	58.29 	1181844	748169	1	58.29 	1329847	568164	1	58.29 	1329847	748169	1	58.29 	1023041	473199	1	57.93 	1023041	920171	1	57.93 	3069270	107197	1	57.77 	3069270	894187	2	57.77 	927576	568164	3	57.32 	3020307	748169	1	56.01 	3020307	6239990	1	56.01 	321648	473199	1	55.04 	321648	748169	1	55.04 	2147739	568164	2	54 	1579429	239192	2	53.83 	1770619	473199	1	53 	1770619	497138	1	53 	2688056	568164	2	53 	982594	142184	5	52.95 	982594	920171	1	52.95 	2410115	920171	1	52 	2467490	920171	1	52 	914551	779191	2	50.59 	3070643	920171	1	49.55 	1826739	473199	2	48 	1895855	473199	2	48 	2136989	891630	1	48 	2294380	891630	1	47 	411739	920171	1	45.85 	859364	920171	1	45.85 	926043	920171	1	45.85 	936643	920171	1	45.85 	1004943	920171	1	45.85 	1630333	920171	1	45.85 	2203410	748169	1	45 	2861827	748169	1	44.3 	2972548	748169	1	44.3 	3019329	748169	1	44.3 	3047476	748169	1	44.3 	3131603	748169	1	44.3 	2279246	748169	1	44 	2454022	748169	1	44 	2320625	748169	1	43 	714711	438200	2	42.67 	1986146	920171	1	42 	338570	748169	1	41 	895191	748169	1	41 	1073453	748169	1	41 	1078953	748169	1	41 	1286482	748169	1	41 	1329842	748169	1	41 	1426432	748169	1	41 	1436891	748169	1	41 	1498430	748169	1	41 	1640092	748169	1	41 	1640131	748169	1	41 	1994335	107197	1	41 	2294352	920171	1	41 	283848	438200	2	40.18 	2970606	107197	1	40.07 	3205132	107197	1	40.07 	2598023	920171	1	40 	2360327	239192	1	39 	508888	107197	1	37.09 	1092661	107197	1	37.09 	187105	920171	1	36.2 	388595	920171	1	36.2 	619744	920171	1	36.2 	846964	920171	1	36.2 	881235	920171	1	36.2 	1404281	920171	1	36.2 	1476552	920171	1	36.2 	3019932	720200	1	36.2 	3019932	924199	1	36.2 	2148851	748169	1	36 	2278334	748169	1	36 	2293245	748169	1	36 	2971122	748169	1	35.99 	1343038	748169	1	33.31 	1755141	748169	1	33.31 	1181401	107197	1	31.73 	1618910	107197	1	31.73 	2771265	568164	1	31.55 	2785450	568164	1	31.55 	2675072	568164	1	31 	436136	568164	1	29.2 	1215699	568164	1	29.2 	2924248	138179	15	29.01 	2714890	497138	1	29 	3047409	568164	1	26.98 	3203089	107197	1	25.86 	1003748	473199	1	25.3 	777152	568164	1	24.98 	2409466	138179	10	22 	654479	473199	1	21.73 	198576	438200	1	21.33 	153777	438200	1	20.09

Prince · Accepted Answer

Pivot
	Row Labels	Min of Ship Cost Per item	Max of Ship Cost Per item	Average of Ship Cost Per item
	107197	25.86	200.21	84.12		Analysis
	138179	1.93	51.75	23.20
	139184	14.94	51.75	27.88		Based on our analysis, it seems that the cost per item for parcel shipping is highly variable and depends on the quantity of each item shipped in a given shipment. Specifically, the minimum cost per item of 1.93 was observed for item 138179, while the maximum cost per item of 244.76 was observed for item 239192. On average, the cost per item was estimated to be 72.74. 
This variability in cost could be due to differences in shipping carriers, packaging materials, and handling fees. Additionally, since the shipping costs were determined at the shipment level an estimation has to be made to determine the cost of each item for those shipments containing multiple items. This inherent uncertainty in our analysis should be taken into account when making predictions about future shipping costs. 
In order to accurately determine the cost saving from opening a warehouse in Agana, it will be necessary to consider other factors such as the cost of warehousing and the cost of bulk shipping. With all relevant costs taken into account, a more precise analysis can be conducted to accurately evaluate the potential cost savings. 
	141184	38.05	38.05	38.05
	142184	10.59	51.75	24.10
	235200	42.52	195.54	123.88
	239192	26.92	244.76	102.41
	250183	137.45	137.45	137.45
	251350	7.92	17.70	12.81
	337131	114.65	181.00	142.02
	340141	83.43	83.43	83.43
	438200	20.09	178.44	71.83
	473199	21.73	129.00	54.07
	481790	114.65	119.28	116.96
	497138	29.00	228.00	120.23
	568164	19.11	177.86	64.99
	574145	11.93	114.65	54.12
	689162	21.72	89.54	57.76
	720200	36.20	36.20	36.20
	748169	23.86	238.55	71.80
	779191	10.65	74.68	36.88
	801113	67.06	67.06	67.06
	834185	26.73	180.00	93.02
	873139	5.38	72.00	28.92
	891630	47.00	205.00	120.08
	894187	15.44	142.90	57.64
	904203	79.00	195.54	139.94
	920171	36.20	219.36	89.21
	924199	36.20	36.20	36.20
	927139	130.40	130.40	130.40
	941190	180.00	180.00	180.00
	941920	177.00	177.00	177.00
	968190	105.42	105.42	105.42
	3072990	93.85	93.85	93.85
	6239990	56.01	175.84	102.32
	Grand Total	1.93	244.76	72.74
Data
	Order Number	Item Number	Quantity	ShipCost	Ship Cost Per item
	655791	689162	4	248.06	62.02
	655791	748169	4	248.06	62.02
	3219625	920171	5	247.73	49.55
	527474	239192	1	244.76	244.76
	527474	473199	7	244.76	34.97
	527474	748169	4	244.76	61.19
	3235609	568164	2	240.17	120.09
	3235609	748169	3	240.17	80.06
	3235609	920171	2	240.17	120.09
	3008067	574145	20	238.62	11.93
	3008067	873139	40	238.62	5.97
	3071589	574145	20	238.62	11.93
	3071589	873139	40	238.62	5.97
	3130648	748169	10	238.62	23.86
	3204811	574145	20	238.62	11.93
	3204811	873139	40	238.62	5.97
	3011468	481790	2	238.55	119.28
	3011468	568164	4	238.55	59.64
	3011468	748169	1	238.55	238.55
	3011468	920171	2	238.55	119.28
	389843	473199	5	237.91	47.58
	389843	748169	4	237.91	59.48
	389843	920171	2	237.91	118.96
	1125282	107197	2	232.02	116.01
	1125282	142184	20	232.02	11.60
	1125282	568164	4	232.02	58.01
	1125282	834185	2	232.02	116.01
	1125282	894187	2	232.02	116.01
	1752724	239192	4	231.72	57.93
	1752724	473199	4	231.72	57.93
	609553	481790	2	229.29	114.65
	609553	107197	2	229.29	114.65
	609553	337131	2	229.29	114.65
	609553	574145	2	229.29	114.65
	609553	894187	8	229.29	28.66
	609553	920171	3	229.29	76.43
	1824673	497138	1	228.00	228.00
	1824673	568164	2	228.00	114.00
	1824673	748169	4	228.00	57.00
	3131250	568164	3	227.56	75.85
	3131250	748169	3	227.56	75.85
	1477115	748169	6	221.60	36.93
	1477115	873139	6	221.60	36.93
	2610044	239192	1	220.14	220.14
	2610044	473199	3	220.14	73.38
	2610044	748169	2	220.14	110.07
	1125121	568164	6	219.36	36.56
	1125121	748169	1	219.36	219.36
	1125121	920171	1	219.36	219.36
	1330541	239192	1	215.47	215.47
	1330541	568164	3	215.47	71.82
	1330541	748169	2	215.47	107.74
	2873698	107197	4	215.00	53.75
	2873698	873139	40	215.00	5.38
	3221108	107197	4	213.81	53.45
	3221108	834185	8	213.81	26.73
	3221108	894187	8	213.81	26.73
	1480389	779191	20	213.00	10.65
	1691885	748169	4	209.87	52.47
	1691885	920171	1	209.87	209.87
	2082053	920171	4	209.00	52.25
	2385723	239192	1	207.00	207.00
	2385723	473199	4	207.00	51.75
	2385723	748169	1	207.00	207.00
	2385723	920171	1	207.00	207.00
	2385679	920171	4	206.00	51.50
	1570966	748169	5	205.02	41.00
	2278608	568164	2	205.00	102.50
	2278608	748169	2	205.00	102.50
	2278608	920171	2	205.00	102.50
	2691061	891630	1	205.00	205.00
	2691061	239192	2	205.00	102.50
	2691061	473199	5	205.00	41.00
	2691061	748169	1	205.00	205.00
	187663	748169	5	202.75	40.55
	187663	920171	1	202.75	202.75
	2772665	473199	4	201.92	50.48
	2772665	748169	3	201.92	67.31
	3046385	473199	4	201.92	50.48
	3046385	748169	3	201.92	67.31
	3131145	473199	4	201.92	50.48
	3131145	748169	3	201.92	67.31
	2995532	107197	1	200.21	200.21
	2995532	473199	4	200.21	50.05
	2995532	748169	2	200.21	100.11
	668357	748169	6	199.87	33.31
	1621080	748169	6	199.87	33.31
	2687898	891630	1	199.00	199.00
	2687898	568164	2	199.00	99.50
	2687898	748169	2	199.00	99.50
	2687898	920171	1	199.00	199.00
	1967843	251350	25	198.00	7.92
	1967843	748169	3	198.00	66.00
	1967843	873139	4	198.00	49.50
	2279164	473199	4	198.00	49.50
	2279164	748169	3	198.00	66.00
	3008185	920171	5	195.57	39.11
	1193625	107197	1	195.54	195.54
	1193625	235200	1	195.54	195.54
	1193625	568164	3	195.54	65.18
	1193625	748169	1	195.54	195.54
	1193625	894187	2	195.54	97.77
	1193625	904203	1	195.54	195.54
	1125698	473199	4	195.53	48.88
	1125698	920171	3	195.53	65.18
	390351	568164	5	194.38	38.88
	390351	748169	1	194.38	194.38
	390351	920171	1	194.38	194.38
	187424	748169	5	191.53	38.31
	187424	873139	8	191.53	23.94
	1897407	568164	3	190.00	63.33
	1897407	748169	3	190.00	63.33
	2838992	107197	3	189.66	63.22
	2838992	834185	3	189.66	63.22
	2838992	894187	5	189.66	37.93
	458978	568164	2	188.97	94.49
	458978	748169	2	188.97	94.49
	458978	920171	2	188.97	94.49
	1264818	568164	2	186.08	93.04
	1264818	748169	3	186.08	62.03
	1264818	920171	1	186.08	186.08
	2924060	568164	3	183.26	61.09
	2924060	748169	2	183.26	91.63
	2478638	748169	3	182.00	60.67
	2478638	920171	1	182.00	182.00
	2688637	239192	2	182.00	91.00
	2688637	748169	2	182.00	91.00
	318015	107197	1	181.58	181.58
	318015	568164	6	181.58	30.26
	1438340	568164	2	181.42	90.71
	1438340	748169	3	181.42	60.47
	1995408	337131	1	181.00	181.00
	1995408	497138	1	181.00	181.00
	1995408	568164	2	181.00	90.50
	1995408	748169	2	181.00	90.50
	1125212	920171	5	180.99	36.20
	1693103	920171	5	180.99	36.20
	3070110	107197	2	180.96	90.48
	3070110	574145	3	180.96	60.32
	3070110	834185	2	180.96	90.48
	3070110	873139	4	180.96	45.24
	3070110	894187	2	180.96	90.48
	2585218	748169	3	180.00	60.00
	2585218	920171	1	180.00	180.00
	2719144	107197	1	180.00	180.

Shipping CostsYour company has several distributors in Guam that service all of your customers on the island. You have been shipping items in parcel shipments based on the requisitions from the...

Answer To: Shipping CostsYour company has several distributors in Guam that service all of your customers on...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment

Sun	Mon	Tue	Wed	Thu	Fri	Sat
30	31	1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	1	2	3