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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!