Can I get some assistance with this assignment? All of the required information is attached.

Rylie & Rachel's Dance and Gymnastics Studio ANNUAL BUDGET BUDGET TOTALS ESTIMATED December 2016 ACTUAL DIFFERENCE Income Err:509 Err:509 Err:509 Expenses Balance (Income minus Expenses) Err:509 0.00 Err:509 18,794.97 Err:509 Err:509 BUDGET OVERVIEW Income EXPLANATION & BACKGROUND Rylie and Rachel's Dance and Gymnastics Studio (named for my daughter and her favorite babysitter and their epic/legendary dance and gymnastics parties) is the focus of the Part I of the Final Project. The goal of the assignment is to show you how budgeting works over a one year period. You will be given actual figures for several categories of income and expenses for 2015. You will then calculate (based on various inputs) budgeted projections for 2016. After you have those calculations, you will find that the 2016 actual numbers are also included. Using the projections you calculated, you will compare actual performance to estimated performance across various expenses and income and look for variances. Finally, you will be asked to comment on the overall accuracy and business impacts based on the variance analysis. To get started, click on the "Part I - Annual Budget Details" tab at the bottom and follow the instructions. When you are finished, you can come back to the annual budget summary to see "big picture" results. When finished with Part I, move to Part II. Submit the completed file once Parts I and II are complete and your work has been saved. Expenses 12.00 10.00 8.00 6.00 4.00 2.00 0.00 ESTIMATED ACTUAL WHAT ARE MY TOP 5 HIGHEST OPERATING EXPENSES? EXPENSE AMOUNT % OF EXPENSES 15% REDUCTION Err:508 Err:508 Err:508 Err:508 Err:509 Err:509 Err:509 Err:509 Err:508 Err:508 Err:509 Err:509 Err:508 Err:508 Err:508 Err:508 Err:509 Err:509 Err:509 Err:509 Total Err:508 Err:508 Err:508 Page 1 of 6 Rylie & Rachel's Dance and Gymnastics Studio ANNUAL BUDGET 2015 Actual Budgeting Strategy for 2016 51,433.20 Projected 15% sales increase 3,264.19 Projected 23% interest income increase 453.78 Projected 4% decrease in asset sales (gain/loss) 55,151.17 ACTUAL INCOME 120.32 Projected 8% raise in employess benefits 4,512.49 Projected 16% increase in commission 14,312.44 ACTUAL 2016 Actual 59,148.18 DIFFERENCE 58,794.43 Err:509 4,216.37 Err:509 Asset sales (gain/loss) 476.81 Err:509 Total Income Err:508 Err:508 Interest income PERSONNEL EXPENSES 9,679.63 Projected wage raise of 19% 2016 Estimated Net sales ESTIMATED ACTUAL Wages Employee benefits Commission Total Personnel Expenses OPERATING EXPENSES DIFFERENCE 10,851.52 Err:509 135.28 Err:509 5,391.94 Err:509 Err:508 ESTIMATED ACTUAL Err:511 DIFFERENCE 2,544.31 Projected increase in advertising of 25% Advertising 3,264.38 Err:509 1,897.27 Projected bad debt decrease of 21% Bad debts 1,697.11 Err:509 2,175.61 Projected 9% decrease in cash discounts Cash discounts 1,849.03 Err:509 Depreciation 1,107.43 Err:509 1,276.24 Projected 15% increase in insurance Insurance 1,278.27 Err:509 2,245.70 Projected interest increase of 27% Interest 2,750.78 Err:509 4,615.78 Projected maintenance and repairs decrease of 10% Maintenance and repairs 4,318.01 Err:509 4,522.09 Projected rent or mortage increase of 8% Rent or mortgage 4,788.82 Err:509 4,452.47 Projected increase in supplies of 15% Supplies 5,155.19 Err:509 1,385.06 Projected 7% decrease in utilities Utilities 980.53 Projected 5% depreciation increase 761.68 Projected otherexpenses increase of 19% 26,856.74 1,253.14 Err:509 Other 851.74 Err:509 Total Operating Expenses Err:508 Err:508 Question One: Relative to the 2016 budgeted projections, how did the company perform in 2016? Enter text here. Question Two: Make recommendations for producting the 2017 Budget. What changes to projections should be considered? Why? Enter text here. Page 2 of 6 INSTRUCTIONS: For this part of the project, you are given the Actual Budget figures for 2015 (in Column A). Based on the 2015 Actual figures, you are given a budget strategies (Column B) for each income statement list item to make the estimated budgets for 2016. You will provide the 2016 Estimated figures for this assignment in Column D. The 2016 Actual figures are also given in Column E. Once you have provided the 2016 Estimated figures, the difference variance will be given in the far right column (Column G). As you can see, some equations are already entered into this spread sheet. The differnece variances figures will change as you key in the 2016 Estimated column. (It is wise to check the calculations of the formulas once completed.) When the variances have been calculated, you should fill the favorable difference variance boxes in with yellow; this can include the line totals as well, if applicable. An example calculation is given for the first line of the income statement (net sales line; Box D6). Once you have completed each of these calculations, and have the 2016 estimates and variances completed, navigate to the bottom of the page and answer the two questions there. Provide the answers to each in the corresponding textboxes by clicking on the textbox and entering your answers in the areas shaded in green. For excel information and assistance (i.e., entering formulas, formatting), here are some helpful webpages to review. - http://www.baycongroup.com/excel2007/02_excel.htm - http://www.pcworld.com/article/2877236/software-productivity/excel-formulas-cheatsheet-15-essential-tips-for-calculations-and-common-tasks.html Question One: Now that you have made it through the course, and learned several trad challenge in the future will be to use these concepts in your careers. The purpose of Mo should be best used. Read the attached article entitled \"Alphabet Soup: Good for You o been managing according to the goal.\" What do you think is meant by this statement? Enter text here. Question Two: \"The Goal\" presents some examples of how managerial accounting infor looks at the relationship between principles and agents and potential issues that can ar Theory. http://www.investopedia.com/terms/a/agencytheory.asp. After reviewing the lin unethical manner. How might you overcome that issue as a manager? Enter text here. INSTRUCTIONS: For the Final Project, Part II, you have two questions to complete. A short reading/link is also provided. Enter your answers into the textboxes below. For each question, your answer should range between 200-300 words. References are should be used to support answers and claims. s to nter your on, your erences