Can you solve this problem in excel pls, i dont know which formula that i will use in EOQ ( net requirements, planned order reciepts) and POQ ( net requirements and planned order reciepts )

Exercise 6: Files and More, Inc. (F&M), a manufacturer of office equipment, uses MRP to schedule its production. Because of the current recession and the need to cut costs, F&M has targeted inventory as a prime area for cost reduction. However, the company does not want to reduce its customer service level in the process. Demand and inventory data for a two-drawer file cabinet are given in the following table. Complete an MRP matrix for the file cabinet using: (a) L4L (b) EOQ (C) POQ lot sizing Which lot-sizing rule do you recommend? Period Demand 1 20 2 40 3 30 4 10 5 45 Lead time = 1 period Holding cost = $1 per cabinet per period Ordering cost = $100 per order Beginning inventory - 25