Please solve within 10 mins

Question 4 (1 point) A kids wear retailer had Net Sales of $979,555.32 for the first half of the year. Its Cost of Goods Sold were 51.00%. Its Operating Expenses were $350,123.00. Their goal was to achieve a 14.00% Profit. Part A: Calculate the appropriate dollars and percentages for the entire Income Statement. (6 marks) Replicate the table below for this question. Show all calculations including formulas where appropriate. Use the exact format below. Round all numbers to two decimal places AND highlight final answers in BOLD. Use dollar signs and/or percentages where appropriate. Dollar $ Percentage % Net Sales Cost of Goods Sold Gross Margin Operating Expenses Profit OR Loss (Before Taxes) Part B: Did this retailer achieve its profit goal, yes or no? Provide a brief explanation as to why they did or did not achieve their profit goal. (2 marks) Answer this question in your excel spreadsheet using text. O a) Click here when you're ready to move to the next