Project 2 Su17 (1) Excel FILE HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEW VIEWPOWER QUERY Nicole Ward send Feedback Help Catalog From From From From Online From Other Recent From Merge Append ShLaunch Data Source Options Update Data Catalog web File. Database Services* Sources* Sources* Table Pane Editor Settings Get Extemal Data Excel Data Combine mbine Workbook Queries Power Bl 6 Enter the last 4 digits of your student ID number: (These digits will be used to for some variables in the project) 8 Save this file in EXCEL FORMAT as: P2Lastname 9 Round all dollar amounts to whole dollars, except for per unit amounts. Per unit amounts should be Lowest other than 0- 10 rounded to the nearest cent. Percentages should be rounded as follows: 20.75% or .2075 11 Do not change rows or colums on this spreadsheet. Input areas are in yellow. 12 You MUST show your wonk in the areas indicated to get credit for the problem. 13 14 Presented below is Trident Company's Income Statement prepared on the traditional (functional) basis: Highest- 16 Requirement 1: Replace the two unknown amounts (?) In A, and B. as directed. To find the unknown for B, you ll have to 17 complete Requirement 2. Then, complete the totals on the income statement. 20 21 Trident Company Income Statement For the Year Ended December 31, 2016 $350,000 Sales Cost of Goods Sold 23 24 25 26 27 28 Direct Materials (variable) Direct Labor (variable) Manufacturing Overhead (mixed) $60,000 64,000 175,500 173,500 Gross Margin Proj 2 - + 100% 812 PM Type here to search