Interpersonal Communication – Week 2 Assignment

Personal Identity

For your essay interview/talk with someone you have a close relationship with (such as spouse, friend, sibling, student advisor, etc.) about how you communicate or are labeled. Use the Johari Window Diagram to diagram how you communicate with them.  What would you both put in the four quadrants? What insights can you draw from this diagram and how does that person see you? Was this your reflected appraisal of yourself? How did things move from the Hidden quadrant to the Open quadrant, or from your Blind to Open quadrant, with that person?  

Do you agree with the guidelines in the textbook for enriching the self toward maintaining a healthy identity? Share why you agree or don’t agree. Apply what you’ve learned this week and write one goal you’ve created to improve your self-concept. Provide a detailed analysis of yourself incorporating the reading and textbook material.

Your paper should be 500 – 750 words (roughly 2 – 3 pages double spaced) double spaced and font Times New Roman size 12.

Before beginning this assignment, you should thoroughly review Excel Worksheets, Charts, Formulas, Functions, and Tables from your course textbook, Go! All in one: Computer concepts and application.
 
For this assignment you will use Microsoft Excel to develop a worksheet that details your personal expenses in at least four categories from the last three months. Some of these expense categories might include, but are not limited to, Mortgage, Rent, Utilities, Phone, Food, Entertainment, Tuition, Childcare, Clothing, and Insurance. (These numbers may be fictitious.)

Part 1: The Spreadsheet

• Begin by opening a new Microsoft Excel file. (You may use the template found here.)
• Use Rows 1 and 2 for a title.
• Beginning in row 4, use column A to list your different expenses.
• Label the next three columns (B, C, D) for the past three months.
• Fill in the appropriate amount for each expense for each month.
• Beside the column with your third month’s entries, create another column for totals for each category.
  • Use a formula to calculate a total for each category of expense. 
• In the row below your last expense entry, create another row for the monthly totals of expenses.
  • Use a formula to calculate a total for each month of expenses.
• Beside the column add another column for calculating the percent of the budget for each expense category.
  • Use a formula to calculate the percent that each expense category is of the total expenditures.
• Format the worksheet by adjusting column widths and wrapping text, and by applying appropriate financial number formatting and cell styles. 

Please Note: While some calculations might be easy to do in your head or using a calculator—merely typing the answer into the appropriate cell—the point of this assignment is to get you accustomed to using formulas. In situations requiring frequently updated data or more complex calculations, Excel is a very powerful tool if you know how to use it. Your grade is based on your demonstrated ability to use the required formulas.

Part 2: The Chart

Below your table of monthly expenses, you will create a chart using the numbers from your spreadsheet similar to the example below.

• Open the Insert ribbon at the top of the screen.
• Click on a populated cell inside your spreadsheet, then, click on Column on the Insert ribbon. Select the style of column chart you like. 
• Click and drag your column chart into position below your spreadsheet.

Suggested challenge for intermediate users: Add a row or rows detailing your income and subtract the total expenditures from the total income.

Suggested challenge for advanced users: Use a formula, function, or combination of both to show your net gain or loss (income minus expenses summed over time) for the three-month period.

ACC/557 Week 3 Chapter 4 (E4-5,E4-7,E4-13,P4-4A) 

Exercise 4-5 
The adjustments columns of the worksheet for Munoz Company are shown below
Adjustments 
Account Titles Debit Credit 
Accounts Receivable 600 
Prepaid Insurance 400 
Accumulated Depreciation—Equipment 900 
Salaries and Wages Payable 500 
Service Revenue 600 
Salaries and Wages Expense 500 
Insurance Expense 400 
Depreciation Expense 900 
2,400 2,400
Instructions: 
(a) Prepare adjusting entries in order presented in the problem. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) 
(b) Indicate with an “X” the financial statement column to which each balance should be extended 

