| 练习01 · 指标与对标 | ||||
| 课程配套练习 ｜ 数据来自《模拟数据库-云璟90天.xlsx》 | ||||
| 练习目的 | ||||
| 会算 OCC/ADR/RevPAR，并用手上的竞品房价算 MPI/ARI/RGI，判断本店在市场上的位置。 | ||||
| 怎么做 | ||||
| 1 | 打开「数据」页，看两周的每日经营与竞品房价 | — | — | — |
| 2 | 在「练习」页白区算出 OCC/ADR/RevPAR | — | — | — |
| 3 | 再用竞品 ADR/OCC 算 MPI/ARI/RGI，写在对应白区 | — | — | — |
| 4 | 对照「答案」页检查，并写出一句话结论 | — | — | — |
| 图例 | ||||
| 输入区 | 浅黄底 + 边框 | — | — | — |
| 公式区 | 白底 + 边框 | — | — | — |
| 参考区 | 灰底 + 斜体 | — | — | — |
| 标题行 | 深蓝底白字 | — | — | — |
| 答案见「答案」页。改输入区（浅黄）即可重算，公式区（白底）请勿手改。 | ||||
| 数据 · 两周每日经营 + 竞品房价 | ||||||||||||||||
| 取自模拟数据库 | ||||||||||||||||
| 日期 | 已售房 | 可用房 | ADR | OCC | RevPAR | 客房收入 | 竞品A_ADR | 竞品A_OCC | 竞品B_ADR | 竞品B_OCC | 竞品C_ADR | 竞品C_OCC | 竞品D_ADR | 竞品D_OCC | 竞品E_ADR | 竞品E_OCC |
| 2026-03-11 | 216 | 300 | 546.5 | 72.0% | 393.5 | 118050 | 811 | 75.3% | 677 | 68.1% | 557 | 66.2% | 704 | 69.2% | 507 | 77.4% |
| 2026-03-12 | 220 | 300 | 556 | 73.3% | 407.7 | 122310 | 826 | 75.4% | 648 | 67.7% | 544 | 78.0% | 664 | 73.2% | 494 | 76.6% |
| 2026-03-13 | 235 | 300 | 569.1 | 78.3% | 445.8 | 133750 | 935 | 80.2% | 694 | 83.7% | 555 | 78.1% | 752 | 82.1% | 521 | 79.3% |
| 2026-03-14 | 242 | 300 | 613.2 | 80.7% | 494.7 | 148400 | 966 | 78.0% | 754 | 84.9% | 609 | 75.2% | 743 | 78.7% | 584 | 85.6% |
| 2026-03-15 | 222 | 300 | 556 | 74.0% | 411.4 | 123430 | 868 | 73.6% | 667 | 72.5% | 542 | 75.8% | 705 | 71.6% | 500 | 78.0% |
| 2026-03-16 | 212 | 300 | 531 | 70.7% | 375.3 | 112580 | 859 | 70.2% | 664 | 72.7% | 538 | 73.2% | 654 | 65.5% | 483 | 65.9% |
| 2026-03-17 | 210 | 300 | 538.3 | 70.0% | 376.8 | 113040 | 861 | 73.3% | 652 | 75.2% | 547 | 68.0% | 683 | 64.7% | 504 | 69.6% |
| 2026-03-31 | 254 | 300 | 609.8 | 84.7% | 516.3 | 154890 | 896 | 82.5% | 748 | 86.7% | 599 | 80.9% | 729 | 79.9% | 553 | 89.5% |
| 2026-04-01 | 286 | 300 | 659.5 | 95.3% | 628.7 | 188620 | 1044 | 99.0% | 787 | 91.7% | 654 | 99.0% | 851 | 98.4% | 633 | 99.0% |
| 2026-04-02 | 294 | 300 | 692 | 98.0% | 678.2 | 203450 | 1046 | 99.0% | 799 | 97.8% | 687 | 99.0% | 841 | 99.0% | 629 | 93.4% |
| 2026-04-03 | 298 | 300 | 730.4 | 99.3% | 725.5 | 217650 | 1138 | 99.0% | 819 | 93.4% | 697 | 99.0% | 867 | 99.0% | 673 | 95.4% |
| 2026-04-04 | 298 | 300 | 755.7 | 99.3% | 750.7 | 225210 | 1143 | 95.1% | 883 | 93.0% | 774 | 99.0% | 931 | 99.0% | 675 | 96.6% |
| 2026-04-05 | 297 | 300 | 692.1 | 99.0% | 685.2 | 205550 | 1007 | 99.0% | 807 | 99.0% | 668 | 99.0% | 836 | 99.0% | 599 | 91.1% |
| 2026-04-06 | 237 | 300 | 583.7 | 79.0% | 461.1 | 138340 | 880 | 76.1% | 711 | 80.5% | 578 | 83.4% | 776 | 82.2% | 565 | 76.0% |
| 练习 · 指标与对标 | ||||||
| 白区=您算 | ||||||
| A. 基础指标（任选 3 天） | ||||||
| 日期 | 已售房 | 可用房 | ADR | OCC | RevPAR | 客房收入 |
| 2026-03-11 | 216 | 300 | 546.5 | 0.72 | 393.47999999999996 | 118044 |
| 2026-03-12 | 220 | 300 | 556 | 0.7333333333333333 | 407.7333333333333 | 122320 |
| 2026-03-13 | 235 | 300 | 569.1 | 0.7833333333333333 | 445.795 | 133738.5 |
| — | — | — | — | — | — | — |
| B. 市场对标（用展会周 7 天均值，数据行 11–17） | ||||||
| 对象 | ADR | OCC | MPI | ARI | RGI | 结论 |
| 本店(周均) | 674.7428571428571 | 0.9352380952380953 | — | — | — | — |
| 竞品A | 1022 | 0.9280428571428571 | 1 | 1 | 1 | — |
| 竞品B | 793.4285714285714 | 0.9172714285714285 | 0.9883933931622616 | 0.7763488957226726 | 0.7673381193211072 | — |
| 竞品C | 665.2857142857143 | 0.9418428571428572 | 1.014870002924742 | 0.650964495387196 | 0.6606443393375068 | — |
| 竞品D | 833 | 0.9378571428571428 | 1.0105752505272232 | 0.815068493150685 | 0.8236880466625998 | — |
| 竞品E | 618.1428571428571 | 0.9158714285714286 | 0.9868848421409111 | 0.6048364551299972 | 0.5969039295420355 | — |
| — | — | — | — | — | — | — |
| C. 一句话结论：本店 ADR 相对竞品处于__档，RGI__1 表示市场份额__预期，应__（提价/放量/维持）。 | ||||||
| 答案 · 指标与对标 | |
| 公式与要点 | |
| 公式 | |
| OCC | = 已售房 / 可用房 |
| ADR | #NAME? |
| RevPAR | #NAME? |
| MPI | #NAME? |
| ARI | #NAME? |
| RGI | #NAME? |
| 要点 | |
| RGI>1 才说明「量价双优」；只盯 ADR 会忽略份额。展会周 ADR 冲高但 OCC 已近满，此时应保价而非再放量。 | |