Data Table Performance Report, June 2017 Actual Static Results Budget 380,000 Units (pounds) 390,000 Revenues 2,203,500 $ 1,423,500 2,166,000 1,368,000 Variable manufacturing costs $ 780,000 $ 798,000 Contribution margin Brian Efron, 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 $18,000, which is less than 1% of the budgeted revenues of $2,166,000. Overall, Efron feels that the business is running fine. Print Done Alpine, Inc. produces the basic fillings used in many popular frozen dessorls and treats-vanilla and chocolate ice crearrs, puddings, meringues, and fudge. Alpine 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: B (click the loon to view the results.) Read the requirements Requirements 1 and 2. Calculate the static-budget variance in unils, revenues, variable manufacturing costs, and contribution margin. What percentage is each static-budget variance relative to its static-budget amount? Break down each static-budget variance into a flexible-budget variance and a sales-volume variance. Begin with the flexible budget columns, then enter in the sales volume variance and static budget variances. Finally, compute the static budget variance as a percentage of the slatic budget. Label each variance as favorable (F) or unfavorable (U). (For variances with a so balance, make sure to enter "O' in the appropriate field. If the variance is zero, do not select a label. Round dolar amounts to the nearest whole dollar and percentages to two decimal places, X.X.C%..) Flexible- Sales- Static- SB variance Actual Budget Flexible Volume Static Budget % of Static Results Variances Budget Variances Budget Variances Budget Units (pounds) % Revenues % Variable mfg. costs % % Contribution margin L Requirement 3. Calculate the selling price variance. The selling price variance is $ Requirement 4. Assume the role of management accountant at Alpine. How would you present the results to Brian Efron? Should he be more concerned? If so, why? and conta per pound were v The The flexible-budget variances show that for the actual sales volume of 390,000 pounds, selling prices were sales-volume variance in revenues the variable-cost variance. -. Efron should concerned because the small static-budget variance in contribution margin is actually made up of ain) sales-volume varlance in contribution margin, ain) selling price variance, and a(n) variable manufacturing costs variance. Efron