Please help!

TASK #1 OPERATING BUDGET, YEAR 5 Stair-Lifts Elevators Ec Premium Lite Comm Total $ DIRECT LABOR BUDGET, YEAR 5 Budgeted Cost of Goods Manufactured % of Total Cost Related to DL-50% E and 38/22/21% Labor Cost Per Unit Labor Cost Per Hour: C36 C25 (copy acrass to columns D thraugh Fl: G is tatal C37 C36 x 0.50; percentages are given in B37; CK G37-$10,639,734 C38 C37/C23 (copy acrass to columns D thraugh FI C40 C38/400 hours; copy format for D41, E42, F43; CK F43 $28.02 Elevators (400 hours each) Economy Stair Lifts (10 hours each] Premium Stair Lifts (12 hours each) Lite Commercial (15 hours each) MANUFACTURING OVERHEAD BUDGET, YEAR 5 Budgeted Cost of Goods Manufactured % of Total Cost Related to MOH-10% E and 11/2319% C46 C25(copy across to columns D through Fl: G is total C47 C46x0.10; percentages are given in B47; Ck: G47 $2,499,53 Direct Materials Used Direct Labor Manufacturing verhead Total Cost of Goods Manufactured CS0 C29 (capy across to columns D through F; G is total CS1 C37 (capy across to columns D through F G is total CS2-C47 (capy across to columns D through F G is total CS3 sum(CS0:C52) copy acrass to columns D thraugh F;G is total Ck: GS3 $24,644,976 Advertising Expense (10,000 per month+ $7362) Sales Commissions $3681) Salaries & Wages Expense($128,232 per month + 80% Depreciation EHpense 8,24U per month) Insurance Expense ($5,300 per month+544] Rent Expense ($12,000 per month) Uilities Expense ($2,000 per month+ 74x) IotalS68A Expenses ffariable FiRed G56 (10000 x 12H7362 x G7 Use information given in column B for each row. G63-sum(G56:G62) Ck: G63 $10,519,097 $8,522,633 ncome lx Balane 93,665 1.6 2,465,753 42.3 Suppliar Ru Material, Inventory Wark-in-P Inventory 260,000 4.5% 256,700 4.4% 275,000 4.7 PrepaidInruranc Compte&Netuark(Syr. life) Furniture&&Fixturor (10 Office Equipmont (5yr. lif&) Vehielor(5r.life) e) 90,000 1.5 42,0000.7 250,000 4.3 Land Buildinar Furniture &Fixturor (10yr. life) CAD Computorr, Netuork(5yr. life Machinery (15r.lfe Forklift (10 xr. life) ArD Depreciation 125,0002.1 18,000 0.3% 75,000 1.3x 590,200 10.1 150,000 2.6% Aecountr Parable 361,644 6.2% 105,000 1. Interest P Incame Ta ayablo Unearned Rovonue Current Partion of LTNoter Payable 168,056 2.9 115,0002.0 77,04713.3 Nator Pa Cammon Stack RetinoEarnin ,000000 17.1 412286 PP&E (SG&A and PRODUCTION ASSETS Year 4 SG&A Computers& Network (5 yr. life) Furniture & Fixtures (10 yr. life) Office Equipment (5 yr. life) Vehicles (5 yr. life) PP&E (Production) Land Buildings Furniture &Fixtures(10 yr. life) CAD Computers, Network (5 yr. life) Machinery (15 yr. life) orklift (10 yr. life Total PP&E Total Depreciation A/D Depreciation Net PP&E Year 1&2 25,000 35,000 12,000 65,000 Year 3 Year 5 Year 1&2 Year 3 Year 4 Year 5 25,000 35,000 12,000 65,000 250,000 300,000 75,000 90,000 108,000 42,000 90,000 10,000 7,000 4,800 26,000 47,800 5,000 3,500 2,400 13,000 23,900 0 15,000 1,500 10,000 23,333 7,500 57,333 81,233 15,000 9,000 8,400 50,000 82,400 18,000 10,800 10,080 60,000 98,880 50,400 125,000 125,000 150,000 750,000 1,300,000 1,560,000 21,600 90,000 350,000 590,200 708,240 75,000 150,000 180,000 137,000 1,502,000 2,715,200 3,258,240 31,200 2,160 18,000 47,216 18,000 97,147 116,576 179,547 215,456 26,000 1,800 15,000 39,347 15,000 15,000 50,000 18,000 75,000 47,800 (47.800) (129,033) (308,580) (524,036 89,2001,372,967 2,406,620 2,734,204 47,800 129,033 308,580 524,036 TASK #1 OPERATING BUDGET, YEAR 5 Stair-Lifts Elevators Ec Premium Lite Comm Total $ DIRECT LABOR BUDGET, YEAR 5 Budgeted Cost of Goods Manufactured % of Total Cost Related to DL-50% E and 38/22/21% Labor Cost Per Unit Labor Cost Per Hour: C36 C25 (copy acrass to columns D thraugh Fl: G is tatal C37 C36 x 0.50; percentages are given in B37; CK G37-$10,639,734 C38 C37/C23 (copy acrass to columns D thraugh FI C40 C38/400 hours; copy format for D41, E42, F43; CK F43 $28.02 Elevators (400 hours each) Economy Stair Lifts (10 hours each] Premium Stair Lifts (12 hours each) Lite Commercial (15 hours each) MANUFACTURING OVERHEAD BUDGET, YEAR 5 Budgeted Cost of Goods Manufactured % of Total Cost Related to MOH-10% E and 11/2319% C46 C25(copy across to columns D through Fl: G is total C47 C46x0.10; percentages are given in B47; Ck: G47 $2,499,53 Direct Materials Used Direct Labor Manufacturing verhead Total Cost of Goods Manufactured CS0 C29 (capy across to columns D through F; G is total CS1 C37 (capy across to columns D through F G is total CS2-C47 (capy across to columns D through F G is total CS3 sum(CS0:C52) copy acrass to columns D thraugh F;G is total Ck: GS3 $24,644,976 Advertising Expense (10,000 per month+ $7362) Sales Commissions $3681) Salaries & Wages Expense($128,232 per month + 80% Depreciation EHpense 8,24U per month) Insurance Expense ($5,300 per month+544] Rent Expense ($12,000 per month) Uilities Expense ($2,000 per month+ 74x) IotalS68A Expenses ffariable FiRed G56 (10000 x 12H7362 x G7 Use information given in column B for each row. G63-sum(G56:G62) Ck: G63 $10,519,097 $8,522,633 ncome lx Balane 93,665 1.6 2,465,753 42.3 Suppliar Ru Material, Inventory Wark-in-P Inventory 260,000 4.5% 256,700 4.4% 275,000 4.7 PrepaidInruranc Compte&Netuark(Syr. life) Furniture&&Fixturor (10 Office Equipmont (5yr. lif&) Vehielor(5r.life) e) 90,000 1.5 42,0000.7 250,000 4.3 Land Buildinar Furniture &Fixturor (10yr. life) CAD Computorr, Netuork(5yr. life Machinery (15r.lfe Forklift (10 xr. life) ArD Depreciation 125,0002.1 18,000 0.3% 75,000 1.3x 590,200 10.1 150,000 2.6% Aecountr Parable 361,644 6.2% 105,000 1. Interest P Incame Ta ayablo Unearned Rovonue Current Partion of LTNoter Payable 168,056 2.9 115,0002.0 77,04713.3 Nator Pa Cammon Stack RetinoEarnin ,000000 17.1 412286 PP&E (SG&A and PRODUCTION ASSETS Year 4 SG&A Computers& Network (5 yr. life) Furniture & Fixtures (10 yr. life) Office Equipment (5 yr. life) Vehicles (5 yr. life) PP&E (Production) Land Buildings Furniture &Fixtures(10 yr. life) CAD Computers, Network (5 yr. life) Machinery (15 yr. life) orklift (10 yr. life Total PP&E Total Depreciation A/D Depreciation Net PP&E Year 1&2 25,000 35,000 12,000 65,000 Year 3 Year 5 Year 1&2 Year 3 Year 4 Year 5 25,000 35,000 12,000 65,000 250,000 300,000 75,000 90,000 108,000 42,000 90,000 10,000 7,000 4,800 26,000 47,800 5,000 3,500 2,400 13,000 23,900 0 15,000 1,500 10,000 23,333 7,500 57,333 81,233 15,000 9,000 8,400 50,000 82,400 18,000 10,800 10,080 60,000 98,880 50,400 125,000 125,000 150,000 750,000 1,300,000 1,560,000 21,600 90,000 350,000 590,200 708,240 75,000 150,000 180,000 137,000 1,502,000 2,715,200 3,258,240 31,200 2,160 18,000 47,216 18,000 97,147 116,576 179,547 215,456 26,000 1,800 15,000 39,347 15,000 15,000 50,000 18,000 75,000 47,800 (47.800) (129,033) (308,580) (524,036 89,2001,372,967 2,406,620 2,734,204 47,800 129,033 308,580 524,036