+61(2) 9976 0909
[email protected]
Contact Us
Facebook
Twitter
LinkedIn
  • Home
  • Who We Are
  • Expertise
    • Financial Modelling
    • Training
  • Our Work
  • Testimonials
Resources Contact

Cost of Goods Sold & Inventory

October 2, 2015No Commentskody

To perpetuate business, sold goods need to be replenished. CoGS is used as a proxy to reorder goods to this end. Such reordering will likely occur before the goods are sold as production and/or shipment of these goods can create an inventory order lead time.

At this point it is important to emphasise that CoGS is only a proxy for stock reordering; there not a perfect correlation between CoGS and inventory. The inter-relationship between CoGS and inventory as presented is a simplification with the following ignored:

  • Inventory valuation method
  • Gross margin expansion / compression due to say foreign exchange – CoGS being the inverse of gross margin
  • Slow moving or obsolete inventory

We demonstrate the CoGS / inventory relationship with two examples. The basic example (Calcs_Basic) illustrates the foundation calculations linking stock reordering, CoGS and ultimately inventory held for sale. It demonstrates the stock cycle from prepayment, through production or work in progress (WiP), into shipment of completed product or stock in transit (SiT) and finally transitioning to inventory. ‘Just in Time’ inventory management is assumed.
The advanced example (Calcs_Adv) draws on the basic example adding:

( i ) complexity of opening balances for prepayments, WiP and SiT;

( ii ) and allowing user to differ creditor period from payments based on physical receipt of goods.

DOWNLOAD EXCEL MODEL
DOWNLOAD PDF
Next post Infrastructure Journal: The black swans of hydro dams

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

BOOK AN APPOINTMENT

Superior Solutions From Experienced Modellers

Recent Posts

  • Using Python with Excel – Part Four
  • Using Python with Excel – Part Three
  • Using Python with Excel – Part Two
  • Using Python with Excel – Part One
  • Cashflow Waterfall

Categories

  • Articles
  • Kenny Chew
  • Levi Bailey
  • Resources
  • Theo West
  • Tutorials

Sharpen your focus. Superior solutions from experienced modellers.

ABOUT US

  • Our Senior Team
  • What We Believe In
  • Blog
  • Resources
  • Contact

FOLLOW US

Facebook
Twitter
LinkedIn
RSS
Log InPrivacy PolicyTerms And Conditions
© 2016 Lentran Modelling Solutions Pty Ltd. ABN 66 615 474 523. Site By Design Fox