I would like some detailed step by step assistance with the following linnear program exercise

QUESTION # ONE (a) Posh Industries, a nationally known manufacturer of menswear, produces four varieties of ties. One is an expensive, all-silk tie, one is an all-polyester tie, and two are blends of polyester and cotton. The following table illustrates the cost and availability (per monthly production period} of the three materials used in the production process: Material Cost Per Yards (5) Material Available Per Month Yards Silk 21 300 Polyester 6 3,000 Cotton 9 1,600 The firm has fixed contracts with several major department store chains to supply ties. The contracts require that Fifth Avenue Industries supply a minimum quantity of each tie but allow for a larger demand if Fih avenue chooses to meet that demand. (Most of the ties are not shipped with the name Fifth Avenue on their labels, incidentally, but with private stick\" labels supplied by the stores.) The table below summarizes the contract demand for each of the fur styles of ties, the selling price per tie, and the fabric requirements of each variety. Variety of Tie Selling Monthly Monthly Material Material Requirements Price Per Contract Demand Required per Tie (11?) Minimum Tie {yards} All Silk 6.70 8,000 7,000 0.125 100% silk All Polyester 3.55 10,000 14,000 0.08 100% polyester Polyootton blend 1 4.31 13,000 16,000 0.10 50% polyester 50% on on Pol cotton blend 2 4.81 6 000 8 500 0.10 30% 0| ester ?0% co..on REQUIRED: i. ii. iii. iv . V. Formulate a linear programming model for this problem. [6 marks] Solve this model by using Microsoft Excel and run 3 Sensitivity and an Answer Report. [12 marks] State the optimal solution to the problem. [2 marks] State Twhat constraints are binding and non-binding? [2 marks] Interpret the non-zero shadow prices in your output constraint table. [2 marks] QUESTION a! ONE ('0) (3) Use the three-month moving average to forecast the demand from April to September in the table above. [2 marks] (b) Use the three-month weighted moving average to forecast the demand from April to September in the table above using weights 0.23, 0.35, 0.42. [2 marks] (c) Given an alpha (0:) value of 0.35, use the exponential smoothing method of forecasting to predict the demand from Pebiuary to September in the table above. [4 marks] (I1) Use the Mean Absolute Deviation (MAD) and the Mean Absolute Percent Error (MAPE) to compare the two methods, and state which is the most efcient one to use. [3 marks]