FMCG Excel forecasting document
Budget: £20 – £250 GBP
I am looking for someone to create me a forecasting template in excel.
This document needs to be able to show me the sales revenue, GP% and cash profit when the cost of the products is inputted and sold to retailers.
I have anywhere up to 50 products
I have up to 20 retailers and each retailer has any number of stores from 10 to 500.
I want to be able to input my predicted units sold in each retailer per week so that the document then gives me a weekly, monthly and yearly forecast on sales and profit and also shows the cost price to the retailer, the price on shelf ex VAT and including VAT and what profit they will make.
This document needs to allow me to add customers in in different months of the year and i need to be able to add in the number of stores each retailer has and the number of units sold per week.
This document needs to be able to show me the sales revenue, GP% and cash profit when the cost of the products is inputted and sold to retailers.
I have anywhere up to 50 products
I have up to 20 retailers and each retailer has any number of stores from 10 to 500.
I want to be able to input my predicted units sold in each retailer per week so that the document then gives me a weekly, monthly and yearly forecast on sales and profit and also shows the cost price to the retailer, the price on shelf ex VAT and including VAT and what profit they will make.
This document needs to allow me to add customers in in different months of the year and i need to be able to add in the number of stores each retailer has and the number of units sold per week.