Break-even and contribution margin analysis is an important technique in evaluating and planning for the financial needs of an organization. The use of this analysis allows managers to determine quantified answers to questions about selling volume, price, profits, and other key business components.
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.
All work to problems must be shown.