Exercise 4-7 
Lanza Company had the following adjusted trial balance. 
LANZA COMPANY 
Adjusted Trial Balance 
For the Month Ended June 30, 2014 
Account Titles Debit Credit
Cash 3,712
Accounts Receivable 3,904
Supplies 480 
Accounts Payable 1,556
Unearned Service Revenue 160
Common Stock 4,000
Retained Earnings 1,760
Dividends 600 
Service Revenue 4,300
Salaries and Wages Expense 1,344
Miscellaneous Expense 180 
Supplies Expense 1,900
Salaries and Wages Payable 344
12,120 12,120

Instructions: 
a. Prepare closing entries at June 30, 2014. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) 
b. Prepare a post-closing trial balance. 

Exercise 4-13 
Kogan Company has an inexperienced accountant. During the first 2 weeks on the job, the accountant made the following errors in journalizing transactions. All entries were posted as made. 
1. A payment on account of $840 to a creditor was debited to Accounts Payable $480 and credited to Cash $480. 
2. The purchase of supplies on account for $380 was debited to Equipment $38 and credited to Accounts Payable $38. 
3. A $500 cash dividend was debited to Salaries and Wages Expense $500 and credited to Cash $500. 

Instructions: 
Prepare the correcting entries. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) 

Problem 4-4A 
Excelsior Amusement Parkhas a fiscal year ending on September 30. Selected data from the September 30 worksheet are presented below. 
Excelsior Amusement Park 
Worksheet 
For the Year Ended September 30, 2014 
Trial Balance Adjusted Trial Balance 
Dr. Cr. Dr. Cr. 
Cash 34,400 34,400 
Supplies 18,600 2,200 
Prepaid Insurance 29,900 10,900 
Land 80,000 80,000 
Equipment 120,000 120,000 
Accumulated Depreciation-Equip. 36,200 42,200 
Accounts Payable 14,600 14,600 
Unearned Ticket Revenue 3,900 1,000
Mortgage Payable 50,000 50,000 
Common Stock 60,000 60,000 
Retained Earnings 36,100 36,100 
Dividends 14,000 14,000 
Ticket Revenue 277,900 280,800 
Salaries and Wages Expense 98,000 98,000 
Maintenance and Repairs Expense 30,500 30,500 
Advertising Expense 9,400 9,400 
Utilities Expense 16,900 16,900 
Property Tax Expense 21,000 24,000 
Interest Expense 6,000 8,000 
Totals 478,700 478,700 
Insurance Expense 19,000 
Supplies Expense 16,400 
Interest Payable 2,000
Depreciation Expense 6,000 
Property Taxes Payable 3,000
Totals 489,700 489,700 

Instructions: 
(a) Prepare a complete worksheet 
(b) Prepare a classified balance sheet. (Note: $15,000 of the mortgage note payable is due for payment in the next fiscal year.) (List assets in order of liquidity and liabilities from largest to smallest eg 10, 5, 3, 2, with notes first.)
(c) Journalize the adjusting entries using the worksheet as a basis.
(d) Journalize the closing entries using the worksheet as a basis.
(e) Prepare a post-closing trial balance.

Winter Lips produces a lip balm used for cold-weather sports. The balm is manufactured in a single processing department. No lip balm was in process on May 31, and Winter Lips started production on 20,400 lip balm tubes during June. Direct materials are added at the beginning of the process, but the conversion costs are incurred evenly throughout the process. Completed production for June totaled 15,200 units. The June 30 work in process was 40% of the way through the production process. Direct materials costing $4,080 were placed in production during June, and direct labor of $3,315 and manufacturing overhead of $1,005 were assigned to the process. 
1. Draw a time line for Winter Lips
2. Use the time line to help you compute the total equivalent units and the cost per equivalent unit for June.
3. Assign total costs to (a) units competed and transferred to Finished Goods and (b) units still in process at June 30.
4. Prepare a T-account for Work in Process Inventory to show activity during June, including the June 30 balance.