Given Information Budgeted unit sales Budgeted selling price \begin{tabular}{|c|c|c|c|} \hline January & February & March & April \\ \hline 3,000 & 2,800 & 3,200 & 3,400 \\ \hline$160 & $160 & $160 & $160 \\ \hline \end{tabular} Ending inventory (finished units) \% of next month's sales Pounds of materials required per unit produced Expected purchase price of materials (per pound) Direct labor hours required per unit produced Expected hourly labor rate Variable manufacturing overhead rate per unit produced Fixed manufacturing overhead per month Variable selling \& administrative expense per unit sold Fixed selling \& administrative expense per month 10% 3 $6 2 $25 $17 $36,000 $15 $44,000 1. Create a revenue budget for January, February, March, and the quarter as a whole on the "Revenue Budget" Worksheet 2. Create a production budget for January, February, March, and the quarter as a whole on the "Production Budget" Worksheet 3. Create a budgeted contribution margin style income statement for January, February, March, and the quarter as a whole on the "CM income statement" Worksheet. Keep in mind that expenses on the income statement are based on the number of units sold, not the number of units produced