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

Themes Page Setup Scale to P21 A F G Flexible Budgets and Standard Cost Systems Using Excel to prepare a flexible budget performance report Pilchuck Company manufactures tote bags and has provided the following informatio Static Budget Actual Results Units 11,000 12,000 Sales Revenue 384,000 368,000 Variable Costs 198,000 183,000 Contribution Margin 186,000 185,000 Fixed Costs 77,184 76,000 Operating Income 108,816 109,000 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 1 variances, and use the drop-down selections for F or U when describing the va 2 Calculate the Static Budget Variance for operating income, and label it as aF (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 Submitting Solution 1 Save file to desktop. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 8 Saving & a. b. Save your solution in the folder you just created; add-solution-date to end Column 1 Column 2 Column 3 Column 4 Column 5 Col (3) Col (5) Col (1) Col (3) Budget Actual Flexible Budget Flexible Sales Volume F or U F or U Static Budget Amounts Results Variance Budget Variance per Unit Units Sales Revenue Variable Costs Contribution Margin Fixed Costs Operating Income Flr Vicw OTel me what you want to de Share commenta Home Insert Paae Lavput Fcrmu as Data Revicw Hep AutnSum Cut Neutral Cakulation Caibr 11 A A Wap Ted GOod Normal Bard t Copy s Check Cell Sot &ind & Flu Sdast Inpul inked Cel Mege & Center I Conde onsl fomat a Explanutory.. Hyperlink Oaiate Lorms - A E Fmalline Tala Cles fomst Pa nter Murher Shdes Alrment Cipbeard Fem ell Eding K15 M N Q U V W A Prepare a tiexible budget pertarmance roport, Including tho heading, Use the ABS tunction when calculating varlances. and uso the droo-down 1selections for F rUwhen describing the variances Plchuck Comoany Flexible Budget Performance Report Manth ended September 30.2018 4 Column 1 Calumn z Column 3 Column 4 Column" Col (31-Col (5 (1)-Cal Budget Sales Volume Budget Flexible Amounts ber Unit E or U Static Budge Actual Result Variance Budeet Variance 12c00.00 Revenue 33A5 12 Varisble Costs 183,000.00 13 Contributicn Margin 14 Fixed Costs 185,000.e 186000,00 6.000,00 77.184,00 15 Operating Incamer 109.000.00 L08.816,00 16 Calculate the Static Budget Variance for aperating income, and label it as a F (favorable) or U (unfavorable) variance. 20 Static Budget Varlance tor Operating Income (1)- (5) Amount 21 22 For U .. 26 29