$2,392,760) Total 500,000 000,000 00,000 Actual Results for Fiscal 2020 Net Revereins Cosmetic Eoad $10.000.000 $1,000 DOO $300.000 Direct Labour Cantins 52.000.000 SR 500,000 $5.500 DO of Assembly Labour Hours 75,000 175.000 250.000 30.000 of Fabrication Machine Hours 200.000 175.000 57.000 of Machines sold 40 100 10 of Machines Produced 70 120 1:90 Inpection Hours 420 2,160 2.589 Factory Area vied (mere) 11,250 22.800 34.050 Results for the year anded Aug 1, 2020 Revenue $12,000,000 $2.000.000 Discount 34,000,000 1,200,000 2.200,000 0.400,000 Neve $10.200.000 $8,400,000 $4,600,000 Material purchased Anting dal 7.19.02.13 2372.000 5.900 Cart Head Office Ulty Cost Production 30.000 Admiteres Inspection Costa 76,000 100 Factory imance Sales como 90.000 Inresten besserede in Manager Omar, Ann Ted 120,000 each Property Head Office Factory Building Amersion Office supplies Could Postage 7,260 Annual Beness and Fees 2.500 Warranty Program te Amortation pense-Fabricationem 650,000 Amortation Experise-Office Equipment 12.000 Bubtity insurance 10.000 Telephone Costs Factory 3.000 Telephone Costs Head Office 6.000 Anna Mee Rent $15.000 Labour Ambly workers 2.000.00 3.500.000 S.M.000 Labour Production supervisor 600.000 Total Experts 32,932,760 Net income Los 152.110 Current Tere End Balance Connets Raw Materiale $1.500.000 $3,000,000 $4.500.000 Corts Machines unfinished at year end 1.000.000 3,000,000 4,000,000 Conto- Machines complete but not ald 3.000.000 5.000.000 9,000,000 Last Year Ende Raw Materials 1,000,000 2.000.000 3.000.000 Costs Machines unfinished we year end 2.500.000 5.000.000 7.500.000 Costs Machines complete but not sold $500,000 $1,500,000 $2.000.000 Se. Details of Proposed Customer Order Direct Materials $225,000 Direct Labour $57.000 Expected of Fabrication Machine Hours 5.642 Question: Using the concepts of ABC costing, calculate the resulting total cost and gross margins for both the Cosmetic and Food lines 100 9.000 pa Results for the year ended August 31, 2020 Revenue Discount Net Revenue Cosmetis End Total $12,000,000 $22.000.000 34,000,000 (1.200,000) (2,200,000 13,400,000) $10,800,000 $19,800,000 $30,600,000 Actual Results for Fiscal 2020 Net Revenue in $ Cosmetic Food $10,800,000 $19,800,000 Total $30,600,000 Direct Labour Cost in $ $2,000,000 $3,500,000 $5,500,000 #of Assembly Labour Hours 75,000 175,000 250,000 200.000 375,000 575,000 # of Fabrication Machine Hours # of Machines sold # of Machines Produced 40 100 140 70 120 190 Inspection Hours 420 2,160 2,580 Factory Area used 6sq metres 11.250 22,800 34,050 Materials purchased 7,899.802 15.377,198 Accounting and legal Utility Costs Head Office Ulty Costs Production Administrative salaries Inspection Costa Factory Insurance Sales commissions Interest on business credit line Management salaries Omar Anna, Ted $120.000 each Property Taxes Head Office Factory Building Amortization Office supplies, Courier and Postage Annual Business Licenses and Fees Warranty Program Costa Amortization Expense Fabrication Equipment Amortization Expense-Office Equipment Business Liability Insurance Teleshone Come Factory Telephone Cost Head Office Anna's House Rent Labour Assembly workers 2,000,000 3,500,000 Labour Production supervisors Total Expenses Net Income fosil Current Year End Balances Cosmetic Raw Materials $1,500,000 $3,000,000 Costs-Machines unfinished at year end 1,000,000 3,000,000 Costs Machines complete but not sold 3,000,000 6,000,000 Last Year End Balances Raw Materials 1,000,000 2,000,000 Costs Machines unfinished at year end 2,500,000 5.000.000 Costs Machines complete but not sold $500,000 $1,500,000 23.277,000 5,000 30,000 240,000 76,000 760,000 80,000 340,000 100,000 160,000 6,500 412,000 7.760 2,500 500,000 550,000 12,000 10,000 3,000 6,000 $15,000 5.500,000 600,000 32.992,760 1$2,392,760) Total $226,000 Details of Proposed Customer Order Direct Materials Direct Labour Expected of Fabrication Machine Hours $57,000 5,642 S4.500,000 Question: 9,000,000 4,000,000 Using the concepts of ABC costing, calculate the resulting total cost and gross margins for both the Cosmetic and Food lines. 3,000,000 7.500,000 $2,000,000 Actual Results for Fiscal 2020 Net Revenue in $ Cosmetic Food Total $10,800,000 $19,800,000 $30,600,000 Direct Labour Cost in $ $2,000,000 $3,500,000 $5,500,000 # of Assembly Labour Hours 75,000 175,000 250,000 # of Fabrication Machine Hours 200,000 375,000 575,000 # of Machines sold 40 100 140 # of Machines Produced 70 120 190 Inspection Hours 420 2,160 2,580 Factory Area used (sq metres) 11,250 22,800 34,050 Details of Proposed Customer Order Direct Materials $226,000 Direct Labour $57,000 Expected # of Fabrication Machine Hours 5,642 Question: Using the concepts of ABC costing, calculate the resulting total cost and gross margins for both the Cosmetic and Food lines. Results for the year ended August 31, 2020 Revenue Discount Net Revenue Cosmetic Food Total $12,000,000 $22,000,000 34,000,000 (1,200,000) (2,200,000) (3,400,000) $10,800,000 $19,800,000 $30,600,000 Materials purchased 7,899,802 15,377,198 23,277,000 Accounting and legal 5,000 Utility Costs- Head Office 30,000 Utility Costs- Production 240,000 Administrative salaries 76,000 Inspection Costs 760,000 Factory Insurance 80,000 Sales commissions 340,000 Interest on business credit line 100,000 Management salaries (Omar, Anna, Ted $120,000 each) 360,000 Property Taxes- Head Office 6,500 Factory Building Amortization 412,000 Office supplies, Courier and Postage 7,760 Annual Business Licenses and Fees 2,500 Warranty Program Costs 500,000 Amortization Expense- Fabrication Equipment 650,000 Amortization Expense - Office Equipment 12,000 Business Liability Insurance 10,000 Telephone Costs-Factory 3,000 Telephone Costs - Head Office 6,000 Anna's House Rent $15,000 Labour- Assembly workers 2,000,000 3,500,000 5,500,000 Labour-Production supervisors 600,000 Total Expenses 32,992,760 Net Income (Loss) ($2,392,760) Current Year End Balances Cosmetic Food Total Raw Materials $1,500,000 $3,000,000 $4,500,000 Costs- Machines unfinished at year end 1,000,000 3,000,000 4,000,000 Costs- Machines complete but not sold 3,000,000 6,000,000 9,000,000 Last Year End Balances Raw Materials 1,000,000 2,000,000 3,000,000 Costs- Machines unfinished at year end 2,500,000 5,000,000 7,500,000 Costs - Machines complete but not sold $500,000 $1,500,000 $2,000,000 $2,392,760) Total 500,000 000,000 00,000 Actual Results for Fiscal 2020 Net Revereins Cosmetic Eoad $10.000.000 $1,000 DOO $300.000 Direct Labour Cantins 52.000.000 SR 500,000 $5.500 DO of Assembly Labour Hours 75,000 175.000 250.000 30.000 of Fabrication Machine Hours 200.000 175.000 57.000 of Machines sold 40 100 10 of Machines Produced 70 120 1:90 Inpection Hours 420 2,160 2.589 Factory Area vied (mere) 11,250 22.800 34.050 Results for the year anded Aug 1, 2020 Revenue $12,000,000 $2.000.000 Discount 34,000,000 1,200,000 2.200,000 0.400,000 Neve $10.200.000 $8,400,000 $4,600,000 Material purchased Anting dal 7.19.02.13 2372.000 5.900 Cart Head Office Ulty Cost Production 30.000 Admiteres Inspection Costa 76,000 100 Factory imance Sales como 90.000 Inresten besserede in Manager Omar, Ann Ted 120,000 each Property Head Office Factory Building Amersion Office supplies Could Postage 7,260 Annual Beness and Fees 2.500 Warranty Program te Amortation pense-Fabricationem 650,000 Amortation Experise-Office Equipment 12.000 Bubtity insurance 10.000 Telephone Costs Factory 3.000 Telephone Costs Head Office 6.000 Anna Mee Rent $15.000 Labour Ambly workers 2.000.00 3.500.000 S.M.000 Labour Production supervisor 600.000 Total Experts 32,932,760 Net income Los 152.110 Current Tere End Balance Connets Raw Materiale $1.500.000 $3,000,000 $4.500.000 Corts Machines unfinished at year end 1.000.000 3,000,000 4,000,000 Conto- Machines complete but not ald 3.000.000 5.000.000 9,000,000 Last Year Ende Raw Materials 1,000,000 2.000.000 3.000.000 Costs Machines unfinished we year end 2.500.000 5.000.000 7.500.000 Costs Machines complete but not sold $500,000 $1,500,000 $2.000.000 Se. Details of Proposed Customer Order Direct Materials $225,000 Direct Labour $57.000 Expected of Fabrication Machine Hours 5.642 Question: Using the concepts of ABC costing, calculate the resulting total cost and gross margins for both the Cosmetic and Food lines 100 9.000 pa Results for the year ended August 31, 2020 Revenue Discount Net Revenue Cosmetis End Total $12,000,000 $22.000.000 34,000,000 (1.200,000) (2,200,000 13,400,000) $10,800,000 $19,800,000 $30,600,000 Actual Results for Fiscal 2020 Net Revenue in $ Cosmetic Food $10,800,000 $19,800,000 Total $30,600,000 Direct Labour Cost in $ $2,000,000 $3,500,000 $5,500,000 #of Assembly Labour Hours 75,000 175,000 250,000 200.000 375,000 575,000 # of Fabrication Machine Hours # of Machines sold # of Machines Produced 40 100 140 70 120 190 Inspection Hours 420 2,160 2,580 Factory Area used 6sq metres 11.250 22,800 34,050 Materials purchased 7,899.802 15.377,198 Accounting and legal Utility Costs Head Office Ulty Costs Production Administrative salaries Inspection Costa Factory Insurance Sales commissions Interest on business credit line Management salaries Omar Anna, Ted $120.000 each Property Taxes Head Office Factory Building Amortization Office supplies, Courier and Postage Annual Business Licenses and Fees Warranty Program Costa Amortization Expense Fabrication Equipment Amortization Expense-Office Equipment Business Liability Insurance Teleshone Come Factory Telephone Cost Head Office Anna's House Rent Labour Assembly workers 2,000,000 3,500,000 Labour Production supervisors Total Expenses Net Income fosil Current Year End Balances Cosmetic Raw Materials $1,500,000 $3,000,000 Costs-Machines unfinished at year end 1,000,000 3,000,000 Costs Machines complete but not sold 3,000,000 6,000,000 Last Year End Balances Raw Materials 1,000,000 2,000,000 Costs Machines unfinished at year end 2,500,000 5.000.000 Costs Machines complete but not sold $500,000 $1,500,000 23.277,000 5,000 30,000 240,000 76,000 760,000 80,000 340,000 100,000 160,000 6,500 412,000 7.760 2,500 500,000 550,000 12,000 10,000 3,000 6,000 $15,000 5.500,000 600,000 32.992,760 1$2,392,760) Total $226,000 Details of Proposed Customer Order Direct Materials Direct Labour Expected of Fabrication Machine Hours $57,000 5,642 S4.500,000 Question: 9,000,000 4,000,000 Using the concepts of ABC costing, calculate the resulting total cost and gross margins for both the Cosmetic and Food lines. 3,000,000 7.500,000 $2,000,000 Actual Results for Fiscal 2020 Net Revenue in $ Cosmetic Food Total $10,800,000 $19,800,000 $30,600,000 Direct Labour Cost in $ $2,000,000 $3,500,000 $5,500,000 # of Assembly Labour Hours 75,000 175,000 250,000 # of Fabrication Machine Hours 200,000 375,000 575,000 # of Machines sold 40 100 140 # of Machines Produced 70 120 190 Inspection Hours 420 2,160 2,580 Factory Area used (sq metres) 11,250 22,800 34,050 Details of Proposed Customer Order Direct Materials $226,000 Direct Labour $57,000 Expected # of Fabrication Machine Hours 5,642 Question: Using the concepts of ABC costing, calculate the resulting total cost and gross margins for both the Cosmetic and Food lines. Results for the year ended August 31, 2020 Revenue Discount Net Revenue Cosmetic Food Total $12,000,000 $22,000,000 34,000,000 (1,200,000) (2,200,000) (3,400,000) $10,800,000 $19,800,000 $30,600,000 Materials purchased 7,899,802 15,377,198 23,277,000 Accounting and legal 5,000 Utility Costs- Head Office 30,000 Utility Costs- Production 240,000 Administrative salaries 76,000 Inspection Costs 760,000 Factory Insurance 80,000 Sales commissions 340,000 Interest on business credit line 100,000 Management salaries (Omar, Anna, Ted $120,000 each) 360,000 Property Taxes- Head Office 6,500 Factory Building Amortization 412,000 Office supplies, Courier and Postage 7,760 Annual Business Licenses and Fees 2,500 Warranty Program Costs 500,000 Amortization Expense- Fabrication Equipment 650,000 Amortization Expense - Office Equipment 12,000 Business Liability Insurance 10,000 Telephone Costs-Factory 3,000 Telephone Costs - Head Office 6,000 Anna's House Rent $15,000 Labour- Assembly workers 2,000,000 3,500,000 5,500,000 Labour-Production supervisors 600,000 Total Expenses 32,992,760 Net Income (Loss) ($2,392,760) Current Year End Balances Cosmetic Food Total Raw Materials $1,500,000 $3,000,000 $4,500,000 Costs- Machines unfinished at year end 1,000,000 3,000,000 4,000,000 Costs- Machines complete but not sold 3,000,000 6,000,000 9,000,000 Last Year End Balances Raw Materials 1,000,000 2,000,000 3,000,000 Costs- Machines unfinished at year end 2,500,000 5,000,000 7,500,000 Costs - Machines complete but not sold $500,000 $1,500,000 $2,000,000