Questions
Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services,...

Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $22.75 per hundred square feet. However, there is some question about whether the company is actually making any money on jobs for some customers—particularly those located on remote ranches that require considerable travel time. The owner’s daughter, home for the summer from college, has suggested investigating this question using activity-based costing. After some discussion, she designed a simple system consisting of four activity cost pools. The activity cost pools and their activity measures appear below:

Activity Cost Pool Activity Measure Activity for the Year
Cleaning carpets Square feet cleaned (00s) 13,500 hundred square feet
Travel to jobs Miles driven 142,000 miles
Job support Number of jobs 1,600 jobs
Other (organization-sustaining costs and idle capacity costs) None Not applicable

The total cost of operating the company for the year is $361,000 which includes the following costs:

Wages $ 137,000
Cleaning supplies 26,000
Cleaning equipment depreciation 12,000
Vehicle expenses 40,000
Office expenses 68,000
President’s compensation 78,000
Total cost $ 361,000

Resource consumption is distributed across the activities as follows:

Distribution of Resource Consumption Across Activities
Cleaning Carpets Travel to Jobs Job Support Other Total
Wages 76 % 14 % 0 % 10 % 100 %
Cleaning supplies 100 % 0 % 0 % 0 % 100 %
Cleaning equipment depreciation 68 % 0 % 0 % 32 % 100 %
Vehicle expenses 0 % 79 % 0 % 21 % 100 %
Office expenses 0 % 0 % 56 % 44 % 100 %
President’s compensation 0 % 0 % 26 % 74 % 100 %

Job support consists of receiving calls from potential customers at the home office, scheduling jobs, billing, resolving issues, and so on.

Required:

1. Prepare the first-stage allocation of costs to the activity cost pools.

2. Compute the activity rates for the activity cost pools. (Round your answers to 2 decimal places.)

3. The company recently completed a 600 square foot carpet-cleaning job at the Flying N Ranch—a 60-mile round-trip journey from the company’s offices in Bozeman. Compute the cost of this job using the activity-based costing system. (Round your intermediate calculations and final answer to 2 decimal places.)

4. The revenue from the Flying N Ranch was $136.50 (600 square feet @ $22.75 per hundred square feet). Calculate the customer margin earned on this job. (Round your intermediate calculations and final answers to 2 decimal places.)

In: Accounting

This problem is an adaptation of the Wholesale Workers Company problem from WORKSHEET 1.


Continuing Problem: Worksheet 2 Scenario: 

This problem is an adaptation of the Wholesale Workers Company problem from WORKSHEET 1. 

You can use your work from WORKSHEET 1 to assist you. Here, we are to assume that Wholesale Workers Company is a merchandising company and sells merchandise inventory. Consequently, Wholesale Workers Company now has the asset Inventory and will have Sales revenue rather than service revenue. The accounts and balances (after closing) at the end of their fiscal year March 31, 2016 are now as follows (the accounts that are changed/new from previous worksheet are underlined): Cash $14,000, Accounts Receivable $46,000, Inventory $65,000, Supplies $6,000, Equipment $230,000, Accumulated Depreciation $45,000, Accounts Payable $28,000, Wages Payable $1,600, Common Stock $40,000 and Retained Earnings $246,400.

Use the T-accounts below and include the appropriate beginning balances.


Cash  


Accounts Receivable



Inventory











































Supplies


Equipment



Accumulated Depreciation



































Accounts Payable


Wages Payable








































Common Stock



Retained Earnings



























Sales Revenue


Cost of Goods Sold



Wage Expense











































Supplies Expense


Depreciation Expense



Other Expenses





















































Write the journal entries for the transactions below. Some of these transactions are unchanged from Worksheet 1 scenario. Use your work there as a resource.   

Inventory Merchandise was purchased on account during the year for $480,000. Because they are selling merchandise, they must purchase it before they sell the product. Inventory is any item purchased with the intent to resell it. Items purchased to be used in the day to day operation of the business (not resold to customers) are classified as Supplies, if they will be used in the short term—one year or less, and Equipment if it will be used over multiple years.

