Please explain steps for excel

1) A production manager at The Bama Companies is trying to determine which of three production processes to implement to produce a new product line of buttermilk biscuits. Process A would entail a variable cost of $17 per unit and an annual fixed cost of $150,000. Process B would entail a variable cost of $11 per unit and an annual fixed cost of $250,000. Process C would entail a variable cost of $20 per unit and an annual fixed cost of $180,000. a) Develop three separate models in a spreadsheet (use the given excel template, the solved excel sheet is your solution for this problem) to calculate the total cost for each process. The models must be flexible and able to calculate total cost for any quantity produced. b) Create a cost-volume graph that shows total cost lines for all three options (use a volume of 1,000 units). c) Interpret the cost-volume graphs. Cost-volume analysis Cost-volume analysis Data Fixed cost Varia e cost 2 Volume (optional) D 1 Results Breakeven points Av. B Avs Dollars 3 DB DA A B C Volume analysis units Total Cost 0 0 0 CV Graph Units B 0 0 0