Please answer the Q1 of this case study

Case Study Best Homes, Inc.: Forecasting excel Best Homes is a new home construction company with headquarters in Kansas City, Missouri. They construct only Page 463 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 company until 1958 when it made its first public offering. While the company started small, it has expanded to become one of the largest homebuilders in America. In 2018 Best Homes built 20,040 new homes with revenue of $6.4 billion in sales. Their sales were 3.2 percent of the national home market of over 627,000 new homes." 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 entire company uses the Best Homes final forecast. Financing uses it to forecast overall revenue of the company, to prepare estimates for income and balance sheet projections, along with quarterly earnings estimates. Marketing uses the monthly forecasts to plan sales projections, hiring plans, sales incentives and sales goals. Operations and supply chain uses the forecasts for its Sales and Operations Planning (S&OP) planning process. S&OP is done for the annual forecast and then updated monthly to make adjustments in the sales forecasts and the resulting hiring plans for new employees, contract employees, and part-time employees, along with any layoffs that might be anticipated. The S&OP process each month starts with an updated rolling forecast for each of the next 12 months. The hiring plans and home building starts are then set for the next month and planned for the next three months. The plan also includes purchasing plans for materials used to construct the houses. The monthly update can require adjustments to both capacity and inventory of new homes. All functions participate in the S&OP process including Finance, Marketing, Sales, Operations, and HR. Page 464 FORECASTING DEMAND Demand forecasting has been difficult due to the seasonal and trend variations. This is why the forecast and associated planning activities are updated monthly and projected for the next twelve months. Insufficient capacity or inventory can have a dramatic effect on sales and profits. Either too much capacity or too little is a problem along with too few or too many homes in inventory. The first part of the planning process is to forecast 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 built in each month by Best Homes over the past five years. The task is to forecast this data forward for the year of 2019 by month. It is not enough to only forecast the average monthly demand going forward. Actual demand can be significantly higher or lower than the average. As a result, the standard deviation of demand, or mean absolute deviation, must also be forecasted. The monthly production level for new homes is then set at the average demand plus a safety stock of new homes for when the demand exceeds the average. Since there is a three-month lead-time for building new homes, any inventory and production levels must anticipate the three-month lead-time. This illustrates how critical forecasting is for both purposes of planning production levels and inventory