Using Excel and showing Formulas please help answer this question

Your company is deciding whether to bottle Vermont Grade A maple syrup in-house or outsource to the local Maple Co-op. The estimated yearly production is 5,000 gallon bottles of delicious syrup. The in-house fixed costs include the purchase of bottling equipment which is estimated at $100,000. The variable costs for direct labor and materials include bottles, caps, and training a new employee to run the machine are estimated at $10 per bottle. The maple Co-op charges $20 per bottle (total landed cost).

Based on the 5000 gallon forecasted demand, which option would cost less?

Assume each bottle is sold for $27 each. What would be the payback period if we chose the in-house option (still at 5000 annual units)?

At what quantity (Break Even) would both options be equal?