Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

On june 1 2019 kris storey

05/01/2021 Client: saad24vbs Deadline: 2 Day

Pr. 2-3A

Problem 2-3A # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")

Name: 0

Section: # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")

144

Score: 0% # N-box +B-box corrects COUNTIF(B7:AT41," ")

0

Key Code: 2 Total SUM(AV13:AV15)

Instructions 144

Answers are entered in the cells with gray backgrounds. Percentage =(AV16-AV13-AV14)/AV16

Cells with non-gray backgrounds are protected and cannot be edited. 0%

Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list. Notes:

In journal entries, dates will not be graded. In the general ledger accounts, only the final balance of the account will be If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "

graded. For correct grading in the trial balance, enter a zero where you would otherwise leave an amount cell blank. If number-entry or blank-entry box is incorrect, returns "*"

An asterisk (*) will appear to the right of incorrect entries in outlined answer cells. Essay answers will not be graded. If number-entry or blank-entry box is correct, returns single space, " "

1. JOURNAL Page 1 Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct.

Post Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.

Date Description Ref. Debit Credit

2019

June

Craig Pence: Enter the date here. Accounts Payable

Accounts Receivable

Cash

Equipment

Fees Earned

Miscellaneous Expense

Wages Expense

Notes Payable

Kris Storey, Capital

Kris Storey, Drawing

Prepaid Insurance

Supplies

Rent Expense

Van

Van Expense

Utilities Expense

Wages Expense

JOURNAL Page 2

Post

Date Description Ref. Debit Credit

2019

June

2. GENERAL LEDGER

Cash 11

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Accounts Receivable 12

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Supplies 13

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Prepaid Insurance 14

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Equipment 16

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Van 18

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Notes Payable 21

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Accounts Payable 22

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Kris Storey, Capital 31

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Kris Storey, Drawing 32

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Fees Earned 41

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Wages Expense 51

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Rent Expense 53

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Utilities Expense 54

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Van Expense 55

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

Miscellaneous Expense 59

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June

3. ECO-CENTRIC DESIGNS

Unadjusted Trial Balance

June 30, 2019

Debit Balances Credit Balances

Cash

Accounts Receivable

Supplies

Prepaid Insurance

Equipment

Van

Notes Payable

Accounts Payable

Kris Storey, Capital

Kris Storey, Drawing

Fees Earned

Wages Expense

Rent Expense

Utilities Expense

Van Expense

Miscellaneous Expense


Peggy Hussey: Total debits should be equal to total credits.

Peggy Hussey: Total debits should be equal to total credits.

4.

5.

[Key essay answer here]

Sol

Problem 2-3A

Name: Solution

Section:

Scoring: ON

Instructions

Answers are entered in the cells with gray backgrounds.

Cells with non-gray backgrounds are protected and cannot be edited.

Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list.

In journal entries, dates will not be graded. In the general ledger accounts, only the final balance of the account will be

graded. For correct grading in the trial balance, enter a zero where you would otherwise leave an amount cell blank.

An asterisk (*) will appear to the right of incorrect entries in outlined answer cells. Essay answers will not be graded.

1. JOURNAL Page 1

Post

Date Description Ref. Debit Credit

2019

June 1

Craig Pence: Enter the date here. Cash 11 35,000 Accounts Payable

Kris Storey, Capital 31 35,000 Accounts Receivable

Cash

1 Rent Expense 53 4,750 Equipment

Cash 11 4,750 Fees Earned

Kris Storey, Capital

6 Equipment 16 14,100 Kris Storey, Drawing

Accounts Payable 22 14,100 Miscellaneous Expense

Wages Expense

8 Van 18 28,500 Notes Payable

Cash 11 4,500 Prepaid Insurance

Notes Payable 21 24,000 Supplies

Rent Expense

10 Supplies 13 2,380 Van

Cash 11 2,380 Van Expense

Utilities Expense

12 Cash 11 12,200 Wages Expense

Fees Earned 41 12,200

15 Prepaid Insurance 14 3,600

Cash 11 3,600

23 Accounts Receivable 12 11,900

Fees Earned 41 11,900

24 Van Expense 55 1,500

Accounts Payable 22 1,500

JOURNAL Page 2

Post

Date Description Ref. Debit Credit

2019

June 29 Utilities Expense 54 3,100

Cash 11 3,100

29 Miscellaneous Expense 59 950

Cash 11 950

30 Cash 11 7,330

Accounts Receivable 12 7,330

30 Wages Expense 51 5,070

Cash 11 5,070

30 Accounts Payable 22 6,825

Cash 11 6,825

30 Kris Storey, Drawing 32 1,600

Cash 11 1,600

GENERAL LEDGER

2. Cash 11

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 1 1 35,000 35,000

1 1 4,750 30,250

8 1 4,500 25,750

10 1 2,380 23,370

12 1 12,200 35,570

15 1 3,600 31,970

29 2 3,100 28,870

29 2 950 27,920

30 2 7,330 35,250

30 2 5,070 30,180

30 2 6,825 23,355

30 2 1,600 21,755

Accounts Receivable 12

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 23 1 11,900 11,900

30 2 7,330 4,570

Supplies 13

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 10 1 2,380 2,380

