If you can please show the excel functions as well. Thank you
A B D E F. G H j 1 Flexible Budgets, Overhead Cost Variances, and Management Control 2 Variable Manufacturing Overhead Variance Analysis w N 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: 4 11 5 6 Direct manufacturing labor use 0.02 hours per baguette 7 Variable manufacturing overhead $10.00 per direct manufacturing labor-hour 8 9 The Sourdough Bread Company provides the following additional data for the year ended December 31, 2020: 10 Planned (budgeted) output 3,100,000 baguettes 12 Actual production 2,600,000 baguettes Direct manufacturing labor 46,800 hours 14 Actual variable manufacturing overhead $617,760 15 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 Instructions tab 17 you will be marked wrong. 18 13 E F G H A B 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 budgeting?) 1 (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste 2 from the Instructions tab you will be marked wrong.) 3 4 hours 5 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 prior calculations, if 7 applicable.) 8 Flexible Budget: Budgeted Input Allocated: Budgeted Quantity Allowed for Input Quantity Allowed Actual Output x for Actual Output x Budgeted Rate Budgeted Rate Actual Input Quantity x Budgeted Rate Actual Costs Incurred: Actual 9 Input Quantity x Actual Rate 10 11 12 Spending variance 13 Efficiency variance 14 Flexible-budget variance 15 16 17 A B D E F. G H j 1 Flexible Budgets, Overhead Cost Variances, and Management Control 2 Variable Manufacturing Overhead Variance Analysis w N 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: 4 11 5 6 Direct manufacturing labor use 0.02 hours per baguette 7 Variable manufacturing overhead $10.00 per direct manufacturing labor-hour 8 9 The Sourdough Bread Company provides the following additional data for the year ended December 31, 2020: 10 Planned (budgeted) output 3,100,000 baguettes 12 Actual production 2,600,000 baguettes Direct manufacturing labor 46,800 hours 14 Actual variable manufacturing overhead $617,760 15 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 Instructions tab 17 you will be marked wrong. 18 13 E F G H A B 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 budgeting?) 1 (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste 2 from the Instructions tab you will be marked wrong.) 3 4 hours 5 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 prior calculations, if 7 applicable.) 8 Flexible Budget: Budgeted Input Allocated: Budgeted Quantity Allowed for Input Quantity Allowed Actual Output x for Actual Output x Budgeted Rate Budgeted Rate Actual Input Quantity x Budgeted Rate Actual Costs Incurred: Actual 9 Input Quantity x Actual Rate 10 11 12 Spending variance 13 Efficiency variance 14 Flexible-budget variance 15 16 17
