Finde Chobaid A1 Cabbri B 3 4 Fant 4 C Alignment Genmal 5-%5148 Munber Flexible Budgets, Overhead Cast Variances, and Management Control D The Sourdough Bread Company bakes baguettes for distribution to upscale grocery stores. The company has two direct-cost categories: direct materials and direct manufacturing labor. Variable manufacturing overhead is allocated to products on the basis of standard direct manufacturing labor hours. Following is some budget data for the Sourdough Bread Company G 5 6 Direct manufacturing labor use 7 8 Variable manufacturing overhead 0.02 hours per baguette $10.00 per direct manufacturing labor-hour 9 The Sourdough Bread Company provides the following additional data for the year ended December 31, 202 10 11 Planned (budgeted) output 12 Actual production 13 Direct manufacturing labor 14 15 3,100,000 baguettes 2,600,000 baguettes 46,800 hours Actual variable manufacturing overhead $617,760 16 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the 17 Instructions tab you will be marked wrong. 18 19 Requirements 20 21 22 1 What is the denominator level used for allocating variable manufacturing overhead? (That is, for how many direct manufacturing labor-hours is Sourdough Bread budgeting?) 2 Prepare a variance analysis of variable manufacturing overhead a. Use the ABS function when calculating variances, and use the drop-down selections for F (favorable) or U (unfavorable) when describing the variances, 23 INSTRUCTIONS Ready Accessibility Investigate Type here to search ENTERANSWERS 22 L 99- 7 8 -utoSave Califon 1415 lontano Cost17e el-23 start Read-Onl General Chipboard AL yent L Alignment Numbr 1. What is the denominator level used for allocating variable manufactur D 1. What is the denominator level used for allocating variable manufacturing overhead? (That is, for how many direct manufacturing labor-hours is Sourdough Bread 1 budgeting?) (Always use cell references and formulas where appropriate to receive full credit. If you 2 copy/paste from the Instructions tab you will be marked wrong.) 3 4 5 hours 6 2. Prepare a variance analysis of variable manufacturing overhead. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Use cell references from 7 prior calculations, if applicable.) 8 Flexible Budget: Actual Costs Incurred: Actual Input Actual Input Quantity x 9 Actual Rate Quantity x Budgeted Rate Budgeted Input Quantity Allowed for Actual Output x Budgeted Rate 10 11 12 Spending variance Allocated: Budgeted Input Quantity Allowed for Actual Output x Budgeted Rate G 13 Efficiency variance 14 Flexible-budget variance 15 INSTRUCTIONS Ready Accessibility Investigate Type here to search ENTERANSWERS P