Using information from the discussions on forecasting techniques, develop a basic exponential smoothing model to forecast customer demands of your product for the next six months using a smoothing average of 0.4 and a trend smoothing constant of 0.2. The recorded data for the products past monthly orders are 700, 850, 800, 950, 1250, and 1350. You must show all your work.

Using the forecasted results and scheduling techniques discussed in unit 3, develop a master schedule in any of the formats shown in the text (or the samples attached), limiting yours to eight-week periods instead of the 12-week periods shown (i.e. you should use any two of your forecasted six months orders to get the required orders for the eight weeks). Show the following in a tabular form: period in weeks, forecast demand, available items, MPS, and number on hand. Use the information from your master production schedule, bill of materials, product structure diagram and gross to net explosion to develop your weekly MRP record of any one of your parts (sample attached). Assume your parts A, B, and C have inventory levels of 15, 20 and 5 pieces respectively. Then, use your MRP record sheet to develop your own daily work schedule to look like the sample attached here.