| A | B | C | D | E | F | G | H | I | J | K | L | M | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | P3 - Simulation of RoI in various cases. ION provide service to Privately Publising Entity (PPE). | White = Fixed/Formulas | Orange = Editable | White = Fixed/Formulas | Orange = Editable | White = Fixed/Formulas | Orange = Editable | White = Fixed/Formulas | Orange = Editable | White = Fixed/Formulas | Orange = Editable | |||
2 | Put numbers in the Orange cells | All prices in USD. They have a $ before them | B2B | Variable | Normal | 5000 copies | Small | 1500 copies | Hobby | 200 copies | Local / Art | 20-50 copies | ||
3 | Time | Occurance | Note! These are only estimates. | Amount | Balance | Amount | Balance | Amount | Balance | Amount | Balance | Amount | Balance | |
4 | - | Decision by PPE to go ahead. | Game Copies | 5000 copies | $0 | 5000 copies | $0 | 2000 copies | $0 | 200 copies | $0 | 50 copies | $0 | |
5 | START | P3 Contract signed | P3 start fee, to ION (per game) from PPE | P3&Desig/Dev fee | -$15,000 | Flat fee | -$7,900 | Flat fee | -$3,000 | Flat fee | -$900 | Flat fee | -$500 | |
6 | 4 months | Beta - Asset complete | Games sold on Crowdfunding (Run by PPE, ION advice) | 800 copies | $26,400 | 2000 copies | $142,100 | 600 copies | $23,550 | 100 copies | $6,600 | 0 copies | -$500 | |
7 | 5 months | Crowd funding end | Games sold on Pledge Manager | 300 copies | $45,030 | 500 copies | $187,100 | 100 copies | $28,860 | not included | $6,690 | not included | -$320 | |
8 | 7 months | Manufacturing start | Printing start cost per game (30% of the cost) | $3 | $30,030 | $18 | $97,100 | $5 | $18,860 | $15 | $3,690 | $30 | -$1,820 | |
9 | 9 months | Manufacturing end (EXW) | Printing/game remaining 70% | $7 | -$4,970 | $7 | $62,100 | $7 | $4,860 | $15 | $690 | $30 | -$3,320 | |
10 | 9 months | Manufacturing end (EXW) | Manufacturing, proof and file handling by ION | $1 | -$9,970 | $1 | $57,100 | $2 | $860 | $5 | -$310 | $25 | -$4,570 | |
11 | 9 months | Manufacturing end (EXW) | Freigt Forward | $1 | -$14,970 | $1 | $52,100 | $2 | -$3,140 | $4 | -$1,110 | $10 | -$5,070 | |
12 | 9 months | Manufacturing end (EXW) | Retailer Preorder | 300 copies | -$3,585 | 100 copies | $57,600 | 150 copies | $1,728 | 75 copies | $3,015 | not included | -$4,960 | |
13 | 11 months | Ships arrive at port | Customs / VAT | $2 | -$14,035 | $5 | $32,900 | $3 | -$3,593 | $6 | $1,723 | $0 | -$4,960 | |
14 | 12 months | Game available in warehouse | Distributor Back oprders | 300 copies | -$5,755 | 0 copies | $32,900 | 300 copies | $3,488 | 0 copies | $1,723 | 0 copies | -$4,960 | |
15 | 12 months | Game available in warehouse | Distributor back order sales by ION | 300 copies | -$7,825 | 0 copies | $32,900 | 300 copies | $1,718 | not included | $1,723 | not included | -$4,960 | |
16 | 12 months | Game available in warehouse | ION Insurance, Freight, VAT & Customs handling by ION | $1 | -$12,825 | $1 | $27,900 | $2 | -$2,283 | $3 | $1,123 | $10 | -$5,460 | |
17 | 12 months | Game available in warehouse | Warehousing (1 year) by ION | $0.20 | -$13,485 | $0.20 | $27,420 | $0.20 | -$2,453 | $0.20 | $1,118 | not included | -$5,460 | |
18 | Inventory and profit after production | 3300 copies | -$13,485 | 2400 copies | $27,420 | 850 copies | -$2,453 | 25 copies | $1,118 | 50 copies | -$5,460 | |||
19 | TOTAL COST PER GAME | $15.29 | $33.14 | $20.86 | $48.66 | $105.00 | ||||||||
20 | MSRP | $69 | $100 | $59 | $100 | $200 | ||||||||
21 | Copies sold, entire print run | 5000 copies | 5000 copies | 2000 copies | 200 copies | 50 copies | ||||||||
22 | % sold by ION of Inventory | 25% | 25% | 25% | 25% | 25% | ||||||||
23 | Inventory copies sold by ION | 825 copies | 600 copies | 212 copies | 6 copies | 0 copies | ||||||||
24 | Average price (% of MSRP) copies sold from warehouse | 75% | 75% | 64% | 85% | 100% | ||||||||
25 | Result afte projected 12 months in warehous (total 24 m) | $128,828 | $177,420 | $24,765 | $2,883 | $4,540 | ||||||||
26 | RoI | 169% | 107% | 59% | 30% | 86% | ||||||||
27 | RoI initial investment | 858.85% | 2245.82% | 825.51% | 320.33% | 908.00% | ||||||||
28 | Sales needed at MSRP for break even | 1847 copies | 2762 copies | 1179 copies | 162 copies | 44 copies |