Answered step by step
Verified Expert Solution
Link Copied!

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 image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: J. David Spiceland, Wayne Thomas, Don Herrmann

3rd edition

9780077506902, 78025540, 77506901, 978-0078025549

Students also viewed these Accounting questions