Question: prepare a 3-month simulation that includes costs that occurred during ( mathrm{T} 0, mathrm{~T} 1, mathrm{~T} 2 ), and ( mathrm{T} 3 ). Please start


prepare a 3-month simulation that includes costs that occurred during \\( \\mathrm{T} 0, \\mathrm{~T} 1, \\mathrm{~T} 2 \\), and \\( \\mathrm{T} 3 \\). Please start the costs on day 1 , the cost of the purchasing goods in T0, then track the costs during the 3 months. The unit cost at T0 will change at T1, T2, and T3; we want you to simulate these changes. Plan the shipments according to daily units sold. Below, you can find the related information. Simulation for 3 Months *Inventory movement of the goods purchased in the warehouse Show the inbound of the goods purchased. After monthly shipments, show the beginning and ending inventory and unit costs of the remaining units *Cost of goods received and sold through Amazon After monthly shipments, calculate the cost of units being shipped each month Costs will be distributed with respect to product volumes. Please prepare tables to show those asked above. \\begin{tabular}{|l|r|} \\hline SKU & \\multicolumn{1}{|l|}{ COGS } \\\\ \\hline 300 & \\( \\$ 2,23 \\) \\\\ \\hline 600 & \\( \\$ 5,91 \\) \\\\ \\hline 1200 & \\( \\$ 8,25 \\) \\\\ \\hline \\end{tabular} \\begin{tabular}{|lr|} \\hline Unit Purchase \\\\ \\hline & 9000 \\\\ \\hline & 6000 \\\\ \\hline & 7500 \\\\ \\hline \\end{tabular} \\begin{tabular}{|l|r|l|r|} \\hline \\multicolumn{5}{|c|}{ Assumptions } \\\\ \\hline US - Daily Units Sold & & Container Cost (TR-US 3PL) & \\\\ \\hline 300 & 70 & Freight & \\( \\$ 6.000 \\) \\\\ \\hline 600 & 24 & Tax & \3,50 \\\\ \\hline 1200 & 55 & Clearence & \\( \\$ 150 \\) \\\\ \\hline CA - Daily Units Sold & & Partial Shipment Cost / Pallet & \\\\ \\hline 300 & 55 & Pallet - US & \\( \\$ 180 \\) \\\\ \\hline 600 & 15 & Pallet - CA & \\( \\$ 900 \\) \\\\ \\hline 1200 & 40 & Storage Fee / Month & \\( \\$ 1.000 \\) \\\\ \\hline Product Volumes (cm3) & & Transit Times & \\\\ \\hline 300 & 1921,3 & US & 7 days \\\\ \\hline 600 & 3667,6 & CA & 14 days \\\\ \\hline 1200 & 6600 & Inventory Levels & \\\\ \\hline Unit / case & & US & 2000 \\\\ \\hline 300 & 48 & CA & \\\\ \\hline 600 & 24 & \\#of cases in a pallet: 24 & \\\\ \\hline 1200 & 12 & \\#of pallet in a container: 21 & \\\\ \\hline \\end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
