1. Please help with this break even and profit/loss problem

Recommended time: 20 minutes Step 1: Open a blank Excel spreadsheet. DO NOT USE A TEMPLATE Step 2: Use Excel to solve the following problem A sporting goods company wants to introduce a new product (tennis balls) that can be sold at a price of $45.00 per package of five balls. The cost to produce each ball is $5, and the equipment necessary for production must be leased for $55,000. The sales forecast says that 14,000 balls can be sold. Create a spreadsheet formatted like the video example in class to determine the break-even point and profit/loss? Step 3: Type your answer to the following on your spreadsheet below your calculations: Will the company make a profit? If so, how much? If you were the manager, would you decide to take on this project given the costs versus the projected profit? Why? No more than 2 sentences. Step 4: Save your file as lastnamebreakeven (You must save your file to your computer's desktop rather than to the cloud. If your file begins with a "$", this means that it is a temporary file, and I will not be able to open it, which results in 0 points.) Recommended time: 20 minutes Step 1: Open a blank Excel spreadsheet. DO NOT USE A TEMPLATE Step 2: Use Excel to solve the following problem A sporting goods company wants to introduce a new product (tennis balls) that can be sold at a price of $45.00 per package of five balls. The cost to produce each ball is $5, and the equipment necessary for production must be leased for $55,000. The sales forecast says that 14,000 balls can be sold. Create a spreadsheet formatted like the video example in class to determine the break-even point and profit/loss? Step 3: Type your answer to the following on your spreadsheet below your calculations: Will the company make a profit? If so, how much? If you were the manager, would you decide to take on this project given the costs versus the projected profit? Why? No more than 2 sentences. Step 4: Save your file as lastnamebreakeven (You must save your file to your computer's desktop rather than to the cloud. If your file begins with a "$", this means that it is a temporary file, and I will not be able to open it, which results in 0 points.)