Question
Howard Cooper, the president of Munoz Computer Services, needs your help. He wonders about the potential effects on the firms net income if he changes
Howard Cooper, the president of Munoz 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 2019.
| Standard rate and variable costs | |||
| Service rate per hour | $ | 82.00 | |
| Labor cost | 35.00 | ||
| Overhead cost | 6.80 | ||
| Selling, general, and administrative cost | 4.10 | ||
| Expected fixed costs | |||
| Facility maintenance | $ | 524,000 | |
| Selling, general, and administrative | 149,000 | ||
Required:
-
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 2019.
-
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 Munoz charges customers $77 per hour, the firm can achieve 46,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 31,000. Prepare a flexible budget using the new assumption.
a.
| MUNOZ COMPUTER SERVICES | |
| Pro Forma Income Statement | |
| Master Budget | |
| not attempted | not attempted |
| Variable costs: | |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | $0 |
| Fixed costs: | |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | $0 |
b.
| MUNOZ COMPUTER SERVICES | |
| Pro Forma Income Statement | |
| Flexible Budget | |
| not attempted | not attempted |
| Variable costs: | |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | $0 |
| Fixed costs: | |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | $0 |
c.
| MUNOZ COMPUTER SERVICES | |
| Pro Forma Income Statement | |
| Flexible Budget | |
| not attempted | not attempted |
| Variable costs: | |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | $0 |
| Fixed costs: | |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | not attempted |
| not attempted | $0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Auditing Information Systems And Controls The Only Thing Worse Than No Control Is The Illusion Of Control
Authors: Ed Danter
1st Edition
1425763227, 978-1425763220
