Break-even and contribution margin analysis is an important technique in evaluating and planning for the financial needs of an organization. It is necessary to understand break-even analysis in order to better estimate whether funds may become available to HR managers for initiatives aimed at staffing, developing and rewarding employees. The analysis filters throughout the organization and allows managers to determine quantified answers to questions about selling volume, price, profits, and other key business components, including investments in human resource assets.

For this Application, you will have the opportunity to use these techniques to aid in decision making for the Great Western Outfitters. You will use the information in this week's Resources about contribution margin and break-even analysis to make projections and recommendations for the future of this organization.

You will set up and use an Excel spreadsheet for all your calculations to complete Problems 1 through 6 below. The spreadsheet you develop should be what you turn in for the Application. Note: The Resources section includes tutorials for those who might need help in designing and using an Excel spreadsheet. These resources are also an excellent refresher for experienced Excel users.

Text: Shim, J. K., & Siegel, J. G. (2012). Budgeting basics and beyond (4^th ed.). Hoboken, NJ: John Wiley & Sons

Chapters 4 & 5