Walcker Transportation Company's general manager reports quarterly to the company president on the firm's operating performance. The company uses a Although the general manager was upset about not obtaining enough revenue, she was happy that her cost performance was favorable; otherwise, her net budget based on detailed expectations for the forthcoming quarter. The general manager has just received the condensed quarterly performance report shown income would be even worse. The president was not satisfied with the performance report and remarked, "I can see some merit in comparing actual below. performance with budgeted performance because we can see whether actual revenue coincided with our best guess for budget purposes. But I can't see how this performance report helps me evaluate cost-control performance." EFF (Click the icon to view the quarterly performance report.) Read the requirements. Requirement 1. Prepare a columnar flexible budget for Walcker Transportation at revenue levels of $12,600,000, $13,000,000, and $13,400,000. Assume that the prices and mix of products sold are equal to the budgeted prices and mix. Begin with the flexible budget at revenues of $12,600,000, next, complete the flexible budget at revenues of $13,000,000 and, then, prepare the flexible budget at revenues of $13,400,000. (Enter all costs as positive numbers.) Walcker Transportation Company X Flexible Budgets for Various Levels of Sales Data Table Net revenue $ 12,600,000 Variable Costs Budget Actual Variance Fuel Net revenue $ 13,000,000 $ 12,700,000 $ 300,000 U Repairs and maintenance Variable Costs Supplies and miscellaneous Fuel $ 520,000 $ 516,000 $ 4,000 F Variable payroll Repairs and maintenance 390,000 398,000 8,000 U Total variable costs Supplies and miscellaneous 2,080,000 2,070,000 10,000 F Fixed Costs Variable payroll 8,060,000 7,940,000 120,000 F Supervision 160,000 Total variable costs* $ 11,050,000 $ 10,924,000 $ 126,000 F Rent 200,000 Fixed Costs Depreciation 460,000 Supervision 160,000 $ 177,000 $ 17,000 U Other fixed costs 170,000 Rent 200,000 200,000 Total fixed costs 990,000 Depreciation 460,000 460,000 Total fixed and variable costs Other fixed costs 170,000 163,000 7,000 F 990,000 1,000,000 10,000 U Operating income Total fixed costs Total fixed and variable costs 12,040,000 $ 11,924,000 $ 116,000 F 960,000 $ 776,000 $ 184,000 Operating income U = Unfavorable. F = Favorable *For purposes of this analysis, assume that all these costs are totally variable with respect to sales revenue. In practice, many are mixed and have to be subdivided into Help Me Solve This Video Get More Help - variable and fixed components before a meaningful analysis can be made. Also, Clear All