The company sold $500,000 of merchandise inventory for $840,000 to customers on account. Write 2 journal entries—1 to recognize the revenue—1 to recognize the expense. Because the company is a merchandiser, they now have Cost of Goods Sold as an expense.

Supplies in the amount of $18,000 were purchased during the year. Supplies ae different than inventory as supplies represent items the company intends to use within the business while inventory are items the company intends to resell.

Cash was collected from customers on account in the amount of $848,000 during the year.

Wholesale Workers Company paid their employees $125,000 for work performed during the year. The amount paid to employees has been reduced from the Scenario in Worksheet 1 to represent the fewer employees utilized by merchandising companies than service companies. Of the $125,000, $1,600 of the payment relates to work performed in the previous year. (Wages Payable).

Other operating expenses in the amount of $155,000 were incurred on account during the year.

Payments on account where made during the year totally $660,000. This amount has increased from the Scenario in Worksheet 1 because merchandising companies pay their suppliers for inventory purchased. Service companies do not.

An adjusting entry was made at year end, March 31, 2017 to recognize depreciation expense in the amount of $26,000.

An adjusting entry was made at year end to recognize $14,000 of supplies used.

A year end adjustment was made to accrue $2,200 of unpaid wages.

Determine the “ending” balances for Wholesale Workers Company as of March 31, 2017.

In: Accounting

The Russell 1000 is a stock market index consisting of the largest U.S. companies. The Dow...

The Russell 1000 is a stock market index consisting of the largest U.S. companies. The Dow Jones industrial Average is based on 30 large companies. The data giving the annual percentage returns for each of these stock indexes for 25 years are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.

 
Year DJIA % Return Russell 1000 % Return
1988 8.82 12.33
1989 26.59 26.44
1990 -3.68 -4.57
1991 16.04 28.88
1992 5.38 1.66
1993 18.58 7.69
1994 6.29 1.76
1995 30.62 37.10
1996 21.49 17.49
1997 19.04 28.68
1998 12.83 29.46
1999 29.15 15.89
2000 -3.01 -6.42
2001 -9.85 -13.16
2002 -15.56 -25.79
2003 27.78 29.69
2004 7.71 10.82
2005 -4.84 8.73
2006 13.34 13.72
2007 8.12 7.04
2008 -31.04 -42.92
2009 20.72 22.47
2010 8.76 9.59
2011 2.80 -3.13
2012 8.40 11.02

a. Which of the following scatter diagrams accurately represents the data set?

#1

Russell 1000

DJIA

#2

Russell 1000

DJIA

#3

Russell 1000

DJIA

#4

Russell 1000

DJIA

_________Scatter diagram #1Scatter diagram #2Scatter diagram #3Scatter diagram #4

b. Compute the sample mean and standard deviation for each index (to 2 decimals).

sample mean standard deviation
DJIA:
Russell 1000:

c. Compute the sample correlation coefficient for these data (to 3 decimals).

d. Discuss similarities and differences in these two indexes.

_________There is a strong positive linear association between DJIA and Russell 1000There is a moderate positive linear association between DJIA and Russell 1000There is neither a positive nor a negative linear association between DJIA and Russell 1000There is a moderate negative linear association between DJIA and Russell 1000There is a strong negative linear association between DJIA and Russell 1000

The variance of the Russell 1000 is slightly _________largersmaller than that of the DJIA.

a. Which of the following scatter diagrams accurately represents the data set?

#1

Russell 1000

DJIA

#2

Russell 1000

DJIA

#3

Russell 1000

DJIA

#4

Russell 1000

DJIA

_________Scatter diagram #1Scatter diagram #2Scatter diagram #3Scatter diagram #4

b. Compute the sample mean and standard deviation for each index (to 2 decimals).

