This is a take home test. We anticipate it may take up to 2 hours to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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? 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?
Expert Answer:
Answer rating: 100% (QA)
To begin with we must address each question one by one following the data provided in the second and third images The data in the second image shows t... View the full 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 finance questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
LOCATE APPROPRIATE CPT CODES ICD-10-CM (CPT) FOR PROCEDURES BELOW- Outpatient procedures only 1. INCISION AND DRAINAGE OF A CYST --- 2. DEBRIDEMENT - 3. SIMPLE REPAIR OF A SUPERFICIAL WOUND- 4....
-
Revise the following expression to show more courtesy: For the last time, Im warning all staff members that they must use virus-protection softwareor else!
-
Examples 9.4 through 9.7 illustrate the approach to problems dealing with non isothermal reactors. This approach to multistage operations of solid catalyzed reactions. To reinforce these concepts,...
-
Have you ever read in the newspapers about the types of people who engage in company misdeeds?
-
The following data are from the income statements of Haskin Company. (a) Compute for each year (1) The inventory turnover (2) The days in inventory. (b) What conclusions concerning the management of...
-
= 12, where Let A, B M(R) and let n 1 be an integer such that Cn C = AB - BA. Prove that n is even and C4 = 12. Hint: use Problem 2.15.
-
Keeper Corporations income statement for the year ended June 30, 2014, and its comparative balance sheets for June 30, 2014 and 2013 follow. Keeper Corporation Income Statement For the Year Ended...
-
If Company XYZ were to make a 40 stock and 60 cash offer for OG and both firms decide to share the synergies equally, how many shares of Company XYZ would the target shareholders received?
-
Discuss specific strategies and insights from CAS and other organizational theories that can help improve the adaptability and resilience of the healthcare team in a dynamic environment.
-
Explain who was Charlemagne? Discuss several of his accomplishments. In a separate paragraph, separated by a blank line...Discuss what you think was his most important accomplishment and why you...
-
There are various known branches of psychology. List these major branches of psychology.?
-
Answer to the following: Discuss how a company's internal environment might affect the development of the corporate strategy. Include product life cycle, personnel, and organizational structure in...
-
1)What makes psychology a science? 2) Do you agree with Stanovich that psychology is "alive and well" among the sciences? Why or why not? Stanovich: how to think straight about psychology
-
Suppose that an individual contemplates committing an illegal act that will yield a gain of g dollars. Assume that the probability of apprehension is p and the punishments consist of a fine, f, and a...
-
In the current year, the City of Omaha donates land worth $500,000 to Ace Corporation to induce it to locate in Omaha and create an estimated 2,000 jobs for its citizens. a. How much income, if any,...
-
Ken paid the following amounts for interest during 2012: Qualified interest on home mortgage...........................................$4,700 Auto loan...
-
On February 2, 2012, Alexandra purchases a personal computer for her home. The computer cost $3,000. Alexandra uses the computer 80 percent of the time in her accounting business, 10 percent of the...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-4. Ivan and Irene paid the following in 2012 (all by check or can otherwise be...
-
Whenever Aliza buys a flashlight, she also always buys exactly two batteries along with it. Any more than two batteries will serve no purpose, because she will not be able to use them in the...
-
State governments in India levy a value-added tax on the sale of goods. The rate of this sales tax varies by type of good and by state. In Maharashtra, the general rate of sales tax is \(12.5 \%\),...
-
Divit enjoys watching team sports and considers tickets to kabaddi and badminton games to be perfect substitutes. Show his preference map. What is his utility function?
Study smarter with the SolutionInn App