Please show formulas and use excel if possible. thanks in advance.

Questions 1-4

idget variance: $45,400U When the master budget was prepared, LawnMate's cost accountant, Joan Ballard, supplied ihe following unit costs: direct material, $60; direct labor, $44; variable production overhead, $36; and vin: able selling expenses, $12. Chapter 11 Flexible Budgeting and Analysis of Overhead Costs The total variable costs of $780,000 for May include $320,000 for direct material, $192,000 for direct labor, $176,000 for variable production overhead, and $92,000 for variable selling expenses. Ballard believes that LawnMate's monthly reports would be more meaningful to everyone if the com- Required: 1. Prepare a flexible budget for LawnMate Company for the month of May that includes separate variable-cost budgets for each type of cost (direct material, etc.). 2. Determine the variance between the flexible budget and actual cost for each cost item. 3. Discuss how the revised budget and variance data are likely to impact the behavior of Al Richmond, the production manager. 4. Build a spreadsheet: Construct an Excel spreadsheet to solve requirements (1) and (2) above. Show how the solution will change if the following information changes: actual sales amounted to 4,700 units, and actual fixed overhead was $179,000