solution

This assignment we will explore the issue of trade-offs with mode of transport, transportation costs andshipment availability. We are working for the supply chain for wheat flour producing company. Happy Wheat Cereal is currently operating two packaging plants, located on in Calgary and second in Toronto. Students will only need to look at one movement, and only one segment of the supply chain: between the mill and the two packaging plants.The flourmill produces 500,000 metric tons offlour per year and produces flour at a steady pace.70% of the flour is shipped to commercial bakeries and food processors. This part of the supply chain is not examined in this exercise.The remaining 30% of the flour is destined for the retail market, and is shipped by the mill to the Happy Wheat Cereal packaging plants. Two-thirds of the shipments go to the Calgary plant, and one-third goes to Toronto.The shipment from the mill to the packaging centres is done in bulk, by rail. Each rail car holds 80 tonnes of flour.With the current ordering process ordering single car loads and the possible cost savings, Happy Wheat Cereal’s supply and purchasing manager are interested in understanding the total cost transportation if they decided to order in lot sizes of:a) once a year b) twice a year or c) three times a year.If the mill decides to ship flour in multiple car shipments, and if the shipments have to be unloaded within 12 hours after arrival, it will have to build bulk storage facilities, and will have to absorb the carrying costs of that inventory. With these costs factored in, the annual carrying cost of the flour will be 25% of the value of product. •The wholesale value of the flour is $350 per tonne•Lead time is 20 daysbetween orders and delivery•Happy Wheat Cereal is forecasting the demand 200,000 (Note: you need to figure out the distribution for Toronto and Calgary Plants) •Happy Wheat Cereal’s annual carrying costs is at 25%the value of the product•Happy Wheat Cereal has also calculated there variable order cost to be $500per orderGeneral RefUnitKilogramsPick up NotificationShip TimeLTL1 Case802hrs5 daysLTL2Pallets2,0001 day10 daysLTL4 Pallets4,0001 day10 daysTL10 Pallets10,0001 day10 daysRailSingle Car80 5 day5 daysRail25 Cars2,00010 day10 daysRail50 Cars4,00017 days10 daysRail100 Cars8,0003 weeks10 daysInstructions:1.Calculate the dimensional weight of the items below.(2 marks)2.Calculate the chargeable weight of the items below and apply the appropriate rate.(2 marks)3.List the total charge for each method of shipment.(2 marks)4.Calculate the savings per metric tonne with multi-car shipments(4 marks)5.How many times per year will Happy Wheat Cereal place an order of size Q”? Calgary? Toronto?(4)6.Using the data from the EOQ formula, what quantity provides the most efficient delivery? Calgary? Toronto?(4)7.Taking a look at Holding vs Ordering inventory, what are a few learning points from this activity? (2)