No format needed, each answer must be at least 100 words.
1. When you're dealing with mixed cost items, such as utilities or possibly shipping costs, the High Low method is a good way to normalize your total costs and better predict your expenses. On the lessons tab, we instructed to ensure that our High and Low values are not outliers...due to unusual behavior. Because if they are, these numbers are not very reliable to normalize your costs.
So to help you guys format your thoughts on how you'll work on this week's project assignment, I'll turn your attention to Chapter 3 in our text, where we're told that when we build a budget, we are building a model of our business and the relationship between volume and costs. How so?
2. A coworker comes to you with the following problem: "I provided my boss a projection of factory overhead using the high-low method. He was unhappy with the results and told me to do more work and not return until I had a lower cost estimate. My initial analysis was based on data points for the last 24 months. By dropping the three highest data points, I was able to get a lower cost." The coworker was unethical. Under what circumstances, do you think, would it be appropriate to remove such data? Perhaps, if you had enough data to analyze and prove that the removal would not have a negative consequence?
3. I'd like to take a look at Materials Price Variance as explained in this document. A negative Materials Price Variance is considered to be good.
Are there any circumstances where a negative Materials Price Variance is not good?
4. So we've got some tutoring aids in doc sharing this week, and in the Standard Costs and Variance Analysis document, I'd like to go to the very end and try an exercise with Sales Revenue Variance.
AQ: Actual quantity sold
AP: Actual sales price per unit
SP: Standard or Budgeted price per unit
SQ: Standard or Budgeted quantity (at actual level of sales)
Total Sales variance = sales price variance + sales volume quantity variance
Sales Price Variance: (AQ x AP) - (AQ x SP)
(A positive balance signifies that our actual selling price was higher so is considered favorable.)
Sales Volume Quantity Variance: (AQ x SP) - (SQ x SP)
(A positive balance signifies that we sold more than expected so is considered favorable.)
So let's mock up some numbers for The Cutting Edge. Calculate the Sales Revenue Variance and decide if it is favorable or unfavorable.
|
Sales per service/unit
|
|
Lawn Mowings
|
Weed Treatments
|
|
Units
|
Units
|
|
Budgeted
|
35,000
|
43,000
|
|
Actual
|
22,000
|
38,000
|
|
Cost of service and Revenues are below
|
|
|
Lawn Mowings
|
Weed Treatments
|
|
|
$ Thousands
|
$ Thousands
|
|
|
Revenue
|
200
|
245
|
|
Direct labor
|
15
|
12
|
|
Direct Material
|
20
|
10
|
|
Variable Costs
|
6
|
7
|
|
Fixed Costs
|
4
|
3
|