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.
The case study is worth 50 points. 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. Any other file types or submissions (Word, etc) will be ignored.