CHAPTER 6Cost of Goods Sold andInventory Model

In this chapter, you will learn how to plan, create, and use the Cost of Goods Sold and Inventory (COGS) model. The COGS model is closely related to the Sales and Revenue (REV) model discussed in Chapter 5. COGS demonstrates the modeling of the cost of goods sold and inventory requirements for Green Devil Control Systems as set forth in its business case, including modeling of variable costs, contributions to margins, inventory, and accounts payable associated with inventory.

In this chapter, you will learn how to

  • Model variable costs associated with products and services and forecast and assess product and services contribution to margin.
  • Develop an inventory model associated with the hardware ...

Get Pro Excel Financial Modeling: Building Models for Technology Startups now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.