The purpose of this assignment is to evaluate and prepare a flexible budget.
Resources: Excel File. Tutorials and links to Excel® help files are located via the week one Excel activity.
1. Download the Excel file posted to the week 6 projects thread.
2. Read the instructions tab.
3. Complete the flexible budget tab.
4. Submit the completed Excel file to the assignments tab.
Based on the example, fixed expenses do not change with volume. Contrary, variable expenses change with volume. With respect to the case study the same principles apply. The only difference is that our variables expenses will change based on sales volume instead of machine hours.
Sales Volume 2,850
Feed cost per animal 3.23
Total feed cost = 2,850*3.23=9,206
Advertisement is a fixed expense at the 2,850 volume level (column F). However, the expense is considered a mixed cost (fixed and variable) with the second budget (column H).
For further clarification my suggestion is to read the instructions tab, row 35.