View the step-by-step solution to:

M-Fresh Water Company Author: Date: Araseli Godinez 10/11/2013 Purpose:

In excel Tutorial 7 Case 3...Need to add a formula to calculate water bill based on the following rules: The billing rate varies based on the type of customer (Cust Type column). The billing rate is $3, $2, or $1.50 per thousand gallons billed, depending on the customer type.

M-Fresh Water Company Author: Araseli Godinez Date: 10/11/2013 Purpose: Calculate water bills for commercial businesses
Background image of page 1
Quarterly Data Page 2 Customer Name Cust Type Bill Waived Taxable Billing Year Gal Used Gal Billed Water Bill Tax Rate 3.5% Red Lake Chapter NPROFIT No Yes 2013 108,300 108,300 Amity Church NPROFIT Yes No 2013 55,160 55,160 Church of Christ NPROFIT Yes No 2013 32,430 32,430 NM State Highway GOV No No 2013 95,660 95,660 Spot Free Power Wash COM No Yes 2013 281,200 281,200 CIT Apartment Complex COM No Yes 2013 257,000 257,000 Housing Agency GOV No No 2013 23,300 0 Pinon Pizza Edge COM No Yes 2013 81,110 81,110 Department of Agriculture GOV No No 2013 2,783,000 2,783,000 Chevron Station COM No Yes 2013 1,131,600 1,131,600 O B Trailer Service COM No Yes 2013 360,800 360,800 Red Mesa Express COM No Yes 2013 392,600 392,600 Inscription House Irrigation GOV No No 2013 895,300 895,300 Pure Lake Building COM No Yes 2013 59,240 59,240 Assembly Of God Church NPROFIT Yes No 2013 41,690 41,690 SD Natural Gas Company COM No Yes 2013 60,870 60,870 Speedy's COM No Yes 2013 34,690 34,690 Window Pebble Apartments GOV No Yes 2013 51,790 51,790 Press City PHS GOV No No 2013 3,031,700 3,031,700 Crown High School GOV No No 2013 990,000 990,000 Watsons Hall COM No Yes 2013 82,000 82,000 Agnew Avenue Church NPROFIT Yes No 2013 88,840 88,840 Accent Landscaping COM No Yes 2013 319,090 319,090 American Painting COM No Yes 2013 332,000 332,000 Sandia Oil Company Inc. COM No Yes 2013 148,590 148,590 NAPI Block Apartments COM No Yes 2013 442,400 442,400 WRABC GOV No No 2013 2,020,300 2,020,300 Robson Bakery COM No Yes 2013 76,700 76,700 Pays Inn COM No Yes 2013 178,300 178,300 Wellness Center Inc COM No Yes 2013 217,700 217,700 Van's Trading Laundromat COM No Yes 2013 964,500 964,500 Huge Industries COM No Yes 2013 28,877 28,877 Huge Global Industries COM No Yes 2013 598,600 598,600 Citizens Frontier COM No Yes 2013 56,900 56,900 Blanding Stake NPROFIT Yes No 2013 238,200 238,200 Elmor construction COM No Yes 2013 80,530 80,530 DNA Office Complex NPROFIT Yes Yes 2013 38,040 38,040 Energy Resources Board GOV No No 2013 26,250 26,250 1st Baptist Church NPROFIT Yes No 2013 75,490 75,490 Eastmoon Petroleum COM No Yes 2013 27,800 27,800 9-12 Laundromat COM No Yes 2013 1,863,100 1,863,100 Ed's Trading Post COM No Yes 2013 49,000 49,000 Red Mesa Diner GOV No Yes 2013 40,530 40,530 JWJ Mobile Home Park COM No Yes 2013 524,900 524,900 Amarillo Trailer Park COM No Yes 2013 25,200 25,200 CFK COM No Yes 2013 380,460 380,460 Evan Carter Center Inc COM No Yes 2013 148,174 148,174 Commision of Children and YouthGOV No Yes 2013 737,000 737,000 Veterans Center COM No Yes 2013 41,920 41,920 Business Affairs GOV No No 2013 3,978,000 3,978,000 Magore High School GOV No No 2013 1,207,700 1,207,700 Tema Health Clinic GOV No No 2013 415,000 415,000 Cedar School GOV No No 2013 479,400 479,400 Chaleta Apartments GOV No Yes 2013 73,050 73,050 Environmental Quality GOV No No 2013 713,400 713,400 Eagle Rock Professional BuildingCOM No Yes 2013 41,830 41,830 Van's Trailer Court COM No Yes 2013 165,900 165,900 Pinon Clinic X-ray GOV No No 2013 63,200 63,200 Bulger Irrigation department GOV No No 2013 625,200 625,200 Pic and Gun COM No Yes 2013 67,270 67,270 Snowy PM Group NPROFIT Yes No 2013 83,270 83,270 Pinon Housing GOV No Yes 2013 55,000 55,000 Sunnyday Day Care GOV No Yes 2013 56,495 56,495 PHS Irrigation GOV No No 2013 70,600 70,600 The Nazarene Church NPROFIT Yes No 2013 84,050 84,050 Balboo Mission NPROFIT Yes No 2013 118,800 118,800 6-12 Trailer Court COM No Yes 2013 88,600 88,600 Shipreck Burger King COM No Yes 2013 204,380 204,380 David Henry Elementary GOV No No 2013 122,800 122,800 Springs Trading Post COM No Yes 2013 44,320 44,320 FDIHS GOV No No 2013 34,100 34,100 Old Peabody TC COM No Yes 2013 2,072,000 2,072,000
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

Attached is a detailed explanation... View the full answer

Water Bill.xlsx

M-Fresh Water Company
Author:
Date: Araseli Godinez
10/11/2013 Purpose: Calculate water bills for commercial businesses Quarterly Data Customer Name
Cust Type
Red Lake Chapter
NPROFIT
Amity Church...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online