Please complete in a spreadsheet for both flexible and static budget variances

Information related to Motorcycle Model X performance for the year ending December 31, 2022, is given below: Actual 75000 Budgeted 70,000 Units made and sold Selling price Variable costs Fixed costs Required: $105 per unit $ 100 per unit $ 80 $85 per unit $ 280,000 $ 250,000 a. Prepare Bradley Motorcycle Manufacturing Company's Flexible and Static-budget variance for (a) revenues, (b) variable costs, (c) fixed costs, and (d) operating income. b. Recommend three strategies to help your Company increase its favorable operating income variance.