Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

20 CP Rebel Ten care 2 Fin - Upload 5 Review View Hole Home Page Layout Formulas Oats 6 Conditional formag foong Anh Jor Agent

image text in transcribed
image text in transcribed
20 CP Rebel Ten care 2 Fin - Upload 5 Review View Hole Home Page Layout Formulas Oats 6 Conditional formag foong Anh Jor Agent Ne 5 fomutable ces he UPLOAD BLOOD wania problem with these days. Pacoy to do D Glven Data Blow Comite.. and Aliciter for Columns, and Decrease increase increase increase 10% IS son 2014 mere 3 25 2000 $50 Sale Price 10 S. 12 U 15 17 Sie 10 S Othe $2.500.000 511,250,000 Variable 51,182.0 of Sri 5450,000 95.000 V 550 300 $1.5.000 51.500.000 Ser Note Now 2. Stikow Set Bow SS2.500 22 21 . -41 Celle Formatos table Editing Agent Number Analyze Data Cell Styles Anal SY We ran into a problem with the file and cant see any w changes Please save a copy to avoid losing Save a UPLOAD BLOCKED E F H B 1 Given Data Below Complete Columns E, F, G and 2 3. Aho calculate Break Even Units for Columns D, E, F, G and H 5 106 Decrease increase increase increase 10% 20% 596 5 6 7 Sales Unite 750,000 9 Sale Price $50 10 11 Revenge 337,500,000 12 13 Expenses 14 Salaries $2,500,000 Fixed 15 Salaries $11,250,000 Variable 16 Benefits $3,162,500 % of Salaries 17 Supplies $650,000 Fixed 18 Supplies $5,625,000 Variable 19 Other $150,000 Fixed 20 Other 51,875,000 Vorable 21 Depreciation $7.500,000 See Note Below 22 Deprecition See Note Below 23 Interest $2,500,000 See Note Below 24 interest See Note Below 25 Total Expenses Sas.212.500 26 27 Profit Before Taxes $2.287,500 28 29 Taxes 25% $571,875 30 31 Profit After tax $1,715,625 32 33 34 Break Even Units 35 36 37 38 Depreciation for each 10% increase in sales units Depreciation increase by 5% 39 No retirement of assets 40 41 Interest for each 15% increase in sales units an increase of $750,000 of interest expense, no retirement 42 43 45 47 20 CP Rebel Ten care 2 Fin - Upload 5 Review View Hole Home Page Layout Formulas Oats 6 Conditional formag foong Anh Jor Agent Ne 5 fomutable ces he UPLOAD BLOOD wania problem with these days. Pacoy to do D Glven Data Blow Comite.. and Aliciter for Columns, and Decrease increase increase increase 10% IS son 2014 mere 3 25 2000 $50 Sale Price 10 S. 12 U 15 17 Sie 10 S Othe $2.500.000 511,250,000 Variable 51,182.0 of Sri 5450,000 95.000 V 550 300 $1.5.000 51.500.000 Ser Note Now 2. Stikow Set Bow SS2.500 22 21 . -41 Celle Formatos table Editing Agent Number Analyze Data Cell Styles Anal SY We ran into a problem with the file and cant see any w changes Please save a copy to avoid losing Save a UPLOAD BLOCKED E F H B 1 Given Data Below Complete Columns E, F, G and 2 3. Aho calculate Break Even Units for Columns D, E, F, G and H 5 106 Decrease increase increase increase 10% 20% 596 5 6 7 Sales Unite 750,000 9 Sale Price $50 10 11 Revenge 337,500,000 12 13 Expenses 14 Salaries $2,500,000 Fixed 15 Salaries $11,250,000 Variable 16 Benefits $3,162,500 % of Salaries 17 Supplies $650,000 Fixed 18 Supplies $5,625,000 Variable 19 Other $150,000 Fixed 20 Other 51,875,000 Vorable 21 Depreciation $7.500,000 See Note Below 22 Deprecition See Note Below 23 Interest $2,500,000 See Note Below 24 interest See Note Below 25 Total Expenses Sas.212.500 26 27 Profit Before Taxes $2.287,500 28 29 Taxes 25% $571,875 30 31 Profit After tax $1,715,625 32 33 34 Break Even Units 35 36 37 38 Depreciation for each 10% increase in sales units Depreciation increase by 5% 39 No retirement of assets 40 41 Interest for each 15% increase in sales units an increase of $750,000 of interest expense, no retirement 42 43 45 47

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Intelligence For IT Professionals

Authors: Karen Berman, Joe Knight, John Case

1st Edition

1422119149, 9781422119143

More Books

Students also viewed these Finance questions

Question

1 Why might people resist change?

Answered: 1 week ago