- 20 Marks
IMAC – MAR 2024 – L1 – Q5 – Forecasting | Standard Costing and Variance Analysis
Calculate daily variations using moving averages and explain interrelationships between material price and usage variances, and labor rate and efficiency variances.
Question
a) BB Importers Ltd has been importing electrical gadgets through the port of Takoradi over the past ten years. Management is aware that the business has been facing seasonal fluctuations but there is no scientific basis for the determination of such variations that can be used to predict future revenue. As a newly recruited Cost Accountant, you have been provided with some past daily sales performance over a three-week period. Details of the sales performance are shown below:
Sales | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
Week 1 | 780 | 830 | 890 | 850 | 850 |
Week 2 | 880 | 930 | 990 | 950 | 950 |
Week 3 | 980 | 1030 | 1090 | 1050 | 1050 |
Required:
Using daily moving averages, calculate the daily variation for the company. (15 marks)
b) The reasons for variances might be connected, and two or more variances may arise from the same cause. For example, a favorable variance and an adverse variance might have the same cause.
Required:
Explain the interrelationships between:
i) Material price and usage variances (2.5 marks)
ii) Labor rate and efficiency variances (2.5 marks)
Find Related Questions by Tags, levels, etc.
- Tags: Material Price Variance, Moving Averages, Sales Forecasting, Usage Variance
- Level: Level 1
- Topic: Forecasting, Standard Costing and Variance Analysis
- Series: MAR 2024