Exercise $8-6$A $($Algo$)$ Using a flexible budget to accommodate market uncertainty LO $8-4$

According to its original plan, Walton Consulting Services Company plans to charge its customers for service at $$125$ per hour in Year $2.$ The company president expects consulting services provided to customers to reach $46,000$ hours at that rate. The marketing manager, however, argues that actual results may range from $41,000$ hours to $51,000$ hours because of market uncertainty. Walton's standard variable cost is $$38$ per hour, and its standard fixed cost is $$1,470,000.$

Required

Develop flexible budgets based on the assumptions of service levels at $41,000$ hours, $46,000$ hours, and $51,000$ hours.

$\backslash$table$[[,\backslash$table$[[$Flexible Budget$],[41,000$ Hours$]],\backslash$table$[[$Flexible Budget$],[46,000$ Hours$]],\backslash$table$[[$Flexible Budget$],[51,000$ Hours$]],],[,,,,],[,,,,],[,,0,,0]]$