please solve the question!!!

If you need additional information, can you comment on what information is needed?

QUESTION IV. The sales amounts of the five products sold by a company for the past three years are given in the table below on the basis of periods. Since historical sales values fluctuate seasonally, find the sales forecast values for each product for the fourth year using regression analysis, ratio on trend technique-1 and ratio on trend technique- 2 . Table. Realized sales quantities (pieces) To prepare the main production plan for the fourth year, write the linear decision model that will minimize the total cost, taking into account the information below. Consider the sales forecast values found by using regression analysis and trend ratio techniques as the demand amount of each month for the fourth year. Two different models will be written for two different monthly demand values obtained by rate technique- 1 on train and rate technique- 2 on train. Unit production costs for each product of the fourth year are given in the table below. Table. Production costs (pb/piece) Unit resource usage values for each product are as follows: Table. Resource amounts In order to meet the changing demand, the company can use options such as normal work, overtime, contract manufacturing, and sell-out. Considering the number of existing workforce, a total of 1000 hours can be worked per month with normal work. It is possible to work overtime, up to 25% of the normal working time each month. Each product is produced using the same raw material. The company has a total of 800m2 of raw materials. The unit inventory holding cost for each month is 1% of the production cost for that month. The cost of disposal for each month is 2% of the production cost for that month. The contract manufacturing cost for each month is 1.25 times the production cost for that month. The overtime cost for each month is 1.5 times the production cost for that month. Find the best solutions of the developed decision models with the help of any solver (CPLEX, LINDO, LINGO, GAMS, etc.) and discuss the best solutions obtained. Interpret by performing sensitivity analysis according to the right-hand side constants and additive vector