Use word or Excel for the solution, explain all the steps clearly The CFO of Phoenix Industries
No answer yet for this question.
Ask a Tutor
Question:
Use word or Excel for the solution, explain all the steps clearly
The CFO of Phoenix Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs.
- Determine fixed and variable costs using the high-low method and prepare graph. You can use MS Excel If you wish.
- Draw a graph showing the behavior of maintenance costs and identify the fixed and variable cost elements. Use 100-hour increments and $1,000 cost increments for the graph.
- Draw a scatter plot showing maintenance costs and machine hours for each month.
| Month | Total Maintenance Costs | Total Machine Hours |
| January | $2,500 | 300 |
| February | 3,000 | 350 |
| March | 3,600 | 500 |
| April | 4,500 | 690 |
| May | 3,200 | 400 |
| June | 4,900 | 700 |
Expert Answer:
Posted Date:
