| 項目 | 当月(入力済み日まで) | 対売上 | |
|---|---|---|---|
| ① 売上(客数 9,650人 × 客単価 2,787円) | 26,899,137 | ||
| ② 食材費 F | -4,643,322 | 17.3% | 変動費 |
| ② ドリンク費 D | -3,081,020 | 11.5% | 変動費 |
| ③ 人件費 L(パートナー) | -3,222,444 | 12.0% | 変動費 |
| ③ 人件費 L(正社員・日按分) | -3,835,250 | 14.3% | 固定人件費 |
| ④ 家賃 R(日割り) | -2,760,600 | 10.3% | 固定費 |
| ⑤ 固定費(家賃以外:光熱・システム・広告等の日割り) | -7,839,400 | 29.1% | 固定費 |
| 営業利益 | 1,517,100 | 5.6% |
FD原価率 28.7% L比率 26.2% R比率 10.3% FL比率 55.0% FLR比率 65.2%
着地見込み:売上 26,899,137 → 営業利益 3,476,984(原価率 -・人件費率 - は直近3ヶ月の実績率)
| 月 | 売上 | POS売上(正データ) | 予算 | 達成率 | 前年 | 昨対 | 原価 | 原価率 | 人件費 | 人件費率 | 固定費 | 営業利益 | 営業利益率 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12月 | 24,829,035 | - | 33,800,000 | 73.5% | 24,393,831 | 101.8% | 7,777,651 | 31.3% | 7,470,447 | 30.1% | 10,200,000 | -619,063 | -2.5% |
| 1月 | 23,334,891 | - | 25,300,000 | 92.2% | 21,564,366 | 108.2% | 5,795,195 | 24.8% | 6,308,606 | 27.0% | 9,200,000 | 2,031,090 | 8.7% |
| 2月 | 23,580,182 | - | 27,500,000 | 85.7% | 23,495,900 | 100.4% | 6,112,552 | 25.9% | 6,974,097 | 29.6% | 9,200,000 | 1,293,533 | 5.5% |
| 3月 | 31,520,317 | - | 35,000,000 | 90.1% | 29,580,668 | 106.6% | 8,211,473 | 26.1% | 6,851,191 | 21.7% | 9,300,000 | 7,157,653 | 22.7% |
| 4月 | 32,214,828 | - | 34,000,000 | 94.7% | 29,710,297 | 108.4% | 5,256,535 | 16.3% | 7,004,284 | 21.7% | 9,300,000 | 10,654,009 | 33.1% |
| 5月 | 32,226,250 | - | 35,500,000 | 90.8% | 31,697,299 | 101.7% | 8,158,838 | 25.3% | 7,965,505 | 24.7% | 9,300,000 | 6,801,907 | 21.1% |
| 6月 | 26,362,588 | - | 35,000,000 | 75.3% | 27,182,812 | 97.0% | 7,149,684 | 27.1% | 7,720,968 | 29.3% | 9,300,000 | 2,191,936 | 8.3% |
| 7月(着地見込) | 26,899,137 | 3,672,362 | 31,700,000 | 84.9% | 25,741,628 | 104.5% | 5,624,330 | 20.9% | 6,110,894 | 22.7% | 10,600,000 | 4,563,913 | 17.0% |
| 店 | データ | 売上(今月) | 目標(同期間) | 達成率 | ペース着地 | 予算 | 予算GAP | 昨年同月 | 昨対 | 客数 | 客単価 | 前年同日比 売上 | 同 客数 | CP杯/日(目標) | 人時売上高 | 食べログ | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Lad's | 07/31 | 7,491,351 | 7,880,000 | 95.1% | 7,491,351 | 7,880,000 | -388,649 | 8,859,687 | 84.6% | 2,695 | 2,680 | - | - | 0.0 / 30 | - | 5,993 | 81 |
| 餃包 新宿店 | 07/31 | 8,533,060 | 9,000,000 | 94.8% | 8,533,060 | 9,000,000 | -466,940 | 10,093,751 | 84.5% | 3,192 | 2,673 | - | - | 0.0 / 15 | - | 10,611 | 83 |
| 餃包 東口店 | 07/31 | 7,202,364 | 7,500,000 | 96.0% | 7,202,364 | 7,500,000 | -297,636 | 7,253,384 | 99.3% | 2,587 | 2,784 | - | - | 0.0 / 15 | - | 4,778 | 73 |
| KABUKI餃子 | 07/31 | 3,389,617 | 4,000,000 | 84.7% | 3,389,617 | 4,000,000 | -610,383 | - | - | 1,153 | 2,940 | - | - | 18.7 / 10 | - | 1,641 | 35 |
| タコスKichi | 07/31 | 282,745 | 0 | - | 282,745 | - | - | - | - | 23 | 12,293 | - | - | 0.0 | - | - | - |
今日の読み 目標に対して 95.1%。残り0日で1日 388,649円 が必要(今の1日平均 249,712円)。 ピークは19時(14.3人/日)。 JDは目標の 0.0%。目標割れ。
| 項目 | 当月(入力済み日まで) | 対売上 | |
|---|---|---|---|
| ① 売上(客数 2,695人 × 客単価 2,680円) | 7,491,351 | ||
| ② 食材費 F | -1,221,693 | 16.3% | 変動費 |
| ② ドリンク費 D | -1,035,169 | 13.8% | 変動費 |
| ③ 人件費 L(パートナー) | -1,277,353 | 17.1% | 変動費 |
| ③ 人件費 L(正社員・日按分) | -1,069,500 | 14.3% | 固定人件費 |
| ④ 家賃 R(日割り) | -660,000 | 8.8% | 固定費 |
| ⑤ 固定費(家賃以外:光熱・システム・広告等の日割り) | -2,140,000 | 28.6% | 固定費 |
| 営業利益 | 87,636 | 1.2% |
FD原価率 30.1% L比率 31.3% R比率 8.8% FL比率 61.5% FLR比率 70.3%
着地見込み:売上 7,491,351 → 営業利益 918,677(原価率 22.7%・人件費率 27.7% は直近3ヶ月の実績率)
売上・客数=POS。原価=売上 × 原価率 30.1%(当月実績または直近3ヶ月)。人件費=その日のパートナー人件費+正社員給与の日按分。固定費=月額の日割り。近似値。正確な数字はマスタースプレッドシートの「利益」タブ。
| 日 | 売上 | 客数 | 客単価 | 原価(推定) | 人件費 | 固定費 | 推定利益 |
|---|---|---|---|---|---|---|---|
| 07/01 | 195,736 | 83 | 2,358 | 58,968 | 76,185 | 90,323 | -29,740 |
| 07/02 | 182,538 | 75 | 2,434 | 54,992 | 76,825 | 90,323 | -39,601 |
| 07/03 | 311,935 | 123 | 2,536 | 93,974 | 70,537 | 90,323 | 57,101 |
| 07/04 | 286,481 | 119 | 2,407 | 86,306 | 75,427 | 90,323 | 34,425 |
| 07/05 | 274,426 | 110 | 2,495 | 82,674 | 88,819 | 90,323 | 12,610 |
| 07/07 | 215,155 | 73 | 2,947 | 64,818 | 84,803 | 90,323 | -24,788 |
| 07/08 | 167,283 | 73 | 2,292 | 50,396 | 76,305 | 90,323 | -49,740 |
| 07/09 | 182,485 | 73 | 2,500 | 54,976 | 89,938 | 90,323 | -52,751 |
| 07/10 | 359,570 | 112 | 3,210 | 108,325 | 70,768 | 90,323 | 90,155 |
| 07/11 | 357,762 | 129 | 2,773 | 107,780 | 34,500 | 90,323 | 125,159 |
| 07/12 | 257,359 | 90 | 2,860 | 77,533 | 66,553 | 90,323 | 22,951 |
| 07/13 | 198,892 | 69 | 2,882 | 59,919 | 87,063 | 90,323 | -38,412 |
| 07/14 | 177,144 | 68 | 2,605 | 53,367 | 94,028 | 90,323 | -60,574 |
| 07/15 | 183,635 | 80 | 2,295 | 55,322 | 70,515 | 90,323 | -32,525 |
| 07/16 | 211,855 | 75 | 2,825 | 63,824 | 75,184 | 90,323 | -17,475 |
| 07/17 | 362,384 | 97 | 3,736 | 109,173 | 65,064 | 90,323 | 97,825 |
| 07/18 | 303,385 | 115 | 2,638 | 91,398 | 62,484 | 90,323 | 59,180 |
| 07/19 | 302,993 | 112 | 2,705 | 91,280 | 79,982 | 90,323 | 41,408 |
| 07/20 | 287,008 | 115 | 2,496 | 86,465 | 80,180 | 90,323 | 30,040 |
| 07/21 | 148,436 | 56 | 2,651 | 44,718 | 76,699 | 90,323 | -63,304 |
| 07/22 | 186,605 | 78 | 2,392 | 56,217 | 97,155 | 90,323 | -57,090 |
| 07/23 | 308,724 | 107 | 2,885 | 93,007 | 100,151 | 90,323 | 25,243 |
| 07/24 | 267,309 | 106 | 2,522 | 80,530 | 81,167 | 90,323 | 15,290 |
| 07/25 | 366,471 | 123 | 2,979 | 110,404 | 58,860 | 90,323 | 106,885 |
| 07/26 | 268,283 | 100 | 2,683 | 80,824 | 60,514 | 90,323 | 36,622 |
| 07/27 | 228,930 | 93 | 2,462 | 68,968 | 83,759 | 90,323 | -14,119 |
| 07/28 | 181,032 | 80 | 2,263 | 54,538 | 73,774 | 90,323 | -37,603 |
| 07/29 | 235,231 | 85 | 2,767 | 70,866 | 67,641 | 90,323 | 6,401 |
| 07/30 | 212,743 | 76 | 2,799 | 64,091 | 103,862 | 90,323 | -45,533 |
| 07/31 | 269,561 | 0 | - | 81,209 | 34,500 | 90,323 | 63,530 |
| 合計 | 7,491,351 | 2,695 | 2,780 | 2,256,862 | 2,263,242 | 2,709,690 | 261,570 |
| 日 | 売上 | 目標 | 達成率 | 差 | 客数 | 客単価 | 前年売上 | 前年比 | 前年客数 | 前年比 |
|---|---|---|---|---|---|---|---|---|---|---|
| 07/01(水) | 195,736 | 230,000 | 85.1% | -34,264 | 83 | 2,358 | - | - | - | - |
| 07/02(木) | 182,538 | 230,000 | 79.4% | -47,462 | 75 | 2,434 | - | - | - | - |
| 07/03(金) | 311,935 | 330,000 | 94.5% | -18,065 | 123 | 2,536 | - | - | - | - |
| 07/04(土) | 286,481 | 350,000 | 81.9% | -63,519 | 119 | 2,407 | - | - | - | - |
| 07/05(日) | 274,426 | 300,000 | 91.5% | -25,574 | 110 | 2,495 | - | - | - | - |
| 07/07(火) | 215,155 | 230,000 | 93.5% | -14,845 | 73 | 2,947 | - | - | - | - |
| 07/08(水) | 167,283 | 230,000 | 72.7% | -62,717 | 73 | 2,292 | - | - | - | - |
| 07/09(木) | 182,485 | 230,000 | 79.3% | -47,515 | 73 | 2,500 | - | - | - | - |
| 07/10(金) | 359,570 | 330,000 | 109.0% | 29,570 | 112 | 3,210 | - | - | - | - |
| 07/11(土) | 357,762 | 350,000 | 102.2% | 7,762 | 129 | 2,773 | - | - | - | - |
| 07/12(日) | 257,359 | 300,000 | 85.8% | -42,641 | 90 | 2,860 | - | - | - | - |
| 07/13(月) | 198,892 | 230,000 | 86.5% | -31,108 | 69 | 2,882 | - | - | - | - |
| 07/14(火) | 177,144 | 230,000 | 77.0% | -52,856 | 68 | 2,605 | - | - | - | - |
| 07/15(水) | 183,635 | 230,000 | 79.8% | -46,365 | 80 | 2,295 | - | - | - | - |
| 07/16(木) | 211,855 | 230,000 | 92.1% | -18,145 | 75 | 2,825 | - | - | - | - |
| 07/17(金) | 362,384 | 330,000 | 109.8% | 32,384 | 97 | 3,736 | - | - | - | - |
| 07/18(土) | 303,385 | 350,000 | 86.7% | -46,615 | 115 | 2,638 | - | - | - | - |
| 07/19(日) | 302,993 | 310,000 | 97.7% | -7,007 | 112 | 2,705 | - | - | - | - |
| 07/20(月) | 287,008 | 270,000 | 106.3% | 17,008 | 115 | 2,496 | - | - | - | - |
| 07/21(火) | 148,436 | 230,000 | 64.5% | -81,564 | 56 | 2,651 | - | - | - | - |
| 07/22(水) | 186,605 | 230,000 | 81.1% | -43,395 | 78 | 2,392 | - | - | - | - |
| 07/23(木) | 308,724 | 230,000 | 134.2% | 78,724 | 107 | 2,885 | - | - | - | - |
| 07/24(金) | 267,309 | 330,000 | 81.0% | -62,691 | 106 | 2,522 | - | - | - | - |
| 07/25(土) | 366,471 | 350,000 | 104.7% | 16,471 | 123 | 2,979 | - | - | - | - |
| 07/26(日) | 268,283 | 300,000 | 89.4% | -31,717 | 100 | 2,683 | - | - | - | - |
| 07/27(月) | 228,930 | 230,000 | 99.5% | -1,070 | 93 | 2,462 | - | - | - | - |
| 07/28(火) | 181,032 | 230,000 | 78.7% | -48,968 | 80 | 2,263 | - | - | - | - |
| 07/29(水) | 235,231 | 230,000 | 102.3% | 5,231 | 85 | 2,767 | - | - | - | - |
| 07/30(木) | 212,743 | 230,000 | 92.5% | -17,257 | 76 | 2,799 | - | - | - | - |
| 07/31(金) | 269,561 | 0 | - | - | 0 | - | - | - | - | - |
| 合計 | 7,491,351 | 7,880,000 | 95.1% | -388,649 | 2,695 | 2,780 | - | - | - | - |
| 時 | 客数 | 売上 | 客単価 | 人時 | 人時売上高 | 客数/人時 |
|---|---|---|---|---|---|---|
| 15時 | 4.0 | 8,768 | 2,192 | 0 | - | 0.0 |
| 16時 | 4.3 | 10,385 | 2,415 | 0 | - | 0.0 |
| 17時 | 5.1 | 12,880 | 2,525 | 0 | - | 0.0 |
| 18時 | 11.7 | 30,047 | 2,568 | 0 | - | 0.0 |
| 19時 | 14.3 | 44,729 | 3,128 | 0 | - | 0.0 |
| 20時 | 10.5 | 35,062 | 3,339 | 0 | - | 0.0 |
| 21時 | 11.1 | 33,003 | 2,973 | 0 | - | 0.0 |
| 22時 | 10.2 | 28,168 | 2,762 | 0 | - | 0.0 |
| 23時 | 6.9 | 22,334 | 3,237 | 0 | - | 0.0 |
| 24時 | 1.0 | 7,584 | 7,584 | 0 | - | 0.0 |
| 25時 | 0.4 | 3,944 | 9,860 | 0 | - | 0.0 |
| 26時 | 0.1 | 1,139 | 11,390 | 0 | - | 0.0 |
| 氏名 | 形態 | 出勤 | 労働h | 残業h | 深夜h | 正社員換算 |
|---|
| 媒体 | 日付 | 累計 | 評価 | 前回比 |
|---|---|---|---|---|
| 09/15 | 5,993 | 4.8 | - | |
| 食べログ | 09/15 | 81 | 3.09 | - |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 月 | 2 | 2 | 5 | 12 | 14 | 17 | 10 | 11 | 3 | 0 | ||||||
| 火 | 4 | 4 | 4 | 8 | 12 | 9 | 8 | 7 | 3 | 1 | ||||||
| 水 | 2 | 3 | 3 | 11 | 15 | 10 | 8 | 13 | 4 | 1 | ||||||
| 木 | 2 | 2 | 2 | 12 | 10 | 10 | 11 | 7 | 12 | 2 | ||||||
| 金 | 4 | 2 | 6 | 14 | 20 | 9 | 15 | 11 | 10 | 4 | 0 | |||||
| 土 | 8 | 9 | 11 | 12 | 15 | 14 | 11 | 13 | 6 | 2 | 0 | |||||
| 日 | 7 | 8 | 7 | 11 | 13 | 7 | 13 | 8 | 7 | 0 |
| 月 | 売上 | POS売上 | 前年 | 昨対 | 原価 | 原価率 | 人件費 | 人件費率 | 固定費 | 営業利益 |
|---|---|---|---|---|---|---|---|---|---|---|
| 12月 | 9,168,362 | - | 7,811,521 | 117.4% | 2,525,563 | 27.5% | 2,107,355 | 23.0% | 2,500,000 | 2,035,444 |
| 1月 | 8,982,646 | - | 6,659,507 | 134.9% | 2,131,516 | 23.7% | 2,107,355 | 23.5% | 2,800,000 | 1,943,775 |
| 2月 | 7,731,811 | - | 6,792,020 | 113.8% | 1,976,078 | 25.6% | 1,808,297 | 23.4% | 2,800,000 | 1,147,436 |
| 3月 | 9,299,722 | - | 8,397,318 | 110.7% | 2,452,789 | 26.4% | 2,164,269 | 23.3% | 2,800,000 | 1,882,664 |
| 4月 | 9,189,855 | - | 9,170,649 | 100.2% | 1,379,370 | 15.0% | 2,288,766 | 24.9% | 2,800,000 | 2,721,719 |
| 5月 | 9,073,717 | - | 8,829,438 | 102.8% | 2,432,069 | 26.8% | 2,541,320 | 28.0% | 2,800,000 | 1,300,328 |
| 6月 | 7,980,061 | - | 8,102,297 | 98.5% | 2,135,322 | 26.8% | 2,439,552 | 30.6% | 2,800,000 | 605,187 |
| 7月 | 7,491,351 | - | 7,505,958 | 99.8% | 2,331,498 | 31.1% | 2,367,203 | 31.6% | 2,800,000 | -7,350 |
| 8月 | 7,354,582 | - | 8,804,367 | 83.5% | 1,766,873 | 24.0% | 1,680,375 | 22.8% | 2,800,000 | 1,107,334 |
| 9月 | 3,186,058 | 3,372,822 | 8,859,687 | 36.0% | 0 | - | 0 | - | 2,800,000 | - |
| 10月 | 8,500,000 | - | 9,505,065 | 89.4% | 2,210,000 | 26.0% | 2,125,000 | 25.0% | 2,800,000 | 1,365,000 |
| 11月 | 10,000,000 | - | 10,027,161 | 99.7% | 2,600,000 | 26.0% | 2,500,000 | 25.0% | 2,800,000 | 2,100,000 |
| 順 | 商品 | 区分 | 出数 | 出数/日 | 売上 | 構成比 | 累積 | 前月比 |
|---|
今日の読み 目標に対して 94.8%。残り0日で1日 466,940円 が必要(今の1日平均 284,435円)。 ピークは19時(15.1人/日)。 JDキャンペーンは9/15開始(開始前はゼロで正常)。
| 項目 | 当月(入力済み日まで) | 対売上 | |
|---|---|---|---|
| ① 売上(客数 3,192人 × 客単価 2,673円) | 8,533,060 | ||
| ② 食材費 F | -1,397,233 | 16.4% | 変動費 |
| ② ドリンク費 D | -672,097 | 7.9% | 変動費 |
| ③ 人件費 L(パートナー) | -736,627 | 8.6% | 変動費 |
| ③ 人件費 L(正社員・日按分) | -1,357,000 | 15.9% | 固定人件費 |
| ④ 家賃 R(日割り) | -400,000 | 4.7% | 固定費 |
| ⑤ 固定費(家賃以外:光熱・システム・広告等の日割り) | -1,900,000 | 22.3% | 固定費 |
| 営業利益 | 2,070,103 | 24.3% |
FD原価率 24.3% L比率 24.5% R比率 4.7% FL比率 48.8% FLR比率 53.5%
着地見込み:売上 8,533,060 → 営業利益 2,368,758(原価率 23.5%・人件費率 21.8% は直近3ヶ月の実績率)
売上・客数=POS。原価=売上 × 原価率 24.3%(当月実績または直近3ヶ月)。人件費=その日のパートナー人件費+正社員給与の日按分。固定費=月額の日割り。近似値。正確な数字はマスタースプレッドシートの「利益」タブ。
| 日 | 売上 | 客数 | 客単価 | 原価(推定) | 人件費 | 固定費 | 推定利益 |
|---|---|---|---|---|---|---|---|
| 07/01 | 237,289 | 97 | 2,446 | 57,544 | 73,543 | 74,194 | 32,008 |
| 07/02 | 257,790 | 89 | 2,897 | 62,516 | 68,293 | 74,194 | 52,788 |
| 07/03 | 301,283 | 112 | 2,690 | 73,063 | 60,662 | 74,194 | 93,364 |
| 07/04 | 354,012 | 129 | 2,744 | 85,851 | 63,843 | 74,194 | 130,125 |
| 07/05 | 263,176 | 103 | 2,555 | 63,822 | 65,941 | 74,194 | 59,220 |
| 07/07 | 195,798 | 69 | 2,838 | 47,482 | 73,773 | 74,194 | 349 |
| 07/08 | 260,345 | 91 | 2,861 | 63,136 | 82,693 | 74,194 | 40,323 |
| 07/09 | 234,166 | 94 | 2,491 | 56,787 | 64,957 | 74,194 | 38,229 |
| 07/10 | 333,090 | 119 | 2,799 | 80,777 | 78,958 | 74,194 | 99,162 |
| 07/11 | 301,682 | 113 | 2,670 | 73,160 | 75,427 | 74,194 | 78,902 |
| 07/12 | 385,473 | 137 | 2,814 | 93,480 | 82,546 | 74,194 | 135,253 |
| 07/13 | 157,472 | 58 | 2,715 | 38,188 | 67,838 | 74,194 | -22,747 |
| 07/14 | 246,702 | 89 | 2,772 | 59,827 | 65,935 | 74,194 | 46,747 |
| 07/15 | 250,770 | 99 | 2,533 | 60,814 | 75,392 | 74,194 | 40,370 |
| 07/16 | 292,172 | 113 | 2,586 | 70,854 | 50,404 | 74,194 | 96,720 |
| 07/17 | 294,618 | 109 | 2,703 | 71,447 | 67,249 | 74,194 | 81,728 |
| 07/18 | 374,727 | 140 | 2,677 | 90,874 | 76,269 | 74,194 | 133,390 |
| 07/19 | 311,510 | 127 | 2,453 | 75,543 | 71,940 | 74,194 | 89,833 |
| 07/20 | 281,340 | 107 | 2,629 | 68,227 | 76,896 | 74,194 | 62,023 |
| 07/21 | 285,017 | 110 | 2,591 | 69,119 | 52,374 | 74,194 | 89,331 |
| 07/22 | 246,626 | 97 | 2,543 | 59,809 | 74,332 | 74,194 | 38,292 |
| 07/23 | 310,508 | 114 | 2,724 | 75,300 | 72,444 | 74,194 | 88,570 |
| 07/24 | 276,065 | 102 | 2,707 | 66,948 | 70,374 | 74,194 | 64,550 |
| 07/25 | 290,002 | 104 | 2,788 | 70,328 | 62,155 | 74,194 | 83,325 |
| 07/26 | 352,401 | 127 | 2,775 | 85,460 | 64,169 | 74,194 | 128,579 |
| 07/27 | 250,757 | 99 | 2,533 | 60,810 | 63,574 | 74,194 | 52,179 |
| 07/28 | 282,574 | 108 | 2,616 | 68,526 | 58,274 | 74,194 | 81,580 |
| 07/29 | 311,309 | 126 | 2,471 | 75,495 | 73,132 | 74,194 | 88,489 |
| 07/30 | 339,424 | 118 | 2,876 | 82,313 | 72,691 | 74,194 | 110,227 |
| 07/31 | 254,962 | 92 | 2,771 | 61,830 | 43,774 | 74,194 | 75,164 |
| 合計 | 8,533,060 | 3,192 | 2,673 | 2,069,330 | 2,049,852 | 2,225,820 | 2,188,073 |
| 日 | 売上 | 目標 | 達成率 | 差 | 客数 | 客単価 | 前年売上 | 前年比 | 前年客数 | 前年比 |
|---|---|---|---|---|---|---|---|---|---|---|
| 07/01(水) | 237,289 | 280,000 | 84.7% | -42,711 | 97 | 2,446 | - | - | - | - |
| 07/02(木) | 257,790 | 280,000 | 92.1% | -22,210 | 89 | 2,897 | - | - | - | - |
| 07/03(金) | 301,283 | 300,000 | 100.4% | 1,283 | 112 | 2,690 | - | - | - | - |
| 07/04(土) | 354,012 | 350,000 | 101.1% | 4,012 | 129 | 2,744 | - | - | - | - |
| 07/05(日) | 263,176 | 350,000 | 75.2% | -86,824 | 103 | 2,555 | - | - | - | - |
| 07/07(火) | 195,798 | 280,000 | 69.9% | -84,202 | 69 | 2,838 | - | - | - | - |
| 07/08(水) | 260,345 | 280,000 | 93.0% | -19,655 | 91 | 2,861 | - | - | - | - |
| 07/09(木) | 234,166 | 280,000 | 83.6% | -45,834 | 94 | 2,491 | - | - | - | - |
| 07/10(金) | 333,090 | 290,000 | 114.9% | 43,090 | 119 | 2,799 | - | - | - | - |
| 07/11(土) | 301,682 | 350,000 | 86.2% | -48,318 | 113 | 2,670 | - | - | - | - |
| 07/12(日) | 385,473 | 350,000 | 110.1% | 35,473 | 137 | 2,814 | - | - | - | - |
| 07/13(月) | 157,472 | 260,000 | 60.6% | -102,528 | 58 | 2,715 | - | - | - | - |
| 07/14(火) | 246,702 | 280,000 | 88.1% | -33,298 | 89 | 2,772 | - | - | - | - |
| 07/15(水) | 250,770 | 280,000 | 89.6% | -29,230 | 99 | 2,533 | - | - | - | - |
| 07/16(木) | 292,172 | 280,000 | 104.3% | 12,172 | 113 | 2,586 | - | - | - | - |
| 07/17(金) | 294,618 | 290,000 | 101.6% | 4,618 | 109 | 2,703 | - | - | - | - |
| 07/18(土) | 374,727 | 350,000 | 107.1% | 24,727 | 140 | 2,677 | - | - | - | - |
| 07/19(日) | 311,510 | 350,000 | 89.0% | -38,490 | 127 | 2,453 | - | - | - | - |
| 07/20(月) | 281,340 | 300,000 | 93.8% | -18,660 | 107 | 2,629 | - | - | - | - |
| 07/21(火) | 285,017 | 280,000 | 101.8% | 5,017 | 110 | 2,591 | - | - | - | - |
| 07/22(水) | 246,626 | 280,000 | 88.1% | -33,374 | 97 | 2,543 | - | - | - | - |
| 07/23(木) | 310,508 | 280,000 | 110.9% | 30,508 | 114 | 2,724 | - | - | - | - |
| 07/24(金) | 276,065 | 290,000 | 95.2% | -13,935 | 102 | 2,707 | - | - | - | - |
| 07/25(土) | 290,002 | 350,000 | 82.9% | -59,998 | 104 | 2,788 | - | - | - | - |
| 07/26(日) | 352,401 | 350,000 | 100.7% | 2,401 | 127 | 2,775 | - | - | - | - |
| 07/27(月) | 250,757 | 260,000 | 96.4% | -9,243 | 99 | 2,533 | - | - | - | - |
| 07/28(火) | 282,574 | 280,000 | 100.9% | 2,574 | 108 | 2,616 | - | - | - | - |
| 07/29(水) | 311,309 | 280,000 | 111.2% | 31,309 | 126 | 2,471 | - | - | - | - |
| 07/30(木) | 339,424 | 280,000 | 121.2% | 59,424 | 118 | 2,876 | - | - | - | - |
| 07/31(金) | 254,962 | 290,000 | 87.9% | -35,038 | 92 | 2,771 | - | - | - | - |
| 合計 | 8,533,060 | 9,000,000 | 94.8% | -466,940 | 3,192 | 2,673 | - | - | - | - |
| 時 | 客数 | 売上 | 客単価 | 人時 | 人時売上高 | 客数/人時 |
|---|---|---|---|---|---|---|
| 11時 | 0.1 | 0 | 0 | 0 | - | 0.0 |
| 12時 | 8.3 | 16,434 | 1,980 | 0 | - | 0.0 |
| 13時 | 9.0 | 22,046 | 2,450 | 0 | - | 0.0 |
| 14時 | 7.6 | 18,022 | 2,371 | 0 | - | 0.0 |
| 15時 | 5.9 | 19,051 | 3,229 | 0 | - | 0.0 |
| 16時 | 5.8 | 17,504 | 3,018 | 0 | - | 0.0 |
| 17時 | 6.5 | 18,627 | 2,866 | 0 | - | 0.0 |
| 18時 | 12.4 | 35,601 | 2,871 | 0 | - | 0.0 |
| 19時 | 15.1 | 44,987 | 2,979 | 0 | - | 0.0 |
| 20時 | 15.1 | 47,294 | 3,132 | 0 | - | 0.0 |
| 21時 | 13.4 | 45,081 | 3,364 | 0 | - | 0.0 |
| 22時 | 6.8 | 25,860 | 3,803 | 0 | - | 0.0 |
| 23時 | 0.5 | 2,805 | 5,610 | 0 | - | 0.0 |
| 氏名 | 形態 | 出勤 | 労働h | 残業h | 深夜h | 正社員換算 |
|---|
| 媒体 | 日付 | 累計 | 評価 | 前回比 |
|---|---|---|---|---|
| 09/15 | 10,611 | 4.8 | - | |
| 食べログ | 09/15 | 83 | 3.26 | - |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 月 | 6 | 13 | 9 | 6 | 6 | 6 | 13 | 14 | 11 | 3 | 1 | |||||
| 火 | 0 | 5 | 10 | 5 | 4 | 5 | 6 | 12 | 16 | 13 | 12 | 5 | 1 | |||
| 水 | 11 | 9 | 6 | 5 | 4 | 5 | 15 | 13 | 15 | 13 | 6 | |||||
| 木 | 6 | 9 | 7 | 4 | 5 | 6 | 14 | 14 | 19 | 15 | 7 | 0 | ||||
| 金 | 0 | 8 | 4 | 12 | 6 | 6 | 6 | 12 | 16 | 14 | 14 | 9 | 1 | |||
| 土 | 10 | 8 | 10 | 7 | 7 | 8 | 11 | 20 | 16 | 17 | 6 | 1 | ||||
| 日 | 11 | 12 | 11 | 8 | 9 | 10 | 14 | 12 | 14 | 12 | 10 | 1 |
| 月 | 売上 | POS売上 | 前年 | 昨対 | 原価 | 原価率 | 人件費 | 人件費率 | 固定費 | 営業利益 |
|---|---|---|---|---|---|---|---|---|---|---|
| 12月 | 7,666,884 | - | 7,789,874 | 98.4% | 2,326,398 | 30.3% | 1,965,342 | 25.6% | 2,200,000 | 1,175,144 |
| 1月 | 9,285,684 | - | 6,875,207 | 135.1% | 2,143,996 | 23.1% | 1,941,965 | 20.9% | 2,200,000 | 2,999,723 |
| 2月 | 7,214,020 | - | 7,460,538 | 96.7% | 1,767,004 | 24.5% | 2,080,500 | 28.8% | 2,200,000 | 1,166,516 |
| 3月 | 10,840,067 | - | 10,245,703 | 105.8% | 2,853,754 | 26.3% | 2,080,500 | 19.2% | 2,200,000 | 3,705,813 |
| 4月 | 11,138,565 | - | 10,192,642 | 109.3% | 2,109,534 | 18.9% | 2,186,166 | 19.6% | 2,200,000 | 4,642,865 |
| 5月 | 11,321,019 | - | 10,440,988 | 108.4% | 2,783,447 | 24.6% | 2,287,724 | 20.2% | 2,200,000 | 4,049,848 |
| 6月 | 8,746,913 | - | 8,599,674 | 101.7% | 2,449,119 | 28.0% | 2,316,259 | 26.5% | 2,200,000 | 1,781,535 |
| 7月 | 8,524,140 | - | 8,295,709 | 102.8% | 2,069,330 | 24.3% | 2,093,627 | 24.6% | 2,300,000 | 2,061,183 |
| 8月 | 8,965,152 | - | 9,708,678 | 92.3% | 2,015,475 | 22.5% | 1,476,750 | 16.5% | 2,300,000 | 3,172,927 |
| 9月 | 4,144,250 | 4,436,939 | 10,093,751 | 41.1% | 0 | - | 0 | - | 2,300,000 | - |
| 10月 | 10,800,000 | - | 10,791,314 | 100.1% | 2,808,000 | 26.0% | 2,700,000 | 25.0% | 2,300,000 | 2,992,000 |
| 11月 | 11,000,000 | - | 10,367,739 | 106.1% | 2,860,000 | 26.0% | 2,860,000 | 26.0% | 2,300,000 | 2,980,000 |
| 順 | 商品 | 区分 | 出数 | 出数/日 | 売上 | 構成比 | 累積 | 前月比 |
|---|
今日の読み 目標に対して 96.0%。残り0日で1日 297,636円 が必要(今の1日平均 240,079円)。 ピークは19時(15.8人/日)。 JDキャンペーンは9/15開始(開始前はゼロで正常)。
| 項目 | 当月(入力済み日まで) | 対売上 | |
|---|---|---|---|
| ① 売上(客数 2,587人 × 客単価 2,784円) | 7,202,364 | ||
| ② 食材費 F | -1,535,244 | 21.3% | 変動費 |
| ② ドリンク費 D | -604,651 | 8.4% | 変動費 |
| ③ 人件費 L(パートナー) | -731,496 | 10.2% | 変動費 |
| ③ 人件費 L(正社員・日按分) | -1,063,750 | 14.8% | 固定人件費 |
| ④ 家賃 R(日割り) | -830,000 | 11.5% | 固定費 |
| ⑤ 固定費(家賃以外:光熱・システム・広告等の日割り) | -2,070,000 | 28.7% | 固定費 |
| 営業利益 | 367,222 | 5.1% |
FD原価率 29.7% L比率 24.9% R比率 11.5% FL比率 54.6% FLR比率 66.2%
着地見込み:売上 7,202,364 → 営業利益 1,129,794(原価率 22.8%・人件費率 21.3% は直近3ヶ月の実績率)
売上・客数=POS。原価=売上 × 原価率 29.7%(当月実績または直近3ヶ月)。人件費=その日のパートナー人件費+正社員給与の日按分。固定費=月額の日割り。近似値。正確な数字はマスタースプレッドシートの「利益」タブ。
| 日 | 売上 | 客数 | 客単価 | 原価(推定) | 人件費 | 固定費 | 推定利益 |
|---|---|---|---|---|---|---|---|
| 07/01 | 189,931 | 73 | 2,602 | 56,430 | 66,068 | 93,548 | -26,116 |
| 07/02 | 170,808 | 57 | 2,997 | 50,749 | 43,626 | 93,548 | -17,116 |
| 07/03 | 283,282 | 94 | 3,014 | 84,166 | 61,043 | 93,548 | 44,524 |
| 07/04 | 316,100 | 112 | 2,822 | 93,917 | 60,576 | 93,548 | 68,059 |
| 07/05 | 197,348 | 76 | 2,597 | 58,634 | 74,425 | 93,548 | -29,259 |
| 07/07 | 175,811 | 68 | 2,585 | 52,235 | 46,155 | 93,548 | -16,128 |
| 07/08 | 184,702 | 70 | 2,639 | 54,877 | 74,400 | 93,548 | -38,123 |
| 07/09 | 218,134 | 85 | 2,566 | 64,810 | 77,052 | 93,548 | -17,276 |
| 07/10 | 286,563 | 106 | 2,703 | 85,141 | 53,544 | 93,548 | 54,330 |
| 07/11 | 348,938 | 125 | 2,792 | 103,673 | 62,874 | 93,548 | 88,843 |
| 07/12 | 314,001 | 111 | 2,829 | 93,293 | 75,106 | 93,548 | 52,054 |
| 07/13 | 199,519 | 82 | 2,433 | 59,279 | 48,230 | 93,548 | -1,539 |
| 07/14 | 171,930 | 60 | 2,866 | 51,082 | 58,585 | 93,548 | -31,285 |
| 07/15 | 196,078 | 74 | 2,650 | 58,257 | 61,863 | 93,548 | -17,590 |
| 07/16 | 135,447 | 56 | 2,419 | 40,243 | 61,848 | 93,548 | -60,192 |
| 07/17 | 332,992 | 119 | 2,798 | 98,935 | 73,400 | 93,548 | 67,108 |
| 07/18 | 271,602 | 98 | 2,771 | 80,696 | 71,391 | 93,548 | 25,967 |
| 07/19 | 261,729 | 86 | 3,043 | 77,762 | 51,366 | 93,548 | 39,052 |
| 07/20 | 208,284 | 78 | 2,670 | 61,883 | 48,150 | 93,548 | 4,703 |
| 07/21 | 170,739 | 65 | 2,627 | 50,728 | 46,199 | 93,548 | -19,736 |
| 07/22 | 258,575 | 95 | 2,722 | 76,825 | 43,477 | 93,548 | 44,724 |
| 07/23 | 245,363 | 78 | 3,146 | 72,900 | 57,960 | 93,548 | 20,955 |
| 07/24 | 268,844 | 88 | 3,055 | 79,876 | 43,915 | 93,548 | 51,505 |
| 07/25 | 300,055 | 114 | 2,632 | 89,149 | 53,600 | 93,548 | 63,758 |
| 07/26 | 193,237 | 69 | 2,801 | 57,413 | 34,315 | 93,548 | 7,961 |
| 07/27 | 245,372 | 88 | 2,788 | 72,902 | 69,344 | 93,548 | 9,577 |
| 07/28 | 354,651 | 110 | 3,224 | 105,370 | 52,865 | 93,548 | 102,868 |
| 07/29 | 227,148 | 86 | 2,641 | 67,488 | 74,018 | 93,548 | -7,906 |
| 07/30 | 215,154 | 75 | 2,869 | 63,924 | 67,308 | 93,548 | -9,627 |
| 07/31 | 260,027 | 89 | 2,922 | 77,257 | 48,230 | 93,548 | 40,992 |
| 合計 | 7,202,364 | 2,587 | 2,784 | 2,139,894 | 1,760,933 | 2,806,440 | 495,087 |
| 日 | 売上 | 目標 | 達成率 | 差 | 客数 | 客単価 | 前年売上 | 前年比 | 前年客数 | 前年比 |
|---|---|---|---|---|---|---|---|---|---|---|
| 07/01(水) | 189,931 | 200,000 | 95.0% | -10,069 | 73 | 2,602 | - | - | - | - |
| 07/02(木) | 170,808 | 200,000 | 85.4% | -29,192 | 57 | 2,997 | - | - | - | - |
| 07/03(金) | 283,282 | 280,000 | 101.2% | 3,282 | 94 | 3,014 | - | - | - | - |
| 07/04(土) | 316,100 | 300,000 | 105.4% | 16,100 | 112 | 2,822 | - | - | - | - |
| 07/05(日) | 197,348 | 280,000 | 70.5% | -82,652 | 76 | 2,597 | - | - | - | - |
| 07/07(火) | 175,811 | 220,000 | 79.9% | -44,189 | 68 | 2,585 | - | - | - | - |
| 07/08(水) | 184,702 | 220,000 | 84.0% | -35,298 | 70 | 2,639 | - | - | - | - |
| 07/09(木) | 218,134 | 220,000 | 99.2% | -1,866 | 85 | 2,566 | - | - | - | - |
| 07/10(金) | 286,563 | 280,000 | 102.3% | 6,563 | 106 | 2,703 | - | - | - | - |
| 07/11(土) | 348,938 | 300,000 | 116.3% | 48,938 | 125 | 2,792 | - | - | - | - |
| 07/12(日) | 314,001 | 280,000 | 112.1% | 34,001 | 111 | 2,829 | - | - | - | - |
| 07/13(月) | 199,519 | 220,000 | 90.7% | -20,481 | 82 | 2,433 | - | - | - | - |
| 07/14(火) | 171,930 | 220,000 | 78.1% | -48,070 | 60 | 2,866 | - | - | - | - |
| 07/15(水) | 196,078 | 220,000 | 89.1% | -23,922 | 74 | 2,650 | - | - | - | - |
| 07/16(木) | 135,447 | 220,000 | 61.6% | -84,553 | 56 | 2,419 | - | - | - | - |
| 07/17(金) | 332,992 | 280,000 | 118.9% | 52,992 | 119 | 2,798 | - | - | - | - |
| 07/18(土) | 271,602 | 300,000 | 90.5% | -28,398 | 98 | 2,771 | - | - | - | - |
| 07/19(日) | 261,729 | 280,000 | 93.5% | -18,271 | 86 | 3,043 | - | - | - | - |
| 07/20(月) | 208,284 | 220,000 | 94.7% | -11,716 | 78 | 2,670 | - | - | - | - |
| 07/21(火) | 170,739 | 220,000 | 77.6% | -49,261 | 65 | 2,627 | - | - | - | - |
| 07/22(水) | 258,575 | 220,000 | 117.5% | 38,575 | 95 | 2,722 | - | - | - | - |
| 07/23(木) | 245,363 | 220,000 | 111.5% | 25,363 | 78 | 3,146 | - | - | - | - |
| 07/24(金) | 268,844 | 280,000 | 96.0% | -11,156 | 88 | 3,055 | - | - | - | - |
| 07/25(土) | 300,055 | 300,000 | 100.0% | 55 | 114 | 2,632 | - | - | - | - |
| 07/26(日) | 193,237 | 280,000 | 69.0% | -86,763 | 69 | 2,801 | - | - | - | - |
| 07/27(月) | 245,372 | 240,000 | 102.2% | 5,372 | 88 | 2,788 | - | - | - | - |
| 07/28(火) | 354,651 | 240,000 | 147.8% | 114,651 | 110 | 3,224 | - | - | - | - |
| 07/29(水) | 227,148 | 240,000 | 94.6% | -12,852 | 86 | 2,641 | - | - | - | - |
| 07/30(木) | 215,154 | 240,000 | 89.6% | -24,846 | 75 | 2,869 | - | - | - | - |
| 07/31(金) | 260,027 | 280,000 | 92.9% | -19,973 | 89 | 2,922 | - | - | - | - |
| 合計 | 7,202,364 | 7,500,000 | 96.0% | -297,636 | 2,587 | 2,784 | - | - | - | - |
| 時 | 客数 | 売上 | 客単価 | 人時 | 人時売上高 | 客数/人時 |
|---|---|---|---|---|---|---|
| 11時 | 0.6 | 251 | 418 | 0 | - | 0.0 |
| 12時 | 4.6 | 9,485 | 2,062 | 0 | - | 0.0 |
| 13時 | 5.1 | 12,718 | 2,494 | 0 | - | 0.0 |
| 14時 | 5.6 | 13,111 | 2,341 | 0 | - | 0.0 |
| 15時 | 2.3 | 7,896 | 3,433 | 0 | - | 0.0 |
| 16時 | 2.2 | 6,030 | 2,741 | 0 | - | 0.0 |
| 17時 | 6.1 | 14,612 | 2,395 | 0 | - | 0.0 |
| 18時 | 13.4 | 38,672 | 2,886 | 0 | - | 0.0 |
| 19時 | 15.8 | 55,734 | 3,527 | 0 | - | 0.0 |
| 20時 | 13.9 | 47,422 | 3,412 | 0 | - | 0.0 |
| 21時 | 9.1 | 34,607 | 3,803 | 0 | - | 0.0 |
| 22時 | 5.9 | 18,845 | 3,194 | 0 | - | 0.0 |
| 23時 | 1.3 | 4,864 | 3,742 | 0 | - | 0.0 |
| 24時 | 0.3 | 949 | 3,163 | 0 | - | 0.0 |
| 氏名 | 形態 | 出勤 | 労働h | 残業h | 深夜h | 正社員換算 |
|---|
| 媒体 | 日付 | 累計 | 評価 | 前回比 |
|---|---|---|---|---|
| 09/15 | 4,778 | 4.9 | - | |
| 食べログ | 09/15 | 73 | 3.21 | - |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 月 | 4 | 5 | 10 | 3 | 4 | 9 | 14 | 8 | 13 | 7 | 4 | 1 | 2 | |||
| 火 | 6 | 5 | 4 | 1 | 9 | 10 | 12 | 18 | 9 | 2 | 0 | 1 | ||||
| 水 | 1 | 4 | 4 | 4 | 1 | 1 | 3 | 14 | 18 | 14 | 9 | 4 | 2 | |||
| 木 | 1 | 2 | 3 | 3 | 2 | 0 | 4 | 10 | 20 | 11 | 8 | 4 | 1 | |||
| 金 | 4 | 5 | 6 | 1 | 1 | 5 | 16 | 18 | 14 | 12 | 15 | 2 | ||||
| 土 | 2 | 8 | 10 | 8 | 4 | 4 | 9 | 12 | 20 | 18 | 12 | 5 | 1 | |||
| 日 | 0 | 6 | 6 | 8 | 5 | 6 | 6 | 18 | 9 | 10 | 5 | 5 | 2 |
| 月 | 売上 | POS売上 | 前年 | 昨対 | 原価 | 原価率 | 人件費 | 人件費率 | 固定費 | 営業利益 |
|---|---|---|---|---|---|---|---|---|---|---|
| 12月 | 6,358,490 | - | 5,176,029 | 122.8% | 2,126,506 | 33.4% | 2,080,250 | 32.7% | 2,800,000 | -648,266 |
| 1月 | 2,701,700 | - | 4,917,028 | 54.9% | 756,281 | 28.0% | 1,020,661 | 37.8% | 2,900,000 | -1,975,242 |
| 2月 | 5,930,304 | - | 5,762,731 | 102.9% | 1,611,711 | 27.2% | 1,877,066 | 31.7% | 2,900,000 | -458,473 |
| 3月 | 8,295,535 | - | 7,433,806 | 111.6% | 2,160,851 | 26.0% | 1,425,000 | 17.2% | 2,900,000 | 1,809,684 |
| 4月 | 7,821,340 | - | 7,647,485 | 102.3% | 1,162,716 | 14.9% | 1,318,805 | 16.9% | 2,900,000 | 2,439,819 |
| 5月 | 8,177,803 | - | 8,093,547 | 101.0% | 2,097,444 | 25.6% | 1,828,685 | 22.4% | 2,900,000 | 1,351,674 |
| 6月 | 6,378,849 | - | 7,315,958 | 87.2% | 1,831,010 | 28.7% | 1,618,624 | 25.4% | 2,900,000 | 29,215 |
| 7月 | 7,202,455 | - | 7,191,797 | 100.1% | 2,139,895 | 29.7% | 1,779,222 | 24.7% | 2,900,000 | 383,338 |
| 8月 | 7,828,245 | - | 7,253,384 | 107.9% | 1,689,984 | 21.6% | 1,363,556 | 17.4% | 2,900,000 | 1,874,705 |
| 9月 | 3,219,560 | 3,450,333 | 7,393,283 | 43.5% | 0 | - | 0 | - | 2,900,000 | - |
| 10月 | 8,500,000 | - | 7,606,529 | 111.7% | 2,210,000 | 26.0% | 2,125,000 | 25.0% | 2,900,000 | 1,265,000 |
| 11月 | 9,500,000 | - | 7,212,397 | 131.7% | 2,470,000 | 26.0% | 2,470,000 | 26.0% | 2,900,000 | 1,660,000 |
| 順 | 商品 | 区分 | 出数 | 出数/日 | 売上 | 構成比 | 累積 | 前月比 |
|---|
今日の読み 目標に対して 84.7%。残り0日で1日 610,383円 が必要(今の1日平均 112,987円)。 ピークは19時(8.6人/日)。 翠ジンは目標の 187.0%。
12月判定線 月 4,000,000円 = 1日 129,032円。客単価 2,940円なら 1日 44人(今 38人/日)。客単価 3,000円なら 1日 43人。着地 3,389,617 → 差 -610,383。
| 項目 | 当月(入力済み日まで) | 対売上 | |
|---|---|---|---|
| ① 売上(客数 1,153人 × 客単価 2,940円) | 3,389,617 | ||
| ② 食材費 F | -452,949 | 13.4% | 変動費 |
| ② ドリンク費 D | -293,685 | 8.7% | 変動費 |
| ③ 人件費 L(パートナー) | -476,968 | 14.1% | 変動費 |
| ③ 人件費 L(正社員・日按分) | -345,000 | 10.2% | 固定人件費 |
| ④ 家賃 R(日割り) | -325,000 | 9.6% | 固定費 |
| ⑤ 固定費(家賃以外:光熱・システム・広告等の日割り) | -875,000 | 25.8% | 固定費 |
| 営業利益 | 621,015 | 18.3% |
FD原価率 22.0% L比率 24.2% R比率 9.6% FL比率 46.3% FLR比率 55.9%
着地見込み:売上 3,389,617 → 営業利益 321,210(原価率 19.9%・人件費率 35.2% は直近3ヶ月の実績率)
売上・客数=POS。原価=売上 × 原価率 22.0%(当月実績または直近3ヶ月)。人件費=その日のパートナー人件費+正社員給与の日按分。固定費=月額の日割り。近似値。正確な数字はマスタースプレッドシートの「利益」タブ。
| 日 | 売上 | 客数 | 客単価 | 原価(推定) | 人件費 | 固定費 | 推定利益 |
|---|---|---|---|---|---|---|---|
| 07/01 | 86,320 | 36 | 2,398 | 19,014 | 17,129 | 38,710 | 11,468 |
| 07/02 | 91,003 | 35 | 2,600 | 20,045 | 29,707 | 38,710 | 2,541 |
| 07/03 | 165,188 | 66 | 2,503 | 36,386 | 40,285 | 38,710 | 49,807 |
| 07/04 | 138,839 | 48 | 2,892 | 30,582 | 25,020 | 38,710 | 44,527 |
| 07/05 | 36,659 | 13 | 2,820 | 8,075 | 17,879 | 38,710 | -28,005 |
| 07/07 | 113,139 | 43 | 2,631 | 24,921 | 17,879 | 38,710 | 31,629 |
| 07/08 | 76,328 | 25 | 3,053 | 16,813 | 32,051 | 38,710 | -11,245 |
| 07/09 | 59,165 | 22 | 2,689 | 13,032 | 35,129 | 38,710 | -27,706 |
| 07/10 | 146,700 | 51 | 2,876 | 32,314 | 31,848 | 38,710 | 43,829 |
| 07/11 | 128,495 | 47 | 2,734 | 28,304 | 26,348 | 38,710 | 35,134 |
| 07/12 | 83,710 | 37 | 2,262 | 18,439 | 18,817 | 38,710 | 7,745 |
| 07/13 | 114,774 | 40 | 2,869 | 25,281 | 27,698 | 38,710 | 23,085 |
| 07/14 | 123,808 | 34 | 3,641 | 27,271 | 30,488 | 38,710 | 27,339 |
| 07/15 | 113,079 | 40 | 2,827 | 24,908 | 33,176 | 38,710 | 16,285 |
| 07/16 | 172,271 | 46 | 3,745 | 37,946 | 31,817 | 38,710 | 63,799 |
| 07/17 | 249,041 | 46 | 5,414 | 54,856 | 19,754 | 38,710 | 135,721 |
| 07/18 | 184,135 | 53 | 3,474 | 40,560 | 22,098 | 38,710 | 82,768 |
| 07/19 | 139,144 | 43 | 3,236 | 30,649 | 24,082 | 38,710 | 45,703 |
| 07/20 | 109,618 | 36 | 3,045 | 24,146 | 20,613 | 38,710 | 26,149 |
| 07/21 | 78,279 | 34 | 2,302 | 17,243 | 11,129 | 38,710 | 11,198 |
| 07/22 | 89,654 | 35 | 2,562 | 19,748 | 27,160 | 38,710 | 4,036 |
| 07/23 | 83,585 | 22 | 3,799 | 18,411 | 34,973 | 38,710 | -8,509 |
| 07/24 | 117,860 | 46 | 2,562 | 25,961 | 28,848 | 38,710 | 24,341 |
| 07/25 | 120,527 | 48 | 2,511 | 26,549 | 43,129 | 38,710 | 12,140 |
| 07/26 | 50,379 | 25 | 2,015 | 11,097 | 17,410 | 38,710 | -16,838 |
| 07/27 | 90,730 | 35 | 2,592 | 19,985 | 37,356 | 38,710 | -5,321 |
| 07/28 | 95,847 | 33 | 2,904 | 21,112 | 22,129 | 38,710 | 13,896 |
| 07/29 | 104,393 | 32 | 3,262 | 22,995 | 28,848 | 38,710 | 13,841 |
| 07/30 | 90,825 | 39 | 2,329 | 20,006 | 28,067 | 38,710 | 4,043 |
| 07/31 | 136,122 | 43 | 3,166 | 29,984 | 29,973 | 38,710 | 37,456 |
| 合計 | 3,389,617 | 1,153 | 2,940 | 746,633 | 810,840 | 1,161,300 | 670,856 |
| 日 | 売上 | 目標 | 達成率 | 差 | 客数 | 客単価 | 前年売上 | 前年比 | 前年客数 | 前年比 |
|---|---|---|---|---|---|---|---|---|---|---|
| 07/01(水) | 86,320 | 120,000 | 71.9% | -33,680 | 36 | 2,398 | - | - | - | - |
| 07/02(木) | 91,003 | 120,000 | 75.8% | -28,997 | 35 | 2,600 | - | - | - | - |
| 07/03(金) | 165,188 | 160,000 | 103.2% | 5,188 | 66 | 2,503 | - | - | - | - |
| 07/04(土) | 138,839 | 160,000 | 86.8% | -21,161 | 48 | 2,892 | - | - | - | - |
| 07/05(日) | 36,659 | 90,000 | 40.7% | -53,341 | 13 | 2,820 | - | - | - | - |
| 07/07(火) | 113,139 | 120,000 | 94.3% | -6,861 | 43 | 2,631 | - | - | - | - |
| 07/08(水) | 76,328 | 120,000 | 63.6% | -43,672 | 25 | 3,053 | - | - | - | - |
| 07/09(木) | 59,165 | 120,000 | 49.3% | -60,835 | 22 | 2,689 | - | - | - | - |
| 07/10(金) | 146,700 | 170,000 | 86.3% | -23,300 | 51 | 2,876 | - | - | - | - |
| 07/11(土) | 128,495 | 170,000 | 75.6% | -41,505 | 47 | 2,734 | - | - | - | - |
| 07/12(日) | 83,710 | 120,000 | 69.8% | -36,290 | 37 | 2,262 | - | - | - | - |
| 07/13(月) | 114,774 | 120,000 | 95.6% | -5,226 | 40 | 2,869 | - | - | - | - |
| 07/14(火) | 123,808 | 120,000 | 103.2% | 3,808 | 34 | 3,641 | - | - | - | - |
| 07/15(水) | 113,079 | 120,000 | 94.2% | -6,921 | 40 | 2,827 | - | - | - | - |
| 07/16(木) | 172,271 | 120,000 | 143.6% | 52,271 | 46 | 3,745 | - | - | - | - |
| 07/17(金) | 249,041 | 160,000 | 155.7% | 89,041 | 46 | 5,414 | - | - | - | - |
| 07/18(土) | 184,135 | 150,000 | 122.8% | 34,135 | 53 | 3,474 | - | - | - | - |
| 07/19(日) | 139,144 | 150,000 | 92.8% | -10,856 | 43 | 3,236 | - | - | - | - |
| 07/20(月) | 109,618 | 120,000 | 91.3% | -10,382 | 36 | 3,045 | - | - | - | - |
| 07/21(火) | 78,279 | 120,000 | 65.2% | -41,721 | 34 | 2,302 | - | - | - | - |
| 07/22(水) | 89,654 | 120,000 | 74.7% | -30,346 | 35 | 2,562 | - | - | - | - |
| 07/23(木) | 83,585 | 120,000 | 69.7% | -36,415 | 22 | 3,799 | - | - | - | - |
| 07/24(金) | 117,860 | 170,000 | 69.3% | -52,140 | 46 | 2,562 | - | - | - | - |
| 07/25(土) | 120,527 | 170,000 | 70.9% | -49,473 | 48 | 2,511 | - | - | - | - |
| 07/26(日) | 50,379 | 120,000 | 42.0% | -69,621 | 25 | 2,015 | - | - | - | - |
| 07/27(月) | 90,730 | 120,000 | 75.6% | -29,270 | 35 | 2,592 | - | - | - | - |
| 07/28(火) | 95,847 | 120,000 | 79.9% | -24,153 | 33 | 2,904 | - | - | - | - |
| 07/29(水) | 104,393 | 120,000 | 87.0% | -15,607 | 32 | 3,262 | - | - | - | - |
| 07/30(木) | 90,825 | 120,000 | 75.7% | -29,175 | 39 | 2,329 | - | - | - | - |
| 07/31(金) | 136,122 | 170,000 | 80.1% | -33,878 | 43 | 3,166 | - | - | - | - |
| 合計 | 3,389,617 | 4,000,000 | 84.7% | -610,383 | 1,153 | 2,940 | - | - | - | - |
| 時 | 客数 | 売上 | 客単価 | 人時 | 人時売上高 | 客数/人時 |
|---|---|---|---|---|---|---|
| 14時 | 0.0 | 307 | - | 0 | - | 0.0 |
| 15時 | 0.4 | 956 | 2,390 | 0 | - | 0.0 |
| 16時 | 0.3 | 813 | 2,710 | 0 | - | 0.0 |
| 17時 | 2.0 | 6,135 | 3,068 | 0 | - | 0.0 |
| 18時 | 3.5 | 10,285 | 2,939 | 0 | - | 0.0 |
| 19時 | 8.6 | 25,602 | 2,977 | 0 | - | 0.0 |
| 20時 | 6.5 | 20,752 | 3,193 | 0 | - | 0.0 |
| 21時 | 6.0 | 16,434 | 2,739 | 0 | - | 0.0 |
| 22時 | 4.7 | 12,864 | 2,737 | 0 | - | 0.0 |
| 23時 | 3.5 | 10,091 | 2,883 | 0 | - | 0.0 |
| 24時 | 1.8 | 4,587 | 2,548 | 0 | - | 0.0 |
| 25時 | 1.0 | 3,991 | 3,991 | 0 | - | 0.0 |
| 26時 | 0.1 | 171 | 1,710 | 0 | - | 0.0 |
| 氏名 | 形態 | 出勤 | 労働h | 残業h | 深夜h | 正社員換算 |
|---|
| 媒体 | 日付 | 累計 | 評価 | 前回比 |
|---|---|---|---|---|
| 09/15 | 1,641 | 4.9 | - | |
| 食べログ | 09/15 | 35 | 3.09 | - |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 月 | 2 | 2 | 8 | 7 | 9 | 7 | 1 | 0 | 0 | |||||||
| 火 | 4 | 2 | 10 | 6 | 3 | 3 | 5 | 2 | 1 | 0 | ||||||
| 水 | 1 | 3 | 7 | 5 | 5 | 6 | 3 | 2 | 1 | 0 | ||||||
| 木 | 0 | 2 | 3 | 6 | 6 | 7 | 3 | 5 | 1 | 0 | ||||||
| 金 | 1 | 2 | 4 | 11 | 9 | 9 | 6 | 3 | 2 | 2 | ||||||
| 土 | 2 | 7 | 10 | 6 | 6 | 6 | 6 | 5 | 2 | |||||||
| 日 | 3 | 1 | 2 | 3 | 9 | 5 | 3 | 3 | 0 | 0 |
| 月 | 売上 | POS売上 | 前年 | 昨対 | 原価 | 原価率 | 人件費 | 人件費率 | 固定費 | 営業利益 |
|---|---|---|---|---|---|---|---|---|---|---|
| 12月 | 1,635,299 | - | - | - | 799,184 | 48.9% | 1,317,500 | 80.6% | 2,700,000 | -3,181,385 |
| 1月 | 2,364,861 | - | - | - | 763,402 | 32.3% | 1,238,625 | 52.4% | 1,300,000 | -937,166 |
| 2月 | 2,704,047 | - | - | - | 757,759 | 28.0% | 1,208,234 | 44.7% | 1,300,000 | -561,946 |
| 3月 | 3,084,993 | - | - | - | 744,079 | 24.1% | 1,181,422 | 38.3% | 1,400,000 | -240,508 |
| 4月 | 4,065,068 | - | - | - | 604,915 | 14.9% | 1,210,547 | 29.8% | 1,400,000 | 849,606 |
| 5月 | 3,653,711 | - | - | - | 845,878 | 23.2% | 1,307,776 | 35.8% | 1,400,000 | 100,057 |
| 6月 | 3,256,765 | - | - | - | 734,233 | 22.5% | 1,346,533 | 41.3% | 1,400,000 | -224,001 |
| 7月 | 3,390,617 | 3,389,617 | - | - | 746,634 | 22.0% | 821,968 | 24.2% | 1,200,000 | 622,015 |
| 8月 | 3,286,482 | 3,318,201 | - | - | 675,122 | 20.5% | 705,187 | 21.5% | 1,200,000 | 706,173 |
| 9月 | 1,508,579 | 1,683,883 | - | - | 0 | - | 0 | - | 1,200,000 | - |
| 10月 | 3,800,000 | - | - | - | 912,000 | 24.0% | 912,000 | 24.0% | 1,200,000 | 776,000 |
| 11月 | 4,500,000 | - | - | - | 1,170,000 | 26.0% | 1,350,000 | 30.0% | 1,200,000 | 780,000 |
| 順 | 商品 | 区分 | 出数 | 出数/日 | 売上 | 構成比 | 累積 | 前月比 |
|---|---|---|---|---|---|---|---|---|
| 1 | お通し | お通し等 | 1,115 | 37.2 | 367,950 | 15.9% | 15.9% | 新 |
| 2 | K餃子(3種盛) | KABUKI | 1,272 | 42.4 | 346,302 | 14.9% | 30.8% | 新 |
| 3 | ビール | ビール・ハイ | 450 | 15.0 | 321,750 | 13.9% | 44.7% | 新 |
| 4 | KABUKIチンチロ | 翠ジン | 1,543 | 51.4 | 297,880 | 12.9% | 57.6% | 新 |
| 5 | ①KABUKI餃子(4個) | KABUKI | 240 | 8.0 | 155,760 | 6.7% | 64.3% | 新 |
| 6 | アンジュエル ボトル | スパークリン | 47 | 1.6 | 151,980 | 6.6% | 70.9% | 新 |
| 7 | シャンパン | シャンパン | 14 | 0.5 | 114,836 | 5.0% | 75.8% | 新 |
| 8 | アネホ | ショット | 64 | 2.1 | 105,600 | 4.6% | 80.4% | 新 |
| 9 | おでん5種 | おすすめ用カ | 414 | 13.8 | 85,448 | 3.7% | 84.1% | 新 |
| 10 | 角ハイ | ビール・ハイ | 187 | 6.2 | 78,078 | 3.4% | 87.4% | 新 |
| 11 | 油淋鶏 | ?揚げ物? | 85 | 2.8 | 63,580 | 2.7% | 90.2% | 新 |
| 12 | タッカルビ | おすすめ用カ | 135 | 4.5 | 63,382 | 2.7% | 92.9% | 新 |
| 13 | おでん3種 | 【テイクアウ | 304 | 10.1 | 56,751 | 2.4% | 95.4% | 新 |
| 14 | 水餃子(4個) | 水餃子 | 170 | 5.7 | 56,595 | 2.4% | 97.8% | 新 |
| 15 | 宴会6品120分 | コース | 17 | 0.6 | 50,660 | 2.2% | 100.0% | 新 |
今日の読み
| 項目 | 当月(入力済み日まで) | 対売上 | |
|---|---|---|---|
| ① 売上(客数 23人 × 客単価 12,293円) | 282,745 | ||
| ② 食材費 F | -36,203 | 12.8% | 変動費 |
| ② ドリンク費 D | -475,418 | 168.1% | 変動費 |
| ③ 人件費 L(パートナー) | -0 | 0.0% | 変動費 |
| ③ 人件費 L(正社員・日按分) | -0 | 0.0% | 固定人件費 |
| ④ 家賃 R(日割り) | -545,600 | 193.0% | 固定費 |
| ⑤ 固定費(家賃以外:光熱・システム・広告等の日割り) | -854,400 | 302.2% | 固定費 |
| 営業利益 | -1,628,876 | -576.1% |
FD原価率 180.9% L比率 0.0% R比率 193.0% FL比率 180.9% FLR比率 373.9%
着地見込み:売上 282,745 → 営業利益 -1,261,455(原価率 26.0%・人件費率 25.0% は直近3ヶ月の実績率)
売上・客数=POS。原価=売上 × 原価率 180.9%(当月実績または直近3ヶ月)。人件費=その日のパートナー人件費+正社員給与の日按分。固定費=月額の日割り。近似値。正確な数字はマスタースプレッドシートの「利益」タブ。
| 日 | 売上 | 客数 | 客単価 | 原価(推定) | 人件費 | 固定費 | 推定利益 |
|---|---|---|---|---|---|---|---|
| 07/31 | 282,745 | 23 | 12,293 | 511,621 | 0 | 45,161 | -274,037 |
| 合計 | 282,745 | 23 | 12,293 | 511,621 | 0 | 45,161 | -274,037 |
| 日 | 売上 | 目標 | 達成率 | 差 | 客数 | 客単価 | 前年売上 | 前年比 | 前年客数 | 前年比 |
|---|---|---|---|---|---|---|---|---|---|---|
| 07/31(金) | 282,745 | 0 | - | - | 23 | 12,293 | - | - | - | - |
| 合計 | 282,745 | 0 | - | - | 23 | 12,293 | - | - | - | - |
| 時 | 客数 | 売上 | 客単価 | 人時 | 人時売上高 | 客数/人時 |
|---|
| 氏名 | 形態 | 出勤 | 労働h | 残業h | 深夜h | 正社員換算 |
|---|
| 媒体 | 日付 | 累計 | 評価 | 前回比 |
|---|
| 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 月 | ||||||||||||||||
| 火 | ||||||||||||||||
| 水 | ||||||||||||||||
| 木 | ||||||||||||||||
| 金 | ||||||||||||||||
| 土 | ||||||||||||||||
| 日 |
| 月 | 売上 | POS売上 | 前年 | 昨対 | 原価 | 原価率 | 人件費 | 人件費率 | 固定費 | 営業利益 |
|---|---|---|---|---|---|---|---|---|---|---|
| 7月 | 282,748 | 282,745 | - | - | 960,530 | 339.7% | 0 | - | 1,400,000 | -2,077,782 |
| 8月 | 1,813,872 | 1,898,926 | - | - | 186,480 | 10.3% | 0 | - | 1,000,000 | 627,392 |
| 9月 | 142,085 | 169,359 | - | - | 0 | - | 0 | - | 1,400,000 | - |
| 10月 | 2,500,000 | - | - | - | 250,000 | 10.0% | 875,000 | 35.0% | 1,400,000 | -25,000 |
| 11月 | 4,500,000 | - | - | - | 450,000 | 10.0% | 1,575,000 | 35.0% | 1,400,000 | 1,075,000 |
| 順 | 商品 | 区分 | 出数 | 出数/日 | 売上 | 構成比 | 累積 | 前月比 |
|---|
| 元データ | 最終取得 |
|---|---|
| ダイニー(KABUKI) | 09/15 07:29 |
| ポスタス(餃包) | 09/15 07:37 |
| ポスタス(Lad's) | 09/15 07:44 |
| エアレジ(Kichi) | 09/15 07:51 |
| らくしふ | 09/15 07:14 |
| 口コミ | 09/15 02:33 |
| 利益対比表・全社版 | 09/15 07:56 |