please develop your answers using EXCEL

Problem-2) (Push Inventory) An importer of television sets from the Far East distributes them throughout the European Union from four warehouses. Shipments are received monthly, and this month's shipment is 120,000 sets. Due to the long lead time, demand and supply for the sets are hard to match. Therefore, an allocation to the warehouses is based on a monthly demand forecast and the service level for each warehouse. The inventory records and forecast for the coming month show the following situation: Forecast error, Quantity on hand, sets Demand forecast, sets Warehouse sets Service level 1 700 10,000 1,000 90% 2 0 15,000 1,200 85 3 2,500 35,000 2,000 88 4 1,800 25,000 3,000 92 If transportation to the warehouses takes one week and import handling requires one week after a shipment arrives, how should the allocation of the sets be made to the warehouses? Let's assume that this company allocate the excess inventory based on the net requirements for all warehouses. Hint) Total requirements = Forecast + z*Forecast Error Service level 0.92 0.90 0.88 0.85 Z 1.41 1.28 1.18 1.04