Please solve using excel showing each step done in excel.

THANK YOU!

A soft drink bottler wants to prepare an aggregate plan for the next 6 weeks. Demand can be met using regular time production, overtime production, or a combination of both as illustrated below: Assume that beginning inventory is zero. Use Excel to formulate and solve this multiperiod production problem to minimize total costs. Set this problem up in an Excel spreadsheet in a well-organized manner. Use formulae that rely on cell references. Clearly label your input parameters, decision variable (or changing cells), constraints (both left-and right-hand sides), and objective function. Use Solver within Excel to solve the