Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
please include formulas GIVEN INFORMATION begin{tabular}{|c|c|c|} hline multicolumn{2}{|l|}{ GIVEN INFORMATION } & January hline multicolumn{2}{|c|}{ Budgeted Unit Sales } & 3,000 hline multicolumn{2}{|c|}{
please include formulas GIVEN INFORMATION \begin{tabular}{|c|c|c|} \hline \multicolumn{2}{|l|}{ GIVEN INFORMATION } & January \\ \hline \multicolumn{2}{|c|}{ Budgeted Unit Sales } & 3,000 \\ \hline \multicolumn{2}{|c|}{ Budgeted Selling Price } & $160 \\ \hline \multicolumn{2}{|c|}{ Ending Invenory (finished units) \% of next month's sales } & 10% \\ \hline \multicolumn{2}{|c|}{ Pounds of materials required per unit produced } & 3 \\ \hline \multicolumn{2}{|c|}{ Expected purchase price of materials (per pound) } & $6 \\ \hline \multicolumn{2}{|c|}{ Direct labor hours required per unit produced } & 2 \\ \hline \multicolumn{2}{|c|}{ Expected Hourly Labor Rate } & $25 \\ \hline \multicolumn{2}{|c|}{ Variable manufacturing overhead rate per unit produced } & $17 \\ \hline \multicolumn{2}{|c|}{ Fixed manufacturing overhead per month } & $36,000 \\ \hline \multicolumn{2}{|c|}{ Variable selling \& administrative expense per unit sold } & $15 \\ \hline \multicolumn{2}{|c|}{ Fixed selling \& administrative expense per month } & $44,000 \\ \hline \multicolumn{2}{|l|}{ GIVEN INFORMATION } & February \\ \hline \multicolumn{2}{|c|}{ Budgeted Unit Sales } & 2,800 \\ \hline \multicolumn{2}{|c|}{ Budgeted Selling Price } & $160 \\ \hline \multicolumn{2}{|l|}{ GIVEN INFORMATION } & March \\ \hline \multicolumn{2}{|c|}{ Budgeted Unit Sales } & 3,200 \\ \hline \multicolumn{2}{|c|}{ Budgeted Selling Price } & $160 \\ \hline \multicolumn{2}{|l|}{ GIVEN INFORMATION } & April \\ \hline \multicolumn{2}{|c|}{ Budgeted Unit Sales } & 3,400 \\ \hline \multicolumn{2}{|c|}{ 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
please include formulas
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started