MBA SIMULATION GAMES

MBA Simulation XM Guides and Tips 

with Excel file for Sales Forecast & Production Calculation

You can download free Excel file here - LINK TO ALL EXCEL FILES

or Download Capsim Capstone Excel file here - LINK 2

Or email to: This email address is being protected from spambots. You need JavaScript enabled to view it. to get Free support for creating excel file.

Free Personal Support for Rounds 1-2

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

MBA SIMULATION GAMES

MBA Simulation XM Guides and Tips
with Excel file for Sales Forecast & Production Calculation

1. General winning strategies for simulation exam (XM)

1.1. Overview of the Simulation Exam

Simulation Exam (XM) is quite similar to Simulation game. The general strategies to win the exam simulation is to R&D new products, name after the old products and try to locate their market segments, this will make calculation of sales forecast and production more easily. This game has four product segments. Thrift is similar to low end, core is similar to traditional, nano is similar to size and elite is similar to performance. The marketing, automation and capacity is important to win the simulation. We compete with 03 computer control companies, each will focus on specific segment, therefore we often can not defeat each company in one segment but we can lead in all segments with much higher total sales and net profit. So, the winning strategies are adding new products and applying the reasonable strategies of marketing and production, support by finance and human resource, TQM strategies and win the game in all 4 rounds.

First step is to download industry condition report, then use the number from industry condition report to put in first line in excel file. The formula automatically calculates the strategies for all 4 years (4 rounds). We will use strategy 2 to win the simulation in 4 rounds.

1.2. Using the Excel file to support all 4 rounds

With the excel file, we can keep track of all rounds update and R&D products, keep updating products as close as possible to ideal spots. Also, the excel file will support calculating prices, sales forecast for each product in each round, as well as calculating productions for each product each round, this is the key to win the game. This simulation for exam has 4 product segments: Thrift, Core, Nano and Elite. We add 4 new products as close to ideal spots of each segment as possible, and also update the old products, for each segment we will have two products supporting each other and can sell better than competitors. This is zero sum game, so when we can gain higher sales, we can compete better.

* Drift rates are the following, which is put in excel already

Segment/ Perf / Size

Thrift +0.5 -0.5

Core +0.8 - 0.8

Nano +0.8 -1.1

Elite +1.1 -0.8

* Also, we adjust product each round using adjustment to get closer to Ideal spot.

We need to check and make sure products match their segments

We also see the details of customer buying criteria for each segment from Industry Condition Report or Courier Report.

We have prices and MTBF for each product as follows:

- Thrift: Price 22, MTBF: 18.000 (17.000)

- Core: Price 30, MTBF: 20.000 (19.000)

- Nano: Price 38 and MTBF: 22.000 (21.000)

- Elite: Price 42 and MTBF: 24.000 (23.000)

We also keep track of prices for all the four rounds as follows:

FREE SUPPORT - HELP TO CREATE EXCEL FOR FREE

(USE EXCEL FILE FOR R&D MANAGEMENT, SALES FORECAST, PRODUCTION CALCULATION TO WIN THE GAME)

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

(Free Support for Creating Excel File for Calculations of R&D, Sales Forecast, Production 

Personal Support for all rounds to Win the game)

2. Sample Winning Strategies

2.1. Round 1 Strategies

R&D

For R&D, we add 4 new products in all the 4 segments, which are close to the ideal spot and can sell well from round 2. Try to control the launching date early next year, so we have enough time to sell new products. Round 1 and 2, we will get normal sales, from round 3 and 4 we will get much higher sales than all competitors.

Note:

- We can also select to add 3 new products in 3 segments and still win the game.

- We can also select to add 2 new products in 2 segments and still win the game.

Note: Do NOT just use these number, use the number created from your game and excel file.

Note: Again – Do not just use the above numbers, you need to download Industry Condition report from your Exam Game and add the first line into Excel file to create your own game numbers. This is very important because each game has different start number for Pfmn, Size for each segment.

