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

Expert Solution

orchestra answered 2 years ago

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%?

The data shown below contains the monthly sales (in thousands of dollars) at a local department...

The data shown below contains the monthly sales (in thousands of dollars) at a local department store for each of the past 24 months. Copy the data to Excel, perform a runs test, and compute a few autocorrelations to determine whether this time series is random. Give your conclusion by referring to the results of your runs test and autocorrelations (no need to try to attach the Excel output in this text box, just mention the specific values you refer...

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.

Question