Question:
Restore the Sports City (Backup) file that you downloaded from the student companion site. Record the following business events in chronological order (remember, dates are in the month of April 2015).
Create, memorize, and print the following reports with no date prepared, time prepared, or report basis fields.
a. Transaction List by Date for April 2015 in landscape orientation.
b. Profit & Loss Standard for April 2015 with a % of Income column.
c. Balance Sheet Standard as of 4/30/15 with a % of Column.
d. Statement of Cash Flows for April 2015.
e. Profit & Loss Budget vs. Actual for April 2015.
f. Profit & Loss Budget Overview for April 2015 through June 2015.
g. Sales by Customer Summary Report for the month ended 4/30/15, sorted by total from largest to smallest amount with month columns.
h. Sales by Item Summary Report for the month ended 4/30/15, sorted by total from largest to smallest amount with total only columns in landscape orientation.
i. Accounts Receivable Aging Summary Report as of 4/30/15.
j. Income and Expense by Account graph for the month ended 4/30/15.
k. Export the Balance Sheet created in (c) to Excel, and then print the Excel worksheet with gridlines and row and column headers.
l. Reconciliation Summary as of 4/30/15.
Transcribed Image Text:
Chronological List of Business Events Event # Date 1 4/16/15 2 3 4 4/17/15 4/20/15 4/20/15 5 4/20/15 6 4/21/15 7 8 4/22/15 4/24/15 9 4/24/15 10 4/27/15 11 4/29/15 12 4/30/15 345 13 4/30/15 14 4/30/15 15 4/30/15 16 17 4/30/15 4/30/15 Business Event Received a bill for $250 from Office Max for supplies purchased on account (record as Supplies, an expense; terms: due on receipt). Received Items and entered a bill from Nike for previously recorded Purchase Order No. 1 (terms: due on receipt). Received Items and entered a bill from Wilson Sporting Goods for previously recorded Purchase Order No. 2 (terms: due on receipt). Hired a new employee, Anne Franks (112 East Fir # 3, Lompoc, CA 93436), a single woman with Social Security number 233-89-4232. She will earn an hourly wage of $8.00, will be paid semimonthly like all employees, and is subject to all payroll taxes including the training tax. Received on account from Cabrillo High School a $400 payment, which is grouped with other undeposited funds. Invoiced Buena Vista Elementary (a new customer) for 100 shirts and five footballs. Received on account from Lompoc High School a $600 pay- ment, which is also grouped with other undeposited funds. Borrowed $10,000 from Mid-State Bank with a short-term note payable. Paid all bills due by 4/30/15 starting with Check No. 6. Invoiced Cabrillo High School for 75 basketball shoes, 75 shirts, 75 shorts, 50 running shoes, 150 soccer balls, and 20 sports bags (terms: net 15). Deposited by mail all previously received but undeposited payments, totaling $1,000, to Mid-State Bank. Paid all employees for the pay period 4/16-4/30. Ms. Franks worked 75 hours during this period. Start with Check No. 12. (See tax Information in Table 11.1.) Recorded depreciation of $2,000 on fumiture & fixtures. Recorded the expiration of $3,000 in prepaid rent. Reclassified the advance payment of $1,000 made by Arroyo Grande High School to Unearned Revenue (a new account). Reconciled the bank account. The ending bank balance shown on the statement was $5,333.52. The bank charged a $40 service charge. Checks for the April 30 payroll do not appear on the statement, nor does the $1,000 deposited by mail on April 29. (Print a reconciliation summary report.) Budget Information for April through June 2015 is given in Table 11.2.