Marketing decisions

For marketing decisions, we apply 1.500 for sales and promotion budget.

Also, using the excel file for calculating the sales forecast and production for round 1.

We can add 10% because we have good product and also good price, high promo and sales budget.

Production decisions

- Add new capacity for 4 new products: about 500 each

- Increase automation: thrift to 6.0, core to 5.0 and nano, elite 4.0

HR decisions

Use 5.000 and 80 hours

Finance

Use max stock issue: 39.125

Max long term loans: 14.722

Note for Round 1 results:

Round 1 result is just good sales and net profit, we focus on R&D new products and add new capacity. From round 2, sales will increase fast when new products sell well and we can update old products.

2.2. Round 2 Strategies

R&D decisions

We update 4 old products to as close to ideal spots as possible based on plan calculated in excel file.

The 4 new products are close to ideal spots already when we R&D from round 1 and they are ready to sell in round 2.

Note: Do NOT just use these number, use the number created from your game and excel file.

Note: Again – Do not just use the above numbers, you need to download Industry Condition report from your Exam Game and add the first line into Excel file to create your own game numbers. This is very important because each game has different start number for Pfmn, Size for each segment.

Marketing decisions

Use excel file to calculate the sales forecast for round 2 based on sales units from round 1 and market segment growth rates.

Production decisions

Use excel file to calculate production, add 10-12% from sales forecast to avoid stock out.

Add more capacity for Agape (Thrift) and THR2: 200 for each

Add more capacity for new products: THR2: 200, COR2: 200, NAN2: 400; ELI2: 400

Increase automation: Thrift to 8.0; Core to 7.0 and Nano, Elite to 5.0

Spend about 67.000 / total 78.000 investment limit.

HR decisions

Use 5.000 and 80 hours

TQM decisions

Use all 1.000 for 10 initiatives

Finance

Use max long-term loans: 51.000

Use max stock issue: 27.000 (or 15.000)

Keep about 20.000 cash in hand

This is the estimated results of round 2.

Note for Round 2 results:

In round 2, we start getting higher sales about 270.000 and net profit increase to about 20.000

2.3. Round 3 Strategies

R&D decisions

For round 3, we will lead the game, just keep updating products based on Pfmn and Size calculated in the excel file. For each segment, we have two products, which support each other and can sell well.

Note: Do NOT just use these number, use the number created from your game and excel file.

Note: Again – Do not just use the above numbers, you need to download Industry Condition report from your Exam Game and add the first line into Excel file to create your own game numbers. This is very important because each game has different start number for Pfmn, Size for each segment.

Marketing decisions

Use excel file to calculate the sales forecast for round 3 based on sales units from round 2 and market segment growth rates. We can add 10% because we have better products and higher promo and sales budgets than competitors. Also, we have good sales and net profit now, we can spend higher promo and sales for round 3.

Reduce prices by 0.50 to keep more competitive prices.

Apply 1.500 for promo and sales, check if customer awareness and accessibility reach 100% then we can reduce to 1.400.

Note: Do NOT just use these number, use the number created from your game and excel file.

Production decisions

Use the excel file to calculate production, often add 12% from sales forecast to production to avoid stock out.

Increase automation for Thrift to 8.0, Core to 7.0 and Nano, Elite to 5.0 or (9.0, 8.0 and 6.0)

Add more capacity for THR2, COR2 about 200 each.

HR decisions

Use 5.000 and 80 hours of training

TQM decisions

Apply 1.000 for all the 10 TQM initiatives

Finance decisions

Keep about 20.000 cash in hand

Pay some dividends, retire stocks if having too much cash in hand

Note for Round 3 results

Note that in round 1 and 2, we do not have very high sales and net profit, just keep that higher than competitors, and from round 3, we will have very high sales and net profit.

Sales about: 270.000.000 and net profit about 40.000.000

2.4. Round 4 Strategies

R&D decisions

