Requirements: Prepare a flexible Budget using the data given.

produces large flowerpots for urban settings and has provided the following variance data \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Variance Report } \\ \hline \multicolumn{5}{|c|}{ For the month ending June 30} \\ \hline & Actual Results & Planning budget & Variances & \\ \hline Batches & 1600 & 1550 & & \\ \hline Revenue & 504,000 & 480,500 & 23,500 & F \\ \hline \multicolumn{5}{|l|}{ Expenses: } \\ \hline Direct Materials & 62,370 & 46,500 & 15,870 & U \\ \hline Direct Labor & 158,400 & 147,250 & 11,150 & U \\ \hline Manufacturing Overhead & 121,660 & 117,250 & 4,410 & U \\ \hline Selling \& Administrative & 35,000 & 37,400 & (2,400) & F \\ \hline Total Expenses & 377,430 & 348,400 & 29,030 & U \\ \hline Net Operating Income & 126,570 & 132,100 & (5,530) & U \\ \hline \end{tabular}