R & S Flexible Budget

\begin{tabular}{|l|r|r|r|} \hline & Master Budget & \multicolumn{1}{|c|}{ Actual } & \multicolumn{1}{|c|}{ Variance } \\ \cline { 2 - 3 } & Units & 350,000 & 335,000 \\ \hline Sales & 3,500,000 & 3,350,000 \\ \hline Variable Costs: & & & \\ \hline Utilities & Maintenance & 70,000 & 76,000 \\ \hline Supplies & 42,000 & 39,000 \\ \hline Variable Payroll & 420,000 & 390,000 \\ \hline 0 Total Variable Costs & 2,040,000 & 1,980,000 \\ \hline 1 & Contribution Margin & 2,572,000 & 2,485,000 \\ \hline 2 & Fixed Costs: & 928,000 & 865,000 \\ \hline 3 & Management Salaries & 720,000 & \\ \hline 4 & Rent & 40,000 & 720,000 \\ \hline 5 & Depreciation & 85,000 & 40,000 \\ \hline 6 & Total Fixed Costs & 845,000 & 85,000 \\ \hline 7 & Operating Income & 83,000 & 845,000 \\ \hline \end{tabular} Flexible Budget \begin{tabular}{l|l|l|l|l|l|l} \hline Rate & Flex Budget & Actual & Variance & % Var & Fav/Unfav & Investigate? \\ \hline & & & & \end{tabular} Units Sales Variable Costs: 5 Utilities 6 Maintenance Supplies 8 Variable Payroll 9 Total Variable Costs 0 Contribution Margin Fixed Costs: 2 Management Salaries 3 Rent 4 Depreciation 5 Total Fixed Costs 6 Operating Income