Could you please assist me with part A if you can. I would really appreciate it. Thank You

32010_03_Attachment_1 v2 - Excel (Product Activation Failed) X Sign in Info Print New Copies: Open Attachment 1 Print Save RIVERSIDE COFFEE PTY LIMITED 20X5 Budget Sav Printer Jul - Sep Oct - Dec Jan - Mar Print EPSON5DA940 (WorkForce 5... REVENUE Ready Sales - Coffee Shop 162,000 175,000 158,000 Share Printer Properties Sales - Wholesale Coffee 58,000 68,000 66,000 220,000 243,000 224,000 Export Settings Print Active Sheets Close Only print the active sheets COST OF SALES Pages: Cost of Sales - Coffee Shop 44,550 48,125 43 ,45 Cost of Sales - Wholesale Coffee 20,88 24,480 23,760 Account Collated 1,2,3 1,2,3 1,2,3 65 ,430 72,605 67,210 Options Portrait Orientation GROSS PROFIT 154,570 170,395 156,790 A4 210 x 297 mm 21 cm x 29.7 cm PERSONNEL EXPENSES Normal Margins Left: 1.78 cm Right: 1.78 cm Salaries and Wages 65,000 68,000 68,000 Superannuation 5,000 5,500 No Scaling 100 Print sheets at their actual size 70,000 73,500 73,500 Page Setup OCCUPANCY EXPENSES Rent 12,480 12,825 12,540 Electricity 10,000 9,000 9,000 Depreciation - Equipment 6,000 6,000 6,000 Other Overheads 2,500 2,500 2,500 30,980 30,325 30,040 of 4 O Type here to search e x w ENG 11:59 AM 16/11/201832010_03_Attachment_1 v2 - Excel (Product Activation Failed) X Sign in Info Print New Copies: Open PERSONNEL EXPENSES Print Salaries and Wages 65,000 68,000 68,000 Save Superannuation 5,000 5,50 5,500 Sav Printer 70,00 73,500 73,500 Print EPSON5DA940 (WorkForce 5... Ready OCCUPANCY EXPENSES Share Printer Properties Rent 12,480 12,825 12,540 Export Settings Electricity 10,000 9,000 9,000 Depreciation - Equipment 6,000 6,000 6,000 Print Active Sheets Only print the active sheets Other Overheads 2,500 2,500 2,500 Close 30,980 30,325 30,040 Pages: Account Collated 1,2,3 1,2,3 1,2,3 MARKETING AND EXPENSES Advertising 5,000 5,000 5,000 Options Portrait Orientation Agent's Commission 3 480 4,080 3,960 A4 210 x 297 mm 8,480 9,080 8,960 21 cm x 29.7 cm Normal Margins FINANCIAL EXPENSES Left: 1.78 cm Right: 1.78 cm Bad Debts No Scaling Interest Expense 4,375 4,200 4,025 100 Print sheets at their actual size 4,3 75 4,200 4,025 Page Setup TOTAL EXPENSES 113,835 117,105 116,525 of 4 O Type here to search e x W ENG 12:00 PM 16/11/201832010_03_Attachment_1 v2 - Excel (Product Activation Failed) X Sign in Info Print New Copies: Open Print Save NET PROFIT BEFORE DIRECTOR'S FEES 40,735 53,290 40,265 Sav Printer EPSON5DA940 (WorkForce 5... DIRECTOR'S FEES 40,000 40,000 40,000 Print Ready Share Printer Properties NET PROFIT 735 13,290 26. Export Settings Print Active Sheets Close Only print the active sheets Pages: Account Collated 1,2,3 1,2,3 1,2,3 Options Portrait Orientation A4 210 x 297 mm 21 cm x 29.7 cm Normal Margins Left: 1.78 cm Right: 1.78 cm No Scaling 100 Print sheets at their actual size Page Setup of 4 O Type here to search EH e 9 x W ENG 12:00 PM 16/11/2018WE 32010_03_Assessment - Word (Product Activation Failed) FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW Sign in do Cut Calibri (Body) Aa Hh Find Copy AaBbCc AaBbCcDc A AaBb( AaBbCcDc AaBbCo dac Replace Paste B U abe = Colorful G... 17 Normal OC - Cove... 1 No Spac... Heading 1 Format Painter Select- Clipboard Font Paragraph Styles Editing ! SECURITY WARNING Macros have been disabled. Enable Content Part A Riverside Coffee Pty Limited owns and operates premises in Parramatta from which they operate a retail coffee shop and roastery. The company also sells roasted coffee beans wholesale to a nationally branded chain of stores and selected independent coffee shops. The company has traded well Click File > Print to preview your worksheet ng to improve its budgeting and reporting processes in order to help make timely responsible decisions for the upcoming period. When preparing the supporting calculations and information, use the Excel Help functions and other applicable online help tools. (a) Attachment 1contains the budget prepared for the 20X5 financial year. Suggest and implement some improvements to layout, format and protection of this file (Attachment 1) ahead of preparing the 20X6 budget. (b) Outline an appropriate storage protocol for the file including the naming of a new file for 20X6. (c) Identify and insert appropriate graphs that will clearly highlight how the company derives its gross profit and allows a clear comparative analysis of expenses. These graphs should have appropriate labels, titles and dollar amounts or percentages shown. Save your new file with graphs as an updated version of the file established in (b). (d) Print both of your revised budget worksheets with appropriately sized graphs, initial and date them in pen and attach a scanned copy to your assessment submission. PAGE 5 OF 11 1803 ENGLISH (AUSTRALIA) 101% O Type here to search e ENG 12:04 PM 16/11/2018 LJ