sample mean standard deviation
DJIA:
Russell 1000:

c. Compute the sample correlation coefficient for these data (to 3 decimals).

d. Discuss similarities and differences in these two indexes.

_________There is a strong positive linear association between DJIA and Russell 1000There is a moderate positive linear association between DJIA and Russell 1000There is neither a positive nor a negative linear association between DJIA and Russell 1000There is a moderate negative linear association between DJIA and Russell 1000There is a strong negative linear association between DJIA and Russell 1000

The variance of the Russell 1000 is slightly _________largersmaller than that of the DJIA.

In: Math

the amateur triathletes who competed in the 2006 ironman Coeur d'Alene were classified by sex and...

the amateur triathletes who competed in the 2006 ironman Coeur d'Alene were classified by sex and age with the following results (ford ironman coeur d'alene 2006 results, 2006.)

18-34 35-49 50+
men 467 950 208
women 229 304 42

Do these data provide sufficient evidence at the 0.05 significance level to conclude that sex and age are related among triathletes who complete in Coeur d'Alene?

In: Statistics and Probability

At June 30, 2017, the end of its most recent fiscal year, Green River Computer Consultants’...

At June 30, 2017, the end of its most recent fiscal year, Green River Computer Consultants’ post-closing trial balance was as follows:

Debit Credit

Cash

$5,230

Accounts receivable

1,200

Supplies

690

Accounts payable

$400

Unearned service revenue

1,120

Common stock

3,600

Retained earnings

2,000
$7,120 $7,120


The company underwent a major expansion in July. New staff was hired and more financing was obtained. Green River conducted the following transactions during July 2017, and adjusts its accounts monthly.

July 1 Purchased equipment, paying $4,000 cash and signing a 2-year note payable for $20,000. The equipment has a 4-year useful life. The note has a 6% interest rate which is payable on the first day of each following month.
2 Issued 20,000 shares of common stock for $50,000 cash.
3 Paid $3,600 cash for a 12-month insurance policy effective July 1.
3 Paid the first 2 (July and August 2017) months’ rent for an annual lease of office space for $4,000 per month.
6 Paid $3,800 for supplies.
9 Visited client offices and agreed on the terms of a consulting project. Green River will bill the client, Connor Productions, on the 20th of each month for services performed.
10 Collected $1,200 cash on account from Milani Brothers. This client was billed in June when Green River performed the service.
13 Performed services for Fitzgerald Enterprises. This client paid $1,120 in advance last month. All services relating to this payment are now completed.
14 Paid $400 cash for a utility bill. This related to June utilities that were accrued at the end of June.
16 Met with a new client, Thunder Bay Technologies. Received $12,000 cash in advance for future services to be performed.
18 Paid semi-monthly salaries for $11,000.
20 Performed services worth $28,000 on account and billed customers.
20 Received a bill for $2,200 for advertising services received during July. The amount is not due until August 15.
23 Performed the first phase of the project for Thunder Bay Technologies. Recognized $10,000 of revenue from the cash advance received July 16.
27 Received $15,000 cash from customers billed on July 20.


Adjustment data:

1. Adjustment of prepaid insurance.
2. Adjustment of prepaid rent.
3. Supplies used, $1,250.
4. Equipment depreciation, $500 per month.
5. Accrual of interest on note payable.
6. Salaries for the second half of July, $11,000, to be paid on August 1.
7. Estimated utilities expense for July, $800 (invoice will be received in August).
8. Income tax for July, $1,200, will be paid in August.


The chart of accounts for Green River Computer Consultants contains the following accounts: Cash, Accounts Receivable, Supplies, Prepaid Insurance. Prepaid Rent, Equipment, Accumulated Depreciation—Equipment, Accounts Payable, Notes Payable, Interest Payable, Income Taxes Payable, Salaries and Wages Payable, Unearned Service Revenue, Common Stock, Retained Earnings, Dividends, Income Summary, Service Revenue, Supplies Expense, Depreciation Expense, Insurance Expense, Salaries and Wages Expense, Advertising Expense, Income Tax Expense, Interest Expense, Rent Expense, Supplies Expense, and Utilities Expense.

