PLEASE INCLUDE THE FORMULAS FOR THE CELLS WHERE POSSIBLE. I will definitely give you thumbs up if u do so.

Themes Scale to Page Setup P21 A B C D E Flexible Budgets and Standard Cost Systems Using Excel to prepare a flexible budget performance report F G Pilchuck Company manufactures tote bags and has provided the following informatio Actual Results Static Budget Units 11,000 12,000 Sales Revenue 368,000 384,000 Variable Costs 183,000 198,000 Contribution Margin 185,000 186,000 Fixed Costs 76,000 77,184 Operating Income 109,000 108,816 Use the blue shaded areas on the ENTERANSWERS tab for inputs. ALWAYS use cell references and formulas where appropriate to receive full credit. If Requirements Prepare a flexible budget performance report, including the heading. Use the variances, and use the drop-down selections for For U when describing the va 2 Calculate the Static Budget Variance for operating income, and label it as a F (f Excel Skills 1 ABS function (Absolute Value) to calculate the variances. 2 Data validation to select a F (favorable) or U (unfavorable) variance 3 Cell references - both absolute and relative 3 Saving & Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS b. Save your solution in the folder you just created; add-solution-date to end Column 1 Column 3 Column 5 Column 2 Col (1) - Col (3) Column 4 Col (3) - Col (5) Budget Amounts per Unit Actual Results Flexible Budget Variance For U Flexible Budget Sales Volume Variance For U Static Budget Units Sales Revenue Variable Costs Contribution Margin Fixed Costs Operating Income