This is the last round of the exam. We are leading the game, just keep updating products based on the excel file plan. We have good products in all the 4 segments, leading in most of the segments with sales and net profit.

Note: Do not just use the above numbers, use the number from your game and excel file.

Note: Again – Do not just use the above numbers, you need to download Industry Condition report from your Exam Game and add the first line into Excel file to create your own game numbers. This is very important because each game has different start number for Pfmn, Size for each segment.

Each game industry condition report may be different from others.

Marketing decisions

Again, use the excel file to calculate sales forecast based on unit sold in round 3. Add 10% if needed because we have better products, better price and higher promo and sales spending.

Reduce prices by 0.50 to keep more competitive than competitors.

Note that do not just use the above numbers, use your excel file to calculate the forecast of sales.

Production decisions

This is the last round of the game, do not need to add more capacity.

Keep automation for thrift at 8.0, core 7.0 and nano, elite at 5.0 or 9.0, 8.0 and 6.0

HR decisions

Keep using 5.000 and 80 hours of training

TQM decisions

Keep applying all 10 initiatives of 1.000 for each

Finance decisions

Retire stocks: about 14.000

Retire long-term loans: about 22.000

Pay some dividend per share: 8.00

Keep about 20.000 cash in hand

Round 4 estimated results

Round 4 is just also high results, sales about 310 - 335.000.000 and net profit about 50- 62.000.000 with Contribution margin about 46-48%, net profit about 18%. Note to keep high cash in hand to avoid emergency loan.

3. Key notes to win the simulation exam

3.1. For R&D

Add new products

R&D and update products each round based on calculation from excel file to as close as possible to ideal spots and launch new product in mid year.

3.2. For Marketing

Keep track of promo and sales budgets of competitors and spend higher

User formula:

(Industry Demand * Industry Growth Rate) * (Own Product Survey Score/Total Product Survey Scores).

Or just use: Sold unit * Growth Rate * 10% and adjust by comparison with competitors’ sales.

3.3. For production

Multiple sales forecast by 1.12 and subtracted by inventory

Increase automation of Thrift, Core, Nano and Elite to 8.0, 7.0 and 5.0 or 9.0, 8.0 and 6.0

3.4. For Finance

For round 1 and 2, get max investment sources from issuing stocks and long-term debts

For round 3, and 4, when having high sales and net profit, can retire some stocks, retire long term debts. Check leverage to maintain high BCS score.

FREE online personal support, for round 1

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Blog: mbasimexam.blogspot.com

FREE SUPPORT - HELP TO CREATE EXCEL FOR FREE

(USE EXCEL FILE FOR R&D MANAGEMENT, SALES FORECAST, PRODUCTION CALCULATION TO WIN THE GAME)

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

PERSONAL SUPPORT & GUIDES TO WIN THE GAME

....

MBA SIMULATIONS GAMES - Free Online Guides & Free Personal Support for Round 1 and Round 2

Free Personal Support for 2 Rounds - Email to: This email address is being protected from spambots. You need JavaScript enabled to view it.

Blog: mbasimgames.blogspot.com

-------

Business Strategy Game Simulation,

Global,

Global DNA,

GlobalDNA,

Win the CapSim CapStone for Free,

Business Strategy Game Advice,

Business Strategy Game Winning Tips,

CapSim, CapStone,

How to win the CapSim, Capstone,

Business strategy winning tips,

How to win capsim, capstone, online,

CAPSIM - 2017 - Winning Guides and Tips - All Decisions,

CAPSIM Guides,

CAPSIM Winning Tips,

capsim basic guides,

Capstone Business Simulation,

CAPSIM WINNING STRATEGY,

capsim rehearsal quiz answers,

capsim situation analysis answers,

reposition a product capsim quiz,

capsim foundation rehearsal quiz answers,

capsim introductory lesson quiz answers,

capsim rehearsal tutorial answers,

capstone situation analysis answers,

capsim introductory quiz answers,

capsim round 1 answers,

