Question: prepare a 3-month simulation that includes costs that occurred during T0, T1, T2, and T3. Please start the costs on day 1, the cost of
prepare a 3-month simulation that includes costs that occurred during T0, T1, T2, and T3. 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.
SKUCOGS Unit Purchase 300$2,23 9000 600$5,91 6000 1200$8,25 7500 AssumptionsUS - Daily Units Sold Container Cost (TR-US 3PL) 30070 Freight$6.00060024 Tax 3,50%120055 Clearence$150CA - Daily Units Sold Partial Shipment Cost / Pallet 30055 Pallet - US$18060015 Pallet - CA$900120040 Storage Fee / Month$1.000Product Volumes (cm3) Transit Times 3001921,3 US7 days6003667,6 CA14 days12006600 Inventory Levels Unit / case US200030048 CA150060024 #of cases in a pallet: 24 120012 #of pallet in a container: 21
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
