please use excel

The two questions below result in a Level 2's performance report (see Exhibit 7-2), however data is given to you differently. You have 1 attempt to upload your work. Please do e7-21 and 7-25 below using EXCEL or WORD, and upload your work. Be careful with e7-25, as I included Fixed Costs of $300,000 (Static) and $320,000 (Actual). 7-21. FLEXIBLE BUDGET. Brabham Enterprises manufactures tires for the Formula I motor racing circuit. For August 2020, it budgeted to manufacture and sell 3,000 tires at a variable cost of $73 per tire and total fixed costs of $57,000. The budgeted selling price was $111 per tire. Actual results in August 2020 were 2,700 tires manufactured and sold at a selling price of $113 per tire. The actual total variable costs were $218,700, and the actual total fixed costs were $53,500. Required 1. Prepare a performance report (akin to Exhibit 7-2) with a flexible budget and a static budget. 2. Comment on the results in requirement 1 . 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 2020 were as follows: 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. The two questions below result in a Level 2's performance report (see Exhibit 7-2), however data is given to you differently. You have 1 attempt to upload your work. Please do e7-21 and 7-25 below using EXCEL or WORD, and upload your work. Be careful with e7-25, as I included Fixed Costs of $300,000 (Static) and $320,000 (Actual). 7-21. FLEXIBLE BUDGET. Brabham Enterprises manufactures tires for the Formula I motor racing circuit. For August 2020, it budgeted to manufacture and sell 3,000 tires at a variable cost of $73 per tire and total fixed costs of $57,000. The budgeted selling price was $111 per tire. Actual results in August 2020 were 2,700 tires manufactured and sold at a selling price of $113 per tire. The actual total variable costs were $218,700, and the actual total fixed costs were $53,500. Required 1. Prepare a performance report (akin to Exhibit 7-2) with a flexible budget and a static budget. 2. Comment on the results in requirement 1 . 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 2020 were as follows: 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