capsim round 1 decisions,

capsim round 2 finance,

capsim round 3 answers,

capsim round 1 r&d,

capsim round 1 marketing,

FAST

capsim cheats pdf,

capsim foundation cheat sheet,

QUICK

capsim round 1 decisions,

REHEARSAL,

Situation Analysis,

Caculating Market Demand,

quiz answers,

HR, Labor, Marketing, TQM,

adding capacity,

repositioning,

sweet spot,

ideal spot,

MTBF,

promotion budget,

sales budget,

accessibility,

awareness,

sales forecasting, pricing,

ideal automation,

sensor, sensors,

adding capacity,

upgrade,

negotiations, labor strikc,

TQM initiative,

------

CAPSIM, 2017, 2018,

CAPSTONE,

Business Strategy Game,

guides,

tutorials,

winning tips,

CAPSIM Guides,

CAPSIM Winning Tips,

Simulation Game,

capsim.com,

how to win capsim, compXM,

learn to win,

capsim winning strategies,

Capsim, guide how to win,

capsim simulation strategy,

capsim, tips, tricks, strategy, guide,

round 1, round 2, round 3,

R&D,

marketing, 

rehearsal,

finance, 

capsim forecasting,

capsim strategy,

capsim cheats,

capsim secret,

capsim finance tips,

quiz answers,

HR, Labor, Marketing, TQM,

Global, GlobalDNA, Global DNA, CAPSIM,2017,CAPSTONE,Business Strategy Game,guides,tutorials,winning tips,CAPSIM Guides,CAPSIM Winning Tips,Simulation Game,capsim.com,how to win capsim,compXM,learn to win,capsim winning strategies,Capsim,guide how to win,capsim simulation strategy,capsim,tips,tricks,strategy,guide,round 1,round 2,round 3,R&D,marketing,rehearsal,finance,capsim forecasting,capsim strategy,capsim cheats,capsim secret

Global, GlobalDNA, Global DNA, CAPSIM,2017,CAPSTONE,Business Strategy Game,guides,tutorials,winning tips,CAPSIM Guides,CAPSIM Winning Tips,Simulation Game,capsim.com,how to win capsim,compXM,learn to win,capsim winning strategies,Capsim,guide how to win,capsim simulation strategy,capsim,tips,tricks,strategy,guide,round 1,round 2,round 3,R&D,marketing,rehearsal,finance,capsim forecasting,capsim strategy,capsim cheats,capsim secret,capsim finance tips,strategies,capsim guide

2018

---------------

CAPSIM - CAPSTONE - FOUNDATION - COMPXM 2017 - Free Online Guides and Tips

Free Personal Support for 2 Rounds - Email to: This email address is being protected from spambots. You need JavaScript enabled to view it.

Website 1: http://topmbabooks.com  Website 2: http://top20mba.com

Business Strategy Game Simulation,

Win the CapSim CapStone,

Business Strategy Game Advice,

Business Strategy Game Winning Tips,

CapSim, 

CapStone,

Foundation,

CompXM,

How to win CapSim, 

Business strategy winning tips,

CAPSIM - 2017 - Winning Guides and Tips - All Decisions,

CAPSIM Guides,

CAPSIM Winning Tips,

capsim basic guides,

Capstone Business Simulation,

CAPSIM WINNING STRATEGY,

capsim rehearsal quiz answers,

capsim situation analysis answers,

reposition a product capsim quiz,

capsim foundation rehearsal quiz answers,

capsim introductory lesson quiz answers,

capsim rehearsal tutorial answers,

capstone situation analysis answers,

capsim introductory quiz answers,

capsim round 1 answers,

capsim round 1 decisions,

capsim round 2 finance,

capsim round 3 answers,

capsim round 1 r&d,

capsim round 1 marketing,

FAST, QUICK GUIDES,

capsim cheats pdf,

capsim foundation cheat sheet,

capsim round 1 decisions,

REHEARSAL,