A. Prepare a trial balance at July 31st

B. Journalize and post closing entries and complete the closing proccess

C. Prepare a post-closing trial balance at July 31st.

In: Accounting

At June 30, 2017, the end of its most recent fiscal year, Bramble Computer Consultants’ post-closing...

At June 30, 2017, the end of its most recent fiscal year, Bramble Computer Consultants’ post-closing trial balance was as follows:

Debit Credit
Cash $4,080
Accounts receivable 940
Supplies 540
Accounts payable $310
Unearned service revenue 870
Common stock 2,800
Retained earnings 1,580
$5,560 $5,560


The company underwent a major expansion in July. New staff was hired and more financing was obtained. Bramble conducted the following transactions during July 2017, and adjusts its accounts monthly.

July 1 Purchased equipment, paying $3,600 cash and signing a 2-year note payable for $15,600. The equipment has a 4-year useful life. The note has a 6% interest rate which is payable on the first day of each following month.
2 Issued 15,600 shares of common stock for $39,000 cash.
3 Paid $3,000 cash for a 12-month insurance policy effective July 1.
3 Paid the first 2 (July and August 2017) months’ rent for an annual lease of office space for $3,100 per month.
6 Paid $3,000 for supplies.
9 Visited client offices and agreed on the terms of a consulting project. Bramble will bill the client, Connor Productions, on the 20th of each month for services performed.
10 Collected $940 cash on account from Milani Brothers. This client was billed in June when Bramble performed the service.
13 Performed services for Fitzgerald Enterprises. This client paid $870 in advance last month. All services relating to this payment are now completed.
14 Paid $310 cash for a utility bill. This related to June utilities that were accrued at the end of June.
16 Met with a new client, Thunder Bay Technologies. Received $9,400 cash in advance for future services to be performed.
18 Paid semi-monthly salaries for $8,600.
20 Performed services worth $21,800 on account and billed customers.
20 Received a bill for $1,700 for advertising services received during July. The amount is not due until August 15.
23 Performed the first phase of the project for Thunder Bay Technologies. Recognized $7,800 of revenue from the cash advance received July 16.
27 Received $11,700 cash from customers billed on July 20.


Adjustment data:

1. Adjustment of prepaid insurance.
2. Adjustment of prepaid rent.
3. Supplies used, $1,000.
4. Equipment depreciation, $400 per month.
5. Accrual of interest on note payable.
6. Salaries for the second half of July, $8,600, to be paid on August 1.
7. Estimated utilities expense for July, $620 (invoice will be received in August).
8. Income tax for July, $940, will be paid in August.


The chart of accounts for Bramble Computer Consultants contains the following accounts: Cash, Accounts Receivable, Supplies, Prepaid Insurance. Prepaid Rent, Equipment, Accumulated Depreciation—Equipment, Accounts Payable, Notes Payable, Interest Payable, Income Taxes Payable, Salaries and Wages Payable, Unearned Service Revenue, Common Stock, Retained Earnings, Dividends, Income Summary, Service Revenue, Supplies Expense, Depreciation Expense, Insurance Expense, Salaries and Wages Expense, Advertising Expense, Income Tax Expense, Interest Expense, Rent Expense, Supplies Expense, and Utilities Expense.

In: Accounting

At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing...

At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing trial balance was as follows:

Debit Credit
Cash $6,380
Accounts receivable 1,460
Supplies 840
Accounts payable $490
Unearned service revenue 1,370
Common stock 4,400
Retained earnings 2,420
$8,680 $8,680


The company underwent a major expansion in July. New staff was hired and more financing was obtained. Blue conducted the following transactions during July 2017, and adjusts its accounts monthly.

