calculating costs, revenue and profitI'm having a hard time writing formulas for the following areas on cell phone planning data. The three columns I need are:
- Cost column showing the total cost of each customer
- Revenue column showing the total revenue for each customer.
- Profit column showing revenue minus costs for each customer.
each line has a $10 fixed cost and $5 for voicemail. Not all customers have VM. costs are fixed at $28 per customer and marginal costs are equal to 20% of all total charges.
Any suggestions on how to write these?
Re: calculating costs, revenue and profitWhat's in your data table to start with?
