Howard Cooper the president of Gibson Computer Services needs your help. He wonders about the potential effects on the firm's net Income if he changes the service rote 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 teneral, and ministrative $ 86.00 32.00 6.30 4.10 $518,000 145,000 Required: o. Prepare the proforma income statement that would appear in the master budget of the firm expects to provide 43,000 hours of Services in Year 3 b. A marketing consultant suggests to Mi Cooper that the service rote may affect the number of service hours that the firm can ochieve. According to the consultant's analysis, it Gibson charges customers 581 per hour the firm can achieve 51000 hours of services. Prepare a flexible budget using the consultant's assumption c. The same consultant also suggests that if the firm toises its rate to $91 per hour the number of service hours will decline to 39,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 proforma Income statement that would appear in the master budget if the firm expects to provide 43,000 hours of services in Year 3 GIBSON COMPUTER SERVICES Pro Forma Income Statement Master Budget Variable costs 0 Fixed costs $ 0 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 the number of service hours that the firm con achieve. According to the consultant's analysis, if Gibson charges customers $81 per hour, the firm can achieve 51,000 hours of services. Prepare a flexible budget using the consultant's assumption GIBSON COMPUTER SERVICES Pro Forma Income Statement Flexible Budget Variable costs 0 Fixed costs Complete this question by entering your answers in the tabs below. Required a Required B Required The same consultant also suggests that if the firm raises its rate to $91 per hour, the number of service hours will decline to 39,000. Prepare a flexible budget using the new assumption GIBSON COMPUTER SERVICES Pro Forma Income Statement Flexible Budget Variable costs $ 0 Fixed costs 0