Assignment 3: Warehouse, Transportation & Journal Entry (5%)Module 6: Warehouse ManagementQuestion 1: (2 marks)Suppose a warehouse at Regina is being considered to lower transportation costs. Shipments currently are made directly from the manufacturer's inventory in Montreal to retail stores in four cities and the demand at four cities is given. There is a $5/cwt 91cwt = 100 lbs handling charge at a third-party warehouse if used. Inbound transportation rate from Montreal to Regina is $25/cwt. The transport rates under direct shipment and warehouse to retailer shipment options are given in the tables below. What strategy between warehousing and direct shipment would you recommend?DIRECT SHIPMENTMFRRetailerVOLUME (cwt)Transport rate ($/cwtMontrealBrandon150 $ 16.00 MontrealMadison Hat200 $ 20.00 MontrealKelowna100 $ 50.00 MontrealAbbotsford250 $ 65.00 WHSRetailerVOLUME (cwt)Transport rate ($/cwtReginaBrandon150 $ 8.00 ReginaMadison Hat200 $ 5.00 ReginaKelowna100 $ 15.00 ReginaAbbotsford250 $ 20.00 Question 2: (1 mark)A beverage distribution in lower mainland BC has an annual throughput of 5,000,000 bottles. The warehouse is open 300 days in a year and 8 hours a day. Since a constant turn-over-ratio is maintained in the warehouse, the daily amount entering or leaving the warehouse is about the same. The average truckload quantity is approximately 1000 for inbound trucks and 1200 for outbound shipments. It takes about 3.5 hour to off-load a truck into the warehouse and 4.0 hours to up-load one from the warehouse. How many loading and unloading bays are needed in this warehouse to support the daily activity level?Module 7: Transportation ManagementQuestion 3: (2 marks)A portion of the agricultural supply chain has three current suppliers who ship to three warehouses. The supplies at three suppliers and demands at three warehouses, along with the unit transportation costs between each pair of supplier and warehouses are given. Balance the transportation problem and use least cost method to solve it. Find the total cost of the suggested distribution plan.DestinationsOriginsWHS 1WHS 2WHS 3 3SupplySupplier A $ 4.00 $ 6.00 $ 7.00 4000Supplier B $ 5.00 $ 2.00 $ 1.00 6000Supplier C $ 8.00 $ 3.00 $ 9.00 4000Demand ->600050005000pls i need the answer to be correct and well detailed thanks

Module 6: Warehouse Management Question 1: (2 marks) Suppose a warehouse at Regina is being considered to lower transportation costs. Shipments currently are made directly from the manufacturer's inventory in Montreal to retail stores in four cities and the demand at four cities is given. There is a $5fcwt 91cwt = 100 lbs handling charge at a third-party warehouse if used. Inbound transportation rate from Montreal to Regina is $25/cwt. The transport rates under direct shipment and warehouse to retailer shipment options are given in the tables below. What strategy between warehousing and direct shipment would you recommend? DIRECT SHIPMENT VOLUME Transport rate MFR Retailer (cwt) ($/cwt S Montreal Brandon 150 16.00 3 Montreal Madison Hat 200 20.00 3 Montreal Kelowna 100 50.00 Montreal Abbotstord 250 $ 65.00 VOLUME Transport rate WHS Retailer (cwt) ($lcwt Madison Hat $ Regina Kelowna 100 15.00 3 Regina Abbotsford 250 20.00 Question 2: (1 mark) A beverage distribution in lower mainland BC has an annual throughput of 5,000,000 bottles. The warehouse is open 300 days in a year and 8 hours a day. Since a constant turn-over-ratio is maintained in the warehouse, the daily amount entering or leaving the warehouse is about the same. The average truckload quantity is approximately 1000 for inbound trucks and 1200 for outbound shipments. It takes about 3.5 hour to off-load a truck into the warehouse and 4.0 hours to up-Ioad one from the warehouse. How many loading and unloading bays are needed in this warehouse to support the daily activity level