Question

In: Statistics and Probability

The monthly value of sales for the first 3 years of a restaurant’s operation is shown...

The monthly value of sales for the first 3 years of a restaurant’s operation is shown below (values are in 1,000 USD).

Use a multiple linear regression model with dummy variables to develop an equation to account for seasonal effect in the data. (data below) ---- SHOW IN EXCEL

Month Sales
1 242
2 235
3 232
4 178
5 184
6 140
7 145
8 152
9 110
10 130
11 152
12 206
13 263
14 238
15 247
16 193
17 193
18 149
19 157
20 161
21 122
22 130
23 167
24 230
25 282
26 255
27 265
28 205
29 210
30 160
31 166
32 174
33 126
34 148
35 173

Solutions

Expert Solution


Related Solutions

Five years of a well-established brand’s monthly sales volume data are shown in the table below....
Five years of a well-established brand’s monthly sales volume data are shown in the table below. As may be noted, there is substantial seasonality in this brand's sales. Forecaster Simulation: Problem #3 Data Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 January 5550 4782 5283 4760 4314 February 5398 4897 4544 4930 4476 March 4236 4693 4370 4930 4476 April 2977 3747 2419 3065 3350 May 2345 2235 2463 2546 2274 June 1198 1156 1887 1602...
The quarterly sales (number of books sold) over the past 3 years are as shown below....
The quarterly sales (number of books sold) over the past 3 years are as shown below. Year Quarter Period Sales 1 1 1 1700 1 2 2 1000 1 3 3 2700 1 4 4 2500 2 1 5 1800 2 2 6 900 2 3 7 2900 2 4 8 2400 3 1 9 1800 3 2 10 1100 3 3 11 2900 3 4 12 2600 Construct a time series plot for this data. Paste the time series...
Scherer Company provided the following income statements for its first 3 years of operation: Scherer Company...
Scherer Company provided the following income statements for its first 3 years of operation: Scherer Company Income Statements Years of Operation 1 Year 1 Year 2 Year 3 2 Net sales $960,000.00 $1,056,000.00 $1,248,000.00 3 Less: Cost of goods sold 295,000.00 324,000.00 363,000.00 4 Gross margin $665,000.00 $732,000.00 $885,000.00 5 Less: 6 Operating expenses 425,000.00 484,000.00 595,500.00 7 Income taxes 109,600.00 121,200.00 136,600.00 8 Net income $130,400.00 $126,800.00 $152,900.00 Required: Prepare common-size income statements by using net sales as the...
A machine has no maintenance costs the first 5 years of operation. At the end of...
A machine has no maintenance costs the first 5 years of operation. At the end of years 6-10, the annual cost is $1000/yr. For years 11-15, the annual cost is $2000/yr. What is the equivalent annual cost for all of this maintenance if the interest rate is 10%?
Wang Company provides the following information for their first year of operation:    Sales                         5,00
Wang Company provides the following information for their first year of operation:    Sales                         5,000 units @ $10                   Variable production costs per unit:         SG&A costs:                                                                        Direct materials          $2      Fixed                    $1,000                                                 Direct labor                 $2       Variable                $1 per unit                                           Var MOH                    $1 Fixed MOH             $7,500                                     Production                              7,500 units    (T or F) If Wang uses variable costing, operating income will be $11,500. True False
3 a) An investment of $11,550 is deposited for 3 years at 2.2% compounded monthly. At...
3 a) An investment of $11,550 is deposited for 3 years at 2.2% compounded monthly. At this point, the interest rate is changed to 1.95% compounded semi-annually. The investment earns interest for 5 more years. What is the value of FV1? b) Money is invested at 8.27% p.a. compounded semi-annually for 39 months. What is the numerical value of n? State your answer with 6 decimals.
The Frontline Corporation's projected sales for the first 8 months of 2019 are shown in the...
The Frontline Corporation's projected sales for the first 8 months of 2019 are shown in the table below. Jan $        190,000 May $    300,000 Feb            120,000 Jun        270,000 Mar            135,000 Jul        225,000 Apr            240,000 Aug        150,000 Of Frontline's sales, 10% is for cash, 60% is collected in the month following the sales, and 30% is collected in the second month following sales. November and December 2018 sales were $220,000 and $175,000, respectively. Frontline purchases...
The Brick Company had cash sales of $227,900 for Year 1, its first year of operation....
The Brick Company had cash sales of $227,900 for Year 1, its first year of operation. On April 2, the company purchased 214 units of inventory at $225 per unit. On September 1, an additional 161 units were purchased for $248 per unit. The company had 66 units on hand at the end of the year. The company’s income tax rate is 40 percent. All transactions are cash transactions. a. The preceding paragraph describes five accounting events: (1) a sales...
With 3-digit rounding after each operation find the value of: a. 0.4 + 0.4 + …...
With 3-digit rounding after each operation find the value of: a. 0.4 + 0.4 + … + 0.4 + 100 (where the 0.4 is repeated 100 times) b. 100+0.4 + 0.4 + … + 0.4 (where the 0.4 is repeated 100 times) c. Find the absolute and relative error in parts a and b.
Storrs Cycles has just started selling the new Cyclone mountain​ bike, with monthly sales as shown...
Storrs Cycles has just started selling the new Cyclone mountain​ bike, with monthly sales as shown in the table.                                                                Month Jan Feb Mar Apr Sales 400 372 418 375 ​a) Based on the given monthly sales​ data, it can be said that there is not a strong linear trend in sales over time. ​b) First,​ co-owner Bob Day wants to forecast by exponential smoothing by initially setting​ February's forecast equal to​ January's sales with α ​= 0.20. Using the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT