Please help me to solve this. I will appreciate.

"Screenshot Tops, inc." case Studv 15!) Points Requirements: 1. Think of this as a presentation to a bank or a supervisor at work. 2. The nal product that vou turn in should be professional: a. All budgets and schedules should be formatted correctly with proper headings. b. Each budget should have its own tab in the excel workbook. c. Schedules and answers should be free from math. spelling, and grammatical errors. d. Final submission should look good and be venlr readable (groupings. oommas. underlines. tables. etc.}l e. We will follow the format discussed in the formatting guidelines included in this document. 3. There are denite solutions to each part of the case studv, ansrs most be EEYEEI- To assist vou. the following check figures are provided. ghgck Figprgs: Total sales 5 300,000 Total collections 5 \"2,400 Total purchases 5 545.0DD Total payments 5 454.0DD Total labor hours Ec Total fixed selling and admin 5 23.230 Total variable overhead 5 46.55D Income before taxes 5 24,5311 Ending cash 5 2,33 Total assets 5 1312311 Your calculationsffinal numbers should match those above. W ingrregt amgpnts. or if vou fail to have the supporting formulas isimplvr keving in the above numbers will not result in awarding of associated points}. 'r'ou should also link 1your schedules to previous schedules where appropriate. 4. 5. 1'. This project must be completed in Excel, with narrative answers {question #1] provided in word. {You cannot use the Apple apps Pages and Numbers or other software programs. Microsoft Ofce 355, which includes Word and Excel is available for free to college students - see the start here section in DEL} Question #1 in the narrative will be answered in MS Word. You will have a separate tab for each question numbers 2-12. You will complete questions 13-15 on a single tab with each question and answer clearly labeled and separated. As noted in Item 3 above, you must use formulas where formulas would logicallyr occu r, as well as correct formats, underlining, etc. in your worksheets. You should link those portions of the worksheet to the previous sections as support and build supporting calculation formulas as needed. Failure to use formulas and proper linkage will result in the loss of points. You mavr work on this in a group or on vour own. If vou work in a group, each group member must fill out a peer evaluation form and vour grade will be based on vour effort put forth bv vou as an individual member according to vour peers. No single team member's grade can exceed the group grade; however, individual grades can be awarded fewer points based on the feedback received. Formatting Guldelines: I The dollar sign should appear only in the first entqlr in each column and not again until the total or subtotal line. Unless the initial number is not in dollars, in which case, when switching from units to dollars the dollar sign should be used. Use commas for numbers over moo. Use horizontal lines to separate headings from column entries and to highlight totals and subtotals {see Chapter 3 exhibits}. Ensure that cells are formatted to the proper size for text to displav f ullv in the cell. Be consistent about vour use of decimal points. Either use them on all numbers in a table or don't use them at all. If vou use decimal points, format to two decimal points. All calculations not included in the budgetfschedule {formula based} should be separated from the schedule clearlv either to the right or below. Calculations {not contained within a formula in a schedule} must be clearlyI labeled and wmmhw