Picture This, Inc. Additional information: Ending finished goods inventory should be 40 percent of the next month's sales Ending direct materials inventory should be 30 percent of the next month's production Picture This Inc Requirement 1: Sales budget Budgeted sales (units) Unit sales price Budgeted sales revenue \begin{tabular}{cccc} April & May & Jund Quarter \\ \hline & & \\ \hline \end{tabular} Requirement 2: Production budget April May June 2nd Quarter Budgeted sales (units) Ending finished goods inventory Beginning finished goods inventory Budgeted production \begin{tabular}{cccc} April & May & June & 2nd Quarter \\ \hline & & \\ \hline \end{tabular} Requirement 3: direct materials purchases budget Budgeted production Material requirements per unit Total material needed for production Ending direct materials inventory Beginning direct materials inventory Budgeted direct materials purchases Material cost per foot Budgeted cost of direct materials purchases April May June 2nd Quarter \begin{tabular}{l|ll} \hline April & May & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Requirement 4: Direct labor budget April May June 2nd Quarter Budgeted production Direct labor requirements per unit Direct labor hours required Direct labor rate Budgeted direct labor cost \begin{tabular}{cccc} April & May & June & 2nd Quarter \\ \hline & & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Requirement 5: Manufacturing overhead cost budget Budgeted production Variable manufacturing overhead rate Budgeted variable manufacturing Fixed manufacturing overhead Budgeted manufacturing overhead April May June 2nd Quarter \begin{tabular}{l|ll} \hline & May & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Requirement 6: Budgeted cost of goods sold Budgeted Manufacturing Costs Per Unit Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Budgeted manufacturing cost per unit Budgeted sales (units) Budgeted manufacturing cost per unit Budgeted cost of goods sold \begin{tabular}{cccc} April & May & June & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Requirement 7: Selling and administrative expense budget Budgeted sales (units) Variable selling and administrative rate Budgeted variable selling and administrative expenses Budgeted fixed selling and administrative expenses Total budgeted selling and administrative expenses April May June 2nd Quarter \begin{tabular}{l|l|l|} \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular}