Question

In: Statistics and Probability

A consulting firm estimates the quarterly sales (in millions of dollars) of a Regional Airlines called...

A consulting firm estimates the quarterly sales (in millions of dollars) of a Regional Airlines called “U Fly”, by the following significant model:

E(Sales) = 300.5 + 2.37(T) - 4.6Q₁ - 6.8Q₃ + 8.65Q₄

Where E(Sales) is the average sales for each quarter (in millions of dollars), T is a time index defined as 1, 2, 3, …………,20, and 20 represents the first quarter of 2020, Q₁ = 1 when in the first quarter, 0 otherwise, Q₃ =1 when in the third quarter, 0 otherwise, and Q₄ = 1 when in the fourth quarter, 0 otherwise,.

a. Briefly explain the meaning of estimated sample slopes for the trend (2.37) and the first quarter (-4.6).

b. Forecast actual sales (in dollars) for the second and third quarters of 2020. Explain your answers.

Expert Solution

Answer:

a) Briefly explain the meaning of estimated sample slopes for the trend (2.37) and the first quarter (-4.6).

The slope for the trend means for every increase in the time period, the quarterly sales will increase by 2.37.

The first quarter means for every first quarter, the quarterly sales will decrease by 4.6.

b) Forecast actual sales (in dollars) for the second and third quarters of 2020. Explain your answers

For the second quarter of 2020:

E(Sales) = 300.5 + 2.37(T) - 4.6Q1 - 6.8Q3 + 8.65Q4

E(Sales) = 300.5 + 2.37(21) - 4.6*0 - 6.8*0 + 8.65*0

E(Sales) = 350.27

For the third quarter of 2020:

E(Sales) = 300.5 + 2.37(T) - 4.6Q1 - 6.8Q3 + 8.65Q4

E(Sales) = 300.5 + 2.37(22) - 4.6*0 - 6.8*1 + 8.65*0

E(Sales) = 345.84

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE SUPPORT ME WITH YOUR RATING...

***PLEASE GIVE ME "LIKE"...ITS VERY IMPORTANT FOR ME NOW....PLEASE SUPPORT ME ....THANK YOU

orchestra answered 2 years ago

1.Assume you collected a quarterly sales data (in millions of dollars) over a four-year period from...

1.Assume you collected a quarterly sales data (in millions of dollars) over a four-year period from the first quarter 2016 to the fourth quarter 2019, and computed the seasonal index for each quarter. If the values of the actual sales and deseasonalised sales were 162 and 158.68, respectively, in the second quarter of 2016, what is the (normalised) seasonal index for the second quarter? Round your answer to two decimal places. 2. Assume you collected data representing the number of...

This data shows the series of quarterly shipments in millions of US dollars of US hosehold...

This data shows the series of quarterly shipments in millions of US dollars of US hosehold appliances between 1985 and 1989. Quarter Shipments Q1-1985 4009 Q1-1986 4123 Q1-1987 4493 Q1-1988 4595 Q1-1989 4245 Q2-1985 4321 Q2-1986 4522 Q2-1987 4806 Q2-1988 4799 Q2-1989 4900 Q3-1985 4224 Q3-1986 4657 Q3-1987 4551 Q3-1988 4417 Q3-1989 4585 Q4-1985 3944 Q4-1986 4030 Q4-1987 4485 Q4-1988 4258 Q4-1989 4533 (a) which of the following methods would be suitable for forecasting this series if applied to raw...

Viena is a regional firm that offers audit, tax, and consulting services. The partners are concerned...

Viena is a regional firm that offers audit, tax, and consulting services. The partners are concerned about the profitability of their audit business, and a closure decision might be forthcoming. If the firm drops the audit activities, it might do more tax work. Only 30 percent of facility costs associated with auditing disappears by dropping the auditing function. More tax work can increase tax revenues by 40 percent, but tax service-level costs also increase by 40 percent. Total facility cost...

The company PR Products Corp. estimates that its quarterly sales for the next year are as...

