Problem 15-19A (Algo) Flexible budget planning LO 152 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 rate that the firm charges its customers. The following basic data pertain to fiscal year 1. Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 37,000 hours of services in Year 1. 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 Gibson charges customers $79 per hour, the firm can achieve 46.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 $89 per hour, the number of service hours will decline to 32,000 . Prepare a flexible budget using the new assumption. Complete this question by entering your answers in the tabs below. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 37,000 hours of services in Year 1. Complete this question by entering your answers in the tabs below. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 37,000 hours of services in Year 1. Complete this question by entering your answers in the tabs below. 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 Gibson charges customers $79 per hour, the firm can achieve 46,000 hours of services. Prepare a flexible budget using the consultant's assumption. Complete this question by entering your answers in the tabs below. The same consultant also suggests that if the firm raises its rate to $89 per hour, the number of service hours will decline to 32,000 . Prepare a flexible budget using the new assumption