This is the first and simplest of three examples to show how you can use Excel and
KDCalc to develop robust training simulations.
Here the user decides how much to spend on marketing and what price to charge
for each unit. From these decisions, the simulation determines the projected demand.
The user can click on the "Get Feedback on my Marketing Plan" to receive feedback
from the VP of Marketing.
TANRO Marketing Plan
production and marketing
Marketing Investment Pricing Projected Demand
Get Feedback on my Marketing Plan
"Developing eLearning Simulations With Tools You Already Know"
E-Learning Developer's Journal
I need you to make decisions on both the Price of the
mowers and the Marketing Investment before I can give you
Thank You for the Feedback
Calculating Pojected Demand from Simulated Marketing Research D
0 0 Learner_Price_Value Learner_Price_Level = LOO
Level Value Learner_MktInv_Level = LOO
0 0 Learner_MktInv_Value
Projected Demand Projected_Demand = OFFSE
Price Normalizer Marketing Normalizer
Level Price Level Investment
0 -99,999,999 0 -99,999,999
1 100 1 1
2 300 2 400,000
3 400 3 500,000
4 430 4 700,000
5 500 5 1,000,000
Calculating Feedback in a Spreadsheet
I need you to make decisions on both the Price of the mowers and the Marketing Investment
Label of the Feedback Rule
Blank If Rule is FALSE Feedback text - only used if the Feedback Rule is TRUE.
No Decisions Made
need you to make decisions on and Price of the mowers a
I need you to make decisionsI on both the Price of the mowersboth the Marketing Investment
Price Below Zero
You cannot have a price below 0. Fix this immediately!
Price is too low
Your price of $0 is kind of low. Although you will sell a lot of mow
Price is too high
Your price of $0 is a little high. I think you could drive higher dem
Marketing Investment Below Zero
You cannot have a marketing investment below 0. Fix this imm
Marketing Investment Too Low
$0 is not a substantial marketing investment. You need to get th
Marketing Investment Too High
$0 is substantially out of our budget. Let us try to get the numb
Projected Demand too low
Your projected demand is not very high. Try adjusting your Price
Your marketing plan looks good. $0 is a reasonable price, and w
Nothing interesting to say (no other feedback rules from above fired,but I should still say som
I don't have anything interesting to tell you.
arketing Research Data
Learner_Price_Level = LOOKUP(Learner_Price_Value, Normalized_Price_Values, Normalized_Price_Levels)
Learner_MktInv_Level = LOOKUP(Learner_MktInv_Value, Normalized_MktInv_Values, Normalized_MktInv_Levels)
Projected_Demand = OFFSET(ProjectedDemandMatrix, Learner_Price_Level, Learner_MktInv_Level)
Projected Demand Matrix
Price 0 1 2 3 4 5
0 0 0 0 0 0 0
1 0 175,000 437,500 546,875 656,250 875,000
2 0 43,750 109,375 262,500 328,125 437,500
3 0 32,156 87,500 218,750 253,750 293,125
4 0 21,875 43,750 75,264 109,000 132,157
5 0 10,937 21,875 27,084 30,137 32,650
and the Marketing Investment before I can give you feedback.
eedback Rule is TRUE. Key Template
both the Price of the mowers and the Marketing Investment before I can give you feedback.
Fix this immediately!
hough you will sell a lot of mowers I think you will have trouble making a profit with such a low price.
hink you could drive higher demand with a lower price.
estment below 0. Fix this immediately!
investment. You need to get the word out if you want to sell enough mowers to break even.
get. Let us try to get the number down.
y high. Try adjusting your Price and Marketing Investment to drive higher demand.
$0 is a reasonable price, and with a $0 marketing budget we will achieve great market penetration.
e fired,but I should still say something)
o tell you.