Situation Analysis,

Caculating Market Demand,

quiz answers,

HR, Labor, Marketing, TQM,

adding capacity,

repositioning,

sweet spot,

ideal spot,

MTBF,

promotion budget,

sales budget,

accessibility,

awareness,

sales forecasting, pricing,

ideal automation,

sensor, sensors,

adding capacity,

upgrade,

negotiations, labor strikc,

TQM initiative,

------

CAPSIM, CAPSTONE, 2017, GUIDES,

Business Strategy Game,

tutorials,

winning tips,

CAPSIM Guides,

CAPSIM Winning Tips,

Simulation Game,

how to win capsim, 

compXM answers,

compXM guides,

Capsim winning strategies,

guide how to win,

capstim tips, 

tricks, 

strategy, 

round 1, round 2, round 8, all rounds,

R&D,

marketing, 

rehearsal,

finance, 

capsim forecasting,

capsim strategy,

capsim cheats,

capsim secret,

Capsim Foundation Guides,

Capsim Competition Guides,

Capsim First Round Strategy,

capsim finance tips,

quiz answers,

HR, 

Labor, 

Marketing, 

TQM,

-----

capsim

capsim guide

capsim strategy plan

capsim secrets

capsim finance

capsim walkthrough

guides

winning guides and tips

quiz answers

guide to capsim

basic strategy

how to win capsim and compXM

tips

tricks

strategy guide

capsim guide quiz

CapSim Foundation,

Competition Rounds Guides,

CompXM,

guides and answers

Board Query Quiz Answers

comp xm board query answers

comp xm exam answers 2016

comp xm exam cheat

comp xm exam answers 2017

comp xm round 1 strategy

comp-xm final exam answers

comp xm strategy guide

comp xm round 1 answers

-- 

VIMEO,

CAPSIM, 

CAPSTONE, 

2017, 

GUIDES,

tutorials,

winning tips,

CAPSIM Guides,

CAPSIM Winning Tips,

CAPSIM HELP,

compXM answers,

compXM guides,

capstim tips, 

round 1, round 2, round 8, all rounds,

capsim forecasting,

capsim strategy,

capsim tutorials,

----

CAPSIM, CAPSTONE, 2017, GUIDES,

capsim secret,

capsim forecasting,

capstone forecasting,

capsim spreadsheet,

capsim tip,

capsim tips,

Business Strategy Game,

tutorials,

winning tips,

CAPSIM Guides,

CAPSIM Winning Tips,

Simulation Game,

how to win capsim, 

compXM answers,

compXM guides,

Capsim winning strategies,

guide how to win,

capstim tips, 

tricks, 

strategy, 

round 1, round 2, round 8, all rounds,

R&D,

marketing, 

rehearsal,

finance, 

capsim forecasting,

capsim strategy,

capsim cheats,

capsim secret,

Capsim Foundation Guides,

Capsim Competition Guides,

Capsim First Round Strategy,

---

CAPSIM, CAPSTONE, 2017, GUIDES,

capsim secret,

capsim forecasting,

capstone forecasting,

capsim spreadsheet,

capsim tip,

capsim tips,

Business Strategy Game,

----...

QUICK Q&A for CompXM (Update 2018)

R & D - Should do

Download Industry Condition Report

Add Round 0 numbers into Excel file, Excel file will automatically calculated Ideal Spots for All products (4 to 8) in all 4 segments: Thrift, Core, Nano and Elite for all 4 years.

Tip: 

- Thrift and Core need 2 years to update to ideal spots

- Nano and Elite can update to ideal spot right from round 1

- Should add new products in Nano and Elite

- Also should add new products in Thrift can Core

- Both strategies can win the game

Tip:

Elite and Nano- Max MTBF

Core and Thrift- 3,000-4,000 lower than the max (depending on competition always be better than them)

Tip:

Can use 18.000 - 20.000 - 22.000 and 24.000 for MTBF for 4 segments

Marketing:

