P20uy @su. Draw Page Layout Home Insert Formulas Data Review View 11 Calibri (Body) BIL AA EEE P Wiap Text EE332Merge & Center Custom $ % A 535 fe? 40 points Accounting 202 PROJECT 2 CVP ANALYSIS Mackenzie Guy 5 Enter the last 4 digits of your student ID number Lowest other than 3 Save this Alein EXCEL FORMAT as testem Round all dollar amount to whole dollars cap for per unit amounts Per unit amounts should be o rounded to the nearest cent. Persentepes should be rounded as follows: 20.75 0.2075 1 Do not changerowo column this spreadsheet. Inputarere in yellow 2 You MUST show you work in the areas indicated to get credit for the problem 4 Presented below is Trident Company's income statement prepared on the traditional GAP absorption costing basis 6 Requirement 1: Replace the two unknown amounts( Pina and b. as directed. To find the unknown forb. you will have to complete Requirement 2. Then, complete the totals on the income statement $350.000 Trident Company Income Statement for the Year Ended December 31, 2018 Sales Cost of Goods Sold Direct Materials variable) Direct Laborwariable Manufacturing Overhead mixed) $60.000 176.500 Gorg Operating Experts Commissions variable Shipping variable a. Multiply the HIGHEST digtentered above above by 1.000 and enter here enter the result Paco 2 Advertising wed) Bling mixed) Sales and Administrative Salaries fred Total Operating Expenses lb. Complete Requirement below and insert result Net Operating income 42 Selling price per unit is $14 and variable manufacturing overhead is si perunik Allwariable expenses in the company vary in terms of 43 units ald. There was no change in beginningar ending interes Tridenplant capacity is 40.000 units per year the relevant rangel. - Proj 2 MacBook Air @SU. P2Guy Home Insert Draw Page Layout Formulas Data Review View = == was text Custom Calibri (Body B 9 - 11 A A -24 12Merye & Center S p 42 43 r chargi ematuring All aber in the comgrywaring n g er ending inventories Tidensplant capacity 0.00 per wher e . There 45 How many product o rdentli 2017 cows for the yearswong with total un d blows saw the method to calculate the following Vabibulling copert 58 Totad billing costs 61 Total costation for billing costs 61 Determine tolling costs for 2018 on the cost insert your answer for in the income statement ove in the bank provided for ng Unknown company has operating sales for several years. Management is trying to determine what can do to make not year profile provided belo 7 do Trident 2018 income wat in contribution format showing both a total column and pericolums in the You MUST e l s and references in the income statements in Requirements and stee l credit. Wind You will need to the wariable and fed components of Manufacturing Overhead (MO) and willing O Couts in Die VOH GOMOR M OR Proja MacBook Air P20uy View 55. Insert Draw Page Layout libri (Boon - 11 BT -- Formulas - AA A Data Review === E Po w alet Emerges Center Custom $ % 9 3 provided 2018 incom m ent in contribution form.howing both to come da per unit eum in the dellence in the income men u irements and stoc Micredit t: You need to calculate the variable and components of Manufacturing Overhead MOH l ing Hint Divide total cos com bo ns to get ve per unit Int: O MOH besi per the remaining MO must bewed Sales commissions Variable billing Variable Cost per unit is the me l e coperit you found in de bove Red Costs we MO 91 Advertising 92 Sales and m 90 biling awries 95 Net Operating income 98 Regiment 99 Calea Tridecurrentbreven point in both units Pade 2 113 Mugly the lowest other than retrom the last four digtrefyour studentimber by 10.000 and MacBook Air P2Guy 5.5. Page Layout Home Insert Draw Formulas Data Review View Calibri (Body) 11 = = P 2 AA A = E Wrap Text Merge & Center Custom $ -% 3.43 Requirements: number by 10,000 and u Multiply the lowest other than retrom the last four digits of your student 314 enter for below to get the reduction in advertising 116 a The vice president pests that selling price be lowered by andering be reduced by C 117 Sheis.confident that this action will increase sales by 10,000 units The new selling priceprice per unit would be 120 The new advertising amount would be 124 129 132 114 17. Prepare a row.seruitioner incomestatement there redentorecommendationem ha. 138 totalwariable costs change proportionately. To get total variable costs, multiply the per unit amounts from Requirement by then 139 number of unit Remember, VC per unit remains constant) 140 145 Variable Costs 146 Direct materials 147 Direct Labe 148 Viale MOH 149 Sales commissions 152 Total Variable Costa 151 Contribution Margin Proj2 MacBook Air P2Guy 55. Draw Page Layout Home Insert Formulas Data Review View E E 26 Wrap Text LL Calibri (Body) BIU 11. AA AA E Custom $ % 93 - 3. Merge & Center fx ? 148 Variable MOH 249 Sales commissions 150 Shipping 151 Variable billing 152 Total Variable Costs 153 Contribution Margin 154 Red Costs 156 Advertising 157 Sales and admin salaries 158 ued billing 159 Total Fixed Costs 160 Net Operating income 163 Requirement: 164 Using the budgeted income statement based on the viceprent proposalsbove, calculate the Page 3 180 Requirement: 181 C h edegree of operating l 182 A should use two decimal place aging the vice president's proposed income matowe 189 volumen 10. ingin Proja MacBook Air 1 20 P200 Data Review View Home Insert @ 50. Draw Page Layout Formulas Calibri (Body) 11 HA A BI - A E = = Wrap Text Merge & Center Custom $ % Pune G35 173 C. Margin of: 176 d. Margin of 180 Requirement: 181 Calculate the degree of operating leveraging the vice president's proposed income statement 182 Answer should use two decimal places Ifules volume increase 10%, operating income will increase by Pro2 MacBook Air