O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Calculating and planning for inventory requirements

Inventory is often a necessary component to business, especially retail. Retail businesses often maintain an inventory of products to allow for sales and customer demand; however, inventory does not have to be limited to product inventory. Staffing can also be considered inventory with respect to forecasting, as a business must maintain a certain level of staffing in order to fulfil the business requirements.

As a financial manager, you are tasked with ensuring proper stock levels of widget A are available for purchase to fulfil customer demand.

In this recipe, you will learn to use forecasting functions to ensure proper product levels.

Getting ready

For this recipe, we will utilize a toolset in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required