Royal Company is preparing a sales forecast for the second half of their fiscal year that runs
Question:
Royal Company is preparing a sales forecast for the second half of their fiscal year that runs to December 31st, 2022.
Actual unit sales for the first six months of fiscal year 2022 (1H2022) were provided by your groups management accountant.
Royal Company actual sales FY2022
Period | Units | Amin | Bavishi | Cheema |
(Q1FY2022) January | 30,000 units | 10,000 | 15,000 | 5,000 |
(Q1FY2022) February | 25,000 units | 5,000 | 10,000 | 10,000 |
(Q1FY2022) March | 15,000 units | 5,000 | 5,000 | 5,000 |
(Q2FY2022) April | 20,000 units | 10,000 | 5,000 | 5,000 |
(Q2FY2022) May | 25,000 units | 10,000 | 5,000 | 10,000 |
(Q2FY2022) June | 30,000 units | 5,000 | 10,000 | 15,000 |
Royal Company sells a single product selling at $12 per unit. Management is projecting growth for 2H2022; forecasting Q3 to grow at 5% per month and Q4 at 10% per month. The company’s fiscal year runs the same as the calendar year.
Turn this data into information by developing an Excel Workbook containing 3-linked worksheets (tabs).
• Sheet 1 shows actual data for the first six months of fiscal year 2022.
• Sheet 2 shows budgeted (forecast)for the second six months of fiscal 2022.
• Sheet 3 shows actual and budgeted data for the whole of fiscal 2022.
Questions (respond in discussion forum)
1. For what reasons would such a budget/forecast be used? -who would use it?
2. What additional information could be provided and for what purpose?