Excel with formulas please and thank you very very much.

Flexible Budgets, Overhead Cost Variances, and Management Control 4-variance analysis, fill in the blanks ProChem, Inc., produces chemicals for large biotech companies. It has the following data for manufacturing overhead costs during August 2017 Variable Fixed $35,000$16,500 15,200 16,000 Actual costs incurred Costs allocated to products Flexible budget Actual input x budgeted rate 36,000 31,500 2 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 3 Instruction tab you will be marked wrong 4 5 Requirement 6 Fill in the blanks on the ENTERANSWERS tab. Use F for favorable and U for unfavorable: a. For variances with a zero amount, leave the box empty; do not select a label or enter a zero b. Use the ABS function when calculating variances, and use the drop-down selections for F or U when describing the variances 8 a. For variances with a zero amount, leave the box empty; do not select a label or enter a zero. b. Use the ABS function when calculating variances, and use the drop-down selections for F or U when describing the variances. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong.) Variable FU Fixed F/U (1) Spending variance (2) Efficiency variance (3) Production-volume variance (4) Flexible-budget variance (5) Underallocated (overallocated) manufacturing overhead