Global Management Challenge

Calculation Name

Calculation State

Year

Quarter

Company Number

Orders

Product 1

Product 2

Product 3

Europe

Uordersp2m1

Uordersp3m1

Nafta

Uordersp2m2

Uordersp3m2

Internet

Uordersp2m3

Uordersp3m3

Rejected %

Product 2

Product 3

Guarantee %

Uassump2guaranteepercent

Uassump3guaranteepercent

Personnel

Asm. workers

Machinists

Employees left

Uassummachinistleft

Absenteeism/sickness %

Machines

Efficiency %

Breakdown hrs

Machines

Uassummachinistleft

Finance

Share price

Min mat. price

Cur. rate

Advertising

Corp. image

Product 1

Product 2

Product 3

Europe

Product 1

Product 2

Product 3

Nafta

Europe

Uadvertp2m2

Uadvertp3m2

Internet

Advert P1 in Internet

Advert P2 in Internet

Advert P3 in Internet

Prices

Europe

Product 2

Product 3

Nafta

Uadvertp2m2

Uadvertp3m2

Internet

Advertp2europe

Advertp3europe

Deliveries

Europe

Product 2

Product 3

Nafta

Internet

Advertp2europe

Advertp3europe

Quality

Implement Improvements

New

Product development ('000)

Assembly Time (min)

Premium materials (%)

Advertp2europe

Advertp3europe

Operations

Subcontracting (units)

Agents and distributors

Number

Support

Commission (%)

European agents

Support

Commission %

Nafta distributors

Internet distributor

Advert P3 in Internet

Operations

Buy materials: spot

3 month

6 month

Plant maintenance (hr)

Shift level

Internet ports

Website develop.

Personnel

Assembly workers: hire

Assembly trainees

Wage rate (cents/hr)

Management budget

Staff training (days)

Finance

Shares (issue/cancel)

Divident (cents/share)

Long term loan ('000)

Term deposit ('000)

Machines - to buy

Machines - to sell

Factory - build (sq m)

Insurance plan

Information

Market shares

Business intelligence

Incoming data from the previous management period (quarter) used in these calculation:

PPD

Automatic purchase of materials

Shortage of machine time (hours)

Shortage of Assembly time (hours)

Shortage of factory area (square meters)

Land available for new construction (m2)

Is building possible (land + borrowing power)?

Maximum number of machines available to buy

Overdraft rate

1 shift per day

2 shift per day

3 shift per day

5 days

6 days

7 days

5 days

6 days

7 days

to market 1

to market 2

via Internet

Movement of Materials

Indicator Name	Planned quarter (Q+0)	Quarter after planned (Q+1)	2 quarters after planned (Q+2)
Incoming materials at the quarter beggining
Delivered materials, bought in the quarter (spot)
Delivered materials automatically purchased
Delivered materials, bought in the previous quarter (3 month futures)
Delivered materials, bought 2 quarters ago (6 month futures)
Materials available
Used in Production
Outgoing materials at the quarter end

Movement of Components

Indicator Name	Product 1	Product 2	Product 3
Available at the beginning of the planned quarter
Used in the planned quarter
Left at the end of the planned quarter
Ordered in the planned quarter
Available in the quarter after planned

1 - 5

Outgoing Inventory and Backlog

Product Costing

Adverising

Internet distributor

Internet Service Provider

Agents and distributors

Sales office

Guarantee servicing

Product development

Web-site development

Personnel department

Machine maintenance

Purchasing and wareshousing

Business intelligence

Credit control

Insurance premiums

Management salaries

Other costs

Total administrative expenses

Profit/Loss before tax

Previous taxable profit/loss

Taxable profit/loss

Primary non-insured risk

Sales revenue

Opening inventory

Purchased components

Purchased materials

Machine running costs

Machinists wages

Assembly wages

Quality Control

Hired Transport

Less closing inventory

Cost of goods sold

Gross profit

Administrative expenses

Insurance receipts

Depreciation

Operating profit/loss

Finance income

Finance expense

Profit/loss before tax

Taxes payable

Profit/loss for the period

Earning per share

Dividends paid

Transferred to retained earnings

Previous retaining earnings

Retaining earnings

Land

Buildings

Machinery

Property, plant and equipment

Product inventories

Component inventories

Material inventory

Trade receivables

Cash and Equivalents

Total current assets

Total assets

Taxes due

Trade payables

Bank overdraft

Current liabilities

Term loans

Net assets

Share capital

Share premium account

Retained earnings

Total equity

Trading receipts

Insurance receipts

Trading payments

Tax paid

Net operating cash flow

Interest received

Assets sold

Assets purchased

Net investment cash flow

Shares issued

Shares repurchased

Dividents paid

Additional loans

Interest paid

Net finance cash flow

Net cash flow

Previous cash balance

Cash balance

Including term deposit of

Overdraft limit for next quarter

Borrowing power next quarter

Calculation Id

Based on Model

Created By

Created On

Launched By

Launched At

Duration

Team

Decision	Unit of measure	Minimum	Maximum	Default
Advertising	€000	0	99	repeat
Product prices	euros	0	999	repeat
Delivery to Europe	number	-999	9999	repeat
Delivery to Nafta	number	0	9999	repeat
Delivery to Internet	number	-999	9999	repeat
Implement improvement	yes/no	0	1	0
Product development	€000	0	99	repeat
Product 1 assembly	minutes	100	999	repeat
Product 2 assembly	minutes	150	999	repeat
Product 3 assembly	minutes	300	999	repeat
Premium materials	%	0	100	repeat
Subcontracting	number	0	9999	0
Agents/distributors wanted	number	0	99	repeat
Support payment	€000	5	99	repeat
Commission rate	%	0	99	repeat
Materials to buy	000	0	99	0
Plant maintenance/machine	hours	0	99	repeat
Shift level	number	1	3	repeat
Website ports	number	0	99	repeat
Website development	€000	0	99	repeat
Assembly workers to recruit	number	-9	99	0
Assembly workers to train	number	0	9	0
Assembly wage rate per hour	cents	900	9999	repeat
Management budget	€000	30	999	repeat
Staff training consultant	days	0	60	repeat
Share issue/repurchase	€000	-999	999	0
Dividend to pay	%	0	99	0
Additional loan	€000	0	9999	0
Term deposit	€000	-999	9999	0
Machines to buy or sell	number	0	99	0
Factory - build	sq. m.	0	9999	0
Insurance plan	number	0	4	repeat
Information wanted	yes/no	0	1	repeat

Calculation

Toolbar

Calculation Selector

Calculation Header

Your Decisions

Assumptions about the next quarter

Orders

Products

Personnel

Machines

Finance

Decisions about your Products

Advertising

Prices

Deliveries

Quality

Operations

Decisions about your Resources

Agents and Distributors

Operations

Personnel

Finance

Information

Data From Previous Period

Incoming data from the previous management period (quarter) used in these calculation:

PPD

PPD_VARIABLES

Management Reporting

Is your plan feasible?

Utilization of

Equipment

Machinists

Assembly workers

Containers

Auxiliary Data

Movement of Materials

Movement of Materials

Movement of Components

Movement of Components

Outgoing Inventory and Backlog

Outgoing Inventory and Backlog

Product Costing

Product Costing

Financial Reporting

Administrative Expenses

Accumulated Taxable Profit

Income Statement

Dividends

Balance Sheet

Non-current assets

Current assets

Liabilities

Net assets

Equity

Cashflow Statement

Operating activities

Investing activities

Financing activities

Other

Calculation Metadata

UOM-en