This case study is about a small manufacturing company. The concepts covered are contribution margin, fixed and variable costs, breakeven point, business decisions related to fixed and variable costs, and analysis of business decisions and results.
Each question refers to the same initial data. Treat each question separately. Ignore income taxes. Assume no beginning or ending inventories. Calculations and backup should be completed and submitted in Excel. Use proper Contribution Income Statement formatting. Analysis can either be typed into cells in Excel (formatted to be easily legible) or typed into a text box in Excel. Leave any formulas used in the Excel files (do not hard code or type in results);
The submission will be one Excel file covering all parts of the Case Study (multiple tabs can be used if desired). Only one Excel file should be submitted. No word documents or any other file types.