Using the Excel Simplex Linear solver optimize the total costs based on the information provided below.

A manufacturer of motorcycle accessories sells wants to optimize the production schedule for its bestselling motorcycle stand. Relevant inputs for the six-month planning horizon are in the file attached below. 2% of each month's new sales (= anticipated new sales) will be returned for a refund (for a reason other than defect). Assume that these returns will happen in the following month, and that in the month after that (allowing time for inspection), the product can be sold as an \"open-box\" product. The company assesses holding costs on all items held in stock from month-to-month. This also applies to returns. The cost of holding products is always based on the current month's production cost, even if some ofthe products being held are returns from the previous month. The company assigns 5% of monthly production cost to each item held in inventory between months. All demand from anticipated sales must be met on time and production capacity cannot be exceeded. Configure and run Solver to find a production schedule that optimizes total costs. Problem 2: Production Planning