please answer everything the ones that have to be yello and theres a part has to be a percentage and check mu work please

thats it I did it and i am not aure if i did it right

can you show me how you got it

ACC 154 Score Ce Seved this PC REQUIRED: Cost-Volume-Profit Analysis Current vs Projected provide the following projected calculations for 2020. (12 Points) A) Contribution Margin B) Break Even in Units C) Break Even in Dollars D) Total Sales E) Income Before Taxes F) Margin of Safety in Dollars G) Margin of Sofety In Units H) Degree of Operating leverage 1. 2019 CVP: Using the Excel spreadsheet file perform the fol- lowing calculations using the information as of the end of 2019: (8 Points) 3. Highlight in which scenario(s) will result in at least on 8% increase in Income before faxes. A) Contribution Margin B) Break Even in Units C) Break Even in Dollars D) Total Sales E) Income Before Taxes F) Margin of Safety In Dollars G) Margin of Safety in Units H) Degree of Operating Leverage 2. Projected 2020 CVP. For each of the three scenarios on the previous page Type here to search SPECIELLT ID Dream Deves F ara Cane . Fixed Costs Please enter as totals * Facility Rent: Management Sales Depreciation machinery Maintenance and repar Other overhead expenses Seling and Administrative Costs: Total Fixed Costs 40,000 6000 24,000 7H0000 240000 800000 10000 00000 24000 780000 1914000 2 40000 800000 40000 60000 24000 7800 240000 800000 40000 60000 24000 780000 1911000 Variable Costs Please enter as per unit Type to search ACCUSACIE C ODE PS le e r Page Layout X 27 S- Total Variable Costs per Unit 670 Results > Total Sales in Dollars Contribution Margin Per Unit - Breakeven in Units: Breakeven in Dollars Margin of Safety in Dollars Margin of Safety in Units Degree of Operating Leverage income CVP Analysis 160000000 1.00 $ 14,954 $ 11,963,200 $ 148,036,800 $ 185,046 160000000 115 16904 13523200 146475800 183096 145 13407 1 0926705 152073295 186593 130 14954 11963200 146436800 183046 $ 24,056,000 21056000 27056000 2376900 Type here to search VISS File Tools View ACC 154 SolarCo Case(1) - Saved to this PC Utilities: $10 per Smart Mirror Selling and Administrative Costs: Delivery expenses: $65per Smart Mirror Sales commissions: $95 per Smart Mirror Here are the three scenarios that are possible: Scenario 1: One of the raw materials used to make the Smart Mirror increases by $15 per mirror. Scenario 2: Your competitive advantage in the market al- lows you to raise prices by $15 per unit. (Assume no effect on volume) Scenario 3: Supply shortages only allow you to produce 198,000 units. Type here to search ACC 154 SolarCaCl - Saved to the ACC 154- Managerial Accounting Cost-Volume-Profit Analysis Excel Assignment Sales Volume: 200,000 Smart Mirrors were sold this past year. Current capacity 220,000 units (there is no plan (or budget to expand operating capacity for 2020) Introduction: You have just been promoted to Division Manager. Your mon ager is looking to you for production projections for next year for the company's only product: Smart Mirrors. Your analysis for the coming year is extremely challenging given current economic conditions, random government programs and competition from lower cost non-U.S. manufacturers. You will be required to forecast changes in the company's fixed and varic ble costs for 2020 to determine its break-even in units and dollar sales, degree of operating leverage and margin of safety. Fixed Costs: Manufacturing Overhead: Facility Rent $240,000 Management Salaries: $800,000 Depreciation, machinery: $40,000 Maintenance and repair: S60,000 Other overhead expenses $24,000 Selling and Administrative Costs Taxes and Insurance: $600,000 Sales salaries $180,000 Management is under pressure to deliver an increase of 8 9 over 2019's Income Before Taxes. Situation as of Year-End 2019: Variable Costs Manufacturing Costs: Materials: $325 per Smart Mirror Labor $125 per Smart Mirror Employee Benefits: 550 per Smart Mirror Sales Price: 1 (one) Smart Mirror sells for $800. Actual 2019 Scenario 1 Scenario 2 Scenario 3 Sales Price per Unit 800 800 815 800 Sales Volume 200,000 200000 200000 200000 Fixed Costs Please enter as total) Facility Rent: Management Sales Deprecation machinery Martenance and repair Other Overhead expenses Seling and Administrative Costs 240,000 200 40,000 210000 800000 240000 800000 40000 10000 24,000 780,00 780 780000 700D E o Type here to search WE RED) - ACC 1S4 PROIECTE CEL TEMPLARIO A Autoevee - OX File Home Forms view Pare 85 we Dw Page Layout Avenir llock 16 - A BTW- L A Th Review Tour Merge 59 60000 24000 14 Muntenance and repair 15 Other overhead expenses Selling and Administrative Costs: Total Fixed Costs 60,000 24,000 780,000 1,9414,000 60000 20000 780000 1944000 60000 24000 780000 191-1000 780001 1914000 Variable Costs Please enter as per unit Total Variable Costs per Unit Results A& MIN E Type here to search 2. A 99 4 160000000 Results Total Sales in Dollars Contribution Margin Per Unit Breakeven in Units Breakeven in Dollars: Margin of Safety in Dollars Margin of Safety in Units Degree of Operating Leverage income 160000000 130 $ 14,954 $ 11,963,200 $ 148,036,800 $ 185,016 160000000 115 16901 13523200 146-175800 183096 160000000 145 134407 1 0926705 152073295 186593 14954 11963200 14614500 182016 S $ 24,056,000 21056000 27036000 2376900 CVP Analysis Type Beach ER ACC 154 Score Ce Seved this PC REQUIRED: Cost-Volume-Profit Analysis Current vs Projected provide the following projected calculations for 2020. (12 Points) A) Contribution Margin B) Break Even in Units C) Break Even in Dollars D) Total Sales E) Income Before Taxes F) Margin of Safety in Dollars G) Margin of Sofety In Units H) Degree of Operating leverage 1. 2019 CVP: Using the Excel spreadsheet file perform the fol- lowing calculations using the information as of the end of 2019: (8 Points) 3. Highlight in which scenario(s) will result in at least on 8% increase in Income before faxes. A) Contribution Margin B) Break Even in Units C) Break Even in Dollars D) Total Sales E) Income Before Taxes F) Margin of Safety In Dollars G) Margin of Safety in Units H) Degree of Operating Leverage 2. Projected 2020 CVP. For each of the three scenarios on the previous page Type here to search SPECIELLT ID Dream Deves F ara Cane . Fixed Costs Please enter as totals * Facility Rent: Management Sales Depreciation machinery Maintenance and repar Other overhead expenses Seling and Administrative Costs: Total Fixed Costs 40,000 6000 24,000 7H0000 240000 800000 10000 00000 24000 780000 1914000 2 40000 800000 40000 60000 24000 7800 240000 800000 40000 60000 24000 780000 1911000 Variable Costs Please enter as per unit Type to search ACCUSACIE C ODE PS le e r Page Layout X 27 S- Total Variable Costs per Unit 670 Results > Total Sales in Dollars Contribution Margin Per Unit - Breakeven in Units: Breakeven in Dollars Margin of Safety in Dollars Margin of Safety in Units Degree of Operating Leverage income CVP Analysis 160000000 1.00 $ 14,954 $ 11,963,200 $ 148,036,800 $ 185,046 160000000 115 16904 13523200 146475800 183096 145 13407 1 0926705 152073295 186593 130 14954 11963200 146436800 183046 $ 24,056,000 21056000 27056000 2376900 Type here to search VISS File Tools View ACC 154 SolarCo Case(1) - Saved to this PC Utilities: $10 per Smart Mirror Selling and Administrative Costs: Delivery expenses: $65per Smart Mirror Sales commissions: $95 per Smart Mirror Here are the three scenarios that are possible: Scenario 1: One of the raw materials used to make the Smart Mirror increases by $15 per mirror. Scenario 2: Your competitive advantage in the market al- lows you to raise prices by $15 per unit. (Assume no effect on volume) Scenario 3: Supply shortages only allow you to produce 198,000 units. Type here to search ACC 154 SolarCaCl - Saved to the ACC 154- Managerial Accounting Cost-Volume-Profit Analysis Excel Assignment Sales Volume: 200,000 Smart Mirrors were sold this past year. Current capacity 220,000 units (there is no plan (or budget to expand operating capacity for 2020) Introduction: You have just been promoted to Division Manager. Your mon ager is looking to you for production projections for next year for the company's only product: Smart Mirrors. Your analysis for the coming year is extremely challenging given current economic conditions, random government programs and competition from lower cost non-U.S. manufacturers. You will be required to forecast changes in the company's fixed and varic ble costs for 2020 to determine its break-even in units and dollar sales, degree of operating leverage and margin of safety. Fixed Costs: Manufacturing Overhead: Facility Rent $240,000 Management Salaries: $800,000 Depreciation, machinery: $40,000 Maintenance and repair: S60,000 Other overhead expenses $24,000 Selling and Administrative Costs Taxes and Insurance: $600,000 Sales salaries $180,000 Management is under pressure to deliver an increase of 8 9 over 2019's Income Before Taxes. Situation as of Year-End 2019: Variable Costs Manufacturing Costs: Materials: $325 per Smart Mirror Labor $125 per Smart Mirror Employee Benefits: 550 per Smart Mirror Sales Price: 1 (one) Smart Mirror sells for $800. Actual 2019 Scenario 1 Scenario 2 Scenario 3 Sales Price per Unit 800 800 815 800 Sales Volume 200,000 200000 200000 200000 Fixed Costs Please enter as total) Facility Rent: Management Sales Deprecation machinery Martenance and repair Other Overhead expenses Seling and Administrative Costs 240,000 200 40,000 210000 800000 240000 800000 40000 10000 24,000 780,00 780 780000 700D E o Type here to search WE RED) - ACC 1S4 PROIECTE CEL TEMPLARIO A Autoevee - OX File Home Forms view Pare 85 we Dw Page Layout Avenir llock 16 - A BTW- L A Th Review Tour Merge 59 60000 24000 14 Muntenance and repair 15 Other overhead expenses Selling and Administrative Costs: Total Fixed Costs 60,000 24,000 780,000 1,9414,000 60000 20000 780000 1944000 60000 24000 780000 191-1000 780001 1914000 Variable Costs Please enter as per unit Total Variable Costs per Unit Results A& MIN E Type here to search 2. A 99 4 160000000 Results Total Sales in Dollars Contribution Margin Per Unit Breakeven in Units Breakeven in Dollars: Margin of Safety in Dollars Margin of Safety in Units Degree of Operating Leverage income 160000000 130 $ 14,954 $ 11,963,200 $ 148,036,800 $ 185,016 160000000 115 16901 13523200 146-175800 183096 160000000 145 134407 1 0926705 152073295 186593 14954 11963200 14614500 182016 S $ 24,056,000 21056000 27036000 2376900 CVP Analysis Type Beach ER