29 Jun Question Kelly Consulting Kelly Consulting Practice Set.
Question
Kelly Consulting
Kelly Consulting Practice Set.
You are given the following information:
•
Post closing trial balance for April 30, 2008
•
Transactions for the month of May 2008
•
Adjustments for May 31,2008
•
Insurance was purchased for a one ? year period, starting on March 1, 2008.
•
Rent was prepaid onJanuary1,2008,for a one-year period, starting on January1.
•
Office equipment has a 5 year life, with a 2,500 salvage value.
•
A supplies inventory count shows an ending balance of $1,235.
•
Assume that the receptionist works 5 days a week, and earns an even amount per day.
The May 28th payroll pays her up to May 28th (Wednesday).
Kelly Consulting Transactions fro May 2008.
May 3: Received cash from clients as an advance payment for services to be provided and recorded it as unearned fees, $1,550.
May 5: Received cash from clients on account, $1750.
May 9: Paid cash for a newspaper advertisement, $100.
May 13: Paid Office Station Co. for part of the debt incurred on April 5, $400.
May 15: Recorded services provided on account for the period May 1-15, $5,100.
May 16: Paid part-time receptionist for two weeks’ salary including the amount owed on April 13, $750.
May 17: Recorded cash from cash clients for fees earned during the period may 1-16, $7,380.
May 20: Purchased supplies on account, $500.
May 21: Recorded services provided on account for the period May 16-20, $2,900.
May 25: Recorded cash from cash clients for fess earned for the period May 17-23, $4,200.
May 27: Received cash from clients on account, $6,600.
May 28: Paid part-time receptionist for two weeks’ salary, $750.
May 30: Paid telephone bill for May, $150.
May 31: Paid electricity bill for May, $225.
May 31: Recorded cash from cash clients for fess earned for the period may 25-31, $2,875.
May 31: Recorded services provided on account for the remained of may, $2,200.
May 31: Kelly withdrew $7,500 for personal use.
Portfolio Instructions:
1. Record the ending balances from the April 30 post closing trial balance into the ledger sheets or alternatively, you may create T-accounts on an Excel spreadsheet.
2. Record journal entries for the May transactions on the journal sheets given or create a spreadsheet configured as a journal sheet.
3. Post the journal entries to the ledger sheets or if you created T-accounts post the entries o your T-accounts.
4. Enter the ending balance from the ledger or T-accounts on to the worksheet trial balance columns.
5. Enter the adjustments directly on to the worksheet.
6. Extend to the adjusted trial balance columns.
7. Extend to the financial statement columns.
8. Prepare the financial statements.
9. Enter the closing entries on to the worksheet.
10. Prepare the post-closing trial balances for May.
Make sure you include the following sections in your final Excel Workbook:
I. The completed worksheet on the given downloadable spreadsheet.
II. Formal income statement, statement of owner’s equity, and balance sheet (These may b
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.