Schedule Of Cost Of Goods Manufactured
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Schedule Of Cost Of Goods Manufactured as PDF for free.
More details
- Words: 1,629
- Pages: 21
Account # 1000 1100 1110 1120 1130
Account Name ASSETS Current Assets CASH - Petty Cash CASH - Operating Account Central Bank
1200 1250
RECEIVABLES Account Receivables
1300 1310 1320 1330 1340 1350 1360 1370 1380 1390
INVENTORIES Raw Materials Inventory Work in Progress Inventory Finished Goods Inventory Indirect Materials Inventory Other Products Inventory Office Inventory Finished Goods Inventory - Product 1 Finished Goods Inventory - Product 2 Finished Goods Inventory - Product 3
1400 1410 1420
PREPAID EXPENSES and OTHER CURRENT ASSETS PREPAID - Insurance PREPAID - Rent
1500 1510 1520 1530 1540 1550
FIXED ASSETS PPE - Computer Equipment PPE - Machinery and Equipment PPE - Furniture and Fixtures PPE - Vehicles PPE - Leasehold Improvements
1600 1610 1620 1630 1640
ACCUMULATED DEPRECIATION and AMORTIZATION ACCUM DEPR - Computer Equipment ACCUM DEPR - Machinery and Equipment ACCUM DEPR - Furniture and Fixtures ACCUM DEPR - Vehicles
2000
LIABILITIES
2100 2110 2120 2130 2140
PAYABLES A/P - Trade Unearned Revenue VAT - Input VAT - Output
2700
DEBTS
2710 2720
Central Bank Long Term Debts Financial Company Short Term Debts
3000 3100 3200 3300 3400
OWNER'S EQUITIES Owner's Capital Retained Earnings Current Earnings Owner's Withdrawal
4000 4100 4101 4102 4103 4200 4201 4202 4203 4300 4301 4302 4303
REVENUE REVENUE - All Products REVENUE - Product 1 REVENUE - Product 2 REVENUE - Product 3 Sales Discounts - All Products Sales Discounts - Product 1 Sales Discounts - Product 2 Sales Discounts - Product 3 Sales Returns and Allowances - All Products Sales Returns and Allowances - Product 1 Sales Returns and Allowances - Product 2 Sales Returns and Allowances - Product 3
5000 5100 5110 5120 5200 5210 5211 5212 5213 5250 5260 5300 5400 5410 5420 5430 5440 5450 5460 5470 5500 5600 5700
COST of GOODS SOLD COGS - Finished Goods Product COGS - Purchase Finished Goods Product COGS - Manufactured Finished Goods Product COGS - Raw Materials COGS - Purchase - Raw Materials COGS - Purchase - Raw Material 1 COGS - Purchase - Raw Material 2 COGS - Purchase - Raw Material 3 COGS - Work in Progress COGS - Work in Progress Material Received COGS - Direct Labor Cost COGS - Indirect Labor Cost COGS - Indirect Material Cost COGS - Salaries and Wages COGS - Compensation COGS - Water COGS - Electricity COGS - Depreciation COGS - Other COGS - Purchase Returns and Allowances COGS - Purchase Discounts COGS - Other Products
6000 6100 6110 6120 6130 6140 6150 6160 6170 6180 6190
OPERATING EXPENSES EXP - Salaries EXP - Administration EXP - Electricity, Water, Phone EXP - Rent EXP - Insurance EXP - Repair and Maintenance EXP - Office Supplies EXP - Depreciation Equipment EXP - Depreciation Vehicles EXP - Other
7000 7100
OTHER INCOME Finance Charge Income
8000 8100 8200
OTHER EXPENSES EXP - Interests EXP - Bank Charges
SCHEDULE OF COST OF GOODS MANUFACTURED 0 1 1 2 3 4 4 4 4 4 4 4 4 4 4 4 5 6 7 8 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 ### ### ### ### ### ### ###
CoA
Account Name INVENTORY - DIRECT MATERIAL
5210 5600
Beginning of Inventory - Raw Materials COGS - Purchase - Raw Materials COGS - Purchase Discounts
5300
Total Raw Materials Ending Inventory - Raw Materials Total Direct Materials DIRECT LABOR COGS - Direct Labor Cost
1,000.00 2,000.00 (200.00)
2,800.00 2,000.00 800.00 1,000.00
Total Direct Labor FACTORY OVERHEAD 5400 5410 5420 5430
COGS - Indirect Labor Cost COGS - Indirect Material Cost COGS - Salaries and Wages COGS - Compensation
1,000.00
500.00 500.00 500.00 300.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
5440 5450 5460 5470
COGS - Water COGS - Electricity COGS - Depreciation COGS - Other
Total Factory Overhead TOTAL MANUFACTURING COST INVENTORY - WORK IN PROGRESS Beginning of Inventory - Work in Progress Total Work in Progress Ending Inventory - Work in Progress COST of GOODS MANUFACTURED © 2018 - Excelindo.com
50.00 100.00 150.00
2,100.00 3,900.00 1,000.00 4,900.00 1,500.00 3,400.00
EXCELINDO COMPANY INC SCHEDULE OF COST OF GOODS MANUFACTURED For the Year Ended MM/DD/YYYY INVENTORY - DIRECT MATERIAL Beginning of Inventory - Raw Materials
1,000.00
COGS - Purchase - Raw Materials
2,000.00
COGS - Purchase Discounts
(200.00)
Total Raw Materials Ending Inventory - Raw Materials
2,800.00 2,000.00
Total Direct Materials
800.00
DIRECT LABOR COGS - Direct Labor Cost
1,000.00
Total Direct Labor
1,000.00
FACTORY OVERHEAD COGS - Indirect Labor Cost
500.00
COGS - Indirect Material Cost
500.00
COGS - Salaries and Wages
500.00
COGS - Compensation
300.00
COGS - Water
50.00
COGS - Electricity
100.00
COGS - Depreciation
150.00
COGS - Other
0.00
Total Factory Overhead
2,100.00
TOTAL MANUFACTURING COST
3,900.00
INVENTORY - WORK IN PROGRESS Beginning of Inventory - Work in Progress
1,000.00
Total Work in Progress Ending Inventory - Work in Progress COST of GOODS MANUFACTURED
4,900.00 1,500.00 3,400.00
EXCELINDO COMPANY INC SCHEDULE OF COST OF GOODS MANUFACTURED For the Year Ended MM/DD/YYYY INVENTORY - DIRECT MATERIAL Beginning of Inventory - Raw Materials
5,000.00
COGS - Purchase - Raw Materials
3,105.00
Total Raw Materials Ending Inventory - Raw Materials
8,105.00 1,000.00
Total Direct Materials
7,105.00
DIRECT LABOR COGS - Direct Labor Cost
59.25
Total Direct Labor
59.25
FACTORY OVERHEAD COGS - Indirect Labor Cost
0.00
COGS - Indirect Material Cost
0.00
COGS - Salaries and Wages
0.00
COGS - Compensation
0.00
COGS - Water
0.00
COGS - Electricity
0.00
COGS - Depreciation
0.00
COGS - Other
0.00
Total Factory Overhead TOTAL MANUFACTURING COST
8,105.00
INVENTORY - WORK IN PROGRESS Beginning of Inventory - Work in Progress
5,000.00
Total Work in Progress Ending Inventory - Work in Progress COST of GOODS MANUFACTURED
13,105.00 3,000.00 10,105.00
INTEGRATED ACCOUNTING SYSTEM for MANUFACTURING COMPAN
Product Info www.excelindo.com/finance-and-accounting/accounting-system-for-manufacturing-com
If you decide to purchase it, you can use the paypal button in its product page or below
USD 28.99 FEATURES 1
2
3
4
5
6
7
8
9
10
11
12
13
© 2017 - Excelindo.com
YSTEM for MANUFACTURING COMPANY
You may try individual templates below where they are part of integrated Accounting System for Manufacturing Company spreadsheet. They are can be downloaded from its product page.
ounting/accounting-system-for-manufacturing-company.html
use the paypal button in its product page or below
Home Panel All tables are linked in this home panel. It should ease you accessing all tables by clicking respective buttons. All buttons are arranged like flow chart that should remind you on the next task to do. Integrated data entry and report. This spreadsheet is equipped with formulas where all entries will be processed and calculated to yield financial reports that should be useful to analyze your company's performance. Simple Journal Entry System There are one general journal and four special journals that will help you recording all transaction activities daily. They are all have similar formats. You just need to entry data in respective journals and make them balance (remember that this accounting spreadsheet is using a double entry bookkeeping method). *Notes : You may need accounting knowledge to entry financial data properly
> > > > > > > >
Automatic General Ledger You don't have to type anything in this General Ledger worksheet. You can monitor debit and credit of respective accounts by selecting its Chart of Accounts number and see its summary.
Customized Balance Sheet Report You can set which company account you want to be shown in Balance Sheet report. And respective values will be calculated and shown automatically. All data will be calculated from Journal entries.
*Monthly Report is available
Customized Profit and Loss Report Similar with balance sheet, you can set which company account you want to see in Profit and Loss report. And respectie values will be calculated and shown automatically based on Journal entries.
*Monthly Report is available
Customized Cash Flow Report You can choose which method you want to use on presenting Cash Flow report. There are two methods, Direct and Indirect Method. Set the accounts you want to see in both methods and respective values will be shown.
*Monthly Report is available
Schedule of Cost of Goods Manufactured Report You can summarize and create specific report of your factory. The formula will filter respective factory accounts and you can have your report with Cost of Goods Manufactured calculated automatically.
Automatic Depreciation Calculator
There is a formula to calculate depreciation of your company assets automatically. You can put all of your assets that have different purchasing dates and usage period within one table. It should ease you on getting the values to be put on respective journals and reports. It uses a common Straight Line method to depreciate all of your assets.
Fully Unprotected Different company requires different accounting report format. You can tweak the formulas, add more worksheets, add charts and modify all layouts to suit your company's financial report policy and style. *Notes : You may need basic knowledge of accounting and excel to modify this spreadsheet Compatibility across Excel version and Operating System You can use this spreadsheet with Excel 2010 for Windows and above and Excel 2008 for Mac and above without having incompatibility issues Multi User License (within one Company) Any employees are allowed to use this spreadsheet as long as they are working within one company One time payment only You can use it every year without additional cost
You may try individual templates below where they are part of integrated Accounting System for Manufacturing Company spreadsheet. They are can be downloaded from its product page. General Journal Special Journal (Cash, Purchase, Sales and Adjusting Journals) General Ledger Balance Sheet Profit and Loss Statement Cash Flow Report Equity Report Schedule of Cost of Goods Manufactured Report
HOW TO PURCHASE
Account Name ASSETS Current Assets CASH - Petty Cash CASH - Operating Account Central Bank
1200 1250
RECEIVABLES Account Receivables
1300 1310 1320 1330 1340 1350 1360 1370 1380 1390
INVENTORIES Raw Materials Inventory Work in Progress Inventory Finished Goods Inventory Indirect Materials Inventory Other Products Inventory Office Inventory Finished Goods Inventory - Product 1 Finished Goods Inventory - Product 2 Finished Goods Inventory - Product 3
1400 1410 1420
PREPAID EXPENSES and OTHER CURRENT ASSETS PREPAID - Insurance PREPAID - Rent
1500 1510 1520 1530 1540 1550
FIXED ASSETS PPE - Computer Equipment PPE - Machinery and Equipment PPE - Furniture and Fixtures PPE - Vehicles PPE - Leasehold Improvements
1600 1610 1620 1630 1640
ACCUMULATED DEPRECIATION and AMORTIZATION ACCUM DEPR - Computer Equipment ACCUM DEPR - Machinery and Equipment ACCUM DEPR - Furniture and Fixtures ACCUM DEPR - Vehicles
2000
LIABILITIES
2100 2110 2120 2130 2140
PAYABLES A/P - Trade Unearned Revenue VAT - Input VAT - Output
2700
DEBTS
2710 2720
Central Bank Long Term Debts Financial Company Short Term Debts
3000 3100 3200 3300 3400
OWNER'S EQUITIES Owner's Capital Retained Earnings Current Earnings Owner's Withdrawal
4000 4100 4101 4102 4103 4200 4201 4202 4203 4300 4301 4302 4303
REVENUE REVENUE - All Products REVENUE - Product 1 REVENUE - Product 2 REVENUE - Product 3 Sales Discounts - All Products Sales Discounts - Product 1 Sales Discounts - Product 2 Sales Discounts - Product 3 Sales Returns and Allowances - All Products Sales Returns and Allowances - Product 1 Sales Returns and Allowances - Product 2 Sales Returns and Allowances - Product 3
5000 5100 5110 5120 5200 5210 5211 5212 5213 5250 5260 5300 5400 5410 5420 5430 5440 5450 5460 5470 5500 5600 5700
COST of GOODS SOLD COGS - Finished Goods Product COGS - Purchase Finished Goods Product COGS - Manufactured Finished Goods Product COGS - Raw Materials COGS - Purchase - Raw Materials COGS - Purchase - Raw Material 1 COGS - Purchase - Raw Material 2 COGS - Purchase - Raw Material 3 COGS - Work in Progress COGS - Work in Progress Material Received COGS - Direct Labor Cost COGS - Indirect Labor Cost COGS - Indirect Material Cost COGS - Salaries and Wages COGS - Compensation COGS - Water COGS - Electricity COGS - Depreciation COGS - Other COGS - Purchase Returns and Allowances COGS - Purchase Discounts COGS - Other Products
6000 6100 6110 6120 6130 6140 6150 6160 6170 6180 6190
OPERATING EXPENSES EXP - Salaries EXP - Administration EXP - Electricity, Water, Phone EXP - Rent EXP - Insurance EXP - Repair and Maintenance EXP - Office Supplies EXP - Depreciation Equipment EXP - Depreciation Vehicles EXP - Other
7000 7100
OTHER INCOME Finance Charge Income
8000 8100 8200
OTHER EXPENSES EXP - Interests EXP - Bank Charges
SCHEDULE OF COST OF GOODS MANUFACTURED 0 1 1 2 3 4 4 4 4 4 4 4 4 4 4 4 5 6 7 8 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 ### ### ### ### ### ### ###
CoA
Account Name INVENTORY - DIRECT MATERIAL
5210 5600
Beginning of Inventory - Raw Materials COGS - Purchase - Raw Materials COGS - Purchase Discounts
5300
Total Raw Materials Ending Inventory - Raw Materials Total Direct Materials DIRECT LABOR COGS - Direct Labor Cost
1,000.00 2,000.00 (200.00)
2,800.00 2,000.00 800.00 1,000.00
Total Direct Labor FACTORY OVERHEAD 5400 5410 5420 5430
COGS - Indirect Labor Cost COGS - Indirect Material Cost COGS - Salaries and Wages COGS - Compensation
1,000.00
500.00 500.00 500.00 300.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
5440 5450 5460 5470
COGS - Water COGS - Electricity COGS - Depreciation COGS - Other
Total Factory Overhead TOTAL MANUFACTURING COST INVENTORY - WORK IN PROGRESS Beginning of Inventory - Work in Progress Total Work in Progress Ending Inventory - Work in Progress COST of GOODS MANUFACTURED © 2018 - Excelindo.com
50.00 100.00 150.00
2,100.00 3,900.00 1,000.00 4,900.00 1,500.00 3,400.00
EXCELINDO COMPANY INC SCHEDULE OF COST OF GOODS MANUFACTURED For the Year Ended MM/DD/YYYY INVENTORY - DIRECT MATERIAL Beginning of Inventory - Raw Materials
1,000.00
COGS - Purchase - Raw Materials
2,000.00
COGS - Purchase Discounts
(200.00)
Total Raw Materials Ending Inventory - Raw Materials
2,800.00 2,000.00
Total Direct Materials
800.00
DIRECT LABOR COGS - Direct Labor Cost
1,000.00
Total Direct Labor
1,000.00
FACTORY OVERHEAD COGS - Indirect Labor Cost
500.00
COGS - Indirect Material Cost
500.00
COGS - Salaries and Wages
500.00
COGS - Compensation
300.00
COGS - Water
50.00
COGS - Electricity
100.00
COGS - Depreciation
150.00
COGS - Other
0.00
Total Factory Overhead
2,100.00
TOTAL MANUFACTURING COST
3,900.00
INVENTORY - WORK IN PROGRESS Beginning of Inventory - Work in Progress
1,000.00
Total Work in Progress Ending Inventory - Work in Progress COST of GOODS MANUFACTURED
4,900.00 1,500.00 3,400.00
EXCELINDO COMPANY INC SCHEDULE OF COST OF GOODS MANUFACTURED For the Year Ended MM/DD/YYYY INVENTORY - DIRECT MATERIAL Beginning of Inventory - Raw Materials
5,000.00
COGS - Purchase - Raw Materials
3,105.00
Total Raw Materials Ending Inventory - Raw Materials
8,105.00 1,000.00
Total Direct Materials
7,105.00
DIRECT LABOR COGS - Direct Labor Cost
59.25
Total Direct Labor
59.25
FACTORY OVERHEAD COGS - Indirect Labor Cost
0.00
COGS - Indirect Material Cost
0.00
COGS - Salaries and Wages
0.00
COGS - Compensation
0.00
COGS - Water
0.00
COGS - Electricity
0.00
COGS - Depreciation
0.00
COGS - Other
0.00
Total Factory Overhead TOTAL MANUFACTURING COST
8,105.00
INVENTORY - WORK IN PROGRESS Beginning of Inventory - Work in Progress
5,000.00
Total Work in Progress Ending Inventory - Work in Progress COST of GOODS MANUFACTURED
13,105.00 3,000.00 10,105.00
INTEGRATED ACCOUNTING SYSTEM for MANUFACTURING COMPAN
Product Info www.excelindo.com/finance-and-accounting/accounting-system-for-manufacturing-com
If you decide to purchase it, you can use the paypal button in its product page or below
USD 28.99 FEATURES 1
2
3
4
5
6
7
8
9
10
11
12
13
© 2017 - Excelindo.com
YSTEM for MANUFACTURING COMPANY
You may try individual templates below where they are part of integrated Accounting System for Manufacturing Company spreadsheet. They are can be downloaded from its product page.
ounting/accounting-system-for-manufacturing-company.html
use the paypal button in its product page or below
Home Panel All tables are linked in this home panel. It should ease you accessing all tables by clicking respective buttons. All buttons are arranged like flow chart that should remind you on the next task to do. Integrated data entry and report. This spreadsheet is equipped with formulas where all entries will be processed and calculated to yield financial reports that should be useful to analyze your company's performance. Simple Journal Entry System There are one general journal and four special journals that will help you recording all transaction activities daily. They are all have similar formats. You just need to entry data in respective journals and make them balance (remember that this accounting spreadsheet is using a double entry bookkeeping method). *Notes : You may need accounting knowledge to entry financial data properly
> > > > > > > >
Automatic General Ledger You don't have to type anything in this General Ledger worksheet. You can monitor debit and credit of respective accounts by selecting its Chart of Accounts number and see its summary.
Customized Balance Sheet Report You can set which company account you want to be shown in Balance Sheet report. And respective values will be calculated and shown automatically. All data will be calculated from Journal entries.
*Monthly Report is available
Customized Profit and Loss Report Similar with balance sheet, you can set which company account you want to see in Profit and Loss report. And respectie values will be calculated and shown automatically based on Journal entries.
*Monthly Report is available
Customized Cash Flow Report You can choose which method you want to use on presenting Cash Flow report. There are two methods, Direct and Indirect Method. Set the accounts you want to see in both methods and respective values will be shown.
*Monthly Report is available
Schedule of Cost of Goods Manufactured Report You can summarize and create specific report of your factory. The formula will filter respective factory accounts and you can have your report with Cost of Goods Manufactured calculated automatically.
Automatic Depreciation Calculator
There is a formula to calculate depreciation of your company assets automatically. You can put all of your assets that have different purchasing dates and usage period within one table. It should ease you on getting the values to be put on respective journals and reports. It uses a common Straight Line method to depreciate all of your assets.
Fully Unprotected Different company requires different accounting report format. You can tweak the formulas, add more worksheets, add charts and modify all layouts to suit your company's financial report policy and style. *Notes : You may need basic knowledge of accounting and excel to modify this spreadsheet Compatibility across Excel version and Operating System You can use this spreadsheet with Excel 2010 for Windows and above and Excel 2008 for Mac and above without having incompatibility issues Multi User License (within one Company) Any employees are allowed to use this spreadsheet as long as they are working within one company One time payment only You can use it every year without additional cost
You may try individual templates below where they are part of integrated Accounting System for Manufacturing Company spreadsheet. They are can be downloaded from its product page. General Journal Special Journal (Cash, Purchase, Sales and Adjusting Journals) General Ledger Balance Sheet Profit and Loss Statement Cash Flow Report Equity Report Schedule of Cost of Goods Manufactured Report
HOW TO PURCHASE
Related Documents
Cost Of Goods Manufactured Schedule
June 2020 18
Schedule Of Cost Of Goods Manufactured
August 2019 26
Cost Of Goods Sold Statement
June 2020 10
Reducing Cost Of Goods Sold
November 2019 13
Cost Of Goods Old Transport Operating Exp
November 2019 17
Sale Of Goods Act
July 2020 16More Documents from ""