Assume the demand for a company's drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can pro- duce x units of Wozac per year, it will cost $16x. Each unit of Wozac is sold for $3. Each unit of Wozac pro- duced incurs a variable production cost of $0.20. It costs $0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years. Status Single DATA TABLE Total Tax Payments Taxable income $ $ 8,342 55,060.00 20,000 30,000 40,000 Total Tax $ 7,972 Refund Amount Amount Owed Use Goal Seek to find the Taxable income (C5) that results in the Total Tax (C7) shown. Answer to the nearest 0.01. Do not include any punctuation ($ or.) in your answer! Example of accepted answer: 12345.67 Examples of incorrect answers: $12,345.67, 12,345.67 $12345.67 Taxable income Total Tax Payments $2,600 $4,200 $8,500 $10,500 $22,000 The Quick Gas Company is planning to open a new convenience store to expand their operations on the north side or owney have identified two locations that meet their criteria for traffic density and ease of access. The first is on Queen Street, and the second is on Gerard Avenue. The Queen Street location is listed available for sale for $550,000. The Gerard Avenue location is available for sale for $375,000, The value of the two locations depends upon the results of two decisions that are being made by politicians. The first is that the county has offered some taxtincentives for a company to build a grocery distribution warehouse that would employ approximately 2,200 people in the area near the Queen Street location. The second is that a multi-year construction project is being considered on Gerard Avenue that would depress traffic. Quick Gas has estimated the financial impact of the political decisions, and forecast the potential income from the two locations for each scenario. The results are shown in the table below, which does not include the cost of the property above or the $850,000 cost to build the convenience store, No Warehouse No Warehouse Warehouse Warehouse No Construction Construction No Construction Construction Queen Street $1,350,000 $1,420,000 $1,680,000 $1,770,000 Gerard Avenue $1,600,000 $1,300,000 $1,650,000 $1,350,000 Probability 12% 28% 18% 42% Find the net income for each outcome and decision by including the costs to purchase the property and build the convenience stores Answer to the nearest dollar. Do not include any punctuation ($ or in your answer! Examples of accepted answers: 12345, -12345 Examples of incorrect answers: $12,345, 12,345, $12345, -12,345, (12345), ($12345) No Warehouse No Warehouse Warehouse Warehouse No Construction Construction No Construction Construction Queen Street Gerard Avenue Find the expected value of each location. Answer to the nearest dollar. Do not include punctuation ($ or in your answer. Queen Street: Gerard Avenue: Which location should the Quick Gas Company choose based on the expected value method of decision making? Queen Street OGerard Avenue 11 f you are getting errors, check to make sure you have not entered any extra symbols (sor, or "spaces) in your answer. This question uses the Excel file 03 -Tax Calculations (xlsx).