Question
In: Economics
Period Sales ($million) 2017 Q1 2874 2017 Q2 3000 2017 Q3 2913 2017 Q4 2916 2918...
|
Period |
Sales ($million) |
||||
|
2017 Q1 |
2874 |
||||
|
2017 Q2 |
3000 |
||||
|
2017 Q3 |
2913 |
||||
|
2017 Q4 |
2916 |
||||
|
2918 Q1 |
2910 |
||||
|
2018 Q2 |
3052 |
||||
|
2018 Q3 |
3116 |
||||
|
2018 Q4 |
3210 |
||||
|
2019 Q1 |
3243 |
||||
|
2019 Q2 |
3351 |
||||
|
2019 Q3 |
3305 |
||||
|
2019 Q4 |
3267 |
The above table represents the quarterly sales (measured in millions of dollars) for the Goodyear Tire from 2017 to 2019.
- Compute the 4-quarter moving average. Put your answers onto the table.
- Compute the 4-quarter centered moving average. Put your answers onto the table.
- Compute the seasonal factor. Put your answers onto the table.Compute the seasonal index. Put your answers onto the table.
- Compute the seasonal index. Put your answers onto the table.
Solutions
Expert Solution
| Period | Period Number | Sales ($million) | Periods Used | 4 Quarter Moving Average | Value | 4 Quarter Centered Moving Average | Value | Seasonality Index |
| 2017 Q1 | 1 | 2874 | 0.077347 | |||||
| 1.5 | ||||||||
| 2017 Q2 | 2 | 3000 | 0.080738 | |||||
| 2.5 | 2017 Q1, 2017 Q2, 2017 Q3, 2017 Q4 | =(2874+3000+2913+2916)/4 | 2925.75 | |||||
| 2017 Q3 | 3 | 2913 | =(2925.75+2934.75)/2 | 2930.25 | 0.078397 | |||
| 3.5 | 2017 Q2, 2017 Q3, 2017 Q4, 2018 Q1 | =(3000+2913+2916+2910)/4 | 2934.75 | |||||
| 2017 Q4 | 4 | 2916 | =(2934.75+2947.75)/2 | 2941.25 | 0.078478 | |||
| 4.5 | 2017 Q3, 2017 Q4, 2018 Q1, 2018 Q2 | =(2913+2916+2910+3052)/4 | 2947.75 | |||||
| 2918 Q1 | 5 | 2910 | =(2947.75+2998.5)/2 | 2973.125 | 0.078316 | |||
| 5.5 | 2017 Q4, 2018 Q1, 2018 Q2, 2018 Q3 | =(2916+2910+3052+3116)/4 | 2998.5 | |||||
| 2018 Q2 | 6 | 3052 | =(2998.5+3072)/2 | 3035.25 | 0.082138 | |||
| 6.5 | 2018 Q1, 2018 Q2, 2018 Q3, 2018 Q4 | =(2910+3052+3116+3210)/4 | 3072 | |||||
| 2018 Q3 | 7 | 3116 | =(3072+3155.25)/2 | 3113.625 | 0.08386 | |||
| 7.5 | 2018 Q2, 2018 Q3, 2018 Q4, 2019 Q1 | =(3052+3116+3210+3243)/4 | 3155.25 | |||||
| 2018 Q4 | 8 | 3210 | =(3155.25+3230)/2 | 3192.625 | 0.08639 | |||
| 8.5 | 2018 Q3, 2018 Q4, 2019 Q1, 2019 Q2 | =(3116+3210+3243+3351)/4 | 3230 | |||||
| 2019 Q1 | 9 | 3243 | =(3230+3277.25)/2 | 3253.625 | 0.087278 | |||
| 9.5 | 2018 Q4, 2019 Q1, 2019 Q2, 2019 Q3 | =(3210+3243+3351+3305)/4 | 3277.25 | |||||
| 2019 Q2 | 10 | 3351 | =(3277.25+3291.5)/2 | 3284.375 | 0.090185 | |||
| 10.5 | 2019 Q1, 2019 Q2, 2019 Q3, 2019 Q4 | =(3243+3351+3305+3267)/4 | 3291.5 | |||||
| 2019 Q3 | 11 | 3305 | 0.088947 | |||||
| 11.5 | ||||||||
| 2019 Q4 | 12 | 3267 | 0.087924 | |||||
| TOTAL | 37157 |
Rahul Sunny answered 1 year agoRelated Solutions
Wentworth Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales...
Wentworth Products has projected the following sales for the
coming year:
Q1
Q2
Q3
Q4
Sales
$360
$450
$600
$540
Sales in the year following this one are projected to be 10
percent greater in each quarter.
Calculate payments to suppliers assuming that the company
places orders during each quarter equal to 25 percent of projected
sales for the next quarter. Assume that the company pays
immediately.
a. What is the payables period in this case?
(Do not round intermediate...
Wentworth Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales...
Wentworth Products has projected the following sales for the
coming year:
Q1
Q2
Q3
Q4
Sales
$650
$740
$875
$805
Sales in the year following this one are projected to be 15
percent greater in each quarter.
a.
Assume that the company places orders during each quarter equal
to 30 percent of projected sales for the next quarter. Assuming
that the company pays immediately, what is the payables period?
(Do not round intermediate calculations and round your
answer to the...
All That Remains Products has projected sales for next year of: Q1 Q2 Q3 Q4 Sales...
All That Remains Products has projected sales for next year
of:
Q1
Q2
Q3
Q4
Sales
$
76,000
$
79,775
$
86,500
$
93,480
The company places orders each quarter that are 52 percent of the
following quarter's sales and has a 60-day payables period. What is
the accounts payable balance at the end of the third quarter?
Production Budget Q1 Q2 Q3 Q4 Total Sales in Units 1,000 1,200 1,500...
Production Budget
Q1
Q2
Q3
Q4
Total
Sales in Units
1,000
1,200
1,500
2,000
5,700
Add: Desired Ending Inv.
240
300
400
400
400
Total Needs
1,240
1,500
1,900
2,400
6,100
Less:Beginning Inv.
180
240
300
400
180
Units to be produced
1,060
1,260
1,600
2,000
5,92
The Direct Materials Budget tells management how much...
Brunell Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4...
Brunell Products has projected the following sales for the
coming year:
Q1
Q2
Q3
Q4
Sales
$480
$570
$720
$660
Sales in the year following this one are projected to be 10 percent
greater in each quarter.
Calculate payments to suppliers assuming that the company places
orders during each quarter equal to 25 percent of projected sales
for the next quarter. Assume that the company pays
immediately.
a. What is the payables period in this case?...
Do all the Q1, Q2, Q3 and Q4 The cash budget is the primary tool used...
Do all the Q1, Q2, Q3 and Q4
The cash budget is the primary tool used in
short-term financial planning. As with many calculations, the sales
forecast is a primary input. As an example of the cash budgeting
process, we will use the Fun Toys Corporation. The sales
projections and other information provided are:
Q1
Q2
Q3
Q4
Sales
$ 200,000,000
$ 300,000,000
$ 250,000,000
$ 400,000,000
Beginning receivables:
$ 120,000,000
Receivables period (days):
45
With the receivables period shown, we can calculate
the percentage...
arranged q1 to q2 to q3 a is between q1 and q2 b is between q2...
arranged q1 to q2 to q3 a is between q1 and q2 b is between q2
and q3
Let a=3 m, b=7 m, q1=2 C, q3=-3 C. What must q2 be for q1 to
feel no net force.
b)
Let a=3 m, b=8 m, q1=4 C, q2=5 C,
q3=-5 C. What is the magnitude of the electric field a
distance c=4 m vertically above q2 i.e. located at
(x,y)=(a,c)?
Let Q1, Q2, Q3, Q4 be constants so that R (2x + 3) sin 4x dx...
Let Q1, Q2, Q3, Q4 be constants so that R (2x + 3) sin 4x dx =
(Q1x + Q2) sin 4x + (Q3x+Q4) cos 4x+C, where C is a constant of
integration. Let Q = ln(3 +|Q1|+ 2|Q2|+ 3|Q3| + 4|Q4|). Then T = 5
sin2 (100Q)
satisfies:— (A) 0 ≤ T < 1. — (B) 1 ≤ T < 2. — (C) 2 ≤ T
< 3. — (D) 3 ≤ T < 4. — (E) 4 ≤...
Let Q1, Q2, Q3 be constants so that (Q1, Q2) is the critical point of the...
Let Q1, Q2, Q3 be constants so that (Q1, Q2) is the critical
point of the function f(x, y) = (175)x 2 + (−150)xy + (175)y 2 +
(−200)x + (400)y + (230), and Q3 = 1 if f has a local minimum at
(Q1, Q2), Q3 = 2 if f has a local maximum at (Q1, Q2), Q3 = 3 if f
has a saddle point at (Q1, Q2), and Q3 = 4 otherwise. Let Q = ln(3
+...
Let Q1, Q2, Q3 be constants so that (Q1, Q2) is the critical point of the...
Let Q1, Q2, Q3 be constants so that (Q1, Q2) is the critical
point of the function f(x, y) = (90)x 2 + (0)xy + (90)y 2 + (−72)x
+ (96)y + (40), and Q3 = 1 if f has a local minimum at (Q1, Q2), Q3
= 2 if f has a local maximum at (Q1, Q2), Q3 = 3 if f has a saddle
point at (Q1, Q2), and Q3 = 4 otherwise. Let Q = ln(3 +...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
ADVERTISEMENT