Author Topic: General calculations for FRM340  (Read 1405 times)

jmountney

  • Global Moderator
  • Jr. Member
  • *****
  • Posts: 58
General calculations for FRM340
« on: June 02, 2014, 02:29:17 pm »
S/S = BOM / net sales

BOM = net sales x Stock to sales     

BOM season total = sum of all months BOM / 7
 
Average inventory = (BOM + EOM)/2   or Average inventory = sum of all BOM / 7

Net sales = BOM / Stock to sales

Turnover = Sales/Average inventory

Sales + Markdown + EOM - BOM = Purchase

Total Sales = all sales added   

Markdown and purchase season totals = sum of all Additional info for formula (the sum is purchases, minus net sales, +BOM for the next month, minus BOM for the month you are working on).

The EOM for one month would be the BOM for the succeeding month.