Every Thursday, Raj, the timekeeping clerk, keys the timecard data from the employees into the system, prints a summary report, sends the summary report to Penny in the payroll department where it is filed by date, and then files the timecards alphabetically and date. The last Thursday of each month, Penny, the payroll clerk, processes the payroll which includes calculating gross pay, calculating withholdings, calculating net pay, printing the checks, printing the payroll summary report and the payroll file is updated. Penny then sends the checks and the payroll summary report to Leonard in the cash disbursements department. Leonard, the cash disbursements clerk, reconciles the payroll summary with the paychecks and then records the transaction in the cash disbursements file. He then files the payroll summary by date and sends the paychecks to the treasurer, Sheldon, for signing. The signed checks are then sent to Howard, the paymaster, who distributes them to the employees on Friday morning 1. Prepare an activity table for this narrative. 2. Prepare a context diagram for this narrative. 3. Prepare a level 0 data flow diagram for this narrative. (Hint: Identify 5 processes)

Every Thursday, Raj, the timekeeping clerk, keys the timecard data from the employees into the system, prints a summary report, sends the summary report to Penny in the payroll department where it is filed by date, and then files the timecards alphabetically and date. The last Thursday of each month, Penny, the payroll clerk, processes the payroll which includes calculating gross pay, calculating withholdings, calculating net pay, printing the checks, printing the payroll summary report and the payroll file is updated. Penny then sends the checks and the payroll summary report to Leonard in the cash disbursements department. Leonard, the cash disbursements clerk, reconciles the payroll summary with the paychecks and then records the transaction in the cash disbursements file. He then files the payroll summary by date and sends the paychecks to the treasurer, Sheldon, for signing. The signed checks are then sent to Howard, the paymaster, who distributes them to the employees on Friday morning 1. Prepare an activity table for this narrative. 2. Prepare a context diagram for this narrative. 3. Prepare a level 0 data flow diagram for this narrative. (Hint: Identify 5 processes)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The accounting records and bank statement of Jeff's Seashell Store provide the following information at the end of April. The closing 'Cash' account balance was $29000, and the bank statement shows a closing balance of $31000. On reviewing the bank statement it is found an account customer has deposited $2500 into the bank account for a March sale and the monthly insurance premium of $550 was automatically charged to the account. Interest of $1500 was paid by the bank and a bank fee of $50 was charged to the account. A payment of $950 to a supplier has been recorded twice in the accounts. After the calculation of the "ending reconciled cash balance", what is the balance of the 'cash' account?A. 33,350 B. None of the other answers C. 31,450 D. 29,000 E. 35,350
Bev is completing the monthly bank reconciliation for her checking account for the month of October. The following facts apply: The balance per the bank on Oct 31st = $3,000 The balance per her checkbook on Oct 31st = $6,000 Deposits in Transit = $2,000 Outstanding Checks = $500 EFT’s ‘into’ her account = $4,000 EFT’s ‘out of’ her account = $5,500 No interest was earned on the account, and there were no bank fees during the month.
The following accounts, with the balances indicated, appear in the ledger of Garcon Co. on December 1 of the current year: The following transactions relating to payroll, payroll deductions, and payroll taxes occurred dur ing December:Dec 2. Issued Chedc No. 410 for $3,400 to Jay Bank to purchase U5. savings bonds for employees.2. Issued Check Na 411 to Jay Bank for $27,046 in payment of $9,273 of social security tax, $2,318 of Medicare tax, and $15,455 of employees'federal income tax due. Dec. 13. Journalized the entry to record the biweekly payroll. A summary of the payroll record follows: 13. Issued Check No. 420 in payment of the net amount of the biweekly payroll.13. Journalized the entry to record payroll taxes on employees' eamings of December 13: social security tax, $4,632; Medicare tax, $1,158; state unemployment tax, $350; federal unemployment tax. $125.16. Issued Check No. 424 to Jay Bank for $27,020, in payment of $9,264 of social security tax. $2316 of Medicare tax. and…
Fateen Shakran, store supervisor, is responsible for creating a summary of the store’s transactions at the end of each day. He is also responsible for checking the register tape against the credit slips and cash in the register, and then depositing the money in the morning. Fateen recently took a new role as head bookkeeper, when the former one retired. Fateen would occasionally change a transaction on the register and pocket the extra money. Now, he waits until the end of the year for the store manager to go on holiday break. He writes a check for himself in the amount of an invoice, then cancels the check originally written to pay for the invoice. He cashes the check for himself, and waits a few weeks before resubmitting the invoice. When the owner writes the second check, Fateen records this in the cash disbursement journal, and then deposits the check. He then files it with all other paid invoices. Fateen has been following this practice successfully for several years and feels…
A local bank began charging $3.40 each month for returning canceled checks. The bank also has an $8.10 "maintenance" fee if a checking account slips below $750.00. Donna Sands likes to have copies of her canceled checks for preparing her income tax returns. She has received her bank statement with a balance of $603.73. Donna received $4.88 in interest and has been charged for the canceled checks and the maintenance fee. The following checks were outstanding: Number 94, $133.49, Number 96, $111.40, Number 98, $212.28; and Number 99, $82.30. A deposit of $777.15 was not recorded on Donna's bank statement. Her checkbook shows a balance of $848.03. Prepare Donna's bank reconciliation. Note: Input all amounts as positive values. Round your answers to 2 decimal places. Donna's checkbook balance Add: Subtotal Deduct Subtotal Reconciled balance BANK RECONCILIATION Bank balance Add Subtotal Deduct. Reconciled balance
David had the following activity with his checking account during the month of July: Starting checkbook balance of $701.13 July 15 electronic payroll deposit of $1,807.44 Online payment of $109.17 to Ameren Utilities Online payment of $104.00 to Gas Company Checks written on July 15 totaling $984.15 On July 27, he received an electronic payroll deposit of $1,807.43 What was David's checkbook balance as of July 31?
Braun issued a $35 check to Rice. Rice took the check to Braun’s bank and had it certified. Rice then raised the amount to $350 and negotiated it to Turner. Turner presented the check for payment and received $350. When Braun received her canceled checks, she noticed the alteration and notified the bank. Who will suffer the loss?
Next, consider the case of Washburn Flooring Company: The management at Washburn Flooring has determined that it takes an average of 6 days for checks the company writes to clear its bank account. Cash receipts from customers are reflected in Washburn's bank account an average of 2 days after the checks are received. On an average day, Washburn writes checks that total $40,000, and it receives checks from customers that total $50,000. Compute the collection float, the disbursement float, and the net float in dollars in the following table. (Note: By definition, collection float is always considered negative, and disbursement float is always positive. Both should be shown as positive numbers here. The net float, however, should be shown as positive if it is favorable and as negative if it is unfavorable.) Washburn Flooring Company Float Calculations Collection float Disbursement float Net float Given this information, you can deduce that on an average day, Washburn Flooring's bank…
When a drawee bank certifies a check, it charges the drawer's account. with the amount of the check and transfers those funds to its own certified check account. within a business day immediately within 48 hours whenever the drawer requests
Record the journal entries for each of the following payroll transactions. If an amount box does not require, leave it blank. Apr. 2 Paid $680 and $300 cash to a federal depository for FICA Social Security and FICA Medicare, respectively. Apr. 4 Paid accumulated employee salaries of $15,220. Apr. 11 Issued checks in the amounts of $480 for federal income tax and $300 for state income tax to an IRS-approved bank. Apr. 14 Paid cash to health insurance carrier for total outstanding health insurance liability of $800. Apr. 22 Remitted cash payments for FUTA and SUTA to federal and state unemployment agencies in the amounts of $130 and $250, respectively. Apr. 2 Apr. 4 Apr. 11 Apr. 14 Apr. 22
The following accounts, with the balances indicated, appear in the ledger of Garcon Co. on December 1 of the current year: 211 Salaries Payable 212 Social Security Tax Payable 213 Medicare Tax Payable 214 Employees Federal Income Tax Payable 215 Employees State Income Tax Payable 216 State Unemployment Tax Payable 217 Federal Unemployment Tax Payable 218 Retirement Savings Deductions Payable $ 9,273 $ 3,400 219 Medical Insurance Payable 411 Operations Salaries Expense 511 Officers Salaries Expense 512 Office Salaries Expense 519 Payroll Tax Expense 27,000 2,318 15,455 950,000 13,909 600,000 1,400 150,000 500 137,951 The following transactions relating to payroll, payroll deductions, and payroll taxes occurred during December: Dec. 2. Issued Check No. 410 for $3,400 to Jay Bank to invest in a retirement savings account for employees. 2. Issued Check No. 411 to Jay Bank for $27,046, in payment of $9,273 of social secu- rity tax, $2,318 of Medicare tax, and $15,455 of employees' federal…
5