Question: please do #3 GIVEN INFORMATION begin{tabular}{|c|r|} hline GIVEN INFORMATION & January hline Budgeted Unit Sales & 3,000 hline & $160 hline Budgeted


GIVEN INFORMATION \begin{tabular}{|c|r|} \hline GIVEN INFORMATION & January \\ \hline Budgeted Unit Sales & 3,000 \\ \hline & $160 \\ \hline Budgeted Selling Price & \\ \hline & 10% \\ \hline Ending Invenory (finished units) \% of next month's sales & 3 \\ \hline Pounds of materials required per unit produced & $6 \\ \hline Expected purchase price of materials (per pound) & 2 \\ \hline Direct labor hours required per unit produced & $25 \\ \hline Expected Hourly Labor Rate & $17 \\ \hline Variable manufacturing overhead rate per unit produced & $36,000 \\ \hline Fixed manufacturing overhead per month & $15 \\ \hline Variable selling \& administrative expense per unit sold & $44,000 \\ \hline Fixed selling \& administrative expense per month & \end{tabular} \begin{tabular}{|c|r|} \hline GIVEN INFORMATION & February \\ \hline Budgeted Unit Sales & 2,800 \\ \hline Budgeted Selling Price & $160 \\ \hline \end{tabular} \begin{tabular}{|c|r|} \hline GIVEN INFORMATION & March \\ \hline Budgeted Unit Sales & 3,200 \\ \hline Budgeted Selling Price & $160 \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline GIVEN INFORMATION & April \\ \hline Budgeted Unit Sales & 3,400 \\ \hline Budgeted Selling Price & $160 \\ \hline \end{tabular} 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. 4. Using the information on the "Variances" Worksheet, prepare the contribution margin style income statement (Actual results)for the first quarter of the year. Also, determine the degree of operating leverage (DOL) and margin of safety (MOS) at this level of sales. 5. Using the information on the "Variances" Worksheet, prepare the flexible budget contribution margin style income statement and flexible budget variances. When determining the variances, you should use "@IF" to properly classify the variances as either favorable or unfavorable. Budgeted Income Statement
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
