Software Associates

The main reason behind it is that the variance analysis of materials, labor, and overhead indicates the difference between original budget and actual sales/amount. It explains that the management should make changes in the budgets in order to diminish the chances of failure (Epstein & Jermakowicz, 2010). Moreover, the company should make changes in its all budgets like production budget, sales budget, manufacturing budget, selling budget and general & administrative. These changes would be helpful to reduce the difference between the actual and projected sales of the firm.

The current cost system allocates overhead costs once a year, as a function of direct labor dollars. This allocation strategy results in:

Compares five to seven expense results with budget expectations and describes possible reason for variances and strategies to keep results aligned with expectations

Use of the flexible budget shows the budgeted operating income given the actual sales. When you compare the flexible budget to the actual budget you are able to compare the total sales and cost incurred given the same units sold. The sales price variance, which is the actual sales less the flexible budgeted sales, was $14,700 favorable. This means that actual sales were higher than budgeted sales at that usage. This is attributable to the increase in service price from $25 to $26.40. Price variance for material usage was $2,100 over the flexible budget projection. This could be attributed to overuse or waste of materials. As expected, the direct labor price variance was $3,375 lower than the flexible budget amount. This is attributed to the manager’s effective use of labor. Operating expenses were also higher than the flexible budget

3. Explain two methods that can be used in order to identify realistic estimations when developing a budget. [2.2]

|2.2 Explain the purpose of using estimations when developing a budget and ways of doing so |Question 2 Page 3 |

With the increasing ramification of economic changes and complex business functioning, each and every company has to implement budget variance analysis to identify the fluctuation in projected amount. In this report, Peyton Approved Company has been taken into consideration to evaluate the effectiveness of business functioning and plant’s operation in determined approach. It reviews the efficiencies and effectiveness of their plant’s operations. With the help of budget variance, it could be easily determined whether Peyton Approved Company has been performing its business throughout the time. Budget variance is the technique which is used by Peyton Approved Company to identify the fluctuation and variability in the set budget and implemented project. Budget variance is defined as differences between the actual amounts of expense incurred by Peyton Approved Company. It is evaluated that when Peyton Approved Company has positive cash flow in its planned budget. For instance, if amount of expenses incurred by company is less than its planned or estimated budget expenses then company has positive budget variance and vice-versa. This could be defined with the estimation of cost budget variance. The formula for the same has been given as below (Steffan, 2008).

Another concern identified, is the utilities expense budget for utilities in Year 9 which is $150,000. This amount is identified as a fixed amount and is unrelated to actually production activities and manufacturing efficiency. Considering that production levels and activity fluctuates throughout the year, the budget for utilities should be a variable item. An example; from Year 7 to Year 8, the utilities expenses increase by $15,000 and with this detection, ways to reduce this expense should be investigate. Another concern is a duplicated line item under the Selling, General, and Administrative Budget for Utilities and Utilities and Services. Another issue for concern, Total Variable Cost was reported to be lower; however was not enough for the lack of sales combined with an increase in advertising and transportation which resulted in an overall negative result. The low Net Sales directly impacted the Contribution Margin which decreased by $49,397. Overall, these concerns indicate the need for a flexible budget with variance analysis.

11. Utilities and services standard output $150,000, actual output is $$218,000. This is a favorable variance of -$1777. This variance is due to reduce sales, less power at the plant is needed because less units are being made. 12. Research and Development standard output is $85,861, actual output is $82,841. This is a favorable variance of -$3,020. This variance is due to cut backs in R&D because of slow sales and low demand for new bikes. 13. Other General and Admin Expenses standard output $170,000, actual output is $172,000. This is an unfavorable variance of $2000. This increase is due to addition materials needed for advertising. 14. Other utilities and

I had a bit of difficulty trying to remember the different types of variances. As the variances are all the something cost of something - the something cost of something else - if you know what I mean, there are 4 things to remember for each variance I am using acronyms to remember what stays the same on both rows and then I can fill in the blanks:

Since a company’s’ budget is typically based on knowledge from their financial history therefore, if a budget variance occurs, it can be because inaccurate estimates were done, or one or more factors have changed unexpectedly, and the company need to make some type of adjustments to their budget. Once a company discovered a significant budget variance, they will need to identify the cause, and address it accordingly. For example,

1.) "Revenue hours" represent the key activity that drives costs at Salem Data Services. Which expenses in Exhibit 2 are variable with respect to revenue hours? Which expenses are fixed with respect to revenue hours?

3. For each of the individual overhead accounts at Bridgeton, do you believe the given cost is variable, fixed, or something else? Why? (Use information or evidence from the case to support your evaluation, if possible. For most of these costs, there is no single right answer from the case information, so the goal is to come up with a reasonable estimate.)

Overhead costs include rent, office staff, depreciation, and other. Once the flexible budget was complete, variances between the actual and flexible budget could be calculated (Exhibit B). The variance for frame assembly was favorable with actual costs being $82,663 less than in the flexible budget. The variances for wheel and final assembly however were both unfavorable. Wheel assembly had an unfavorable variance of $50,650, while final assembly variance was the highest at an unfavorable variance of $231,200. Taking into account these three aspects of direct cost, direct cost has an unfavorable variance $199,187. Although most overhead costs are fixed, 2/3 of other costs are variable and increase with the increased production. As shown in Exhibit B, overhead variance is unfavorable at $60,000. The direct cost variance and overhead variable together lead to a total unfavorable variance of $259,187.

3. Under the new activity-based costing (ABC) system, compute the indirect cost allocation rates for each of the three activities: