Check my work 14 Howard Cooper, the president of Walton Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative $ 89.00 37.00 6.50 4.10 $525,000 144,000 Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 32,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Walton charges customers $84 per hour, the firm can achieve 40,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm raises its rate to $94 per hour, the number of service hours will decline to 30,000. Prepare a flexible budget using the new assumption Complete this question by entering your answers in the tabs below. IM Check my work 14 Complete this question by entering your answers in the tabs below. Required A Required B Required Prepare the pro forma income statement that would appear in the master budg of services in Year 3. WALTON COMPUTER SERVICES Pro Forma Income Statement Master Budget Services revenue Variable costs: Labor cost Overhead cost Selling, general, and administrative costs Contribution margin 0 Fixed costs Facility maintenance Selling, general, and administrative costs Net income Required a M Question 14 - Midterm 2 - Connect Saved 20 Help Submit Save & Exit Check my work Complete this question by entering your answers in the tabs below. Required A Required B Required A marketing consultant suggests to Mr. Cooper that the service rate may affect achieve. According to the consultant's analysis, if Walton charges customers $8 of services. Prepare a flexible budget using the consultant's assumption. WALTON COMPUTER SERVICES Pro Forma Income Statement Flexible Budget Variable costs: 0 Fixed costs: $ Check my work 14 Howard Cooper, the president of Walton Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative $ 89.00 37.00 6.50 4.10 $525,000 144,000 Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 32,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Walton charges customers $84 per hour, the firm can achieve 40,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm raises its rate to $94 per hour, the number of service hours will decline to 30,000. Prepare a flexible budget using the new assumption Complete this question by entering your answers in the tabs below. IM Check my work 14 Complete this question by entering your answers in the tabs below. Required A Required B Required Prepare the pro forma income statement that would appear in the master budg of services in Year 3. WALTON COMPUTER SERVICES Pro Forma Income Statement Master Budget Services revenue Variable costs: Labor cost Overhead cost Selling, general, and administrative costs Contribution margin 0 Fixed costs Facility maintenance Selling, general, and administrative costs Net income Required a M Question 14 - Midterm 2 - Connect Saved 20 Help Submit Save & Exit Check my work Complete this question by entering your answers in the tabs below. Required A Required B Required A marketing consultant suggests to Mr. Cooper that the service rate may affect achieve. According to the consultant's analysis, if Walton charges customers $8 of services. Prepare a flexible budget using the consultant's assumption. WALTON COMPUTER SERVICES Pro Forma Income Statement Flexible Budget Variable costs: 0 Fixed costs: $