The 100-room Delavan Inn's past three years of room sales for April are as follows: Rooms Room Year Sold ADR Revenues 20X1 2,100 $45 $94,500 20X2 2,130 47 100,110 20X3 2,160 49 105,840 Analyze the past performance and project sales for April 20X4. Assume that the trends of rooms sold and ADR continue for April of 20X4.

The 100-room Delavan Inn's past three years of room sales for April are as follows: Rooms Room Year Sold ADR Revenues 20X1 2,100 $45 $94,500 20X2 2,130 47 100,110 20X3 2,160 49 105,840 Analyze the past performance and project sales for April 20X4. Assume that the trends of rooms sold and ADR continue for April of 20X4.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 11P: For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12...

See similar textbooks

Similar questions

The following information concerning sales revenues for a development, Cool Blue, for the last four months have been as follows. Month Sales revenues Website 'hits' 1 145,000 90,000 2 115,000 80,000 3 111,000 77,000 4 100,000 67,000 Calculate the revenues that should be expected in month five when hits is expected to be 85,000 units. Ignore inflation.
Macom Manufacturing has total contribution margin of $61,250 and net income of $24,500 for the month of June. Marcus expects sales volume to increase by 10% in July. What are the degree of operating leverage and the expected percent change in income for Macom Manufacturing? 0.4 and 10% 2.5 and 10% 2.5 and 25% 5.0 and 50%
Blake McKenzie Tax Services is a company serving 72 clients (as of the beginning of last month) that is working on reorganizing its balanced scorecard. Currently, the company has the following performance metrics: online client satisfaction rating, client growth percentage (the number of total clients at the beginning of the current month compared to the number of total clients at the beginning of the prior month), market share, and profit margin. The company tracks these metrics from month to month. The companys target client growth percentage is 4% per month. Its target average online client satisfaction rating is 4.8 stars. Last month, the company noted the following data related to these metrics: a. Working together in teams, create strategic objectives that each of the companys four performance metrics might represent. b. Determine whether the company achieved its client growth percentage target last month. c. Suppose that last month, the company received 55 five-star reviews, 10 four-star reviews, 3 three-star reviews, 1 two-star review, and 1 one-star review (some clients did not submit a review). Determine whether the company met its average online client satisfaction rating target. d. Come up with at least one strategic initiative for the strategic objective of any performance metric target that you know the company did not meet last month.
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. Construct a time series plot. What type of pattern exists in the data? Compare a three-month moving average forecast with an exponential smoothing forecast for α = 0.2. Which provides the better forecasts using MSE as the measure of model accuracy? What is the forecast for next month?
If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
The quarterly sales data (number of copies sold) for a college textbook over the past three years are as follows: a. Construct a time series plot. What type of pattern exists in the data? b. Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = l if quarter l, 0 otherwise; Qtr2 = l if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. c. Based on the model you developed in part (b), compute the quarterly forecasts for next year. d. Let t = 1 to refer to the observation in quarter 1 of year 1; t = 2 to refer to the observation in quarter 2 of year 1; ; and t = 12 to refer to the observation in quarter 4 of year 3. Using the dummy variables defined in part (b) and t, develop an equation to account for seasonal effects and any linear trend in the time series. e. Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year. f. Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.
The Toro Cutlery Company has collected monthly sales information below: MONTH MONTH May January February June March April SALES 15,000 18,000 33,000 115,000 SALES 77,000 30,000 80,000 44,000 MONTH September October November December SALES 34,000 101,000 68,000 84,000 July August The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): Forecast (January, 4-month MA): Forecast (January, 5-month MA): b. What will the forecast be for January the following year using exponential smoothing with a = 0.4? Assume the forecast for February this year is 15,000. Do not round intermediate calculations. Round your answer to the nearest whole number.
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account):1st Quarter 2nd Quarter 3rd Quarter 4th QuarterBudgeted unit sales ............................ 11,000 12,000 14,000 13,000The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of salesin the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to beuncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in thefi rst quarter, is $70,200.The company expects to start the first quarter with 1,650 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,850 units.Required:1. Prepare the company’s sales budget and schedule of expected cash…
ARE YOU READY TO PRACTICE: Complete the table below. A Company has the following sales 2,000 in January, 2,200 in February, 2,800 in Apr and 3,000 in May. Assuming the selling prices is P100/unit. Sales for each month ar expected to be collected as follows: • Month of sales: 20% ► A month after sales: 50% ► 2 months after sales: 30% - How much is total receipts from sales? Apr Jan Feb Mar May Total Units Sold 12, 500 P1,250,000 P250,000 Sales in Pesos Collection from current months sales Collection from previous P150,000 months sales Collection from two months P84,000 sales Total Collections from Sales 40,000 P926,000 PRACTICE EXERCISE 1: Fill the table below. A Company has the following sales 2,000 in January, 2,200 in February, 2,800 in April and 3,00 in May. Assume that cost per unit is PHP50. All purchases this month are paid the following month. How much is total cash disbursements for purchases? Jan Feb Mar Apr May Total Required production Cost in Pesos Payment from current…
Monthly sales of storage sheds at Wallace Garden supply are shown in the following table. Using the 3-month moving average forecasting method (simple average), what is your forecast of December sales? Actual Month Sales January February March April May June July August September October November December? O 15.2 16.7 20.67 O None of the above 10 12 16 13 17 19 15 20 22 19 21
Given: Month Total Sales/month November December January February March P1,500 8,000 6,000 7,200 8,600 Requirements: (Show solutions) 1. What is the growth rate per month? 2. What is the Average growth rate? 3. Forecast for the next 6-month the Total Sales, based on the above previous sales performance.
A July sales forecast projects that 8,000 units are going to be sold at a price of $9.00 per unit. Management forecasts 2% growth in sales each month. Total August sales are anticipated to be: Multiple Choice $72,000. $70,560. $74,880. $73.440. $68,000.