I need the following problem solved along with steps using Solver on Excel

Morgan Inc. is planning to purchase one of the component parts it needs for its finished product. The anticipated demands for the component for the next 12 periods are shown in the enclosed Excel table. The cost to order the component (labor, shipping, and paperwork) is $150. The cost to hold these components in inventory is $1 per component per period. The price of the component is expected to remain stable at $12 per unit for the next 12 periods, and no quantity discounts are available. The maximum order size is 1,000 units. A. Formulate a model to minimize the total cost of satisfying Morgan Inc.'s demand for this component. B. Solve the model formulated in part A. What is the optimal cost? How many orders are placed? Morgan Inc. is planning to purchase one of the component parts it needs for its finished product. The anticipated demands for the component for the next 12 periods are shown in the enclosed Excel table. The cost to order the component (labor, shipping, and paperwork) is $150. The cost to hold these components in inventory is $1 per component per period. The price of the component is expected to remain stable at $12 per unit for the next 12 periods, and no quantity discounts are available. The maximum order size is 1,000 units. A. Formulate a model to minimize the total cost of satisfying Morgan Inc.'s demand for this component. B. Solve the model formulated in part A. What is the optimal cost? How many orders are placed