The Bee Sweet Honey Company now has two warehouses they are utilizing the supply the Canadian market. One warehouse is located in Ontario and the other located in Edmonton. The full truckload cost to each of the warehouse (from the Vancouver plant) are $0.45/b. and $0.27/1b, respectively, with the following information, calculate the gross requirements, projected available, and planned order releases from both the Ontario and Edmonton warehouses Calculate the same information for the Vancouver production facility Ontario Warehouse Transit time: 2 weeks Order quantity: 100 units Week 1 2 3 4 5 Forecast 105 105 145 110 130 Intransit 200 Projected available 95 Planvied order release Activate Windows Edmonton Warehouse Transit time: 1 week Order quantity: 200 units Week 1 2 3 4 5 Forecast 120 110 115 100 105 in transit 200 Projected available 75 Planned order release Vancouver Production Facility Lead time: 1 weeks Order quantity 500 units Week 2 3 5 Forecast Scheduled receipts Projected available 400 Planned order release The Bee Sweet Honey Company now has two warehouses they are utilizing the supply the Canadian market. One warehouse is located in Ontario and the other located in Edmonton. The full truckload cost to each of the warehouse (from the Vancouver plant) are $0.45/b. and $0.27/1b, respectively, with the following information, calculate the gross requirements, projected available, and planned order releases from both the Ontario and Edmonton warehouses Calculate the same information for the Vancouver production facility Ontario Warehouse Transit time: 2 weeks Order quantity: 100 units Week 1 2 3 4 5 Forecast 105 105 145 110 130 Intransit 200 Projected available 95 Planvied order release Activate Windows Edmonton Warehouse Transit time: 1 week Order quantity: 200 units Week 1 2 3 4 5 Forecast 120 110 115 100 105 in transit 200 Projected available 75 Planned order release Vancouver Production Facility Lead time: 1 weeks Order quantity 500 units Week 2 3 5 Forecast Scheduled receipts Projected available 400 Planned order release