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 8 months 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
- 1. What is the historical role of investment bankers ? Has this role changed ? Why...
- How were the original Internet requirements met through its design? What are the two main requirements...
- discuss crowdfunding on platforms: What features of the services incorporate virality? What are some of the...
- A textbook of mass 2.08 kg rests on a frictionless, horizontal surface. A cord attached to...
- Describe a time when someone did not really listen to or understand a point you were...
- Enumerations Create an advanced enumeration to represent months (JANUARY – DECEMBER) called enuMonths Add internal properties...
- What is the minimum size of the automorphism group of a simple directed graph having more...
ADVERTISEMENT