Calculation model v2 (pro version)

UPDATE 20.04.2024: Latest version 3.91

– Made 45+ improvements
– Strategy worksheet is completely automated.
– Model is pre-filled with high quality decisions for all 5 periods

UPDATE 15.09.2021: Latest version 3.63

– Bugs fixed
– Made 50+ improvements
– Most of decisions on Strategy worksheet are automated

UPDATE 29.11.2017: Latest version 3.28

– Bugs fixed
– Made 40+ improvements
– New Goodwill worksheet with information about Goodwill factors and Investment performance

UPDATE 30.01.2017: Tutorial for calculation model v2 (pro version)

UPDATE 02.06.2014: Latest version 3.02

– New English translation
– Bugs fixed
– New Strategy worksheet, where can be simulated all 5 decisions to choose the best decision for game
– Demand prediction module 100% remade, module calculates elasticities changes of demand factors, forecast accuracy increased x2 times

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 english language with configuration worksheet v2. Other languages can be downloaded in store. Model can help to improve your decisions and contains:

– Operations calculator
– Finance calculator
– Demand prediction module
– Investment perfomance prediction module
– Opponents analysis
– Strategy module fo 5 periods

Operations calculator consists of several parts:

– Physical resouces (space, machines, materials, internet-ports)
– 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)

Demand prediction module helps you to calculate demand for current and next periods which is one of the most important things in Global Management Challenge. Module gives you ability to see everything you need on one worksheet, including how your decisions influence production capacity.
This module is the core of your decision, because Global Management Challenge is mainly about demand prediction, working efficiently and increasing Investment perfomance. This module covers demand prediction and partly efficiency. Module forecast changes in demand from each of factors:

– Backlog
– Seasonality
– Assembly
– Research and development
– Corporate advertising
– Direct advertising
– Prices
– Agents and distributors - comisssion
– Agents and distributors - support
– Agents and distributors - recruit
– Premium materials
– Training
– Management budget
– Internet ports
– Web-site development

Investment perfomance prediction module contains useful tips about how to rise investment perfomance in last decision. Module covers investment perfomance prediction from each of factors:

– Dividends
– Liquid assets
– Research and development
– Market shares
– Backlog
– Resources
– Agents and distributors
– Profit

Oponents analysis helps you quickly orient in information flow, which is especially important in final rounds:

– Stock market data (share price, market valuation, dividends, investment perfomance)
– Production capacity (product prices, production employees, assemby wage rate)
– Company balance (assets, liabilities, equity, net worth)
– Competitors business activity (market shares, advertising, product development)

Strategy module for 5 periods contains operations and finance calculator for all 5 periods, where you can simulate your decisions for whole game in one place.

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.
– 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.