DIRECTIONS for questions 1 – 5: Refer to the following bar graph of monthly cumulative sales over the last three years of star budget.
If the sales of three consecutive years are steadily increasing or steadily decreasing, then it is called a steady trend. The only months in which increasing steady trend is observed are
A. March & June
B. Jan & June
C. April & March
D. Feb & May
Answer: C By Visual Observation, sales of three consecutive years are steadily increasing in March and April.
In 2000, the ratio of actual to budget was highest in the month of
Answer: B In 2000, The ratio of Actual to Budget in Jan. = 100/50 = 2 Ratio of Actual to Budget in Feb. = 500/200 = 2.5 Ratio of Actual to Budget in Mar. = 900/400 = 2.25 Ratio of Actual to Budget in Apr. = 1150/600 = 1.92 Therefore, the highest ratio is in February.
Total approximate growth in sales in the year 1999, over the previous year was
Answer: D Total sales in 1998 = 1600 kgs Total sales in 1999 = 1300 kgs Therefore,total growth in sales = 100 x (1300-1600)/1600 = -18.76%
The annual budget for 2000 was achieved during
Answer: D By visual observation, Annual budgeted sale is 1000 Kg, which is achieved in August.
Predictor is the ratio of sales during Jan-Mar quarter to annual sales (budgeted for current year & actual for previous years). The predictor was highest in
D. Can’t say
Answer: C Predictor value in 1998 = 780 / 1600 = 0.4875. Predictor value in 1999 = 800 / 1310 = 0.6106 Predictor value in 2000 = 900 / 1300 = 0.69 Predictor was highest in 2000.