Using the pivot table you created for Requirement 2 for Grand Falls, how much was spent in Public Works in 2014? A. $88,753,532 B. $14,033,249 C. $45,901,659 D. $58,226,387 Using the pivot table you created for Requirement 3 for Grand Falls, how much was supplies expense in 2014? A. $7,271,960 B. $25,586 C. $19,792 D. $88,043 This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor. Using the pivot table you created for Requirement 1 for Grand Falls, what was the total spending for Grand Falls in 2014? A. $148,688,440 B. $194,025,134 C. $170,968,395 D. $196,445,172 Using the pivot table you created for Requirement 2 for Grand Falls, how much was spent in General Government in 2014? A. $123,382,768 B. $88,753,532 C. $45,901,659 D. $14,033,249 Using the budgeted worksheet results from requirement 4 for Grand Falls, what was the variance expressed as a percentage for bonds and debt-related expeditures? O A. 3.42% OB. -4.66% O C. 7.76% OD. 0.65% Using the budgeted worksheet results from requirement 4 for Grand Falls, how many variances had a red diamond? O A. 9 B. 2 C. 8 D. None City of Grand Falls Budgeted Expenditures (hypothetical) For Year Ended December 31, 2016 2016 Actual Variance $ Variance % Expenditure (Item Class) Advertising Athletics expense Bonds and debt-related expenditures Books Dues and subscriptions Education-related Miscellaneous line item Professional services expense Property, plant and equipment Rental expense Repairs and maintenance expense Supplies expense Technology expense Utilities expense Total expenditures Budget $ 67,148 $ 37,228 $ 23,665,215 $ 22,998 $ 180,554 $ 355,807 $ 52,448,643 $ 11,994,653 $ 7,002,915 $ 418,880 $ 3,682,554 $ 22,854 $ 634,552 $ 265,481 $ 100,799,482 ( Using the pivot table you created for Requirement 2 for Grand Falls, how much was spent in Public Works in 2014? A. $88,753,532 B. $14,033,249 C. $45,901,659 D. $58,226,387 Using the pivot table you created for Requirement 3 for Grand Falls, how much was supplies expense in 2014? A. $7,271,960 B. $25,586 C. $19,792 D. $88,043 This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor. Using the pivot table you created for Requirement 1 for Grand Falls, what was the total spending for Grand Falls in 2014? A. $148,688,440 B. $194,025,134 C. $170,968,395 D. $196,445,172 Using the pivot table you created for Requirement 2 for Grand Falls, how much was spent in General Government in 2014? A. $123,382,768 B. $88,753,532 C. $45,901,659 D. $14,033,249 Using the budgeted worksheet results from requirement 4 for Grand Falls, what was the variance expressed as a percentage for bonds and debt-related expeditures? O A. 3.42% OB. -4.66% O C. 7.76% OD. 0.65% Using the budgeted worksheet results from requirement 4 for Grand Falls, how many variances had a red diamond? O A. 9 B. 2 C. 8 D. None City of Grand Falls Budgeted Expenditures (hypothetical) For Year Ended December 31, 2016 2016 Actual Variance $ Variance % Expenditure (Item Class) Advertising Athletics expense Bonds and debt-related expenditures Books Dues and subscriptions Education-related Miscellaneous line item Professional services expense Property, plant and equipment Rental expense Repairs and maintenance expense Supplies expense Technology expense Utilities expense Total expenditures Budget $ 67,148 $ 37,228 $ 23,665,215 $ 22,998 $ 180,554 $ 355,807 $ 52,448,643 $ 11,994,653 $ 7,002,915 $ 418,880 $ 3,682,554 $ 22,854 $ 634,552 $ 265,481 $ 100,799,482 (
