Not: Please solve this question by explaining in the excel, thanks.

Q2) The time-phased net requirements over the next 6 weeks, the setup cost and the holding cost per unit of a product per week are given in the tables below. You may assume 52 weeks per year. 1 2 3 4 5 6 Week Time Phased Net Requirements 275 240 225 350 264 225 Setup cost Holding cost 250 0.2 a) Determine the lot sizes using the Silver-Meal heuristic. Calculate the holding and setup costs. Make it in excel according to the table below. Period Demand On hand inventory Planned Order Receipts Planned Order Releases Q2) The time-phased net requirements over the next 6 weeks, the setup cost and the holding cost per unit of a product per week are given in the tables below. You may assume 52 weeks per year. 1 2 3 4 5 6 Week Time Phased Net Requirements 275 240 225 350 264 225 Setup cost Holding cost 250 0.2 a) Determine the lot sizes using the Silver-Meal heuristic. Calculate the holding and setup costs. Make it in excel according to the table below. Period Demand On hand inventory Planned Order Receipts Planned Order Releases