Please show how to do it on excel and the formulas used on excel also.

Use a Level strategy and develop an aggregate plan using inventories and backorders. Test and evaluate the plan. The data is tabulated below. If the number of employees required is fractional, always round up (ceiling). Suppose the number of units produced per employee per period is fractional, always round down. Answer the following questions. a. total cost incurred. b. cost per unit c. number of workers hired. d. number of workers fired e., inventory units f., backorder units