Question
Devils Tower Utility Company:The Devils Tower Utility Company uses turnaround documents in its computerized customer accountingsystem. Meter readers (employees that read utility meters) are provided
Devils Tower Utility Company:The Devils Tower Utility Company uses turnaround documents in its computerized customer accountingsystem. Meter readers (employees that read utility meters) are provided with preprinted computerforms, each form containing the account number, name, address, and previous account meter reading.Each form also contains a formatted area in which the customers current meter reading is marked inpencil based on the reading. After making their rounds, meter readers turn in batches of thesedocuments to the computer data preparation department, where they are keyed into the monthlymeter reading file (stored on magnetic disk). The completed (entered) meter reading forms are thenfiled by date.Next, the Monthly Meter Reading file along with the Customer Master file is used as input in the preparecustomer bill process which is completed in several steps. During the first step of the process, thecustomer numbers from each file (Monthly Meter Reading file and the Customer Master file) arematched to each other and the difference from the previous reading (Customer Master file) and the current reading (Monthly Meter Reading file) to be calculated and stored to the Monthly BillingsTransaction file (temporary file). In the second step, the utility usage (Monthly Billings Transaction file) ismultiplied by the current rate stored in the Utility Rate file (magnetic disk) to compute the bill amountwritten (updated) to the Monthly Billings Transaction file and printed on a customer invoice. Next, thecustomer balance in the Customer Master File is updated based on information from the MonthlyBillings Transaction file. Next, Invoices are mailed to customers.Customer payments are received in the mail room and checked for consistency against the remittanceadvices returned by the customer. If there is a discrepancy between the check and the remittanceadvice (difference in amount or no remittance advice), then a blank remittance advice is completed withthe correct information. Checks are then sent to the cashiers office and the remittance advices areprovided to the accounts receivable.Using the remittance advices, Accounts Receivable personnel input payments received (use a computersymbol) and update the A/R Payment file (temporary storage).The cashier prepares a deposit slip (two copy document) for payment receipts. The checks and the 1stdeposit ticket are sent to the bank. The 2nd copy of the deposit ticket is matched to the balance of theA/R Payment file. If no discrepancies exist, the A/R Payment file is used to update the Customer Masterfile and the General Ledger (on magnetic disk). The 2nd copy of the deposit ticket is filed by date.SOURCE: The prior narrative is based on Problem 3.2 in the Romney et al. Accounting InformationSystems 11th edition text. It has been modified with an attempt to provide additional detail.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started