Please show Formula steps in excel

17. The time-phased net requirements for the base assembly in a table lamp over the next six weeks are The setup cost for the construction of the base assembly is $200, and the holding cost is $0.30 per assembly per week. a. What lot sizing do you obtain from the EOQ formula? b. Determine the lot sizes using the Silver-Meal heuristic. c. Determine the lot sizes using the least unit cost heuristic. d. Determine the lot sizes using part period balancing. e. Compare the holding and setup costs obtained over the six periods using the policies found in parts (a) through (d) with the cost of a lot-for-lot policy. 17. The time-phased net requirements for the base assembly in a table lamp over the next six weeks are The setup cost for the construction of the base assembly is $200, and the holding cost is $0.30 per assembly per week. a. What lot sizing do you obtain from the EOQ formula? b. Determine the lot sizes using the Silver-Meal heuristic. c. Determine the lot sizes using the least unit cost heuristic. d. Determine the lot sizes using part period balancing. e. Compare the holding and setup costs obtained over the six periods using the policies found in parts (a) through (d) with the cost of a lot-for-lot policy