(Answered) : Please Show Excel Formulas Used Thank Manager Trying Determine Three Production Processes Q35141441

Please show excel formulas used! Thank you! 🙂

A manager is trying to determine which of three productionprocesses to implement to produce a component for a new productline. Process A would entail a variable cost of $17 per unit and anannual fixed cost of $150,000. Process B would entail a variablecost of $11 per unit and an annual fixed cost of $250,000. ProcessC would entail a variable cost of $20 per unit and an annual fixedcost of $180,000.

a. Develop three separate models in your spreadsheet tocalculate Total cost for each process.

           The models must be flexible and able to calculate Total cost