i need ans.as soon as possible

Insert Format Tools Data Window Help 100% Sun 11:27 AM Gagandeep kaur Q Coke +INC+Cost+alloc.xlsx do 2. A. Y Six 100% Home ? Layout Tables Charts SmartArt Q. Search in Sheet Formulas Data Edit Review Font Fill Calibri Number 18 Alignment abc Format Cells Wrap Text A- A SA Accounting Themes aste Clear B 1 Normal U Merge 70 G. .00 00 2.0 E17 A Bad Conditional Formatting X Insert Delete Format fx 1500000 B Themes Aa: 11 D E F G H A+B+C TMC B Allocation costs Direct Materials Direct labour Ma per unit 4 Assignment 1 Coke Inc has the following cost data for the month of July for their Ohio plant Production volume 10,000,000 Units Selling price per unit 1.00 COSTS 1 Administration salaries 85/15 office/fac 1,275,000.00 annual 2 Google ads 300,000.00 annual 3 Aluminium for cans 0.05 cents Electricity for machinary - 5 units in all 5,000.00 per unit 5 Employee Medical Standard life 25 off/75 factory 25,000.00 month 6 Research and Dev new products 750,000.00 7 Patents registration newproducts 50,000.00 8 Coke ingrdients and mixes 0.50 per unit 9 Depreciation Office equip 9,500.00 per month 10 Electrical supplies 0.50 per unit 11 Factory salaries 85 Fac/15 office 1,500,000.00 annual 12 Insurance Fac/Office 75/25 split 75,000.00 annual 13 Legal and accounting 200,000.00 annual 14 Logistics Shipping 55,000.00 monthly 15 Misc materials cleaning supplies 20,000.00 month 16 Rent 85,000.00 month 17 Property taxes 175,000.00 annual Office 250,000.00 annual 0.05 can 19 Sales commissions 20 Software ringradas Sheet2 + 1,500,000.00 Normal View Ready 18 Rent 2000 manth Sum= 11.107 NOV @? 14 B C D E F G H 25 off/75 factory 85 Fac/15 office Fac/Office 75/25 split 4 Electricity for machinary - 5 units in all 5 Employee Medical Standard life 6 Research and Dev new products 7 Patents registration newproducts 8 Coke ingrdients and mixes 9 Depreciation Office equip 10 Electrical supplies 11 Factory salaries 12 Insurance 13 Legal and accounting 14 Logistics Shipping 15 Misc materials cleaning supplies 16 Rent 17 Property taxes 18 Rent 19 Sales commissions 20 Software upgrades 21 Supervisor salary 22 Wages assembly line 5,000.00 per unit 25,000.00 month 750,000.00 50,000.00 0.50 per unit 9,500.00 per month 0.50 per unit 1,500,000.00 annual 75,000.00 annual 200,000.00 annual 55,000.00 monthly 20,000.00 month 85,000.00 month 175,000.00 annual 250,000.00 annual 0.05 can 30,000.00 month 60,000.00 annual 0.15 per unit Office Total TMC 1 What is TMC? 2 What is Net profit? +