Question
Required: 1. Prepare a flexible budget like exhibit 12.4 for the activity of moving materials, but you will use the number of moves as the
Required: | |||||||||||
1. Prepare a flexible budget like exhibit 12.4 for the activity of moving materials, but you will use the number of moves as the activity driver. | |||||||||||
Use | 60,000 | moves and | 80,000 | moves | |||||||
2. What if the actual costs incurred were the amounts below for 60,000 moves. | |||||||||||
Prepare an activity-based performance report like exhibit 12.6 to present a comparison of actual to budget with a budget variance determine. | |||||||||||
You must also designate U or F if there is a variance. If there is no variance you can leave the designation blank, since the variance of zero is not U or F. You must use the IF Function to designate U or F to earn credit. | |||||||||||
Activity | Actual cost | ||||||||||
Salaries | $1,290,000 | ||||||||||
Leases | 144,000 | ||||||||||
Crates | 118,000 | ||||||||||
Fuel | 24,000 | ||||||||||
3. Explain what type of value that the moving activity provides the company. Provided a recommendation on what the company should attempt to do with this activity. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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