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?