4 Develop a solution and calculate total relevant costs for the gross requirements in the following table" Period 1 2 3 5 5 7 8 9 10 11 12 Gross requirements 30 10 30 30 30 1040 50 "Holding cost - 5150/unitweek setup cost-$150 lead time 1 week beginning invertory -40 What is the average demand per week enter your response with 2 decimal places Calculate Economic Order Quantity (E007(enter your responds wholm Develop a EOQ solution for your responses as whole numbers) 2 4 1 30 3 40 5 6 7 8 30 30 30 9 10 11 12 1040 50 Period Gross requirements Scheduled roce Projected On hand Not Requirements Planned Ordericit 40 Nel Requirements Planned Oder reci Paned Order Sato cost 12 w (enter your own as a wholm Carrying cost for 12 weeks www your responde ao e who runde) The total cost is your home Develop a solution and calculate total relevant costs for the gross requirements in the following table Period 1 2 3 4 5 6 7 8 9 10 11 12 Gros requirements 30 30 30 30 20 20 40 50 Holding co$2.50/unit week setup cost $200 load time week beginning inventory 40 What is the average domander Wok your responses with 2 cm placea) Calculate Economic Order Quamvity FOO) your reson a whole number Calculate the number of penods for POC enter your responses a whole number Develop a POQ solution (enter your responses as whole numbers) 1 IN 4 8 3 30 5 6 7 30 30 20 9 10 11 12 20 40 50 30 Period Gross requirements Scheduled receipt Projected On-hand Not Requirements Planned Order receipt Planned Order release 40 Net Requirements Planned Order receipt Planned Order release setup cont for 12 work in order your responde as a whole number Carrying cost for 12 wool is enter your response as a whole nom The total costs center your raponte se a whole number 4 Develop a solution and calculate total relevant costs for the gross requirements in the following table" Period 1 2 3 5 5 7 8 9 10 11 12 Gross requirements 30 10 30 30 30 1040 50 "Holding cost - 5150/unitweek setup cost-$150 lead time 1 week beginning invertory -40 What is the average demand per week enter your response with 2 decimal places Calculate Economic Order Quantity (E007(enter your responds wholm Develop a EOQ solution for your responses as whole numbers) 2 4 1 30 3 40 5 6 7 8 30 30 30 9 10 11 12 1040 50 Period Gross requirements Scheduled roce Projected On hand Not Requirements Planned Ordericit 40 Nel Requirements Planned Oder reci Paned Order Sato cost 12 w (enter your own as a wholm Carrying cost for 12 weeks www your responde ao e who runde) The total cost is your home Develop a solution and calculate total relevant costs for the gross requirements in the following table Period 1 2 3 4 5 6 7 8 9 10 11 12 Gros requirements 30 30 30 30 20 20 40 50 Holding co$2.50/unit week setup cost $200 load time week beginning inventory 40 What is the average domander Wok your responses with 2 cm placea) Calculate Economic Order Quamvity FOO) your reson a whole number Calculate the number of penods for POC enter your responses a whole number Develop a POQ solution (enter your responses as whole numbers) 1 IN 4 8 3 30 5 6 7 30 30 20 9 10 11 12 20 40 50 30 Period Gross requirements Scheduled receipt Projected On-hand Not Requirements Planned Order receipt Planned Order release 40 Net Requirements Planned Order receipt Planned Order release setup cont for 12 work in order your responde as a whole number Carrying cost for 12 wool is enter your response as a whole nom The total costs center your raponte se a whole number