The King County Walks is an annual fund-raising event that raises money for research on childs autism. The Walk costs $94,000 to stage even if nobody shows up. To encourage people to participate, each walker is given a keychain that costs the Walk $4.0 and refreshments that cost an average of $5 per person. This year, the walkers got a $32,000 grant from the Parks and Recreation Department to offset part of costs associated with staging the Walk. The Walk raises money by asking each walker to pay a registration fee of $20 and requires each walker to solicit sponsors. Additionally, each sponsor pays $2.0 per mile for each of the 10 miles that the walker completes. In the past, all of the walkers have completed the ten-mile course and have had an average of 10 sponsors.

In a table or excel screenshot..... prepare a flexible budget highlighting revenues, expenditures and budget balances for the event highlighting five different levels of walker participation participation at a breakeven point, then two above the breakeven point (at 105% and 110% participation levels), and two below the breakeven point (at 95% and 90% participation respectively). Present your flexible budget in a neatly organized excel table: list all revenues and all (line items), and budget balances at the end of each scenario. Briefly discuss results in one or two sentences.