宿泊実績分析【年間】の見方

宿泊実績分析【年間】の見方

(1)このレポートでわかること。

宿泊実績について、当月から最大24ヶ月(最短で当月を含む過去13か月分)の推移を表示します。
月ごとの宿泊実績状況を、昨年の同月と比較しながら確認できます。 また、エクセルでの出力も可能です。

(2)出力イメージ

823img2

(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"
↑Pagetop