Problem 4:28 in Microsoft excel

George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows. George has forecasted that annual demand for his sailboats in year 5 will equal 5, 600 sailboats. Based on this data and the multiplicative seasonal model, what will the demand level be for George's sailboats in the spring of year 5? Attendance at Orlando's newest Disneylike attraction, Lego World, has been as follows: Compute seasonal indices using all of the data. North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be: D = 77 + 0.43Q where Q refers to the sequential quarter number and Q = 1 for winter of Year 1. In addition, the multiplicative seasonal factors are as follows