FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
  • FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
  • FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
  • FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
  • FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
  • FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
  • FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
  • FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
  • FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
  • FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
  • FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
  • FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting
Originally published: 15/02/2019 21:20
Publication number: ELQ-93269-1
View all versions & Certificate
certified

FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting

Financial model for a FMCG business in Excel that can be used during consulting projects - eg: due diligence

Description
In this Excel file you will find an Excel Financial Business model of a FMCG company.

Modeled in this file are: production costs (variable and fixed costs), sales costs, gross margin, net margin, Head-office costs and finally the profit and loss statement, along with the Working Capital statement. We assumed sales via 2 main channels: traditional small stores (via some wholesalers) and retail chains that we sell to directly.

The model you can be used in a due diligence context to check whether a startup idea in the FMCG sector makes sense and/or to try to find ways to improve the profitability of the business.

You can adjust the model by changing the parameters that are highlighted in blue. FMCG (Fast Moving Consumer Goods) business models, as all consumer goods related businesses, are very demanding in terms of sales & marketing and are not the easiest to manage when it comes to the supply chain.

Consulting projects, especially when it comes to Fast Moving Consumer Goods (FMCG), are pretty difficult in terms of analysis.

To accompany the model I have also prepared a short presentation covering the most important aspect of the FMCG business model. You will find there some tips on how to work on the sales and marketing as well as supply chain issues in FMCG businesses.

Below a link to the presentation
https://www.slideshare.net/AsenGyczew/fmcg-for-management-consultants-and-business-analysts
This presentation should help you understand and modify the model

If you have any questions, you're welcome to reach out to me via Private message here: https://www.eloquens.com/channel/asen-gyczew

This Best Practice includes
1 Excel Model Template

Asen Gyczew offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

keyboard_arrow_downShow all


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Asen Gyczew

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on FMCG (Fast Moving Customer Goods) Business Model In Excel - Management Consulting?

The user community and author are here to help. Go ahead!


4.6 / 5 (17 votes)

please wait...