[go: up one dir, main page]

0% found this document useful (0 votes)
233 views13 pages

Code 4 WITH ANSWER

The document outlines various accounting projects including production budgets, job order cost accounting, and financial statement preparation. It details sales forecasts, production costs, and adjusting entries for a clothing manufacturer and a governmental unit's budget. Specific calculations for gross profit, gross margin ratios, and financial statements are also included.

Uploaded by

accfn881
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
233 views13 pages

Code 4 WITH ANSWER

The document outlines various accounting projects including production budgets, job order cost accounting, and financial statement preparation. It details sales forecasts, production costs, and adjusting entries for a clothing manufacturer and a governmental unit's budget. Specific calculations for gross profit, gross margin ratios, and financial statements are also included.

Uploaded by

accfn881
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 13

Project 1

The following information about Fishplates X has been made available from the accounting records of
payment of Precision Tools Ltd. for the last six months of 2024 (and of only sales for January 2023).

(i) The units to be sold in different months are:

· July: 2,200

·August: 2,200

·September: 3,400

· October:3,800

·November:5,000

·December: 4,600

· January 2025:4,000

(ii) There will be no work-in-progress at the end of any month

(iii) Finished units equal to half the sales for the next month will be in stock at the end of every month
(including June 2024)

(iv) Budgeted production and production costs for the year ending December 2024 are as thus:
· Production units: 44,000

· Direct materials per unit: $10.00

·Direct Wages per unit: $4.00

·Total factory overheads apportioned to the product: $88,000

Required

Prepare:

(a) Production budget for the last six months of 2024

(b) Production cost budget for the same period

Project 2

Accounting In A Job Order Cost Accounting System A clothing manufacturer had the following
transactions in its first month of operations relating to its only job, Job #101.

a) Purchased 500 yards of silk@$8 per yard for cash.

b) Requisitioned 300 yards of silk to produce Job #101.

c) Incurred 50 hours of direct labor to produce Job #101;the average labor rate is $9 per hour.

d) Paid various factory overhead costs, $650.

c) Applied factory overbead at the rate of 150% of direct labor costs to Job #101.

f) Completed Job#101. g) Sold Job#101, receiving cash of $4,400.

INSTRUCTIONS
1.Enter the transactions in the T-accounts below. Assume the opening balance of Cash is $9,000.

2. Determine the ending balance of each account.

3. What was the gross profit eamned on Job#101?

4. What was the gross margin ratio earned on Job#101?

5. If management had expected a gross margin ratio of 20% on Job #101,do you believe the actual
results warrant further investigation by management? Why or why not?

6. Is factory over applied or under applied, and by how much?

PROJECT 4

PROJECT 4
Trial Balance
Debit Credit,
Cash, $ 5,400,
Accounts Receivable ,2,400,
Supplies 2,800,
Prepaid Insurance, 1,300
,Equipment, 60,000,
Notes Payable, $40,000
,Accounts Payable 2,400,
,common stock , 30,000
Drawing, 1,000
Service Revenue 4,900
,Salaries Expense ,3,200
,Utilities Expense, 800
,Advertising Expense 400,
Total $77,300, $77,300,
Additional information
1.Insurance expires at the rate of $200 per month.
2.S1,000 of supplies are on hand at August 31.
3.Monthly depreciation on the equipment is $900.
4.Interest of $500 on the notes payable has accrued during August.

Instructions
(a) Prepare adjusting entries.
(b) Prepare adjusted trial balance.
(c) Prepare balance sheet
(d) Prepare income statement
(e) Prepare closing entry
PROJECT 3

Assume the following are the amounts that have been legally approved as the budget for the general
fund of a curtain governmental unit for the fiscal

Your ending December 31, 2008.

Estimated revenue .

Taxes 882,500

License and Permit _ 195,000

Intergovernmental revenue 200.000

Total 1.277.500

Appropriations

General gov't. 1,150,000

Pbulic Safts 212,000

Total 1362000

Estimated other financin > Uses (Eoru)

Operating transfer out to other funds 274500

Required

Show in general from the entries that would be necessary to record the budget assumes it is legally
approved at the beginning of the year Show the subsidiary ledger as well
ANSWER FOR CODE 4

Project 1: Production and Cost Budgeting

Background:

 Sales forecasts for Jul-Dec 2024 and Jan 2025 are given.
 Ending Finished Goods Inventory policy: 50% of the next month's sales units.
 No Work-in-Progress.
 Costs: DM $10/unit, DL $4/unit, FOH
