please using the excel to solve this problem like the sheet of excel with change information to conduct the problem

Best Homes is a new home construction company with headquarters in Kansas City, Missouri. They construct only residential homes throughout the U.S. and only new homes. Having started on the East coast in 1945 they expanded to the Midwest and ultimately to the West coast and the South. They build all types of residential new homes from low-end prices to the high-end of the market. Best Homes was a private comparty until 1958 when it made its first public offering. While the company started small, it has expanded to become one of the largest homebu Iders in America. In 2015 Best Homos built 20,040 new homes with revenue of $6.4 bilion in sales. Their salas were 4.0 percent of the national home market of over 501,000 new homes. 1 COMPANY STRATEGY AND PLANNING CYCLE Best Homes competes based on its excellent brand reputation. Their reputation is earned by building quality homes at a competitive price. The cost per square foot of their homes is comparable to competitors, but the design and interior finish of their homes is outstanding. This provides an advantage that competitors find hard to meet. The operations and supply chain strategy is organized around having sufficient capacity to bulid homes on schedule with the quality required to provide outstanding designs and interior finishes. As a result, they hire only the best carpenters to do the work that will show after the building is completed, including installation of the interior wals, flooring, windows, siding, cabinets, and woodwork to provide a beautiful home. For other parts of the construction that do not show upon completion, they hire some part-time or contract workers to do the foundations, rough-in walls, roofing. wiring and plumbing. In each of these areas, however, they employ at least 60 percent full-time workers. All new employees, part-time or contract workers are assigned to a full-time employee to insure training and quality control of the work for the first six months. The hiring of contract and part-time workers helps Best Homes deal with fluctuating monthly demand for homes during the year. It also helps them control their costs. Demand or sales planning is done once a year and then updated each month. The planning cycle for annual demand includes two elements. First a forecast is made by month for the next year of new home sales. This is done using data from the past five years by month, shown 'The data in this case are representative of a portion of the national sales data for new homes derived from https/hww. census.goulconstructaninrshistoricaldatalndex.html 2016. This case was prepared by Royer G. Schroeder for class discuss inventory can have a dramatic effect on sales and profits. lead-time for building new homes, any inventory and Either too much capacity or too little is a problem along production levels must anticipate the three-month leadwith too little or too many homes in inventory. time. This Illustrates how critical forecasting is for both The first part of the planning process is to forecast purposes of planning production levels and inventory. demand for new homes on a monthly basis. To accomplish this data in Exhibit 1 is provided. It shows the number of new single-family houses buil in each month by Discussion Questions Best Homes. The task is to forecast this data forward for 1. What forecasting methods should the company the year of 2016 by month. consider? Please justify. It is not enough to only forecast the average monthly 2. Use the classical decomposition method to forecast demand going forward. Actual demand can be signifiaverage demand for 2016 by month. What is your cantly higher or lower than the average. As a result, the forecast of monthly average demand for 2016? standard deviation of demand, or mean absolute devia- 3. Best Homes is also collecting sales projections from tion, must also be forecasted. The monthly production each of its regions for 2016 . What role should these level for new homes is then set at the average demand additional sales projections play, along with the plus a safety stock of new homes for when the demand forecast from question 2, in determining the final exceeds the average. Since there is a three-month national forecast? \begin{tabular}{|l|l|l|} \hline Period & Quarter & Demand \\ \hline & & \\ \hline \multicolumn{3}{|c|}{} \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Quarter & Year 1 & Year 2 & Year 3 & Quarter Average & Quarter Relative \\ \hline & & & & & \end{tabular} Overall average \begin{tabular}{|l|l|l|l|l|l|} \hline Period & Season & Actual & MA7 & Centered MA7 & Season Index \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular}