Using data in the attached Option 1 Excel file : 1. Calculate the EOQ for wood pellets. 2. Calculate the number of orders that will be placed each year. 3. Calculate the reorder point for wood pellets. Follow the instructions you see on the Data tab of the worksheet. Show all calculations within the cells of the Excel spreadsheet. This means that you must use formulas and links so that your thought process can be examined. Sims Hardware sells wood pellets used in heating stoves and slow-cook grills. The supplier for the pellets pays all incoming freight. Following is detailed data collected regarding pellet inventory needs: The purchasing lead time is three weeks. Sims Hardware is open 240 days a year ( 48 weeks for 5 days a week). Carrying cost : Economic Order Quantity: Orders per year Demand Each Working Day Demand per week Reorder point per bag per year bags orders bags bags bags