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 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 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
