Plz give explanation on how to make this in edcelxcel using the necessary formula and plz give complete solution

Task $1$Prepare a budget in ExcelTotal: $76$ MarksConstruct a budget for the six months ending $31$ December $2024$ for "Rainey Dey $-$ Umbrella Emporium" using Excel.All dollar amounts should be shown to zero $(0)$ decimal places.Base the budget on the following information:Rainey Dey has been running a business as a sole trader for two $(2)$ years. The business purchases Sun Umbrellas from an importer and sells them online throughout New Zealand. Rainey has asked you to prepare a budget for the six months from July to December.There are three $(3)$ different products that the business purchases and sells: Pipsqueak Umbrella, Everyday Umbrella and Jumbo Umbrella.Due to international supply chain problems, the costs of the Umbrellas are expected to rise over the following months. Rainey's supplier has provided forecast purchases prices for the budget period as follows:As cost of goods is increasing, Rainey plans to increase the sales price of the Pipsqueak and Everyday Umbrellas in September, as indicated in the following table:The business is slowing growing with budgeted sales for the three products, in units, from June to January are shown in the following table:Te P$$kenga Assessment Guide $|$ ACCY$5104$ Budgets for Planning and ControlTe PukengaSales PricesProductJune to AugustSeptember to JanuaryPipsqueak Umbrella$$17\mathrm{.}00$$$20\mathrm{.}00$Everyday Umbrella$$19\mathrm{.}00$$$22\mathrm{.}00$Jumbo Umbrella$$28\mathrm{.}00$$$28\mathrm{.}00$Sales VolumesMonthPipsqueak UmbrellaEveryday UmbrellaJumbo UmbrellaJune$160120100$July$160120100$August$162120100$September$162120100$October$170120100$November$170135100$December$170135100$January$170135100$

Task $1$

Prepare a budget in Excel

Total: $76$ Marks

Construct a budget for the six months ending $31$ December $2024$ for "Rainey Dey $-$ Umbrella Emporium" using Excel.

All dollar amounts should be shown to zero $(0)$ decimal places.

Base the budget on the following information:

Rainey Dey has been running a business as a sole trader for two $(2)$ years. The business purchases Sun Umbrellas from an importer and sells them online throughout New Zealand. Rainey has asked you to prepare a budget for the six months from July to December.

There are three $(3)$ different products that the business purchases and sells: Pipsqueak Umbrella, Everyday Umbrella and Jumbo Umbrella.

Due to international supply chain problems, the costs of the Umbrellas are expected to rise over the following months. Rainey's supplier has provided forecast purchases prices for the budget period as follows:

$\backslash$table$[[$Purchase Prices,$],[$Product$,$June to October,November to January$],[$Pipsqueak Umbrella,$$11\mathrm{.}00,$$$13\mathrm{.}00$