88,000���44,000�������������(88,000for44,000unitsannually
(

2/unit).

(a) Production Budget (Units) for July - December 2024

The formula for production needs is:


Units to Produce = Budgeted Sales Units + Desired Ending FG Units - Beginning FG Units

+ Desired Ending = Total


Budgeted - Beginning = Units to
Month FG (0.5 * Next Needs
Sales (Units) FG (Units) Produce
Month Sales) (Units)

1,100 (0.5 * 2,200 1,100 (0.5 *


July 2,200 3,300 2,200
Aug) 2,200 Jul)

1,700 (0.5 * 3,400 1,100 (July


August 2,200 3,900 2,800
Sep) End FG)

1,900 (0.5 * 3,800 1,700 (Aug


Sept 3,400 5,300 3,600
Oct) End FG)

2,500 (0.5 * 5,000 1,900 (Sep


October 3,800 6,300 4,400
Nov) End FG)

2,300 (0.5 * 4,600 2,500 (Oct


Nov 5,000 7,300 4,800
Dec) End FG)

2,000 (0.5 * 4,000 2,300 (Nov


Dec 4,600 6,600 4,300
Jan) End FG)

Total 21,200 22,100

(b) Production Cost Budget for July - December 2024


 Variable Costs per unit:
o Direct Materials: $10.00
o Direct Wages: $4.00
 Fixed Cost Allocation per unit (based on annual budget):
o Factory Overheads: $88,000 / 44,000 units = $2.00
 Total Production Cost per Unit: $10.00 + $4.00 + $2.00 = $16.00

Direct Direct Factory Total


Units to
Month Materials Wages Overheads Production
Produce
(@$10) (@$4) (@$2) Cost

July 2,200 $22,000 $8,800 $4,400 $35,200

August 2,800 $28,000 $11,200 $5,600 $44,800

Sept 3,600 $36,000 $14,400 $7,200 $57,600

October 4,400 $44,000 $17,600 $8,800 $70,400

Nov 4,800 $48,000 $19,200 $9,600 $76,800

Dec 4,300 $43,000 $17,200 $8,600 $68,800

Total 22,100 $221,000 $88,400 $44,200 $353,600

Project 2: Job Order Cost Accounting System

1 & 2. T-Accounts and Ending Balances

Cash Raw Materials Inventory


------------------------- -------------------------
Beg Bal | 9,000 | 4,000 (a) (a) 4,000 | 2,400 (b)
(g) | 4,400 | 650 (d) ---------|---------
| | End Bal | 1,600
--------|-------
End Bal | 8,750 |

Work In Process (Job 101) Factory MOH Control


------------------------- -------------------------
(b) DM | 2,400 | 3,525 (f) (d) 650 |
(c) DL | 450 | -------|-------
(e) MOH | 675 | End Bal| 650
| |
--------|-------
End Bal | 0 |

Applied Factory MOH Finished Goods Inventory


------------------------- -------------------------
| 675 (e) (f) 3,525 | 3,525 (g)
--------|------- ---------|---------
| 675 End Bal End Bal | 0

Cost of Goods Sold Sales Revenue


------------------------- -------------------------
(g) 3,525 | | 4,400 (g)
-------|------- -------|-------
End Bal| 3,525 | 4,400 End Bal

Wages Payable*
-------------------------
| 450 (c)
--------|-------
| 450 End Bal
(*Assuming direct labor was credited to Wages Payable and not yet paid)

3. Gross Profit on Job #101


 Gross Profit = Sales Revenue - Cost of Goods Sold
 Gross Profit = $4,400 -
3,525=∗∗3,525=∗∗

875**

4. Gross Margin Ratio on Job #101

 Gross Margin Ratio = Gross Profit / Sales Revenue


 Gross Margin Ratio = $875 / $4,400 = 0.19886... ≈ 19.89%

5. Analysis of Gross Margin Ratio

 The actual gross margin ratio (19.89%) is very close to the expected ratio (20%).
 Conclusion: No, the actual results likely do not warrant further investigation solely based on
this variance. The difference is minimal (0.11%) and could be due to normal minor
fluctuations in costs or rounding. Management attention is usually focused on more
significant deviations from expectations.

6. Factory Overhead Applied/Underapplied

 Actual MOH (MOH Control) = $650


 Applied MOH = $675
 Since Applied MOH (
675)>���������(675)>ActualMOH(

650), factory overhead is Overapplied.

 Amount Overapplied = $675 -


650=∗∗650=∗∗

25**

PROJECT 4: Adjusting Entries and Financial Statements

(a) Adjusting Entries (August 31)

1. Insurance Expense:
o Dr. Insurance Expense 200
o Cr. Prepaid Insurance 200
o (To record insurance expired during August)
2. Supplies Expense:
o Supplies Used = Beginning Supplies - Supplies on Hand
o Supplies Used = $2,800 - $1,000 = $1,800
o Dr. Supplies Expense 1,800
o Cr. Supplies 1,800
o (To record supplies used during August)
3. Depreciation Expense:
o Dr. Depreciation Expense - Equipment 900
o Cr. Accumulated Depreciation - Equipment 900
o (To record monthly depreciation on equipment)
4. Interest Expense:
o Dr. Interest Expense 500
o Cr. Interest Payable 500
o (To record interest accrued on notes payable)

(b) Adjusted Trial Balance (August 31)

Account Unadjuste Unadjuste Adjustment Adjustment Adjuste Adjuste


Title d TB Dr d TB Cr s Dr s Cr d TB Dr d TB Cr

Cash 5,400 5,400

Accounts
2,400 2,400
Receivable

Supplies 2,800 1,800 1,000

Prepaid
1,300 200 1,100
Insurance

Equipment 60,000 60,000

Accumulate
d
900 900
Depreciatio
n - Equip.

Notes
40,000 40,000
Payable

Accounts
2,400 2,400
Payable

Interest
500 500
Payable

Common
30,000 30,000
Stock

Drawing 1,000 1,000

Service
4,900 4,900
Revenue

Salaries
3,200 3,200
Expense

Utilities
800 800
Expense

Advertising 400 400


Expense

Insurance
200 200
Expense

Supplies
1,800 1,800
Expense

Depreciatio
n Expense - 900 900
Equipment

Interest
500 500
Expense

Totals $77,300 $77,300 $3,400 $3,400 $78,700 $78,700

(d) Income Statement

[Company Name]
Income Statement
For the Month Ended August 31

Amount ($)

Revenue

Service Revenue 4,900

Expenses

Salaries Expense 3,200

Supplies Expense 1,800

Depreciation Expense - Equipment 900

Utilities Expense 800

Interest Expense 500

Advertising Expense 400

Insurance Expense 200

Total Expenses 7,800

Net Loss (2,900)


(c) Balance Sheet

[Company Name]
Balance Sheet
August 31

Assets Amount ($) Liabilities & Equity Amount ($)

Current Assets Current Liabilities

Cash 5,400 Accounts Payable 2,400

Accounts Receivable 2,400 Interest Payable 500

Supplies 1,000 Notes Payable (Current)* 40,000

Prepaid Insurance 1,100 Total Current Liabilities 42,900

Total Current Assets 9,900

Non-Current Liabilities

Property, Plant & Equipment Notes Payable (Non-Current)* -

Equipment 60,000 Total Liabilities 42,900

Less: Accumulated Depreciation (900)

Net Property, Plant & Equipment 59,100 Equity

Common Stock 30,000

Retained Earnings** (3,900)

Total Equity 26,100

Total Assets 69,000 Total Liabilities & Equity 69,000

* Notes Payable classified as Current assuming due within one year. Adjust if info differs.
** Retained Earnings = Beginning RE (assume $0) + Net Income/(Loss) - Drawings
RE = 0 + (-2,900) - 1,000 = -3,900

(e) Closing Entries (August 31)

1. Close Revenue to Income Summary:


o Dr. Service Revenue 4,900
o Cr. Income Summary 4,900
2. Close Expenses to Income Summary:
o Dr. Income Summary 7,800
o Cr. Salaries Expense 3,200
o Cr. Supplies Expense 1,800
o Cr. Depreciation Expense - Equipment 900
o Cr. Utilities Expense 800
o Cr. Interest Expense 500
o Cr. Advertising Expense 400
o Cr. Insurance Expense 200
3. Close Income Summary to Retained Earnings (Net Loss):
o Dr. Retained Earnings 2,900
o Cr. Income Summary 2,900
o (Income Summary balance: 4,900 Cr - 7,800 Dr = 2,900 Dr balance before closing)
4. Close Drawings to Retained Earnings:
o Dr. Retained Earnings 1,000
o Cr. Drawing 1,000

PROJECT 3: Government Budgetary Accounting

Background: Budget approved for General Fund.

 Estimated Revenues: $1,277,500 (Taxes $882.5k, L&P $195k, Intergov $200k)


 Appropriations: $1,362,000 (Gen Gov't $1,150k, Public Safety $212k)
 Estimated Other Financing Uses (EOFU): $274,500 (Op. Transfer Out)

Required: Record the budget in general journal form, including subsidiary ledger detail.

1. Calculate Budgetary Fund Balance:

 Budgetary Fund Balance = Est. Revenues - Appropriations - EOFU


 Budgetary Fund Balance = $1,277,500 - $1,362,000 -
274,500=−274,500=−

359,000 (Budgetary Deficit)

2. General Ledger Entry to Record Budget:

Date Account Title & Explanation Debit Credit

Jan 1* Estimated Revenues Control 1,277,500


Budgetary Fund Balance 359,000

Appropriations Control 1,362,000

Estimated Other Financing Uses Control 274,500

(To record the legally adopted budget)

Assuming budget adopted at the beginning of the year.

3. Subsidiary Ledger Detail:

 Estimated Revenues Subsidiary Ledger:


o Taxes: Dr. $882,500
o Licenses and Permits: Dr. $195,000
o Intergovernmental Revenue: Dr. $200,000
o (Total Debits = $1,277,500, equals control account debit)
 Appropriations Subsidiary Ledger:
o General Government: Cr. $1,150,000
o Public Safety: Cr. $212,000
o (Total Credits = $1,362,000, equals control account credit)
 Estimated Other Financing Uses Subsidiary Ledger:
o Operating Transfers Out: Cr. $274,500
o (Total Credits = $274,500, equals control account credit)

You might also like