For each of the six months: check and average costs of sales food. 1. 2. Calcula

Question

For each of the six months: check and average costs of sales food. 1. 2. Calculate the average Using these averages, calculate a trend index number. Set the trend index for one month 1 at 100% (or 100) and complete the trend index numbers for the remaining five months. With the index numbers identified, convert sales revenue and cost of sales food from historic to current dollars. 3. . Round decimals to the nearest hundredth for average check and average cost of sales, food. Round to the nearest whole number for trend index. Round to the nearest whole number for current dollar Avgerage Check Average Cost of Sales, FoodTrend Index Trend Index Current DollarCurrent Dollar Month Sales Revenue Cost of Sales, Food Guests Served per Guest per Guest Average Check Average Cost of Sales, Food Sales Revenue Cost of Sales, Food $256,600 273,500 285,100 288,600 297,300 303,200 10,200 $ 25.16 10,500 10,100 10,000 10,300 10,400 $94 100 100 110 116 120 125 130 256600 255607 256847 257679 256293 256949 94500 94182 94828 94167 94720 160160 $ 9.26 103 107 110 113 118, 123 26.05 28.23 28.86 28.86 29.15 9.87 10.89 11.30 11.50 11.85 112 116 118

Explanation / Answer

Let's first calculate a new column - Trend Index Sales Revenue as below:

The above column Trend Index Sales Revenue will be used to determine the Current Dollar Sales Revenue

The complete table is as below:

Month Sales Revenue Trend Index Sales Revenue 1 $2,56,600 100 2 $2,73,500 107 3 $2,85,100 111 4 $2,88,600 112 5 $2,97,300 116 6 $3,03,200 118

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.