What is the Seasonal Factor for this firm\'s first quarter? second quarter? thir

Question

What is the Seasonal Factor for this firm's first quarter? second quarter? third quarter?

What is the appropriate Seasonal Index for this firm's fourth quarter?

What is the sales forecast in dollars for the first quarter year three? second quarter year three? third quarter year three? fourth quarter year three?

23 Tucson Machinery, Inc. manufactures numerically controlled machines, which sells for an wered average price of $0.5 million each. Unit sales for the past two years are shown in the table below. Also shown is the graph of the demand. The equation for the deseasonalized data is Y 0.76X 16.6. uestion Quantity Quarter 26 29 Finis Time overall Average Quarter What is appropriate Seasonal Factor (SF) for this firm's first quarter? Select one

Explanation / Answer

The above given Table is the total table for all the answers of above given questions.

Seasonal Factor for

First quarter = 0.71

Second quarter = 1.06

Third quarter = 1.37

Fourth Quarter = 0.86

Formula for all these seasonal Factor is [ sum of quarter I values] * 4 / [ sum of total sales quantity]

Sales forcast for

Year third and quarter

Quarte I = First put quarter value ( year 3 and quarter I that means 9th quarter)

so Y = 16.6 + 0.76 * 9 = 23.44

Multiplying it with seasonal factor Yforcasted seasonal = 23.44 * 0.71 = 16.62

Similarly

For Quarter II, FOrecast = 25.73

For quarter III, Forecast = 34.12

For quarter IV, Forecast = 22.14

Quarter Quantity(Year I) Quantity(Year II) sum seasonal index Quarter Values Quantity(Year II) I 12 16 28 0.71 9.00 16.62 II 18 24 42 1.06 10.00 25.73 III 26 28 54 1.37 11.00 34.12 IV 16 18 34 0.86 12.00 22.14 158

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.