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.