Unit 2 Assignment - Cost Volume Profit Submi Assignment ents Due Sunday by 11:59pm Points 80 Submitting a text entry box or a file upload Instructions In this assignment we will explore Cost-Volume-Profit (CVP) which examines how costs behave Specifically, we will look at fixed and variable costs to see how changes in each affect profitability. Download the assignment template and complete the problems on each tab. In this assignment Problem 1 - Basic CVP problem Problem 2 - Intermediate CVP Problem Problem 3 - Advanced CPV Problem Problem 4 - Mixed Cost problem Assignment Objectives Differentiate between the available costing methods. Deliverables When you have finished, rename the file using your first initial, last name, course number and assignment number (for example "Doe_AC306_A2.xlsx"). Estimated time to complete: 4 hours Assignment File(s) Excel File Edit View Insert Format Tools Data Window ) 62% Tue 8:29 PM Q E Help AC306 Unit 2 Assignment template Home View + Share a Insert Page Layout Calibri (Body) Formulas AA Data = Review = = 16 General ErWrap Text Marge & Center Ba d Datute 49 Paste $ 94 Conditional Format Formatting as Table Styles Format - Sort & Filter A6 E x fx Problem 3 A B C D 1 Enter titles and accounts in the green cells Enter Numbers in the blue cells 3 Enter your calculations in the yellow cells Unit 2 Cost Volume Profit 6 Problem 3 Frost Fre Company is analyzing two alternative methods of manufacturing is custom snowboards. The Managerial Accountant has performed an analysis that indicates that variable costs can be reduced 40X by Installing a machine that would automate production, but fed costs would increase to $675,000. Analysis 1 shows costs before Installing the machine: Analysis 2 shows costs after the machine installed. If Analysis 2 is selected, Management would like to reduce the sales prkes by half the savings of the variable costs to be more competitive in the marketplace For both options: 1 Calculate the contribution margin 2 Calculate the contribution margin ratio a Calculate the break even in units and in sales $ 4 Prepare a CVP Income Statement, assme that Frost Fire's projects sales of 75,000 units s Recommend which alternative Frost Fire should choose Analysis 2 Analysis 1 Variable 5125 Fixed costs $475,000 Selling $350 Income tax 25% $550.000 25% $350 Analysis 1 Per Unit Units Sales Varishlarnetel Problem 2 Problem 3 Problem 4 Analysis 2 Per Unit Units 1 Sales Varishlarnet Resources Problem 1 Count: 2 -- + 100% Ready RJUU UMIL 2 A551Merilerde View Review = = : Insert - insert Page Layout Formulas Data Calibri (Body) - 11 A- A = BI U A E 1x v fox Ep Wrap Text Merge & Center General $ % * Delete- 3 & Conditional Format Cell CVP Income Stmt Total # Units 7,500 Sales $ Variable costs $ Contribution Margin $ Fixed Costs $ Net Income $ CVP Income Stmt Total # Units 7,500 Sales $ Variable costs $ Contribution Margin $ Fixed Costs $ Net income $ 5 Recommendation Problem 1 Resources Problem 1 Problem 2 problema Problem 4 Problem 3