July 1 Purchased equipment, paying $4,400 cash and signing a 2-year note payable for $24,400. The equipment has a 4-year useful life. The note has a 6% interest rate which is payable on the first day of each following month.
2 Issued 24,400 shares of common stock for $61,000 cash.
3 Paid $4,200 cash for a 12-month insurance policy effective July 1.
3 Paid the first 2 (July and August 2017) months’ rent for an annual lease of office space for $4,900 per month.
6 Paid $4,600 for supplies.
9 Visited client offices and agreed on the terms of a consulting project. Blue will bill the client, Connor Productions, on the 20th of each month for services performed.
10 Collected $1,460 cash on account from Milani Brothers. This client was billed in June when Blue performed the service.
13 Performed services for Fitzgerald Enterprises. This client paid $1,370 in advance last month. All services relating to this payment are now completed.
14 Paid $490 cash for a utility bill. This related to June utilities that were accrued at the end of June.
16 Met with a new client, Thunder Bay Technologies. Received $14,600 cash in advance for future services to be performed.
18 Paid semi-monthly salaries for $13,400.
20 Performed services worth $34,200 on account and billed customers.
20 Received a bill for $2,700 for advertising services received during July. The amount is not due until August 15.
23 Performed the first phase of the project for Thunder Bay Technologies. Recognized $12,200 of revenue from the cash advance received July 16.
27 Received $18,300 cash from customers billed on July 20.


Adjustment data:

1. Adjustment of prepaid insurance.
2. Adjustment of prepaid rent.
3. Supplies used, $1,550.
4. Equipment depreciation, $600 per month.
5. Accrual of interest on note payable.
6. Salaries for the second half of July, $13,400, to be paid on August 1.
7. Estimated utilities expense for July, $980 (invoice will be received in August).
8. Income tax for July, $1,460, will be paid in August.


The chart of accounts for Blue Computer Consultants contains the following accounts: Cash, Accounts Receivable, Supplies, Prepaid Insurance. Prepaid Rent, Equipment, Accumulated Depreciation—Equipment, Accounts Payable, Notes Payable, Interest Payable, Income Taxes Payable, Salaries and Wages Payable, Unearned Service Revenue, Common Stock, Retained Earnings, Dividends, Income Summary, Service Revenue, Supplies Expense, Depreciation Expense, Insurance Expense, Salaries and Wages Expense, Advertising Expense, Income Tax Expense, Interest Expense, Rent Expense, Supplies Expense, and Utilities Expense.

Prepare an adjusted trial balance.

In: Accounting

At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing...

At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing trial balance was as follows:

Debit Credit
Cash $6,380
Accounts receivable 1,460
Supplies 840
Accounts payable $490
Unearned service revenue 1,370
Common stock 4,400
Retained earnings 2,420
$8,680 $8,680


The company underwent a major expansion in July. New staff was hired and more financing was obtained. Blue conducted the following transactions during July 2017, and adjusts its accounts monthly.

July 1 Purchased equipment, paying $4,400 cash and signing a 2-year note payable for $24,400. The equipment has a 4-year useful life. The note has a 6% interest rate which is payable on the first day of each following month.
2 Issued 24,400 shares of common stock for $61,000 cash.
3 Paid $4,200 cash for a 12-month insurance policy effective July 1.
3 Paid the first 2 (July and August 2017) months’ rent for an annual lease of office space for $4,900 per month.
6 Paid $4,600 for supplies.
9 Visited client offices and agreed on the terms of a consulting project. Blue will bill the client, Connor Productions, on the 20th of each month for services performed.
10 Collected $1,460 cash on account from Milani Brothers. This client was billed in June when Blue performed the service.
13 Performed services for Fitzgerald Enterprises. This client paid $1,370 in advance last month. All services relating to this payment are now completed.
14 Paid $490 cash for a utility bill. This related to June utilities that were accrued at the end of June.
16 Met with a new client, Thunder Bay Technologies. Received $14,600 cash in advance for future services to be performed.
18 Paid semi-monthly salaries for $13,400.
20 Performed services worth $34,200 on account and billed customers.
20 Received a bill for $2,700 for advertising services received during July. The amount is not due until August 15.
23 Performed the first phase of the project for Thunder Bay Technologies. Recognized $12,200 of revenue from the cash advance received July 16.
27 Received $18,300 cash from customers billed on July 20.


