Verizon LTE 4:44 PM 67% Spreadsheets Undo Project 2 Su17 Proj 2 0 points Accounting 202 PROJECT 2 CVP ANALYSIS Enter the lnt 4 digits of your student ID mumber These digits will be uned to for some varales it Lowest other than Round alf doWar amounts to whole dollars, except for per unit anounts, Per unit amounts should be rounded to thr nearest cent Percentages ahould be rounded as pollo, 20.75% er 2075 De not change rows or colums on this spreadsheet. Input annes are in yelwaw You MUST show your work in the ernas indvicated to get credit for the proble 14 Presented below Trident Company's Income Statement prepared on the traditional (functionalj ba 6Requirement 1: Replace the two unknown amounts (h in A. and & an directed. To fied the unhneen for you wll have to complete Requirement 2 Then, complete the totals on the income stanement Trident Company Income Statement For the Year Ended December 31,2016 150,000.00 540,000.00 2 500 Direct Labor Manufacturing Overhead (mixed 173,500 Gress Margi Operating Espees vartable Mutiply the HIGHESTdigit entered above bove by 1,000 and enter here enter the resalt sing thaed B, Complete Rewrement 2 below and insert result Sales and Admiistrative Salanies ffixed atal Operating Expenses Net Operating Income osw) ing price per urt's $14 and warable manufacting overhead$1 per unit All vnele reperon in be carpany-ary n terms of units sold. There was ne change in beginning or ending leventories. Tnderns plan capacity is 4000 units per Requirement Z Blking cots for the past 5 years, along with total units sold follown 2,000 22,750 ,290.00 ube the high low method to calolate the following b. Total fixed bisingcots C. Total cost equation for billing conts d. Detemnine the total nunber of units currently being wold. Then determintotal bilis costs lor h eof Insert your answer for ZH in the income statement above in the blank previded for Bing (UnknownB The company has been operating at a los for several years Managenment is trying to determine wat it can do to mahe nt Verizon LTE 4:44 PM 67% Spreadsheets Undo Project 2 Su17 Proj 2 0 points Accounting 202 PROJECT 2 CVP ANALYSIS Enter the lnt 4 digits of your student ID mumber These digits will be uned to for some varales it Lowest other than Round alf doWar amounts to whole dollars, except for per unit anounts, Per unit amounts should be rounded to thr nearest cent Percentages ahould be rounded as pollo, 20.75% er 2075 De not change rows or colums on this spreadsheet. Input annes are in yelwaw You MUST show your work in the ernas indvicated to get credit for the proble 14 Presented below Trident Company's Income Statement prepared on the traditional (functionalj ba 6Requirement 1: Replace the two unknown amounts (h in A. and & an directed. To fied the unhneen for you wll have to complete Requirement 2 Then, complete the totals on the income stanement Trident Company Income Statement For the Year Ended December 31,2016 150,000.00 540,000.00 2 500 Direct Labor Manufacturing Overhead (mixed 173,500 Gress Margi Operating Espees vartable Mutiply the HIGHESTdigit entered above bove by 1,000 and enter here enter the resalt sing thaed B, Complete Rewrement 2 below and insert result Sales and Admiistrative Salanies ffixed atal Operating Expenses Net Operating Income osw) ing price per urt's $14 and warable manufacting overhead$1 per unit All vnele reperon in be carpany-ary n terms of units sold. There was ne change in beginning or ending leventories. Tnderns plan capacity is 4000 units per Requirement Z Blking cots for the past 5 years, along with total units sold follown 2,000 22,750 ,290.00 ube the high low method to calolate the following b. Total fixed bisingcots C. Total cost equation for billing conts d. Detemnine the total nunber of units currently being wold. Then determintotal bilis costs lor h eof Insert your answer for ZH in the income statement above in the blank previded for Bing (UnknownB The company has been operating at a los for several years Managenment is trying to determine wat it can do to mahe nt