1. Use the Excel solver templates (time series forecasting) to identify the best forecasting method based on error indicators.

Have you ever worked on excel before? If not then you shouldnt have answered to this question. Kindly refer it to other expert.

FORMULAS DATA REVIEW VIEW Sign in FILE 4 A A On HOME INSERT PAGE LAYOUT % Cut Calibri - 11 En Copy Format Painter BIU R Clipboard Font === E AutoSum AY # Wrap Text Merge & Center, General % 2 x Paste A , Conditional Format as Cell Formatting Table Styles Styles Insert Delete Format - Cells Fill Clear Sort & Filter Editing Find & Select Alignment Number Q11 H K L M - BC 1 Exhibit 3: Monthly Units Forecast, Planned, and Actual Output, 2010 N O P Q R A Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total 4 Pharmaceutical Line Forecast Aggregate production plan Actual 6 10,750 15,357 14,419 7,679 15,357 12,722 9,214 11,518 16,115 7,679 15,357 16,115 23,804 15,357 10,178 18,429 11,518 11,874 10,750 11,518 11,874 14,589 15,357 13,570 16,893 15,357 11,026 13,054 15,357 16,963 17,661 15,357 14,419 29,179 15,357 15,267 1,79,680 1,72,769 1,64,542 9 9 Retail Line Forecast Aggregate production plan Actual 5,953 5,177 4,409 5,694 6,471 6,224 8,800 6,471 8,039 8,541 6,471 6,224 ,836 9,059 5,964 16,306 11,647 14,004 11,130 5,177 2,334 5,694 9,059 8,039 8,800 9,059 7,002 14,753 12,942 12,448 10,871 14,236 14,004 19,412 19,412 21,005 1,25,792 1,15,180 1,09,695 Note: Figures represent the number of smart label rolls (1,000 labels per roll) 2,74,237 Actual output per year 20 machine capacity 21 production time per month 1 machine produces 20,000 units/hr 8 hr shift * five days a week * 4 weeks = 160 hours/month 20 machine capacity 21 production time per month 1 machine produces 20,000 units/hr 8 hr shift * five days a week * 4 weeks = 160 hours/month Monthly Capacity (rolls) = Monthly capacity/machine (rolls) 4 "personalization" machines (rolls) 32,000 3,200 12,800 Total annual capacity (rolls)= 3,84,000 FORMULAS DATA REVIEW VIEW Sign in FILE 4 A A On HOME INSERT PAGE LAYOUT % Cut Calibri - 11 En Copy Format Painter BIU R Clipboard Font === E AutoSum AY # Wrap Text Merge & Center, General % 2 x Paste A , Conditional Format as Cell Formatting Table Styles Styles Insert Delete Format - Cells Fill Clear Sort & Filter Editing Find & Select Alignment Number Q11 H K L M - BC 1 Exhibit 3: Monthly Units Forecast, Planned, and Actual Output, 2010 N O P Q R A Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total 4 Pharmaceutical Line Forecast Aggregate production plan Actual 6 10,750 15,357 14,419 7,679 15,357 12,722 9,214 11,518 16,115 7,679 15,357 16,115 23,804 15,357 10,178 18,429 11,518 11,874 10,750 11,518 11,874 14,589 15,357 13,570 16,893 15,357 11,026 13,054 15,357 16,963 17,661 15,357 14,419 29,179 15,357 15,267 1,79,680 1,72,769 1,64,542 9 9 Retail Line Forecast Aggregate production plan Actual 5,953 5,177 4,409 5,694 6,471 6,224 8,800 6,471 8,039 8,541 6,471 6,224 ,836 9,059 5,964 16,306 11,647 14,004 11,130 5,177 2,334 5,694 9,059 8,039 8,800 9,059 7,002 14,753 12,942 12,448 10,871 14,236 14,004 19,412 19,412 21,005 1,25,792 1,15,180 1,09,695 Note: Figures represent the number of smart label rolls (1,000 labels per roll) 2,74,237 Actual output per year 20 machine capacity 21 production time per month 1 machine produces 20,000 units/hr 8 hr shift * five days a week * 4 weeks = 160 hours/month 20 machine capacity 21 production time per month 1 machine produces 20,000 units/hr 8 hr shift * five days a week * 4 weeks = 160 hours/month Monthly Capacity (rolls) = Monthly capacity/machine (rolls) 4 "personalization" machines (rolls) 32,000 3,200 12,800 Total annual capacity (rolls)= 3,84,000