Question: May someone help me. I am having trouble formatting a way to calculate the number of days in the billing cycle. If the initial Date
May someone help me. I am having trouble formatting a way to calculate the number of days in the billing cycle. If the initial Date is May 7 and Final date is July 7, I am not understanding how to account for the 30 days of June in between. I am a beginner so not too complex please. Thank you

Background Monthly natural gas billing amounts for a certain city are calculated using various quantities and rates which are available on the billing statement. Several related terms and charges are defined below: Basic Charge Number of days in the billing period Final Date Initial Date (from 26 to 35 days) Initial meter reading, Final meter reading -5 digit meter readings in CCF (100 cubic feet) Gas Used = Final meter reading-Initial meter reading (add 100000 if negative)-see note below Gas Cost (Up to 35 CCF of gas used)*(37.74G/CCF) = cost for up to 35 CCF = $8.00 (this fee is charged regardless of the energy usage) (Gas used over 35 CCF)*(34858c/CCF-cost for the amount used over 35 CCF Utility Tax = $2.40 (this fee is charged regardless of the energy usage) Late Penalty 1.5% of the previous month's bill (before taxes) if it was paid late Average Daily Cost Bill Amount before taxes and not including late penalties Number of days in the billing period Note: the reading on the meter displays 5 digits, so the meter reads counts 99998, 99999, 00000, etoc So if the final meter reading is less than the initial reading (or if the Gas Used is negative), 100000 must be added. Example Initial Date: May 7 Final Date: June 5 Number of days in the billing period 29 Previous month's Bill: S42.67 (paid late) Initial meter reading = 01699 CCF Final meter reading = 01772 CCF Gas Used = Final meter reading-Initial meter reading-01772-01699-73 CCF $8.00 $26.46 $34.46 64 $2.40 $37.50 $1.19 Cost summary: Basic Charge Gas Cost= (35 CCF Subtotal Late Payment Charge (S42.67)(0.015) Utility Tax Total Current Charges Average daily cost (S33.06/29 days) 37.74/CCF-(38 CCF)(34.858/CCF) =
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
