This case study is about a small manufacturing company. The concepts covered are flexible budgets. contribution margin, fixed and variable costs, budgeting, profitability, analysis, variances and business decisions.
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); this allows for partial credit if possible.