Can someone work this problem so I can check my work against it. I feel like im not doing everything correctly. Thank you in advance!

These are the answer I got based on the information given in my other pictures.

Save B D F Requirement 1 Prepare a flexible budget performance report, including the heading. Use the ABS function when calculating variances, and use the drop-down selections for F or when describing the variances. Note: start with calculating the budget amounts, then calculate variances and choose appropriate descriptions of the variances. (For variances with a zero amount, make sure to include the result of "o" in the appropriate cell and leave the drop down to identify the variance seither For U blank.) 3 (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) 6 7 B 9 Column 1 Column 2 Column 3 Column 4 10 Columns Col (1) Col (3) Col(3) Col (5) Budget Actual Amounts Flexible Budget Flexible Sales Volume Foru 11 Results Variance Foru Static Budget Budget per Unit Varlance 12 Units 12 14 15 10 17 18 19 20 Requirement 2 21 Calculate the Static Budget Variance for operating income, and label it as a favorable or Ufuntavorable) variance 22 Always use cell references and formulas where appropriate to receive full credit) 23 24 Statie Budget Variance for Operating Income (0) (5) 25 Amount: 25 For 37 20 Instructions ENTERANSWERS Close ch o A B D E G K 1 Flexible Budgets and Standard Cost Systems 2 Using Excel to prepare a flexible budget performance report files. Save 3 4 Plichuck Company manufactures tote bags and has provided the following information for September 2018 5 Slator 6 Actual Results Static Budget the 7 Units 14,000 15,000 B Sales Revenue 560,000 540,000 9 Variable Costs 294,000 262,500 10 Contribution Margin 266,000 277,500 11 Fixed Costs 109,000 122,000 12 Operating Income 157,000 155,500 13 Use the blue shaded areas on the ENTERANSWERS tab for inputs. 14 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- 15 16 17 Requirements Prepare a flexible budget performance report, including the heading. Use the ABS function when calculating variances, and 1 18 use the drop-down selections for For U when describing the variances. 19 2 Calculate the Static Budget Variance for operating income, and label it as a F (favorable) or (unfavorable) variance 20 21 22 Excel Skills 23 1 ABS function (Absolute Value) to calculate the variances. 24 2 Data validation to select a F (favorable) or U(unfavorable) variance 25 3 Cell references - both absolute and relative 26 27 28 29 Saving & Submitting Chapter Excel Assignments 30 1. Save file 31 a. You may want to create folder on desktop, and label COMPLETED EXCEL PROJECTS 32 b. Name your files CHnumber_FirstNameLastName (e g.. CH1_RobynVerdery Clace Instructions ENTERANSWERS Sood tego to search RI Font Alignment 5 Number =J15/112 F G H D E K Prepare a flexible budget performance report, including the heading. Use the ABS function when calculating variances, and use the drop-down selections for F or when describing the variances. Note: start with calculating the budget amounts, then calculate variances and choose appropriate descriptions of the variances. (For variances with a zero amount, make sure to include the result of "o" in the appropriate cell and leave the drop down to identify the variance as either For U blank.) (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.) Pilchuck Company Flexible Budget Performance Report Month Ended September 30, 2018 Column 3 Column 5 Column 4 Col(3) - Col (5) Sales Volume Variance For U Flexible Budget For U Static Budget Units Sales Revenue Variable Costs Contribution Margin Fixed Costs Operating Income Column 1 Column 2 Col (1) - Col (3) Budget Amounts Actual Flexible Budget Results Variance per Unit 14,000 $ 36.00 $ 560,000 S 56,000 S 17.50 294,000 $ 49,000 18.5 266,000 5 7,000 8.1333333 109,000 $ 4,867 10.366667 $ 157,000 $ 11,867 U F U F F 14,000 $504,000 245,000 $ 259,000 S 113,867 S $ 145,133 S 36,000 17,500 18,500 8,133 10,367 15,000 S 540,000 262,500 277,500 122,000 S 155,500 U F U Requirement 2 Calculate the Static Hudget Variance for operating income, and label it as a F (favorable) or (untavorable) variance (Always use cell references and formulas where appropriate to receive full credit.) Static Budget Variance for Operating Income (1)-(5) $1,500 Amount: For U 16 7 P8 19 DO HINTS 31 Cell Hint 12 C13:014, D12:017,312017 Use cell references to the values in the datatable provided at the top of the instruction worksheet for calculations 13 13:17, H13:H17, 025 Use the function ABSE) to calculate the variances. 4 F13 F17, 113:117 Do not choose the descriptions and leave cells blank if corresponding variances equal tero Instructions ENTERANSWERS