Using the check register below and the following bank statement, prepare a bank reconciliation for Lee.com. (Input all amounts as positive values. Round your answers to 2 decimal places.)

RECORD ALL CHARGES OR CREDITS THAT AFFECT YOUR ACCOUNT
	DATE	DESCRIPTION OF		PAYMENT/ DEBIT			FEE (IFANY)	DEPOSIT/ CREDIT	BALANCE
NUMBER	2015	TRANSACTION		()	?		()	(+)	$	4,770.00
959	7/7	AT+T		$156.80			$	$		156.80
										4,613.20
960	7/15	Staples		71.20						71.20
										4,542.00
	7/19	Deposit						725.00		725.00
										5,267.00
961	7/20	West Electric		489.68						489.68
										4,777.32
962	7/24	Bank of America		415.94						415.94
										4,361.38
	7/29	Deposit						439.80		439.80
									$	4,801.18

BANK STATEMENT
Date	Checks		Deposits	Balance
7/1 balance				$4,770.00
7/18	$156.80			4,613.20
7/19			$725.00	5,338.20
7/26	415.94			4,922.26
7/30	13.50	SC		4,908.76

BANK RECONCILIATION

Lee.com checkbook balance

$

Bank balance

$

Add:

(Click to select)Service chargeCanceled checkDeposit in transitOutstanding checks (total)ATM charge

Deduct:

Deduct:

(Click to select)Deposit in transitATM chargeOutstanding checks (total)Service chargeCanceled check

(Click to select)Service chargeDeposit in transitCanceled checkATM chargeOutstanding checks (total)

Ending checkbook balance

$

Ending bank balance

$

---

A local bank began charging $4.10 each month for returning canceled checks. The bank also has an $9.20 "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 $661.88. Donna received $7.18 in interest and has been charged for the canceled checks and the maintenance fee. The following checks were outstanding: No. 94, $144.67; No. 96, $148.10; No. 98, $249.71; and No. 99, $74.40. A deposit of $791.05 was not recorded on Donna's bank statement. Her checkbook shows a balance of $842.17.

Prepare Donnas bank reconciliation. (Input all amounts as positive values. Round your answers to 2 decimal places.)

Donnas checkbook balance

$

Bank balance

$

Add:

Add:

(Click to select)Service chargeMaintenance feeNotes collectedInterestCanceled checkDeposit in transitOutstanding checks (total)

(Click to select)Maintenance feeService chargeOutstanding checks (total)Canceled checkNotes collectedDeposit in transitInterest

$

$

Deduct:

Deduct:

(Click to select)Outstanding checks (total)InterestCanceled checkNotes collectedService chargeMaintenance feeDeposit in transit

$

(Click to select)Service chargeCanceled checkInterestOutstanding checks (total)Deposit in transitMaintenance feeNotes collected

(Click to select)Canceled checkInterestService chargeOutstanding checks (total)Maintenance feeDeposit in transitNotes collected

Reconciled balance

$

Reconciled balance

$

---

Banks are finding more ways to charge fees, such as a $33.10 overdraft fee. Sue McVickers has an account in Fayetteville; she has received her bank statement with this $33.10 charge. Also, she was charged a $10.60 service fee; however, the good news is she earned $14.15 interest. Her bank statements balance was $590.45, but it did not show the $1,394.95 deposit she had made. Sues checkbook balance shows $691.00. The following checks have not cleared: No. 250, $662.75; No. 253, $417.40; and No. 254, $243.80.

Prepare Sues bank reconciliation. (Input all amounts as positive values. Round your answers to 2 decimal places.)

Sue's checkbook balance		$	Bank balance	$
Add:			Add:
(Click to select)Deposit in transitTeller feeInterestOverdraftService chargeOutstanding checks (total)Maintenance fee			(Click to select)Teller feeDeposit in transitService chargeMaintenance feeInterestOverdraftOutstanding checks (total)
		$		$
Deduct:			Deduct:
(Click to select)InterestService chargeMaintenance feeOutstanding checks (total)OverdraftDeposit in transitTeller fee	$		(Click to select)Teller feeDeposit in transitOverdraftMaintenance feeInterestOutstanding checks (total)Service charge
(Click to select)Teller feeOverdraftDeposit in transitOutstanding checks (total)InterestService chargeMaintenance fee
Reconciled balance		$	Reconciled balance	$
Each Tuesday, Ryan Airlines reduces its one-way ticket from Fort Wayne to Chicago from $150 to $30. To receive this special $30 price, the customer must buy a round-trip ticket. Ryan has a nonrefundable 25% penalty fare for cancellation; it estimates that about nine-tenths of 1% will cancel their reservations. The airline also estimates this special price will cause a passenger traffic increase from 400 to 700. Ryan expects revenue for the year to be 55.8% higher than the previous year. Last year, Ryans sales were $484,000. To receive the special rate, Janice Miller bought two round-trip tickets. On other airlines, Janice has paid $125 round trip (with no cancellation penalty). a. Calculate the percent discount Ryan is offering. Percent discount % b. Calculate the percent passenger travel will increase. Percent passenger travel % c. Calculate the sales for new year. Sales for new year $ d. Calculate Janices loss if she cancels one round-trip flight. Janices loss $ e. Approximately how many more cancellations can Ryan Airlines expect (after Janices cancellation)? (Round down your answer to nearest whole number.) No of cancellations people