Howard Cooper, the president of Stuart Computer Services, needs your help He wonders about the potential effects on the firms 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 $ 82 00 Labor cost 33 00 Overhead cost 6 20 Selling, general, and administrative cost 4 10 Expected fixed costs Facility maintenance $ 516,000 Selling, general, and administrative 143,000 Required Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 34,000 hours of services in Year 3 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 consultants analysis, if Stuart charges customers $77 per hour, the firm can achieve 42,000 hours of services Prepare a flexible budget using the consultants assumption The same consultant also suggests that if the firm raises its rate to $87 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 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 34,000 hours of services in Year 3 STUART COMPUTER SERVICES Pro Fornia Income Statement Master Budget Variable costs 0 Fixed costs $ 0 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 Stuart charges customers $77 per hour, the firm can achieve 42,000 hours of services Prepare a flexible budget using the consultant's assumption STUART COMPUTER SERVICES Pro Forma Income Statement Flexible Budget Variable costs $ 0 Fixed costs 5 0 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 $87 per hour, the number of service hours will decline to 30,000 Prepare a flexible budget using the new assumption STUART COMPUTER SERVICES Pro Forma Income Statement Flexible Budget Vorable costs $ 0 Fixed costs 0

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 13, 2024

Howard Cooper, the president of Stuart Computer Services, needs your help. He wonders about the potential effects on the firms net income if he changes

Howard Cooper, the president of Stuart Computer Services, needs your help. He wonders about the potential effects on the firms 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	$	82.00
Labor cost		33.00
Overhead cost		6.20
Selling, general, and administrative cost		4.10
Expected fixed costs
Facility maintenance	$	516,000
Selling, general, and administrative		143,000

Required:

Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 34,000 hours of services in Year 3.
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 consultants analysis, if Stuart charges customers $77 per hour, the firm can achieve 42,000 hours of services. Prepare a flexible budget using the consultants assumption.
The same consultant also suggests that if the firm raises its rate to $87 per hour, the number of service hours will decline to 30,000. Prepare a flexible budget using the new assumption.

image text in transcribed

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 34,000 hours of services in Year 3. STUART COMPUTER SERVICES Pro Fornia Income Statement Master Budget Variable costs 0 Fixed costs $ 0 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 Stuart charges customers $77 per hour, the firm can achieve 42,000 hours of services. Prepare a flexible budget using the consultant's assumption. STUART COMPUTER SERVICES Pro Forma Income Statement Flexible Budget Variable costs $ 0 Fixed costs 5 0 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 $87 per hour, the number of service hours will decline to 30,000. Prepare a flexible budget using the new assumption STUART COMPUTER SERVICES Pro Forma Income Statement Flexible Budget Vorable costs $ 0 Fixed costs 0