Adjustment data:

1. Adjustment of prepaid insurance.
2. Adjustment of prepaid rent.
3. Supplies used, $1,550.
4. Equipment depreciation, $600 per month.
5. Accrual of interest on note payable.
6. Salaries for the second half of July, $13,400, to be paid on August 1.
7. Estimated utilities expense for July, $980 (invoice will be received in August).
8. Income tax for July, $1,460, will be paid in August.


The chart of accounts for Blue Computer Consultants contains the following accounts: Cash, Accounts Receivable, Supplies, Prepaid Insurance. Prepaid Rent, Equipment, Accumulated Depreciation—Equipment, Accounts Payable, Notes Payable, Interest Payable, Income Taxes Payable, Salaries and Wages Payable, Unearned Service Revenue, Common Stock, Retained Earnings, Dividends, Income Summary, Service Revenue, Supplies Expense, Depreciation Expense, Insurance Expense, Salaries and Wages Expense, Advertising Expense, Income Tax Expense, Interest Expense, Rent Expense, Supplies Expense, and Utilities Expense.

Prepare a trial balance at July 31

In: Accounting

At June 30, 2017, the end of its most recent fiscal year, Flounder Computer Consultants’ post-closing...

At June 30, 2017, the end of its most recent fiscal year, Flounder Computer Consultants’ post-closing trial balance was as follows:

Debit Credit
Cash $4,390
Accounts receivable 1,010
Supplies 580
Accounts payable $340
Unearned service revenue 940
Common stock 3,000
Retained earnings 1,700
$5,980 $5,980


The company underwent a major expansion in July. New staff was hired and more financing was obtained. Flounder conducted the following transactions during July 2017, and adjusts its accounts monthly.

July 1 Purchased equipment, paying $3,600 cash and signing a 2-year note payable for $16,800. The equipment has a 4-year useful life. The note has a 6% interest rate which is payable on the first day of each following month.
2 Issued 16,800 shares of common stock for $42,000 cash.
3 Paid $3,000 cash for a 12-month insurance policy effective July 1.
3 Paid the first 2 (July and August 2017) months’ rent for an annual lease of office space for $3,400 per month.
6 Paid $3,200 for supplies.
9 Visited client offices and agreed on the terms of a consulting project. Flounder will bill the client, Connor Productions, on the 20th of each month for services performed.
10 Collected $1,010 cash on account from Milani Brothers. This client was billed in June when Flounder performed the service.
13 Performed services for Fitzgerald Enterprises. This client paid $940 in advance last month. All services relating to this payment are now completed.
14 Paid $340 cash for a utility bill. This related to June utilities that were accrued at the end of June.
16 Met with a new client, Thunder Bay Technologies. Received $10,100 cash in advance for future services to be performed.
18 Paid semi-monthly salaries for $9,200.
20 Performed services worth $23,500 on account and billed customers.
20 Received a bill for $1,800 for advertising services received during July. The amount is not due until August 15.
23 Performed the first phase of the project for Thunder Bay Technologies. Recognized $8,400 of revenue from the cash advance received July 16.
27 Received $12,600 cash from customers billed on July 20.


Adjustment data:

1. Adjustment of prepaid insurance.
2. Adjustment of prepaid rent.
3. Supplies used, $1,050.
4. Equipment depreciation, $425 per month.
5. Accrual of interest on note payable.
6. Salaries for the second half of July, $9,200, to be paid on August 1.
7. Estimated utilities expense for July, $670 (invoice will be received in August).
8. Income tax for July, $1,010, will be paid in August.


