Given the following gasoline data:
Quarter Year 1 Year 2
1 150 156
2 140 148
3 185 201
4 160 174
(a) Compute the seasonal index for each quarter.
(b) Suppose we expect year 3 to have annual demand of 800. What is the forecast value for each quarter in year 3?
(a)
Quarter Year 1 Year 2 Average two-
year demand Quarterly demand Average seasonal index
1 150 156 153 164.25 .932
2 140 148 144 164.25 .877
3 185 201 193 164.25 1.175
4 160 174 167 164.25 1.017
(b)
Quarter Forecast
1 200 * .932 = 186.00
2 200 * .877 = 175.34
3 200 * 1.175 = 235.01
4 200 * 1.017 = 203.35
You might also like to view...
In a proposal, the statement of qualifications
A) presents the concept, product, or service you're proposing. B) delineates the costs involved in your proposed solution. C) describes your company's experience, personnel, and facilities. D) asks a decision-maker to authorize your proposed solution. E) orients readers to the information that the proposal will include.
Which of the following terms is defined as the set of values that helps an organization's members understand what it stands for, how it does things, and what it considers important?
A. Culture B. Diversity C. Ethnicity D. Folkway
Which of the following is the most likely application of data analytics for accountants to develop expertise in?
A. Scientific research. B. Medical testing. C. Domain knowledge of business functional areas. D. Directed marketing campaigns.
All of the other constraints and priorities remained the same. Based on this snippet of the sensitivity report, what should happen during this production run?
William ran the original model in Excel and discovered that he was walking away from significant income. He reformulated the model with a new profit constraint of 16R + 24W + d2+ + d2- = 550. Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$14 Rotgut 10 0 0 0 0 $C$14 White Lightning 15 0 0 0 0 $D$16 Hours d1+ 0 1 1 1E+30 1 $E$16 Hours d1- 7 0 0 1 0 $D$17 Profit d2+ 30 0 0 0 0 $E$17 Profit d2- 0 0 0 1E+30 0