Calculate the adjustment amount for Supplies and Prepaid Insurance and enter those amounts on the worksheet.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter19: Variable Costing (varcost)
Section: Chapter Questions
Problem 2R: Open the file VARCOST from the website for this book at cengagebrain.com. Enter the formulas where...
icon
Related questions
icon
Concept explainers
Question
100%
Using this information and the pictures below make a journal and ledger for the worksheet included. Adjustments: Blair's Custom Shop performed a count of supplies at the end of the accounting period (June 30, 20XX) and determined that value of supplies "on hand" (not used) was $1,700.00. The value of prepaid insurance coverage "on hand" (not used) at the same time was $750.00. Calculate the adjustment amount for Supplies and Prepaid Insurance and enter those amounts on the worksheet.
ACCOUNT Supplies
ACCOUNT NO.
130
POST.
BALANCE
DATE
ITEM
REF.
DEBIT
CREDIT
DEBIT
CREDIT
Jan
16
1
750.00
750.00
Feb
22
1,408.00
2,158.00
5
400.00
Apr
May
2,558.00
2.758.00
3,189.00
1
9
200,00
June
431.00
ACCOUNT Prepaid Insurance
ACCOUNT NO.
140
POST.
BALANCE
DATE
ITEM
REF.
DEBIT
CREDIT
DEBIT
CREDIT
Jan
1
1,500.00
1,500.00
ACCOUNT Insurance Expense
ACCOUNT NO.
530
POST.
BALANCE
DATE
ITEM
REF.
DEBIT
CREDIT
DEBIT
CREDIT
560
ACCOUNT Supplies Expense
ACCOUNT NO.
POST.
BALANCE
DATE
ITEM
REF.
DEBIT
CREDIT
DEBIT
CREDIT
Transcribed Image Text:ACCOUNT Supplies ACCOUNT NO. 130 POST. BALANCE DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Jan 16 1 750.00 750.00 Feb 22 1,408.00 2,158.00 5 400.00 Apr May 2,558.00 2.758.00 3,189.00 1 9 200,00 June 431.00 ACCOUNT Prepaid Insurance ACCOUNT NO. 140 POST. BALANCE DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Jan 1 1,500.00 1,500.00 ACCOUNT Insurance Expense ACCOUNT NO. 530 POST. BALANCE DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT 560 ACCOUNT Supplies Expense ACCOUNT NO. POST. BALANCE DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT
Google Doc Access Direc
Please click on File in the upper left corner.
If you are working on a Chromebook or Google Docs, choose the Make a copy option and save a copy of the document to your Google Drive.
If not, choose the Download as option and then the Microsoft Excel option to download an editable copy of the document to your computer.
2
Blair's Custom Shop
Work Sheet
For Period Ended June 30, 200X
3
4
5.
6.
2
3
4
6.
8.
7.
TRIAL BALANCE
ADJUSTMENTS
INCOME STATEMENT
BALANCE SHEET
8
ACCOUNT TITLE
DEBIT
CREDIT
DEBIT
CREDIT
DEBIT
CREDIT
DEBIT
CREDIT
9
1 Cash
15,267.00
10
2 Accounts Receivable - Bill Lang Upholstry
1,450.00
2
11
3 Accounts Receivable - Vinnie's Custom Designs
1,664.00
3
12
4 Supplies
3,189.00
4
13
5 Prepaid Insurance
1,500,00
5
14
6 Account Payable - Pop's Gun Shop
3,295.00
6
15
7 Accounts Payable - Ammo R Us
1,700.00
7
16
8 Jack Black, Capital
14,044.00
8.
9 Jack Black, Drawing
1,750.00
9
10| Income Summary
10
11Sales
8,772.00
11
12 Advertising Expense
1,000.00
12
13 Insurance Expense
13
22
14 Miscellaneous Expense
216.00
14
23
15 Rent Expense
1,000.00
15
24
16 Supplies Expense
16
25
17 Utilities Expense
775.00
17
26
18 Totals
27,811.00
27,811.00
18
27
19
19
28
20
20
29
21
21
30
22
22
31
23
23
32
24
24
33
34
35
36
37
38
39
Transcribed Image Text:Google Doc Access Direc Please click on File in the upper left corner. If you are working on a Chromebook or Google Docs, choose the Make a copy option and save a copy of the document to your Google Drive. If not, choose the Download as option and then the Microsoft Excel option to download an editable copy of the document to your computer. 2 Blair's Custom Shop Work Sheet For Period Ended June 30, 200X 3 4 5. 6. 2 3 4 6. 8. 7. TRIAL BALANCE ADJUSTMENTS INCOME STATEMENT BALANCE SHEET 8 ACCOUNT TITLE DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT 9 1 Cash 15,267.00 10 2 Accounts Receivable - Bill Lang Upholstry 1,450.00 2 11 3 Accounts Receivable - Vinnie's Custom Designs 1,664.00 3 12 4 Supplies 3,189.00 4 13 5 Prepaid Insurance 1,500,00 5 14 6 Account Payable - Pop's Gun Shop 3,295.00 6 15 7 Accounts Payable - Ammo R Us 1,700.00 7 16 8 Jack Black, Capital 14,044.00 8. 9 Jack Black, Drawing 1,750.00 9 10| Income Summary 10 11Sales 8,772.00 11 12 Advertising Expense 1,000.00 12 13 Insurance Expense 13 22 14 Miscellaneous Expense 216.00 14 23 15 Rent Expense 1,000.00 15 24 16 Supplies Expense 16 25 17 Utilities Expense 775.00 17 26 18 Totals 27,811.00 27,811.00 18 27 19 19 28 20 20 29 21 21 30 22 22 31 23 23 32 24 24 33 34 35 36 37 38 39
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage