0% found this document useful (0 votes)
17 views7 pages

Manufacturing Cost Analysis Report

Uploaded by

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

Manufacturing Cost Analysis Report

Uploaded by

limasrynyyn
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Dr Cr

1 Raw materials inventory 164,000.00


Accounts payable 164,000.00

2 Work in process inventory 134,000.00


Variable overhead control 46,000.00
Raw materials inventory 180,000.00

3 Work in process inventory 62,000.00


Fixed overhead control 26,000.00
Salaries payable 88,000.00

4 Variable overhead control 5,400.00


Fixed overhead control 1,600.00
Utilities payable 7,000.00

5 Fixed overhead control 2,000.00


Property taxes payable 2,000.00

6 Fixed overhead control 1,600.00


Prepaid insurance 1,600.00

7 Fixed overhead control 40,000.00


Accumulated depreciation- factory equipment 40,000.00

8 Work in process inventory 76,600.00


Variable overhead control 5,400.00
Fixed overhead control 71,200.00

9 Finished goods inventory 320,000.00


Work in process inventory 320,000.00

10 Accounts receivable 550,000.00


Cash 150,000.00
Sales 700,000.00

11 Cost of goods sold 330,000.00


Finished goods inventory 330,000.00

12 Selling and Admin expense 280,000.00


Various accounts 280,000.00
Schedule: Cost of goods manufactured

Raw materials, beg 20,300.00


Purchases 164,000.00
Raw materials available for use 184,300.00
Raw materials, end - 4,300.00
Raw materials used 180,000.00
Indirect materials issued - 46,000.00
Direc materials issued/ used 134,000.00

Direct labor 62,000.00


Factory overhead
-VO raw materials 46,000.00
-FO Indirect labor 26,000.00
-VO utilities 5,400.00
-FO utilities 1,600.00
-FO taxes 2,000.00
-FO insurance 1,600.00
-FO Depreciation - equipment 40,000.00
Total Overhead 122,600.00

Total Manufacturing cost 318,600.00


Add: WIP beg 7,000.00
Less: WIP, end 5,600.00
Total cost of goods manufactured 320,000.00

Income statement

Sales 700,000.00
Cost of goods sold

Finished goods, beg 18,000.00


Total cost of goods manufactured 320,000.00
Total goods available for sale 338,000.00
Less: Finished goods, end 8,000.00
Total cost of goods sold 330,000.00

Gross profit 370,000.00


Selling and admin expense 280,000.00
Net income 90,000.00
Raw materials inventory During discussion we used direct materials GL
beg 20,300.00
purchases 164,000.00
180,000.00 beg
purchases
4,300.00

WIP inventory
beg 7,000.00
DM 134,000.00 Direct materials, beg
DL 62,000.00 Purchases
FO 122,600.00 Direct materials available for use
320,000.00 Direct materials, end
5,600.00 Direct materials used

FG inventory
beg 18,000.00
320,000.00

330,000.00

8,000.00
sed direct materials GL

Direct materials inventory


20,300.00
164,000.00
134,000.00

50,300.00

20,300.00
164,000.00
184,300.00
50,300.00
134,000.00 same results different method

Common questions

Powered by AI

Reconciling accounts receivable ($550,000) and cash ($150,000) in sales ensures accurate revenue recognition and cash flow analysis. This distinction separates credit transactions from cash sales, aiding in financial visibility and liquidity management, and reflects actual customer payment activities, crucial for financial planning and ensuring sustainable operations .

Work in Process (WIP) inventory adjustments reflect the costs that have been capitalized for unfinished goods in the production process. This includes the costs for direct materials, direct labor, and overhead applied during the period. For instance, $134,000 from direct materials and $62,000 from direct labor contributed to the WIP inventory, critical in determining the cost flow and valuation of inventory .

The accounting system captures transitions by initially debiting Raw Materials Inventory upon purchase, crediting Work in Process Inventory as they move into production, and finally crediting Finished Goods Inventory upon completion. This document displays these transitions through journal entries like the movement from Raw Materials Inventory ($180,000) to WIP ($134,000) and then to Finished Goods ($320,000), which is crucial for inventory valuation and cost tracking throughout production .

Beginning and ending inventory levels critically influence the Cost of Goods Sold and, ultimately, the net income. For example, Finished Goods Inventory beginning at $18,000 and ending at $8,000 demonstrate inventory cost absorbed in sales calculation. A correct evaluation helps determine true sales cost, which when subtracted from total sales, leaves a gross profit of $370,000, leading to a net income of $90,000 after accounting for selling and administrative expenses .

Selling and administrative expenses, totaling $280,000, directly reduce the gross profit of $370,000, leading to a net income of $90,000. These expenses encompass costs not directly tied to product manufacturing but essential for operating, significantly affecting operating margins and net income, indicating the company’s efficiency in managing overhead costs unrelated to production .

Depreciation of factory equipment is accounted as a non-cash fixed overhead cost, recorded as a debit to Fixed Overhead Control ($40,000) and a credit to Accumulated Depreciation. This allocation spreads the cost of the equipment over its useful life, contributing to the accurate representation of long-term asset costs in financial statements and influencing total overhead .

The acquisition of raw materials is recorded by debiting Raw Materials Inventory and crediting Accounts Payable, which increases the amount payable by $164,000, indicating an increase in the company's liabilities .

Direct materials used are determined by adjusting the beginning raw materials inventory with the purchases during the period and subtracting the ending inventory, resulting in $134,000. This amount is crucial in the computation of total manufacturing costs as it represents the direct material costs incurred for goods produced in the period .

The Cost of Goods Manufactured schedule aggregates all production costs incurred during the period, detailing direct materials, labor, and overheads involved, leading to a calculated total manufacturing cost of $318,600 and a total cost of goods manufactured of $320,000. This schedule serves as a bridge to determining the Cost of Goods Sold on the income statement, ensuring accurate financial representation of inventory flows .

Overhead costs are allocated into variable and fixed categories, affecting total manufacturing costs by shifting some of these overhead expenditures into the product costs. For example, variable overhead includes $46,000 from raw materials and $5,400 from utilities, while fixed overhead includes expenses like indirect labor and depreciation. These figures, combined with other direct manufacturing costs, result in a comprehensive total manufacturing cost of $318,600, influencing the product's manufacturing cost assessment .

You might also like