Exercise 4 You have a company producing units of Product A. Your fixed costs for a year are S100,000. The cost of making one unit is $3.40. You can sell a unit for $5.00. Assume you can sell as many units as you produce. If you make 100,000 units per year how much profit will you make? Create a worksheet to answer this question. Have the total cost and the total sales (and the difference - the profit) included. NOTE THAT YOU CAN TYPE COMMAS IN NUMBERS TO INDICATE THE BREAKS AT THOUSANDS AND MILLIONS FOR EXAMPLE, TYPE '1,000,000' IN A CELL AND EXCEL WILL DISPLAY THE COMMAS BUT WILL IGNORE THEM WHEN DOING CALCULATIONS. THIS MAKES LARGE NUMBERS EASIER TO READ AND REDUCES THE CHANCES OF ERRORS BEING MADE Use Goal Seek to determine how many units you need to produce in order to break even (i.e. to have zero profit) Use Goal Seek to determine what the lowest selling price is for you to break even if you sell 100,000 units per year