please answer question and fill in excel sheet

Question 1: Harley Davidson Input Demand, D Fixed cost per order, S- Cost per engine, C = Holding cost, 109,500 (assuming 365 operating days) 1,000 500 Harley Davidson has its engine assembly plant in Milwaukee and its motorcycle assembly 2024 plant in Pennsylvania, Engines are transported between the two plants using trucks. Each truck trip costs $1,000. The motorcycle plant assembles and sells 300 motorcycles each day (109,500 annual demand). Each engine costs $500 and Harley incurs a holding cost of 20 percent per year. How many engines should Harley load onto each truck? What is the cycle inventory of engines at Harley? Output E0Q # of orders per year Annual order cost Cycle inventory (units) Cycle inventory (value) Annual holding cost Total inventory.cost