What's new in calculation model v2:
– New correct translation in english.
– Fixed more than 30 small bugs.
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)
– 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.