5. Printing Instructions: If the solution requires you to use Excel, please submit two copies of your answer sheet, one with the numerical answers and the other with the formulas. To print out a formula view of the Excel sheet, please follow the instructions below: 1. Cllck on Formulos on the Excei Ribbon Click Formulas > Show Formula 3. Cllck File> Print 4. Change setting to Fit Sheet on One Page under the scoing option to avoid Excel Worksheet being Note: If you ore using goal seeker, you don't need to print out a formula sheet for it. Just mention in printed on multiple sheets. your answer which cell references you used to get to the solution. Question 1: A manufacturer is evaluating options regarding his production equipment. He is trying to decide whether he should refurbish his old equipment for $70,000, make major modifications to the production line for $135,000, or purchase new equipment for $230,000. The product sells for $10, but the variable costs to make the product are expected to vary widely, depending on the decision that is to be made regarding the equipment. If the manufacturer refurbishes, the variable costs will be $7.20 per unit. If he modifies or purchases new equipment, the variable costs are expected to be $5.25 and $4.75, respectively. Which alternative should the manufacturer choose if it the demand is expected to be between 30,000 and 40,000 units? b) What will be the manufacturer's profit if the demand is 38,000 units? Question 2