Optimizing Resources to Better Forecast Future Profits

In this chapter, inventory and sales data from a small business with seven showrooms are evaluated to forecast future sales and maximize total profits. In each showroom, three major brands of ceiling fans are sold and a limited amount of products from each brand are displayed. Each showroom varies in their sales volume, display capacity, and profit margins. Using historical data, the optimal display configuration was determined for each showroom; that is, the proportion of products from each brand to display in the limited display grid, while acknowledging existing constraints. Next using the optimal displays, profit for the next year is forecasted. Finally a comparison is made between actual and forecasted results and profits pre and post the optimal product display.