Question

1 Approved Answer

Posted on Sep 02, 2024

Allocations and Departmental Income Statements Sales and Direct Expenses Total Sales and Expenses Coding Marketing Accounting Hiring Security C Suite Sales 3,000,000 1,000,000 800,000 1,200,000

image text in transcribed

Allocations and Departmental Income Statements Sales and Direct Expenses Total Sales and Expenses Coding Marketing Accounting Hiring Security C Suite Sales 3,000,000 1,000,000 800,000 1,200,000 Direct Expenses Direct Materials 105,000 20,000 50,000 35,000 Direct Labor 1,628,000 400,000 300,000 450,000 100,000 80,000 298,000 Depreciation - Equipment 72,060 20,000 2,000 15,000 1980 33080 Supplies 43,000 5,000 25,000 10,000 3000 Total Direct Expenses 1,848,060 445,000 377,000 510,000 104,980 113,080 298,000 Gross Profit 1,151,940 555,000 423,000 690,000 (104,980) (113,080) (298,000) Indirect Expenses Rent (allocate over square feet) 64,000 Utilities (allocate over square feet) 28,000 Corporate Training (allocate over # of emplo 50,000 Total Indirect Expenses 142,000 Particulars Total Basis Coding Coding Amount Marketing Marketing Amount Accounting Accounting Amount Total of basis Hiring 104980 No of hire 20 52490 7 18371.5 13 34118.5 40 Secuirty 113080 Sq Ft 1500 23723.07692 3650 57726.15385 2000 31630.76923 7150 C Suite 298000 Employee 90 111750 50 62083.33333 100 124166.6667 240 Rent 64000 Sq Ft 1500 13426.57343 3650 32671.32867 2000 17902.0979 7150 Utilities 28000 Sq Ft 1500 5874.125874 3650 14293.70629 2000 7832.167832 7150 Employee 90 18750 50 10416.66667 100 20833.33333240 Corporate 50000 Training Instructions: Calculate the rate by which to allocate Indirect Expenses Sales and Direct Expenses Total Sales and Expe Coding Marketing Accounting Hiring Security C Suite Sales 3,000,000 1,000,000 800,000 1,200,000 Direct Expenses Direct Materials 105,000 20,000 50,000 35,000 Direct Labor 1,628,000 400,000 300,000 450,000 100,000 80,000 298,000 Depreciation - Equipment 72,060 20,000 2,000 15,000 1,980 33,080 Supplies 43,000 5,000 25,000 10,000 3,000 Total Direct Expenses 1,848,060 445,000 377,000 510,000 104,980 113,080 298,000 Gross Profit 1,151,940 555,000 423,000 690,000 (104,980) (113,080) (298,000) Indirect Expenses Total Allocation Rate Rent (allocate over square feet) 64,000 Utilities (allocate over square feet) 28,000 Corporate Training (allocate over # of emplo 50,000 Total Indirect Expenses 142,000 Allocation Activities Coding Marketing Accounting Hiring Security C Suite Total Square Feet Used 1,500 3,650 2,000 250 100 2,500 #employees 90 50 100 5 2 3 Allocations and Departmental Income Statements Sales and Direct Expenses Total Sales and Expenses Coding Marketing Accounting Hiring Security C Suite Sales 3,000,000 1,000,000 800,000 1,200,000 Direct Expenses Direct Materials 105,000 20,000 50,000 35,000 Direct Labor 1,628,000 400,000 300,000 450,000 100,000 80,000 298,000 Depreciation - Equipment 72,060 20,000 2,000 15,000 1980 33080 Supplies 43,000 5,000 25,000 10,000 3000 Total Direct Expenses 1,848,060 445,000 377,000 510,000 104,980 113,080 298,000 Gross Profit 1,151,940 555,000 423,000 690,000 (104,980) (113,080) (298,000) Indirect Expenses Rent (allocate over square feet) 64,000 Utilities (allocate over square feet) 28,000 Corporate Training (allocate over # of emplo 50,000 Total Indirect Expenses 142,000 Particulars Total Basis Coding Coding Amount Marketing Marketing Amount Accounting Accounting Amount Total of basis Hiring 104980 No of hire 20 52490 7 18371.5 13 34118.5 40 Secuirty 113080 Sq Ft 1500 23723.07692 3650 57726.15385 2000 31630.76923 7150 C Suite 298000 Employee 90 111750 50 62083.33333 100 124166.6667 240 Rent 64000 Sq Ft 1500 13426.57343 3650 32671.32867 2000 17902.0979 7150 Utilities 28000 Sq Ft 1500 5874.125874 3650 14293.70629 2000 7832.167832 7150 Employee 90 18750 50 10416.66667 100 20833.33333240 Corporate 50000 Training Instructions: Calculate the rate by which to allocate Indirect Expenses Sales and Direct Expenses Total Sales and Expe Coding Marketing Accounting Hiring Security C Suite Sales 3,000,000 1,000,000 800,000 1,200,000 Direct Expenses Direct Materials 105,000 20,000 50,000 35,000 Direct Labor 1,628,000 400,000 300,000 450,000 100,000 80,000 298,000 Depreciation - Equipment 72,060 20,000 2,000 15,000 1,980 33,080 Supplies 43,000 5,000 25,000 10,000 3,000 Total Direct Expenses 1,848,060 445,000 377,000 510,000 104,980 113,080 298,000 Gross Profit 1,151,940 555,000 423,000 690,000 (104,980) (113,080) (298,000) Indirect Expenses Total Allocation Rate Rent (allocate over square feet) 64,000 Utilities (allocate over square feet) 28,000 Corporate Training (allocate over # of emplo 50,000 Total Indirect Expenses 142,000 Allocation Activities Coding Marketing Accounting Hiring Security C Suite Total Square Feet Used 1,500 3,650 2,000 250 100 2,500 #employees 90 50 100 5 2 3