can you please do this on excel and show all calculations

Part A

Task 1 Data entry

1. Type the following data on a new worksheet within a new workbook.

Expenditure Budget
Expense Type	Qtr 1	Qtr 2	Qtr 3	Qtr 4	Average Cost	Max Cost	Min Cost	Total
Wages	10000	12000	11500	9850
Raw Materials	12058	25854	26785	26972
Freight	1254	4872	6147	4517
Telephones	954	655	554	433
Electricity	1233	1100	1433	1200
Water	1250	1250	1250	1250
Insurance	1287	0	2587	0
Council Rates	1125	1125	1125	1125
Motor Vehicles	2500	2560	3200	1500
Entertainment	455	655	666	555
Expense Total

Insert into the heading row the following heading Total (GST inc)

2. Insert a heading GST Rate and 10% into the spreadsheet (at the bottom of the data area, ensure the 10% is located in a separate cell to the heading.)

3. Insert formulas/functions below the headings (Average Cost, Max Cost, Min Cost, Total, Total (GST inc)

(Total (GST inc) you must use an Absolute Reference and the GST is inclusive, Assume all items have GST)

4. Copy to another worksheet in the same workbook and name the new tab EXPENSE

Delete the Entertainment row

2. Change the Council Rates to 2546 for the Qtr1 and Qtr 3 only

3. Copy to another worksheet in the same workbook and name the new tab EXPENSE

Insert a Column Chart on a new worksheet (within the workbook) for Expense Type vs Qtr 1, 2, 3, 4.
2. Insert a Pie Chart on the same worksheet for Wages vs Qtr 1, 2, 3, 4. Explode the sector with the smallest wage and display the percentages for each sector
3. Name this tab EXPENSE 5