{"id":219254,"date":"2018-09-16T16:58:10","date_gmt":"2018-09-16T16:58:10","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/16\/hcs-380-week-2-wileyplus-excel-assignment-ex-4-12-ex-4-13-ex-4-16-ex-p4-1a-2\/"},"modified":"2018-10-24T08:46:34","modified_gmt":"2018-10-24T08:46:34","slug":"hcs-380-week-2-wileyplus-excel-assignment-ex-4-12-ex-4-13-ex-4-16-ex-p4-1a-2","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/hcs-380-week-2-wileyplus-excel-assignment-ex-4-12-ex-4-13-ex-4-16-ex-p4-1a-2\/","title":{"rendered":"HCS 380 Week 2 WileyPLUS Excel Assignment (Ex 4-12, Ex 4-13, Ex 4-16, Ex P4-1A)"},"content":{"rendered":"<p>Complete\u00a0the assigned exercises in WileyPLUS.\t\u00a0\tYou should see the following assignments that are due for a grade:\t\u00b7 \ufffd\u00a0\u00a0\u00a0 \u00a0\t\t\tChapter 4 &#8211; Excel assignment\tNOTE: \u00a0Assignment must be completed by Due Date. \u00a0Automatic deduction of 50% of points if received after due date. \u00a0No points awarded if completed after 4 days from Due Date.\t\u00a0\tExcel Exercise 4-12\tExcel Exercise 4-13\tExcel Exercise 4-16\tExcel Problem 4-1A\t\u00a0\t\u00a0\tE4-12\u00a0 Prepare a correct income statement \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd  \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\tThe income statement of Garska Co. for the month of July shows net income of $2,000 \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\tbased on Service Revenue $5,500; Salaries and Wages $2,100; Supplies Expense $900; \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\tand Utilities Expense $500.\u00a0 In reviewing the statement, you discover the following: \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t1. \ufffd\u00a0\u00a0\u00a0 Insurance expired during July of $350 was omitted. \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t2. \ufffd\u00a0\u00a0\u00a0 Supplies expense includes $200 of supplies that are still on hand at July 31. \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\t3. \ufffd\u00a0\u00a0\u00a0 Depreciation on equipment of $150 was omitted. \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t4. \ufffd\u00a0\u00a0\u00a0 Accrued but unpaid wages at July 31 of $360 were not included, \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0\t5. \ufffd\u00a0\u00a0\u00a0 Services performed but unrecorded totaled $700. \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\tInstructions \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0\tPrepare a correct income statement for July 2014. \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\tNOTE:\u00a0 Enter a number in cells requesting a value; enter either a number or a formula in cells with a &#8220;?&#8221; .  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0\t \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\tE4-13\u00a0 Analyze adjusted data \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\tThis is a partial adjusted trial balance of Barone Company \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd  \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\t \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\t \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd BARONE COMPANY \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0\t \ufffd \ufffd\u00a0 Adjusted Trial Balance \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0\t \ufffd \ufffd\u00a0 January 31, 2014 \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\t \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\t \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0 Debit\u00a0\u00a0 Credit \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\t \ufffd \ufffd\u00a0 Supplies \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0 $700  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t \ufffd \ufffd\u00a0 Prepaid Insurance \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd 1,560 \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t \ufffd \ufffd\u00a0 Salaries and Wages Payable \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0 $1,060  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\t \ufffd \ufffd\u00a0 Unearned Service Revenue \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd 750 \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\t \ufffd \ufffd\u00a0 Supplies Expense \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0 950 \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\t \ufffd \ufffd\u00a0 Insurance Expense \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0 520 \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\t \ufffd \ufffd\u00a0 Salaries and Wages\u00a0 Expense \ufffd \ufffd \ufffd \ufffd \ufffd 1,800 \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t \ufffd \ufffd\u00a0 Service Revenue \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0 4,000 \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\t \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\tInstructions \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\tAnswer these questions, assuming the year begins January 1. \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t(a) \ufffd\u00a0\u00a0 If the amount in Supplies Expense is the January 31 adjusting entry, and  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\t \ufffd \ufffd\u00a0 $300 of supplies was purchased in January, what was the balance in Supplies \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0\t \ufffd \ufffd\u00a0 on January 1? \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t(b) \ufffd\u00a0\u00a0 If the amount in Insurance Expense is the January 31 adjusting entry, and the \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0\t \ufffd \ufffd\u00a0 original insurance premium was for 1 year, what was the total premium and \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0\t \ufffd \ufffd\u00a0 when was the policy purchased? \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\t(c ) \ufffd\u00a0 If $2,500 of salaries was paid in January, what was the balance in Salaries and \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0\t \ufffd \ufffd\u00a0 Wages Payable at December 31, 2013? \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\t(d) \ufffd\u00a0 If $1,800 was received in January for services performed in January, what was \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd  \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t \ufffd \ufffd\u00a0 the balance in Unearned Service Revenue at December 31, 2013? \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\tNOTE:\u00a0 Enter a number in cells requesting a value; enter either a number or a formula in cells with a &#8220;?&#8221; .  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t\u00a0\tE4-16\u00a0 Prepare adjusting entries from analysis of trial balance \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\tThe trial balance shown below are before and after adjustment for Bere Company at the end of its fiscal year. \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\t \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\tBERE OMPANY \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\tTrial Balance \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\tAugust 31, 2014 \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0\u00a0\t \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\t \ufffd \ufffd\u00a0\t \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\tInstructions \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\tPrepare the adjusting entries that were made \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\tNOTE:\u00a0 Enter a number in cells requesting a value; enter either a number or a formula in cells with a &#8220;?&#8221; .  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\t \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\tP4-1A\u00a0 Record transactions on accrual basis; convert revenue to cash receipts \ufffd \ufffd \ufffd \ufffd  \ufffd \ufffd \ufffd \ufffd\u00a0\u00a0\u00a0  \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd \ufffd\u00a0\tThe following selected data are taken from the comparative financial statements of American&#038;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Complete\u00a0the assigned exercises in WileyPLUS. \u00a0 You should see the following assignments that are due for a grade: \u00b7 \ufffd\u00a0\u00a0\u00a0 \u00a0 Chapter 4 &#8211; Excel assignment NOTE: \u00a0Assignment must be completed by Due Date. \u00a0Automatic deduction of 50% of points <a href=\"https:\/\/www.benedictsol.com\/blogs\/hcs-380-week-2-wileyplus-excel-assignment-ex-4-12-ex-4-13-ex-4-16-ex-p4-1a-2\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-219254","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/219254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=219254"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/219254\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=219254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=219254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=219254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}