; Project 2 Su17- Excel FILE HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEW VIEW POWER QUERY Nicole Ward S Cut Calibri Wrap Text General Fill Clear Copy Paste Conditional Format as Cell Insert Delete Format ormatting TableStyles- Sort &Find& 1 u. A Merge & Center. $. % , em tstE Format Painter Filter Select Font Alignment Cells Editing 14 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 18 complete Requirement 2. Then, complete the totals on the income statement. Trident Company Income Statement For the Year Ended December 31, 2016 Sales Cost of Goods Sold $350,000 $60,000 Direct Materials (variable) Direct Labor (variable) Manufacturing Overhead (mixed) 24 25 64,000 176,500 173,500 27 28 Gross Margin Proj 2 - + 100% 10:11 PM Type here to search ^4, 7/17/2017 ea