I only have one more chance to answer this and I can't figure it out.I need the answer in Excel if possible.

Davis , Managerial Accounting , Be Help System Announcements Lexi Belcher picked up the monthly report that Irvin Santamaria left on her desk . She smiled as her eyes went straight to the bottom line of the report and sa the favorable variance for operating inco me , confirming her decision to push the workers to get last 350 cases off the production line before the end of the month But as she glanced over the rest of numbers , Lexi couldn't help but wonder if there were errors in some of the line items . She was puzzled at how most of the operating expenses could be higher than the budget since she had worked hard to manage the production line to improve efficiency and reduce costs . Yet the report shown below showed a different story Cases produced and sold 250 FavorsS 2 Sales revenue 51 928 090 51 851 300 576 700 Favorable Less variable expenses Direc . maters ! 10.890 Unfavorable Direct later 7574 Unfavorable Variable manufacturing overhead 4 , 562 Unfavorable Variable selling expenses 3059 Unfavorable Variable administrative expenses 1 723 Unfavorable btal variable expense 28 . 243 Unfavor Contribution margin 45 . 452 FEVERS Less fixed expenses Ficed manufacturing overhead 550 Unfavorable Ficed selling expenses ( 495 Favorable ) Fixed administrative expenses ( 198 Favorable Total fixed expense 297 Unfavorable Operating income $48 , 155 Favorable Let me look into it and back to you , " Irvin replied Irvin gathered the fo lowing additional information about the month's performance . Direct materials purchased ; 106 980 pounds at a total of $555 390 . Direct materials used 100.980 pounds Direct labor hours worked : 26 .235 at a total cost of 52 64 , 974 Machine hours weed : 40 , 541 Irvin also found the standard cost card for a case of product Standard Pric Standard Quantity Direct materials $5.50 per pound 10 pounds 510 per DLH Variable overhes Fixed overhead $2 72 per NH Total standard cost per caseDavis, Managerial Accounting, 3e Help | System Announcements CALCULATOR PRINTER VERSION 1 BACK NE Direct material price variance Direct material quantity variance (c-d) Calculate the direct labor rate variance and direct labor efficiency variance for the month. (Round answers to 0 decimal places, e.g. 1,525. If variance is zero, select "Not Applicable" and enter 0 for the amounts.) Direct labor rate variance Direct labor efficiency variance (e-f) Calculate the variable overhead spending variance and variable overhead efficiency variance for the month. ( If variance is zero, select "Not Applicable" and enter 0 for the amounts.) Variable overhead spending variance Variable overhead efficiency variance (g) Calculate the fixed overhead spending variance for the month. (If variance is zero, select "Not Applicable" and enter 0 for the amounts.) Fixed overhead spending variance $1 LINK TO TEXT LINK TO VIDEO LINK TO TEXT LINK TO VIDEO LINK TO TEXT LINK TO VIDEO LINK TO TEXT LINK TO VIDEO Prepare a performance report that will assist Lexi in evaluating her efforts to control production costs. (If variance is zero, select "Not Applicable" and enter 0 for the amounts.) Price/ Rate/Spending Variance Quantity/ Efficiency Variance Direct materials Direct labor Variable overhead Fixed overhead Total LINK TO TEXT LINK TO VIDEO