How do I compute this using Excel or Word?

7-25 Flexible-budget and sales volume variances. Cascade, Inc., produces the basic fillings used in many popular frozen desserts and treats-vanilla and chocolate ice creams, puddings, meringues, and fudge. Cascade uses standard costing and carries over no inventory from one month to the next. The ice-cream product group's results for June 2017 were as follows: une olayout Performance Report June 2017 Actual Results Static Budget 3 Units (pounds) 460,000 447.000 4 Rens 52.625.000 $2.512.500 5. Variable manufacturing costs 1651000 1.564 500 5 Contrbuton margin $975 200 $1028 100 ALSO include Actual Fixed Costs $520,000 Static Budget Fixed Costs $500,000. Jeff Geller, the business manager for ice-cream products, is pleased that more pounds of ice cream were sold than budgeted and that revenues were up. Unfortunately, variable manufacturing costs went up, too. The bottom line is that contribution margin declined by $52,900, which is just over 2% of the budgeted revenues of $2,592,600. Overall, Geller feels that the business is running fine. Required: 1. Eateulate the statie-budget varianee in units, revenues, variable manufacturing costs, and contribution margin. What pereentage is each statie-budget varianee relative to its statie- budget-amount? 2. Break down each static-budget variance into a flexible- budget variance and a sales-volume variance. (that is, prepare a performance report (akin to Exhibit 7-2, page 254) that uses a flexible budget and a static budget). 3. Euleulete What is the selling price variance. 4. Assume the role of management accountant at Cascade. How would you present the results to Jeff Geller? Should he be more concerned? If so, why