NHM 310 - Forecasting Methods - HW/QZ: (CHP9-6) NAME: SCORE: Question 1: Following table shows sales data of past five years (2010-2014) of Ole Miss Hotel. With this information, forecast sales for 2015 (Use Nave Method). % increase Sales $ 100,820.00 9.80% Year 2010 2011 2012 2013 $ 110,599.54 9.70% 10.00% $ 121,659.49 $ 133,703.78 $ 147,207.87 9.90% 2014 10.10% 2015 Question 2: Following table shows monthly number of rooms sold of Oxford B&B in 2014. Using this information and moving average method, the owner wants to forecast the number of rooms sold for January in 2015. MONTH Demand Month Demand January 89 July 223 February 57 August 286 March 144 September 212 April 221 October 275 May 177 November 188 June 280 December 312 Required: 1) 3-month moving average: 2) 6-month moving average: 3) 12-month moving average