The chart of accounts for Flounder Computer Consultants contains the following accounts: Cash, Accounts Receivable, Supplies, Prepaid Insurance. Prepaid Rent, Equipment, Accumulated Depreciation—Equipment, Accounts Payable, Notes Payable, Interest Payable, Income Taxes Payable, Salaries and Wages Payable, Unearned Service Revenue, Common Stock, Retained Earnings, Dividends, Income Summary, Service Revenue, Supplies Expense, Depreciation Expense, Insurance Expense, Salaries and Wages Expense, Advertising Expense, Income Tax Expense, Interest Expense, Rent Expense, Supplies Expense, and Utilities Expense.

Please journalize the july transactions

In: Accounting

Accounting Cycle Review 4-4 (Part Level Submission) At June 30, 2017, the end of its most...

Accounting Cycle Review 4-4 (Part Level Submission)

At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing trial balance was as follows:

Debit Credit
Cash $6,380
Accounts receivable 1,460
Supplies 840
Accounts payable $490
Unearned service revenue 1,370
Common stock 4,400
Retained earnings 2,420
$8,680 $8,680


The company underwent a major expansion in July. New staff was hired and more financing was obtained. Blue conducted the following transactions during July 2017, and adjusts its accounts monthly.

July 1 Purchased equipment, paying $4,400 cash and signing a 2-year note payable for $24,400. The equipment has a 4-year useful life. The note has a 6% interest rate which is payable on the first day of each following month.
2 Issued 24,400 shares of common stock for $61,000 cash.
3 Paid $4,200 cash for a 12-month insurance policy effective July 1.
3 Paid the first 2 (July and August 2017) months’ rent for an annual lease of office space for $4,900 per month.
6 Paid $4,600 for supplies.
9 Visited client offices and agreed on the terms of a consulting project. Blue will bill the client, Connor Productions, on the 20th of each month for services performed.
10 Collected $1,460 cash on account from Milani Brothers. This client was billed in June when Blue performed the service.
13 Performed services for Fitzgerald Enterprises. This client paid $1,370 in advance last month. All services relating to this payment are now completed.
14 Paid $490 cash for a utility bill. This related to June utilities that were accrued at the end of June.
16 Met with a new client, Thunder Bay Technologies. Received $14,600 cash in advance for future services to be performed.
18 Paid semi-monthly salaries for $13,400.
20 Performed services worth $34,200 on account and billed customers.
20 Received a bill for $2,700 for advertising services received during July. The amount is not due until August 15.
23 Performed the first phase of the project for Thunder Bay Technologies. Recognized $12,200 of revenue from the cash advance received July 16.
27 Received $18,300 cash from customers billed on July 20.


Adjustment data:

1. Adjustment of prepaid insurance.
2. Adjustment of prepaid rent.
3. Supplies used, $1,550.
4. Equipment depreciation, $600 per month.
5. Accrual of interest on note payable.
6. Salaries for the second half of July, $13,400, to be paid on August 1.
7. Estimated utilities expense for July, $980 (invoice will be received in August).
8. Income tax for July, $1,460, will be paid in August.


The chart of accounts for Blue Computer Consultants contains the following accounts: Cash, Accounts Receivable, Supplies, Prepaid Insurance. Prepaid Rent, Equipment, Accumulated Depreciation—Equipment, Accounts Payable, Notes Payable, Interest Payable, Income Taxes Payable, Salaries and Wages Payable, Unearned Service Revenue, Common Stock, Retained Earnings, Dividends, Income Summary, Service Revenue, Supplies Expense, Depreciation Expense, Insurance Expense, Salaries and Wages Expense, Advertising Expense, Income Tax Expense, Interest Expense, Rent Expense, Supplies Expense, and Utilities Expense.

Prepare a classified balance sheet at July 31

In: Accounting