Prepaid Insurance 14

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 15 1 3,600 3,600

Equipment 16

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 6 1 14,100 14,100

Van 18

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 8 1 28,500 28,500

Notes Payable 21

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 8 1 24,000 24,000

Accounts Payable 22

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 6 1 14,100 14,100

24 1 1,500 15,600

30 2 6,825 8,775

Kris Storey, Capital 31

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 1 1 35,000 35,000

Kris Storey, Drawing 32

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 30 2 1,600 1,600

Fees Earned 41

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 12 1 12,200 12,200

23 1 11,900 24,100

Wages Expense 51

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 30 2 5,070 5,070

Rent Expense 53

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 1 1 4,750 4,750

Utilities Expense 54

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 29 2 3,100 3,100

Van Expense 55

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 24 1 1,500 1,500

Miscellaneous Expense 59

Post Balance

Date Item Ref. Dr. Cr. Dr. Cr.

2019

June 29 2 950 950

3. ECO-CENTRIC DESIGNS

Unadjusted Trial Balance

June 30, 2019

Debit Balances Credit Balances

Cash 21,755 -

Accounts Receivable 4,570 -

Supplies 2,380 -

Prepaid Insurance 3,600 -

Equipment 14,100 -

Van 28,500 -

Notes Payable - 24,000

Accounts Payable - 8,775

Kris Storey, Capital - 35,000

Kris Storey, Drawing 1,600 -

Fees Earned - 24,100

Wages Expense 5,070 -

Rent Expense 4,750 -

Utilities Expense 3,100 -

Van Expense 1,500 -

Miscellaneous Expense 950 -

91,875

Peggy Hussey: Total debits should be equal to total credits. 91,875

Peggy Hussey: Total debits should be equal to total credits.

4.

$8,730

5.

Some supplies may have been used, prepaid insurance expired, or depreciation of equipment incurred for which the expense has not been recorded.


Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Essay Tutor
Helping Hand
University Coursework Help
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$65 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Shrek donkey lonely song - Sales mix in units formula - Risk management - 4 pages from the attached article - Ethical dilemma worksheet law enforcement - The earnings dividends and stock price of shelby inc - Ideal pasta price philippines - Csuf computer engineering flowchart - English 102 research paper - John mayer mulholland drive - How to run driver verifier - If the tension developed in either cable ab or ac - Cloud Computing - Period of physical pendulum - Gavin de becker's gift of fear - Project charter example for a wedding - The support consists of a solid red brass - Hw - Army magic bullet missed appointment - Interrelationships in travel and tourism - Which division detects stimuli of the general senses and special senses? - Individual health care identifier - Caltex sae 30 oil - Pra - Assignment for Macroeconomics - Discussion #1 - Tell us about a "causal study" you've been involved in. - Google analytics merchandise store demo account - Managment - Martin luther king presentation ideas - Cryptography - Picture book analysis example - Assume that male and female births are equally likely - HA 425 Operational Analysis and Quality Improvement - Program Development - Followership and servant leadership compare and contrast army - Vce examination score review application - Royal college of psychiatrists portfolio - Functional health assessment example - Actors in romeo and juliet - Active file recovery software - Nutrition and drugs - Content writing - Assignment - Azimuth marine port hedland - Leccion 5 contextos activities - Case Study Analysis - Wow little tommy newcomer - Cloud computing business model ppt - 8 steps decision making process example management - Enrollment amendment form monash - To bid or not to bid - Labor connections hickory north carolina - Ferny grove transfer station - How to find ksp from absorbance - Fiu refworks - Security architecture 1 - Need 8+ pages of PPT and 7+ pages of research along with all steps including step 10 chart in requirement with no plagiarism follow all instructions - IT incident response wk7 - Purdue university medical coding - Average value of a function and 2nd fund thm homework - To work as a BI consultant using Altryx and Tableau software to analyse a company's operational data and make recommendations Textual/Sentiment Analysis, Predictive Business Intelligence, Regression modelling, Classification modelling (binary/non-binary). Clustering modelling - V - It general controls review - The armada portrait symbolism - Doublespeak william lutz summary - Literature Review and Critical Appraisal - Episode where ross and rachel kiss - Two types of prewriting penn foster - Business management 3 4 practice exams - Denver post newsstand price 2018 - Wells Fargo Fraud - Iep goals for word retrieval - Hollywood silver fox farm v emmett - Ckw investments pty perth - Kilkelly ireland peter jones - Slosson intelligence test scores interpretation - Marketing Mgmt - Reflection, Discussion and Assignment - Crime watch daily lacey spears full episode - Summary of major counseling theories - Haribo nederland b v - The banker's algorithm is used - Multiplying a monomial and a polynomial - Honig v.doe case brief - A él / aburrir / clases - Algebra 1 chapter 3 test answer key - Mcis sau - You give me that bottom of the ninth quote - Www keiserlibrary com - Borderline symptom checklist scoring - Cedric sunray wannabe - English unit 1 exam - University of indiana plagiarism test - The butterfly lion worksheets - Axe target market demographics - High crags primary school bradford - Monifieth parish church website - Lockwood keyless digital deadbolt - I come before you today - What does mod mean in medical terms - Ansul r 102 cartridge - Answer part a and b.