The following is the problem description and the excel file that has already been solved using Solver. I only need help outputting 12 months using SolverTable.

You are in charge of the purchasing department for an e-commerce company. Your job is to minimize the inventory-related costs of purchasing products. This exercise will track your performance for one of the products. The inventory-related costs include inventory ordering costs (per order), inventory holding costs (per unit of inventory/day), and backlog costs (extra processing, lost customers, lost goodwill). Below are the parameters for the exercise.

1. Each day you have orders (demand) from your customers that historically vary according to a approximately normal distribution with a mean of 20 and a variance of 9 (standard deviation = 3).

2. Each day you may choose to order any quantity of the product from a supplier for arrival the next day. Each time you order a processing cost of $40 must be paid.

3. Each day you try to fulfill the customer orders (and any backlogs). The following costs are assessed at the end of each day.

   • Each unit left in inventory costs $2 to handle (storing, moving, interest, etc.)

   • Each customer left unsatisfied costs you $6 (extra processing, lost customers, lost

     goodwill).

4. Your goal is to maximize the amount of money left in your monthly $5,000 budget for

   inventory-related expenses.

Please help me solve the following questions using SolverTable.

Use the SolverTable to simulate twelve months of results. You will need to use a dummy data cell for the SolverTable input. The outputs should include the order quantities, reorder points, and monthly budget surplus. Based on the results what order quantity and reorder point would you suggest adopting? Justify your answer. Based on the results what part of the purchasing budget for inventory-related costs is excessive? Justify your answer.

Q R S = U T V 1 $ 7 Q RoP 7 25 Upper Bound for Multistart