Calculation Model (lite version)

Product is not avaliable for purchase. Please use new version - Calculation Model v2 (lite version)

Many teams do not calculate anything at all or use very lousy models. From our experience - the better model you use, the further you go in challenge. This calculation excel model is powerfull companion in your journey to defeat other teams. Zip archive contains calculation excel model in russian and english. Model can help you to improve your decisions and contains:

– Operations calculator
– Finance calculator

Operations calculator consists of several parts:

– Physical resouces (space, machines, materials, internet statistics)
– Human resources (production personnel, assembly workers, agents and distributors, transport, carbon footprint)
– Product data (quantities, delivered, orders, sold, backlog, warehouse stocks, guarantee services, product improvements, components)

Finance calculator consists of several parts:

– Administrative expenses (accumulated taxable profit, insurance)
– Income statement (sales revenue, cost of sales, gross profit, earnings per share)
– Balance sheet (non-current assets, current assets, liabilities, equity)
– Cash flow statement (operating activities, investing activities, financing activities)

Cells colors:

– White background, Blue font - cells with formulas, do not change.
– Green background, Red font - for manual input.
– White background, Black font - static data from report or constant, do not change.
– Yellow background - empty cells, which are active only in PRO version of calculation model.
– Red background - alert, check your decision, it is not good enough.

Warning - model contains VBA macroses, so you need to activate macroses in excel worksheet. Write us, if you still have problems.