L 2 Miscellaneous line item 3 Professional services expense Property, plant and equipment 5 Rental expense...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
L 2 Miscellaneous line item 3 Professional services expense Property, plant and equipment 5 Rental expense 5 Repairs and maintenance expense Supplies expense B Technology expense e Utilities expense O 3 5 City of Little Lake Budgeted Expenditures (hypothetical) For Year Ended December 31, 2016 2 Expenditure (Item Class) Advertising Athletics expense Bonds and debt-related expenditures Books Dues and subscriptions Education-related Total expenditures B Budget 68,515 $ $ 39,541 $ 32,914,557 $ 26,884 195,976 $ $ 365,991 $ 53,467,889 $ 9,356,421 $7,009,650 $ 417,840 $ 3,551,672 $ $ S 20,150 650,884 300,400 с Actual 2016 D Variance $ E Variance % F Part A 1. Analyze total spending by using a pivoltable. Calculate the total spending in each of the four calendar years. Analyze the trend. Part B 2 Requirements for the variance analysis and recommendation in PowerPoint: B G 33. Analyze expenditures for each year, in each "Item Class" in the General Government category by using a pivot table. by "Item Cl 9 B 45. Analyze the budget variance report you prepared in Step 4. 5 5 Questions to answer in Excel 71. Using the pivot table you created for Requirement 1, what was the total spending for each year? 3 2. Using the pivot table you created for Requirement 2, how much was spent in General Government in each year? 93. Using the pivot table you created for Requirement 2, how much was spent in Public Works in each year? ) 2. Calculate spending for each year, in each of the three categories of government (Education, General Government, and Public Works) using a pivot table. H 41. Calculate the variances by category of expenses by comparing the most recent year versus the preceding year 5 2. Provide a probable cause for each significant expense variance obtain in 1. above 5 3. Provide a realistic recommendation for improvement for the variances identified in 2. above. 2 I J K L M N 0 P 4. Prepare a budget variance report that compares actual spending by "Item Class" in 2016 for the General Government category, by using the budget worksheet included in the Excel data file. Use cell references for the actual spending totals. Use conditional formatting (use the "Shapes, 3 Signs" style) to denote the direction of the percentage variances. You will want to denote any variance that is more than +/-10% with a red diamond, between +/-3-9.99% with a yellow diamond, and less than +/- 3% Q R S T L 2 Miscellaneous line item 3 Professional services expense Property, plant and equipment 5 Rental expense 5 Repairs and maintenance expense Supplies expense B Technology expense e Utilities expense O 3 5 City of Little Lake Budgeted Expenditures (hypothetical) For Year Ended December 31, 2016 2 Expenditure (Item Class) Advertising Athletics expense Bonds and debt-related expenditures Books Dues and subscriptions Education-related Total expenditures B Budget 68,515 $ $ 39,541 $ 32,914,557 $ 26,884 195,976 $ $ 365,991 $ 53,467,889 $ 9,356,421 $7,009,650 $ 417,840 $ 3,551,672 $ $ S 20,150 650,884 300,400 с Actual 2016 D Variance $ E Variance % F Part A 1. Analyze total spending by using a pivoltable. Calculate the total spending in each of the four calendar years. Analyze the trend. Part B 2 Requirements for the variance analysis and recommendation in PowerPoint: B G 33. Analyze expenditures for each year, in each "Item Class" in the General Government category by using a pivot table. by "Item Cl 9 B 45. Analyze the budget variance report you prepared in Step 4. 5 5 Questions to answer in Excel 71. Using the pivot table you created for Requirement 1, what was the total spending for each year? 3 2. Using the pivot table you created for Requirement 2, how much was spent in General Government in each year? 93. Using the pivot table you created for Requirement 2, how much was spent in Public Works in each year? ) 2. Calculate spending for each year, in each of the three categories of government (Education, General Government, and Public Works) using a pivot table. H 41. Calculate the variances by category of expenses by comparing the most recent year versus the preceding year 5 2. Provide a probable cause for each significant expense variance obtain in 1. above 5 3. Provide a realistic recommendation for improvement for the variances identified in 2. above. 2 I J K L M N 0 P 4. Prepare a budget variance report that compares actual spending by "Item Class" in 2016 for the General Government category, by using the budget worksheet included in the Excel data file. Use cell references for the actual spending totals. Use conditional formatting (use the "Shapes, 3 Signs" style) to denote the direction of the percentage variances. You will want to denote any variance that is more than +/-10% with a red diamond, between +/-3-9.99% with a yellow diamond, and less than +/- 3% Q R S T
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
For each of the following requirements, create a new pivot table in a new worksheet. Name each new worksheet as Req 1, Req 2, etc. Format the dollar amounts in each pivot table or pivot chart using...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
2. Using the data from the Income Statement and Balance Sheet, provide the correct calculation of the activity ratios and an assessment of the company's ability to maintain liquidity. Include the...
-
What are the three shapes of periodic signals a function generator can produce?
-
Using the information for Otis, Inc., in SE and SE, compute profit margin, asset turnover, and return on assets for 2011 and 2012. In 2010, total assets were $200,000. Comment on the results. In SE,...
-
In a certain region, a charge distribution exists that is spherically symmetric but nonuniform. That is, the volume charge density p(r) depends on the distance r from the center of the distribution...
-
State the different types of pulleys used in power transmission and define the velocity ratio of pulleys.
-
An investigation of the effectiveness of an antibacterial soap in reducing operating room contamination resulted in the accompanying table. The new soap was tested in a sample of eight operating...
-
Suppose a Summons and Complaint were filed on February 16, 2021 and personally served on the defendant on March 1, 2021, please calendar the following dates: a the day Proof of Service of Summons and...
-
Prepare a simple tax provision and the journal entries to calculate the current and the deferred tax provision (benefit) using the following data: a. ABC, Inc. reported pre-tax book income of...
-
An employee is being paid a bonus of $2,000.00 along with her regular monthly pay of $3,980.00. She also has a monthly non-cash taxable benefit of $20.00. Calculate QPP, EI and QPIP along with...
-
Implement technological tools in production models like forecasting, lean manufacturing and world class manufacturing (WCM) to enhance the productivity and communication with other persons involving...
-
dx +2 +2x = sin(2t)u(t) with the ICs x(0) = 4 and x(0)=-4. dt dt a) Use the MATLAB "dsolve" command to solve the ODE. You might want to include "assume(t > 0);" in your code and use 'simplify' on the...
-
Tesla management are trying to decide whether to keep an older piece of machinery or buy a replacement. Management was presented with the following information to assist in their decision: The old...
-
Consider you are the chief of police. Your community is experiencing an increase in residential burglaries and to address this, you have decided to select a new detective from the ranks of patrol....
-
Consider a periodic half-rectified sine wave, defined by [Asin(27) 051s SISI for all integer values, k With x(t)=x(t+k) a) Find the coefficients of the complex exponential Fourier series of x(t)....
-
John plans to enter into a project that will be awarded 12,000 $ annually for 10 years. If the required rate of return is 12 % What is the amount Mr. John would be willing to pay to get involved in...
-
Calculate the Lagrange polynomial P 2 (x) for the values (1.00) = 1.0000, (1.02) = 0.9888, (1.04) = 0.9784 of the gamma function [(24) in App. A3.1] and from it approximations of (1.01) and (1.03).
-
Deborah purchases a new $30,000 car in 2012 to use exclusively in her business. If Deborah does not elect to expense or take bonus depreciation in 2012 and holds the car until it is fully...
-
Jason and Mary are married taxpayers in 2012. They are both under age 65 and in good health. For this tax year, they have a total of $41,000 in wages and $500 in interest income. Jason and Mary's...
-
For each of the following situations, indicate whether the taxpayer(s) is (are) required to file a tax return for 2012. Explain your answer. a. Helen is a single taxpayer with interest income in 2012...
-
What is the change in velocity of \((a)\) cart 1 (b) cart 2 in Figure 4.6? (c) What do you notice about your two answers? Figure 4.6 Velocity-versus-time graph for two identical carts before and...
-
(a) Are the accelerations of the motions shown in Figure 4.1 constant? (b) For which surface is the acceleration largest in magnitude? Figure 4.1 Velocity-versus-time graph for a wooden block sliding...
-
The \(x\) component of the final velocity of the standard cart in Figure 4.8 is positive. Can you make it negative by adjusting this cart's initial speed while still keeping the half cart initially...
Study smarter with the SolutionInn App