Excel spreadsheet for students.

Teaching note for product 9B06D017.

The general manager of the Wilkins plant in Paso Robles, California has received instructions from head office to reduce inventory by 30 per cent in the next quarter. Although inventory had been accumulating over the past years, this has been seen as a benefit to the company for a couple of reasons. One is that the cost of raw materials has risen in the past year. The second is that the company has a policy of no layoffs, so having inventory in stock .....more

The materials manager at the Wilkins plant in California is surprised to find out that an auditor's report recommends a second annual physical inventory count. He had concerns about the level of the inventory that was conducted, he knew changes were needed and must decide what alternatives to consider. Students are exposed to the difficulties of managing inventory as well as typical problems that occur in growing businesses. Students will diagram .....more

Teaching note for product 9B06D006.

The newly promoted inventory manager wonders if there is an easier, more reliable means of forecasting the sales demand. Currently forecasts are based on the plant manager, sales/marketing manager and inventory manager's knowledge of industry trends, competitive strategies and sales history. He must decide if using statistical forecasting methods would ease the forecasting process and make the forecast more reliable. Students are exposed to different .....more

Teaching note for product 9B06D005.