Price - you want it to be about a 40% contribution margin if possible

Elite and Nano - Max Price

Core and Thrift - A couple of dollars above the others (be competitive but keep higher due to your higher MTBF)

Sales/promo budget:

- round 1: 1500 

- round 2: 1500 

- round 3: 1400 

- round 4: 1300

Tip:

If you like high sales and net profit right from round 1, can use 1.200 - 1.400 - 1.600 and 2.000 in 4 rounds.

Note that round 1, 2 can have high sales and some net profit, because of strong investment in R&D, new products, add new capacity. Round 3-4 will have both highest sales and net profit, leading the game.

How to calculate Sales forecast: the formula is as follows

Benchmark prediction * .55 = sales forecast (not so good)

Last round units sold x segment growth (good)

Note to check suggestions to adjust forecast, also check customer preference.

ProductionSales forecast * 1.15 - inventory in hand = production schedule (if you have inventory on hand)
Sales forecast * 1.20  = production on hand (if you do not have inventory on hand)

Capacity:
Add capacity to each as needed to each product plan to produce 100-200 more than your current sales forecast for the next round. 

Tip:

- Keep the 2nd shift capacity as low a possible, about 50% (because 2nd shift cost is higher than first shift)

Automation:Add 1 full point (6.0 to 7.0) each round to each product.

This can be 4-4-6-8

Then 5-5-7-9

Then 6-6-8-10

Human resources: do this every round
5,000

80 hours 

Tip:
- If you really like good sales and also some good net profit from round 1, use 3.000 and 40 hours in round 1, all round 2-4 use 5.000 and 80 hours of training

TQM:
Round:

1. 1500
2. 1500
3. 1000
4. 0 (max total 4.000 reach) 

Add this amount to each section through the full TQM for all ten TQM initiatives

Or just use 1.000 for each year for all 4 years

Finance: 
Issue long term debt on right side in the amount to cover the RED number on the bottom, ex.(32,000)
Make sure the same  bottom number is positive 5,000 at least.

Tip

- Round 1-2 use both issue stocks and long term loans

- Round 3 have over 50 million cash in hand, can use only long term loan or not at all

- Round 4 can retire all stocks, also retire some long term loan, pay very small dividends and keep about 50 to 80 million cash in hand.

FREE SUPPORT - HELP TO CREATE EXCEL FOR FREE

(USE EXCEL FILE FOR R&D MANAGEMENT, SALES FORECAST, PRODUCTION CALCULATION TO WIN THE GAME)

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

PERSONAL SUPPORT & GUIDES TO WIN THE GAME

EXCEL FILE

FOR SALES FORECAST

AND PRODUCTION

CALCULATION

NOW IT IS FREE !

DOWNLOAD HERE

Also

Free Personal Support for

ROUND 1

ROUND 2

Email: 

This email address is being protected from spambots. You need JavaScript enabled to view it.

THE E-BOOK

IS NOW FREE

WIN WITH 5 DIFFERENT STRATEGIES

ALL WINNING GUIDES AND TIPS

WIN ALL 8 ROUNDS

Update 2018

New Stratetgies

Download here - LINK

And Free Personal Support

for Round 1 and Round 2

Email: 

This email address is being protected from spambots. You need JavaScript enabled to view it.

Free Excel file for CompXM - LINK

Personal Support for CompXM, Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

CompXM 2022

Free Winning Guide and Tips - Personal Support 

MBA SIMULATION GAMES

MBA Simulation XM Guides and Tips 

with Excel file for Sales Forecast & Production Calculation

You can download free Excel file here - LINK TO ALL EXCEL FILES

or Download Capsim Capstone Excel file here - LINK 2

Or email to: This email address is being protected from spambots. You need JavaScript enabled to view it. to get Free support for creating excel file.

Free Personal Support for Rounds 1-2

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

LINK TO VIDEO GUIDE: https://www.youtube.com/watch?v=V_8PA41ecbc