Question

The following data relate the sales figures of the bar in Mark? Kaltenbach's small? bed-and-breakfast inn...

The following data relate the sales figures of the bar in Mark? Kaltenbach's small? bed-and-breakfast inn in? Portland, to the number of guests registered that? week:The following data relate the sales figures of the

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

Linear regression method Here Here, x refers to the current time period n refers to the total number of periods Here, n is 4 Now, enter the following formulas in the excel spreadsheet to find out the values: Week Guests(x) Bar Sales(y) 16 12 18 14 TotalSUM(B2B5) 340 270 375 300 B2 C2 B3 *C3 B2 2 B3 2 B5*C5 B5 2 SUMC2:C -SUMD2 D5)SUM(E2.E5 Average AVERAGEB2:B5) -AVERAGE(C2:C5 Resultant values are as follows: 1Week Guests(x Bar Sales(y) xy 340 270 375 300 1285 321.25 256 144 324 196 16 12 18 5440 3240 6750 4200 19630 920 4 6 Total 7 Average 15

Add a comment
Know the answer?
Add Answer to:
The following data relate the sales figures of the bar in Mark? Kaltenbach's small? bed-and-breakfast inn...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • The following data relate the sales figures of the bar in Mark Kaltenbach's small bed-and-breakfast inn...

    The following data relate the sales figures of the bar in Mark Kaltenbach's small bed-and-breakfast inn in Portland, to the number of guests registered that week Gues 18 14 $315 a) The simple Snear regression equation that relates bar sales to number of guests (not to time) is (round your responses to one decimal place): Bar Sales-D + □x guests b) lf the forecast is 24 guests next week, the bar sales are expected to be s□ round your respo...

  • Please step by step like how can I do them by hand Solve by hand (or...

    Please step by step like how can I do them by hand Solve by hand (or you can use Excel). Solving by hand is preferred since you will not have access to a computer duripg the exams or quizzes Sue Higgins, the sales manager at The Boler Corporation, has given you the following information regarding the sales history of one of Boler's products, the Candi Kane: 330 350 300 270 235 220 195 180 a. Plot the quarterly sales data...

  • Papenfuss Family Inn is a bed and breakfast establishment in a converted 100-year-old mansion. The Inn's...

    Papenfuss Family Inn is a bed and breakfast establishment in a converted 100-year-old mansion. The Inn's guests appreciate its gourmet breakfasts and individually decorated rooms. The Inn's overhead budget for the most recent month appears below: Activity level 62 guests Variable overhead costs: Supplies $ 83.70 Laundry 409.20 Fixed overhead costs: Utilities 540.00 Salaries and wages 5,140.00 Depreciation 2,650.00 Total overhead cost $ 8,822.90 The Inn's variable overhead costs are driven by the number of guests. What would be the...

  • Mongelli Family Inn is a bed and breakfast establishment in a converted 100-year-old mansion. The Inn's...

    Mongelli Family Inn is a bed and breakfast establishment in a converted 100-year-old mansion. The Inn's guests appreciate its gourmet breakfasts and individually decorated rooms. The Inn's overhead budget for the most recent month appears below: Activity level 90 guests Variable overhead costs: Supplies $234 Laundry 315 Fixed overhead costs: Utilities 220 Salaries and wages 4,290 Depreciation 2,680 Total overhead cost $7,739 The Inn's variable overhead costs are driven by the number of guests. Assuming that the activity levels of...

  • May Corporation, a merchandising firm, has budgeted sales as follows for the third quarter of the...

    May Corporation, a merchandising firm, has budgeted sales as follows for the third quarter of the year:    July$99,000 August$72,000 September$86,400 Cost of goods sold is equal to 65% of sales. The company wants to maintain a monthly ending inventory equal to 110% of the Cost of Goods Sold for the following month. The inventory on June 30 is less than this ideal since it is only $68,185. The company is now preparing a Merchandise Purchases Budget. The budgeted purchases...

  • The following figures relate to a hospitality business. 35% of all sales and 80% of all...

    The following figures relate to a hospitality business. 35% of all sales and 80% of all purchases are on credit. Using accepted ratios and percentages comment on the gross and net profits, the current ratio and the acid test, debtors and creditors payment periods, stock turnover, and return on capital employed. Trading and profit and loss account for year ending December 31st 2014 £000's 2014 60,000 24,000 36,000 15.000 21,000 9.750 11,250 Sales Cost of sales Gross profit Wages Net...

  • The small leather goods department had planned the following figures for the Fall season: Planned total sales for season...

    The small leather goods department had planned the following figures for the Fall season: Planned total sales for season:                $102,000 Planned turnover for season:                       2.0 Planned sales for November:                  $26,000 Calculate the November BOM figure for this department using the basic stock method.

  • The following data relate to Webster Manufacturing: Anticipated sales...............................     50,000 units Normal sales price/unit.....................    ...

    The following data relate to Webster Manufacturing: Anticipated sales...............................     50,000 units Normal sales price/unit.....................     $20 Variable manufacturing cost/unit..... $6 Variable selling cost/unit.................... $2 Fixed manufacturing cost.................     $150,000 ($3.00/unit) Fixed selling cost ............................ $200,000 ($4.00/unit) Total cost/unit (full absorption)........     $15.00 Webster has the opportunity to take a one-time special order from a customer who wants to buy 10,000 units, but is only willing to pay $14.00 per unit. The special order will not affect Webster’s anticipated sales...

  • Payroll Register The following data for Throwback Industries Inc. relate to the payroll for the week...

    Payroll Register The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 2018: Hours Hourly Federal Retirements Weekly Salary Eme Worked Rate Income Tax Savings Aaron $46 $486.68 Cobb 295.84 Clemente 216.6 DiMaggio 264.18 Griffey, 3r. Mantle $2,140 Robinson 458.64 513.60 189.00 528.00 249.20 Williams 2.400 Vaughn Employees Mantle and Williams are office staff, and all of the other employees are sales personnel. All sales personnel are paid 1 times the regular rate...

  • The following table shows the data for a hypothetical economy in a specific year All figures...

    The following table shows the data for a hypothetical economy in a specific year All figures are in billions of dollars The following table shows the data for a hypothetical economy in a specific year. All figures are in billions of dollars. Value $80 Category Personal consumption expenditures Purchases of stocks and bonds Net exports Government purchases Sales of secondhand items Gross investment 25 Instructions: Enter your answer as a whole number What is the country's GDP for the year?...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT