second picture is the format, plz need it on excel with same format and plz include formulas and cell references, please and thanks.

Flexible Budgets, Overhead Cost Variances, and Management Control Fixed overhead variance analysis Your taco truck is testing out producing tortillas for distribution to upscale grocery stores. Currently, you have been producing and distributing tortillas for a 3 month testing period. It is now the fourth month, and your team must perform an analysis to determine what changes are necessay moving forward. Your truck has two direct-cost categories: direct materials and direct labor and allocates fixed overhead to products on the basis of standard direct labor-hours. The following is some budget data your team put together prior to starting tortilla production. The following is additional information for your truck's tortilla adventure for the past three months: 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 you will be marked wrong. Requirements 1 Prepare a variance analysis of fixed overhead cost. Use the exhibit that shows the variance analysis of fixed overhead cost as a guide. 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. 2 Is fixed overhead underallocated or overallocated? By what amount? a. Use the ABS function when calculating the underallocated or overallocated amount.) Saving & Submitting Solution 1 Save file to desktop. 2 Upload and submit your file to be graded. a. Navigate back to the assignments page in Canvas b. Click the assignment for Taco Truck Round-Up FOH c. Attach your file d. Click Submit 1. Prepare a variance analysis of fixed overhead cost. Use the exhibit that shows the variance analysis of fixed overhead cost as a guide. 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 instructions tab you will be marked wrong-1 2. Is fixed overhead underallocated or overallocated? By what amount? a. Wse the ABS function when calculating the underallocated or overallocated amount. (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-)