Worksheet Grade 10 Social Studies & Civics

Where the Rate Dollar Goes: A Weller Falls Water Budget Worksheet

A grade 10 worksheet where students read a fictional city water budget, compute each category's dollars, and judge a proposed shift toward pipe repair.

Objectives

  1. Students will calculate the dollar amount of each category in a utility operating budget from its percentage share.
  2. Students will explain how a shift in budget priorities changes the average household bill.
  3. Students will evaluate why some budget categories are difficult to cut in the short term.

Vocabulary

Debt service
The money a utility must pay back each year on loans it took out to build big projects, much like a family paying its mortgage. These payments come out of customers' water bills.
Ratepayer
A person or business that pays a utility bill. Ratepayers provide most of the money that keeps a water system running.

Also: operating budget, revenue, fixed cost

Teacher overview

A water utility publishes a budget every year that shows where the money from bills is spent. This worksheet uses a fictional utility so students can read a full budget and do the math a city council would do. Students find each category's dollars, convert the total into an average bill, and test what a proposed shift toward pipe repair would cost each household.

Answer Key

Every figure below is drawn from the fictional Weller Falls budget stated in the worksheet.

  1. Answer: $1,200,000. Treatment chemicals and power is 20 percent of $6,000,000, and 0.20 x 6,000,000 = 1,200,000.
  2. Answer: $1,500,000. Pipe repair is 25 percent of $6,000,000, and 0.25 x 6,000,000 = 1,500,000.
  3. Answer: Staff wages. At 30 percent it is the largest share, ahead of pipe repair at 25 percent.
  4. Answer: $600 per year. Dividing $6,000,000 by 10,000 households gives $600 per household each year.
  5. Answer: $50 per month. $600 per year divided by 12 months is $50 each month.
  6. Answer: $300,000. The addition equals 5 percent of the current budget, and 0.05 x 6,000,000 = 300,000 more dollars for repair.
  7. Answer: $30 per year. $300,000 divided by 10,000 households is $30 more per household each year.
  8. Answer: Answers will vary. A strong answer names a benefit such as fewer main breaks, less lost water, or avoided emergency repairs, and states that this benefit can be worth more than the $30 added yearly cost per household.
  9. Answer: Answers will vary. Debt service is a legal payment owed on money already borrowed, so skipping it risks default; wages must be paid to keep operators and repair crews on the job.
  10. Answer: Administration is only 10 percent of the budget, or $600,000, which is about $60 per household each year. Removing it would leave the other 90 percent of costs, so water would still cost most of what it does now.

Differentiation

Support

Provide the budget with the dollar amount already filled in for two categories, so students see the percent-to-dollars method modeled before item 1. Allow calculators and give a worked example using a made-up 10 percent category.

Extension

Ask students to rewrite the fictional Weller Falls budget so pipe repair becomes the largest category without raising the $6,000,000 total, state which other categories they cut, and explain the tradeoff each cut creates for service or staffing.

ELL supports

Pre-teach "operating budget," "revenue," "fixed cost," "debt service," and "ratepayer" with a simple pie-slice image of the five categories. Allow items 8, 9, and 10 to be answered in short phrases, and provide the sentence frame "The council might raise repair spending because ___."