| Business Plan Spreadsheets| RDL's UK Model Business Plan |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | Sales Forecast |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Year |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | Unit Sales | 2010 | 2011 | 2012 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | | Utopia [U] | 1 | 2 | 4 | 8 | 16 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative U | 1 | 3 | 7 | 15 | 31 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | | Mother Hawks [MH] | 3 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative MH | 3 | 3 | 3 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | | Gavin Hawks [GH] | 5,000 | 10,000 | 40,000 | 80,000 | 160,000 | 130,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative GH | 5,000 | 15,000 | 55,000 | 135,000 | 295,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | 425,000 | | PATCO | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative PATCO | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | | PATC | 5 | 10 | 40 | 80 | 160 | 130 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative PATC | 5 | 15 | 55 | 135 | 295 | 425 | 425 | 425 | 425 | 425 | 425 | 425 | 425 | 425 | 425 | 425 | 425 | 425 | 425 | 425 | 425 | 425 | | GaviHas [DH] | 1,600 | 3,200 | 6,400 | 12,800 | 25,600 | 20,800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative DH | 1,600 | 4,800 | 11,200 | 24,000 | 49,600 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | 70,400 | | Amalric III [AIII] | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative AIII | 5 | 10 | 15 | 20 | 24 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | | Gia & Super GiaBats [GB] | 8,000 | 16,000 | 32,000 | 64,000 | 128,000 | 104,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative GB | 8,000 | 24,000 | 56,000 | 120,000 | 248,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | 352,000 | | WFI Mmeals/day mM | 55 | 110 | 219 | 438 | 876 | 712 | 712 | 712 | 712 | 712 | 712 | 712 | 712 | 712 | 712 | 712 | 712 | 712 | 712 | 712 | 712 | 712 | | Cummulative mM | 55 | 164 | 383 | 821 | 1,697 | 2,409 | 3,121 | 3,833 | 4,544 | 5,256 | 5,968 | 6,680 | 7,391 | 8,103 | 8,815 | 9,527 | 10,238 | 10,950 | 11,662 | 12,374 | 13,085 | 13,797 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | RDL's US Model Business Plan |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | Sales Forecast |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Year |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | Unit Sales | 2010 | 2011 | 2012 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | | Utopia [U] |
| 2 | 4 | 8 | 16 | 32 | 64 | 128 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative U |
| 1 | 5 | 13 | 29 | 61 | 125 | 253 | 253 | 253 | 253 | 253 | 253 | 253 | 253 | 253 | 253 | 253 | 253 | 253 | 253 | 253 | | Mother Hawks [MH] |
| 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | | Cummulative MH |
|
| 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36 | 39 | 42 | 45 | 48 | 51 | 54 | 57 | 60 | | Gavin Hawks [GH] |
| 5,000 | 10,000 | 20,000 | 40,000 | 80,000 | 160,000 | 320,000 | 640,000 | 1,280,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative GH |
| 5,000 | 15,000 | 35,000 | 75,000 | 155,000 | 315,000 | 635,000 | 1,275,000 | 2,555,000 | 2,555,000 | 2,555,000 | 2,555,000 | 2,555,000 | 2,555,000 | 2,555,000 | 2,555,000 | 2,555,000 | 2,555,000 | 2,555,000 | 2,555,000 | 2,555,000 | | PATCO |
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | Cummulative PATCO |
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | | PATC |
| 5 | 10 | 20 | 40 | 80 | 160 | 320 | 640 | 1,280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative PATC |
| 5 | 15 | 35 | 75 | 155 | 315 | 635 | 1,275 | 2,555 | 2,555 | 2,555 | 2,555 | 2,555 | 2,555 | 2,555 | 2,555 | 2,555 | 2,555 | 2,555 | 2,555 | 2,555 | | GaviHas [DH] |
| 3,200 | 6,400 | 12,800 | 25,600 | 51,200 | 102,400 | 204,800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative DH |
| 1,600 | 8,000 | 20,800 | 46,400 | 97,600 | 200,000 | 404,800 | 404,800 | 404,800 | 404,800 | 404,800 | 404,800 | 404,800 | 404,800 | 404,800 | 404,800 | 404,800 | 404,800 | 404,800 | 404,800 | 404,800 | | Amalric III [AIII] |
| 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative AIII |
| 28 | 56 | 84 | 112 | 141 | 169 | 197 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | | Gia & Super GiaBats [GB] |
| 16,000 | 32,000 | 64,000 | 128,000 | 256,000 | 512,000 | 1,024,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative GB |
| 16,000 | 48,000 | 112,000 | 240,000 | 496,000 | 1,008,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | 2,032,000 | | WFI Mmeals/day mM |
| 55 | 274 | 712 | 1,588 | 3,340 | 6,844 | 13,852 | 13,852 | 13,852 | 13,852 | 13,852 | 13,852 | 13,852 | 13,852 | 13,852 | 13,852 | 13,852 | 13,852 | 13,852 | 13,852 | 13,852 | | Cummulative mM |
| 55 | 329 | 1,040 | 2,628 | 5,968 | 12,812 | 26,663 | 40,515 | 54,367 | 68,219 | 82,070 | 95,922 | 109,774 | 123,626 | 137,477 | 151,329 | 165,181 | 179,033 | 192,884 | 206,736 | 220,588 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | RDL's UK + US Model Business Plan |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | Sales Forecast |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Year |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | Unit Sales | 2010 | 2011 | 2012 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | | Utopia [U] | 1 | 4 | 8 | 16 | 32 | 45 | 64 | 128 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative U | 1 | 5 | 13 | 29 | 61 | 106 | 170 | 298 | 298 | 298 | 298 | 298 | 298 | 298 | 298 | 298 | 298 | 298 | 298 | 298 | 298 | 298 | | Mother Hawks [MH] | 3 | 3 | 3 | 6 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | | Cummulative MH | 3 | 6 | 9 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36 | 39 | 42 | 45 | 48 | 51 | 54 | 57 | 60 | 63 | 66 | 69 | | Gavin Hawks [GH] | 5,000 | 15,000 | 50,000 | 100,000 | 200,000 | 210,000 | 160,000 | 320,000 | 640,000 | 1,280,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative GH | 5,000 | 20,000 | 70,000 | 170,000 | 370,000 | 580,000 | 740,000 | 1,060,000 | 1,700,000 | 2,980,000 | 2,980,000 | 2,980,000 | 2,980,000 | 2,980,000 | 2,980,000 | 2,980,000 | 2,980,000 | 2,980,000 | 2,980,000 | 2,980,000 | 2,980,000 | 2,980,000 | | PATCO | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | Cummulative PATCO | 1 | 2 | 3 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | | PATC | 5 | 15 | 50 | 100 | 200 | 210 | 160 | 320 | 640 | 1,280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative PATC | 5 | 20 | 70 | 170 | 370 | 580 | 740 | 1,060 | 1,700 | 2,980 | 2,980 | 2,980 | 2,980 | 2,980 | 2,980 | 2,980 | 2,980 | 2,980 | 2,980 | 2,980 | 2,980 | 2,980 | | GaviHas [DH] | 1,600 | 6,400 | 12,800 | 25,600 | 51,200 | 72,000 | 102,400 | 204,800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative DH | 1,600 | 8,000 | 20,800 | 46,400 | 97,600 | 169,600 | 272,000 | 476,800 | 476,800 | 476,800 | 476,800 | 476,800 | 476,800 | 476,800 | 476,800 | 476,800 | 476,800 | 476,800 | 476,800 | 476,800 | 476,800 | 476,800 | | Amalric III [AIII] | 5 | 33 | 33 | 33 | 33 | 33 | 28 | 28 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative AIII | 5 | 38 | 71 | 104 | 137 | 170 | 198 | 226 | 254 | 254 | 254 | 254 | 254 | 254 | 254 | 254 | 254 | 254 | 254 | 254 | 254 | 254 | | Gia & Super GiaBats [GB] | 8,000 | 32,000 | 64,000 | 128,000 | 256,000 | 360,000 | 512,000 | 1,024,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | Cummulative GB | 8,000 | 40,000 | 104,000 | 232,000 | 488,000 | 848,000 | 1,360,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | 2,384,000 | | WFI Mmeals/day mM | 55 | 164 | 493 | 1,150 | 2,464 | 4,052 | 7,556 | 14,564 | 14,564 | 14,564 | 14,564 | 14,564 | 14,564 | 14,564 | 14,564 | 14,564 | 14,564 | 14,564 | 14,564 | 14,564 | 14,564 | 14,564 | | Cummulative mM | 55 | 219 | 712 | 1,862 | 4,325 | 8,377 | 15,932 | 30,496 | 45,059 | 59,623 | 74,186 | 88,750 | 103,313 | 117,877 | 132,440 | 147,004 | 161,567 | 176,131 | 190,694 | 205,258 | 219,821 | 234,385 |
| |