宿泊実績分析【年間】の見方
(1)このレポートでわかること。
宿泊実績について、当月から最大24ヶ月(最短で当月を含む過去13か月分)の推移を表示します。
月ごとの宿泊実績状況を、昨年の同月と比較しながら確認できます。 また、エクセルでの出力も可能です。
(2)出力イメージ

(3)出力項目の詳細
※ その月に、何件チェックアウトされる予約があったのかを集計しています。
例えば、4月に予約された4月チェックアウト宿泊と、3月など過去に予約された4月チェックアウト宿泊も含めて集計しています。
※ 集計は、毎日深夜に行っているため、本日チェックアウトされた件数はカウントしていません。
| 項目名 | 出力単位 |
| 宿泊延人数(人泊数) | 「宿泊延人数」 |
| 宿泊延室数 | 「宿泊延室数」 |
| 宿泊売上 | 「宿泊売上」 |
| 宿泊平均室売上 | 「宿泊売上」 ÷ 「宿泊延室数」(小数点以下は四捨五入) |
| 宿泊1人あたり売上 | 「宿泊売上」 ÷ 「宿泊延人数」(小数点以下は四捨五入) |
| 平均利用人数 | 「大人人数 + 子供人数」 ÷ 「宿泊件数」(小数点以下は四捨五入) |
| 平均泊数 | 「泊数合計」 ÷ 「宿泊件数」(小数点以下は四捨五入) |
| 宿泊件数 | 「宿泊件数」 |
| キャンセル件数 | 「キャンセル件数」 |
| ノーショウ件数 | 「ノーショウ件数」 |
ダウンロードデータの形式
| ダウンロードすると、csv形式で出力されます。出力結果は下記のような順番で出力されています。エクセルで開くことも可能です。 |
| "宿泊実績年間分析","","","","","","","","","","","" "月","年","宿泊延人数(人泊数)","宿泊延室数","宿泊売上(円)","宿泊平均室売上(円)","宿泊1人あたり売上(円)","平均利用人数","平均泊数","宿泊件数","キャンセル件数","ノーショウ件数" "9月","2005年","100","200","3000","400000","250000","500","2","500","20","10" "9月","2004年","0","0","0","0","0","0","0","0","0","0" "10月","2005年","100","200","3000","400000","250000","500","2","500","20","10" "10月","2004年","0","0","0","0","0","0","0","0","0","0" "11月","2005年","100","200","3000","400000","250000","500","2","500","20","10" "11月","2004年","200","400","6000","800000","500000","1000","4","1000","40","20" "12月","2005年","100","200","3000","400000","250000","500","2","500","20","10" "12月","2004年","200","400","6000","800000","500000","1000","4","1000","40","20" "1月","2006年","100","200","3000","400000","250000","500","2","500","20","10" "1月","2005年","200","400","6000","800000","500000","1000","4","1000","40","20" "2月","2006年","100","200","3000","400000","250000","500","2","500","20","10" "2月","2005年","200","400","6000","800000","500000","1000","4","1000","40","20" "3月","2006年","100","200","3000","400000","250000","500","2","500","20","10" "3月","2005年","200","400","6000","800000","500000","1000","4","1000","40","20" "4月","2006年","100","200","3000","400000","250000","500","2","500","20","10" "4月","2005年","200","400","6000","800000","500000","1000","4","1000","40","20" "5月","2006年","100","200","3000","400000","250000","500","2","500","20","10" |