Question
Use the Cost Variance Report attached to answer the questions. 1. If the threshold for reporting on sources of variances is 5% over or under
Use the Cost Variance Report attached to answer the questions. 1. If the threshold for reporting on sources of variances is 5% over or under budget at the total level; does this report require a variance report for monthly or year-to-date variance? 2. Which of the subaccounts are overrun and underrun in the current month? 3. Which of the subaccounts are overrun and underrun for year-to-date? 4. What were the primary drivers of the current month variance? Use a threshold of $1,000 to indicate a major driver. 5. What were the primary drivers of the year-to-date variance? Use a threshold of $10,000 to indicate a major variance. 6. Training & development is overrun for the current month but underrun for the year. What is the likely cause of these opposite variances? 7. The largest expenditure in the month of June was for Depreciation. Are you concerned that this account may overrun? 8. Based upon the current variances, which account is likely to have the largest overrun? Is there any way to control the variance?
Variance Report June Report Current Month Year-to-date Annual Account Budget Actual Budget Actual Budget Computer - Hardware $1,667 $1,342 $10,000 $8,854 $20,000 Computer - Software $1,667 $1,689 $10,000 $13,872 $20,000 Depreciation $69,105 $69,105 $138,210 $138,210 $276,420 Equipment maintenance $1,000 $921 $6,000 $5,743 $12,000 Furniture & fixtures $1,500 $0 $9,000 $7,488 $18,000 Office Supplies $1,000 $1,126 $6,000 $5,487 $12,000 Personnel - Salaries $51,023 $51,001 $416,875 $413,840 $723,451 Personnel - Benefits $12,765 $12,761 $91,843 $90,923 $185,397 Printing & postage $2,500 $3,351 $15,000 $15,053 $30,000 Professional fees $8,000 $18,500 $50,000 $67,300 $100,000 Training & development $4,000 $17,338 $25,000 $21,722 $50,000 Travel & entertainment $10,000 $14,231 $60,000 $58,639 $120,000 Total $164,227 $191,365 $837,928 $847,131 $1,567,268Step 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