Seved Help Howard Cooper, the president of Glacier 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 2019. Standard rate and variable conta Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected tixed costs Facility maintenance Selling, general, and administrative $ 60.00 32.00 5.76 3.44 $320,000 120,000 services in 2019. Required a. Prepare the pro forma income statement that would appear in the master budget i the firm expects to provide 30,000 hours of 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 Glacier charges customers $56 per hour, the firm can achieve 38,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 $64 per hour, the number of service hours will decline to 25.000 Prepare a flexible budget using the new assumption 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 budget of the Armexpects to provide 30,000 hour of services in 2019 OLACIER COMPUTER SERVICES Proforma Income Statement Master Budget Complete this question by entering your answers in the tabs below. Required A Required B Required C Prepare the pro forma income statement that would appear in the master budget If the firm expects to provide 30,000 hours of services in 2019. GLACIER COMPUTER SERVICES Pro Forma Income Statement Master Budget Variable costs: Contribution margin Fixed costs: $ 0 Required B > Required A Required B Required 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 Glacier charges customers $56 per hour, the firm can achieve 38,000 hours of services. Prepare a flexible budget using the consultant's assumption. GLACIER COMPUTER SERVICES Pro Forma Income Statement Flexible Budget Variable costs: $ Fixed costs: $ 0 tomework Sayed Required A Required B Required C The same consultant also suggests that if the firm raises its rate to $64 per hour, the number of service hours will decline to 25,000. Prepare a flexible budget using the new assumption. GLACIER COMPUTER SERVICES Pro Forma Income Statement Flexible Budget Variable costs: 0 Fixed costs: