This is a take home test. We anticipate it may take up to 2 hours to complete. Use the "Answers" worksheet to record your answers electronically. Also, you are free to format your answers/analysis as you see fit or deem necessary. Partial credit may be given for good methodology but an incorrect answer. It will be important that your answers stem from visible inputs, and auditable calculations and/or formulae. Return completed test to chadj@fcsgroup.com. Category Historical Consumer Price Index (CPI) Number of Customers City Revenue: Rate Revenue Other Revenue City Expenses: Operating Expenses Debt Service New Debt Sample Data 2006 201.60 1,030 2011 $100,000 10,000 2011 $90,000 30,000 2014 2007 207.34 1,045 2008 2009 215.30 214.54 1,045 1,077 2010 218.06 1,093 Customer Number 1 2 3 4 5 Customer Number 1 2 3 4 Winter Jan 5 3,740 4,488 2,992 11,220 3,740 11. One cubic foot (cf) of water = 7.48 gallons. 100 cubic feet (ccf) of water = 748 gallons. i. Convert the table above into ccf in the table below. Winter Feb Winter Jan 4,488 7,480 3,740 10,472 3,740 Hypothetical Customer Statistics Winter Feb Winter Winter Winter May Mar Apr 5,610 5,984 6,732 5,984 Customer Monthly Water Usage Data - gallons Summer Summer Summer Summer Winter Jun Jul Aug Sep Oct 5,236 7,480 8,228 10,472 11,220 5,984 8,228 11,220 11,968 12,716 14,960 3,740 4,488 4,488 3,740 3,740 5,236 5,984 5,984 5,984 3,740 4,488 8,976 10,472 11,968 12,716 11,220 10,472 11,968 13,464 12,716 5,236 2,992 5,236 8,976 11,968 13,464 10,472 7,480 5,236 Winter Nov 3,740 Winter Mar Customer Monthly Water Usage Data - ccf Winter Apr Winter Summer Summer Summer Summer Winter Winter Jun Jul Aug Sep Oct Nov May Winter Dec 5,236 5,236 5,236 11,220 5,984 Winter Dec 12. What is the total annual consumption for all the customers combined? 13. What is the average monthly consumption per customer and for the customer group? 14. What is the average winter month consumption per customer and for the customer group? 15. What is the average summer month consumption per customer and for the customer group? 16. What is the ratio between the summer monthly average and the winter monthly average? What does this ratio tell you? Rate Design 17. The City needs to collect $100,000 in 2011 from 1,000 customers, which use on average 8 ccf per month per customer. i. Assuming the City charges $5 per month per customer fixed charge, what rate does the City need to charge per cof to collect the $100,000 in 2011?