The practice of Customer Appreciation!
You are your supplier's customer->You sell to your Customer
|
Ice Cream Game |
|
|
|
|
|
Average Profit : |
|
$1,665 |
|
Average Return on Inv |
|
34% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
History |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Blend/Pack |
Period |
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
|
|
Segment |
Start |
End |
Start |
End |
Start |
End |
Start |
End |
Start |
End |
Start |
End |
Start |
End |
Start |
End |
Start |
End |
Start |
End |
Start |
End |
|
Current Raw Material |
|
10 |
|
10 |
|
10 |
|
10 |
|
7 |
|
12 |
|
12 |
|
12 |
|
10 |
|
0 |
|
0 |
|
|
Last Raw Material Cost |
|
$535 |
|
$535 |
|
$537 |
|
$539 |
|
$534 |
|
$534 |
|
$535 |
|
$536 |
|
$400 |
|
$400 |
|
$400 |
|
|
Period RM Order |
|
10 |
|
15 |
|
15 |
|
15 |
|
15 |
|
5 |
|
10 |
|
3 |
|
10 |
|
20 |
|
20 |
|
|
Willing to Pay |
|
$565 |
|
$565 |
|
$565 |
|
$565 |
|
$565 |
|
$540 |
|
$545 |
|
$600 |
|
$600 |
|
$600 |
|
$600 |
|
|
New RM Received |
|
|
10 |
|
15 |
|
15 |
|
12 |
|
10 |
|
5 |
|
10 |
|
3 |
|
10 |
|
20 |
|
20 |
|
New RM Cost |
|
|
$535 |
|
$537 |
|
$539 |
|
$534 |
|
$534 |
|
$535 |
|
$536 |
|
$400 |
|
$400 |
|
$400 |
|
$400 |
|
Current Finished Goods |
|
10 |
|
10 |
|
15 |
|
20 |
|
25 |
|
20 |
|
15 |
|
15 |
|
0 |
|
0 |
|
0 |
|
|
Price of Last Sale |
|
$565 |
|
$565 |
|
$565 |
|
$565 |
|
$565 |
|
$565 |
|
$565 |
|
$560 |
|
$499 |
|
$499 |
|
$499 |
|
|
New Sales Price |
|
$565 |
|
$565 |
|
$565 |
|
$565 |
|
$565 |
|
$565 |
|
$560 |
|
$499 |
|
$499 |
|
$499 |
|
$499 |
|
|
Plan to Produce |
|
10 |
|
15 |
|
15 |
|
15 |
|
5 |
|
5 |
|
10 |
|
5 |
|
20 |
|
20 |
|
20 |
|
|
Number Produced |
|
|
10 |
|
15 |
|
15 |
|
15 |
|
5 |
|
5 |
|
10 |
|
5 |
|
20 |
|
20 |
|
20 |
|
#Requested || #Sold |
|
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
20 |
20 |
20 |
20 |
20 |
20 |
20 |
20 |
|
New Finished Goods |
|
|
10 |
|
15 |
|
20 |
|
25 |
|
20 |
|
15 |
|
15 |
|
0 |
|
0 |
|
0 |
|
0 |
|
Measurements: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# WIP |
|
20 |
|
25 |
|
30 |
|
35 |
|
27 |
|
27 |
|
27 |
|
12 |
|
10 |
|
0 |
|
0 |
|
|
$ WIP |
|
$11,000 |
|
$13,825 |
|
$16,670 |
|
$19,515 |
|
$15,038 |
|
$14,883 |
|
$14,820 |
|
$6,432 |
|
$4,000 |
|
$0 |
|
$0 |
|
|
Profit |
|
$300 |
|
-$2,405 |
|
-$2,435 |
|
-$758 |
|
$310 |
|
$2,975 |
|
$240 |
|
$8,780 |
|
$5,980 |
|
$1,980 |
|
$1,980 |
|
|
ROInv |
|
3% |
|
-17% |
|
-15% |
|
-4% |
|
2% |
|
20% |
|
2% |
|
137% |
|
150% |
|
Max |
|
Max |
Last Updated on 11/28/2000
By James R. Holt
Email: holt@vancouver.wsu.edu