The company PR Products Corp. estimates that its quarterly sales for the next year are as follows: (units) The price per unit is $ 70 1. 1 Quarter 30,000 units 2. 2 Quarter 50,000 3. 3 Quarter 60,000 4. 4 Quarter 40,000 Accounts receivable as of December 31 are $ 90,000. The company estimates that sales are charged 60% in the quarter they are made and 40% in the following quarter. Finished Goods' desired ending inventory represents 20% of next...

This data shows the series of quarterly shipments in millions of US dollars of US hosehold appliances between 1985 and 1989.

Please show answers and code using R/R Studio. This data shows the series of quarterly shipments in millions of US dollars of US hosehold appliances between 1985 and 1989. Quarter Shipments Q1-1985 4009 Q1-1986 4123 Q1-1987 4493 Q1-1988 4595 Q1-1989 4245 Q2-1985 4321 Q2-1986 4522 Q2-1987 4806 Q2-1988 4799 Q2-1989 4900 Q3-1985 4224 Q3-1986 4657 Q3-1987 4551 Q3-1988 4417 Q3-1989 4585 Q4-1985 3944 Q4-1986 4030 Q4-1987 4485 Q4-1988 4258 Q4-1989 4533 (b) apply a moving average with window span w=4...

Figures are in millions of dollars Net sales $ 2,473.8 Cost of goods sold (COGS) $...

Figures are in millions of dollars Net sales $ 2,473.8 Cost of goods sold (COGS) $ 1,316.2 Operating expenses (S&GA) $ 575.8 Inventory $ 250.1 Accounts receivable $ 36.7 Other current assets $ 68.9 Fixed assets $ 690.0 What's the net profit margin? $____ Show work. What's the net profit margin %? _____ Show work. What's the value of total assets? $____ Show work. What's the asset turnover ? $____ Show work. What's the return on assets (ROA)? $____ Show...

Snowcome Company estimates that quarterly unit sales will increase by 15% assuming a unit selling price...

Snowcome Company estimates that quarterly unit sales will increase by 15% assuming a unit selling price of $30. Prepare a Sales Budget Quarterly for the upcoming year, 2018. Last Years quarterly sales figures are Sales 2017 Q1- 75076 Q2- 70041 Q3- 65081 Q4- 80037 2. Snowcome would like to have an ending inventory of finished goods equal to 10% of expected sales for the following period. Assuming the ending inventory of finished goods on December 31, 2017 is 8,500 units....

Wildcat Inc has estimates sales (in millions) for the next four months as follows: January: $230...

Wildcat Inc has estimates sales (in millions) for the next four months as follows: January: $230 February: $195 March: $270 April: $290 Gross sales in November were $250, in December were $200, and May are projected at $250 million. Wildcat has a 60-day collection period. Wildcat’s purchases from suppliers in a month are equal to 55 percent of the next month’s forecasted sales, and suppliers are normally paid in 30 days. Wages, taxes, and other expenses run about 30 percent...

Income statement (millions of dollars) Net sales $ 39,579 COGS $ 12,180 Other Expenses $ 12,147...

Income statement (millions of dollars) Net sales $ 39,579 COGS $ 12,180 Other Expenses $ 12,147 Depreciation $ 7,554 EBIT $ 7,698 Interest Expense $ 2,055 Income Before Tax $ 5,643 Tax Expense (35%) $ 2,055 Net income $ 3,669 Dividends $ 2,568 Balance sheet (millions of dollars) Cash $ 300 Accounts Receivable $ 10,000 Inventories $ 5,000 Other Assets $ 3,000 Property, Plant and Equipment, net $100,000 Other Long-Term Assets $ 15,000 Accounts Payable $ 8,000 Short-Term Debt $ ...

The sales manager of a consulting firm hires salespeople based on the personalities of the customers...

The sales manager of a consulting firm hires salespeople based on the personalities of the customers and when assigning customers to sales people. What are the pros and cons of this?