Chapter CS, Problem 10.3CQ

Best Homes, Inc.: Forecasting eXcel

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 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 2015 Best Homes built 20,040 new homes with revenue of $6.4 billion in sales. Their sales were 4.0 percent of the national home market of over 501,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 operations and supply chain strategy is organized around having sufficient capacity to build homes on schedule with the quality required to provide outstanding designs and Intenor 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 walls, 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 in Exhibit 1. Another input to the forecasting process comes from the sales force in each region of the country. The sales force input is combined with the forecast from past sales data to come up with a final national sales forecast for the company for the next year by month.

EXHIBIT 1 New residential houses sold.

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 qua-terly 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.

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 little 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. The task is to forecast this data forward for the year of 2016 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.

Discussion Questions

1. 1. What forecasting methods should the company consider? Please justify.
2. 2. Use the classical decomposition method to forecast average demand for 2016 by month. What is your forecast of monthly average demand for 2016?
3. 3. Best Homes is also collecting sales projections from each of its regions for 2016. What role should these additional sales projections play, along with the forecast from question 2, in determining the final national forecast?

This case was prepared by Roger G. Schroeder for class discussion. Copyright © by Roger G. Schroeder, 2016. All rights are reserved. Reprinted with permission.