with the given info PLEASE TYPE ANSWER Month 1 2 3 4 Actual Sold 5000 6000 7000 Forecast 5000 5000 5300 5810 Forecast for period t F=F+O4(D..-F...) Let forecast for month 1 Fz=5000 units F=F,+Q*(D-F) -5000+0.3+(5000-5000) =5000 units F;=F.+ar+(D-F.) =5000+0.3*(6000-5000) =5000+300=5300 units F.=Fs+Cr"(D.-F.) =5300+0.39(7000-5300) =5300+510=5810 units Use the forecasted results to develop a 12-week master production schedule for all the parts to be produced. Show the following in a tabular form: period in weeks, forecast demand, available items, MPS, and number on hand. Use the master schedule to develop a weekly MRP record. with the given info PLEASE TYPE ANSWER Month 1 2 3 4 Actual Sold 5000 6000 7000 Forecast 5000 5000 5300 5810 Forecast for period t F=F+O4(D..-F...) Let forecast for month 1 Fz=5000 units F=F,+Q*(D-F) -5000+0.3+(5000-5000) =5000 units F;=F.+ar+(D-F.) =5000+0.3*(6000-5000) =5000+300=5300 units F.=Fs+Cr"(D.-F.) =5300+0.39(7000-5300) =5300+510=5810 units Use the forecasted results to develop a 12-week master production schedule for all the parts to be produced. Show the following in a tabular form: period in weeks, forecast demand, available items, MPS, and number on hand. Use the master schedule to develop a weekly MRP record