Software Associates

Assignment 1 Variance psycho digest Report In coiffe to perform a magnetic declination analysis report Jenkins calculated the essential taxations and write offs and found the difference which was $296,610 in profits. Then Jenkins did the same with budgeted values and found the budgeted profits to be $606,350. The deviation criterion in turn is $309,960 under budget. Also, the random variable fare for taxs is $32,100. This nume mark is favorable due to the event that they made much than what they had budgeted for. But on the contrary, the stochastic variable substance for expenses was $342,060, which was unfavorable beca spend they spent far more(prenominal) than what they had budgeted for.This information would not be sufficient in order to explain to Norton why their profit portion is nearly half of what they budgeted. This variance analysis report only shows the raw numbers and not any(prenominal) detail to why they spent more on expenses than what they budgeted . Jenkins would drive home a difficult time explaining details to why they went over budget. She would need to show him a detailed expense report of the budgeted items and the effective mensuration they spent on the items. Then she would have to clearly define which items went over budget and why.This variance analysis report would not help Jenkins in the 8 am meeting she has would need to provide more information. Assignment 2 Preparing the Budget Variance Analysis Report In order to provide more information to Norton, Jenkins will need to perform a variance analysis report. Jenkins would be required to use the numbers provided in bear witness 2. She will use the numbers on the budget and actual income educational activity to identify revenue quantity, which is provided in number of hours. She will then identify actual and anticipate quantity.The actual number of consultant hours exceeded the expect number of consultant hours. Then Jenkins subtracted the actual come up of ho urs from the evaluate amount of hours and then calculate by the expect labor price of $90. Jenkins found that software Associates made a total of $278,100 when providing the extra amount of hours billed. This is favorable for Software Associates if the calculate rate was $90 as expected however the average rate per consultant amounted to $83. 69. Next, Jenkins workd the average billing rate variance by subtracting the actual price from the expected price.She then multiply the difference in price and the quantity of lend done. Jenkins found that they had a deficit of $246,090. This is unfavorable because Software Associates is losing bills due to the actual rate degrade from $90 to $83. 69. When Jenkins compared the variance of both quantity of hours and hourly rate, this gave her the total revenue variance of $32,100. The total revenue variance is also the difference between the actual revenue and expected revenue. Over all, it is favorable that Software Associates created m ore revenue.Jenkins then determined whether or not the additional revenue would cover the additional be incurred for the excess consultants. Jenkins used the same method for consultant expenses. By subtracting the actual number of hours supplied (50,850) from the budgeted number of hours supplied (47,250) and multiplying the expected personifys, $37, Jenkins found a address of $133,200. $133,200 is the amount they paid over the expected cost due to the make up in actual labor. Next, Jenkins took the actual cost of $39. 90 and subtracted the expected cost of $37 then multiplied the actual amount of labor hours, 50,850.This amounted to $147,465. This is the extra amount Software Associates paid due to the labor cost change. The two numbers, $133,200 and $147,465, equal $280,800. The difference in consultant salaries cost from actual to expect cost is $280,800. general operating expense is broken down into two categories, actual and expected. Subtract the actual operating expense, $938,560, from the expected operating expense of $877,300 to get the variance of $61,260. This amount is unfavorable. Jenkins found the total expense variance by completing the same equation.She subtracted the expected total expense from the actual total expense. The total expense variance was found to be $342,060. The extra hours worked created more costs than the extra revenue acquired. This puts the corporation in an wondrous position. The budget was not planned out very well. The price of the billed labor decreased man more labor was done and less was billed for. This is an equation for disaster as you can see. more planning essential be taken when figuring out a budget and Software Associates must stick strictly to the budget for reasons like this. Numbers can add up quickly.Assignment 3 write down Analysis Spending and Volume Variance Analysis of Operating Expenses Jenkins then needed to analyze the expense analysis. Many of the expenses for Software Associates were not entirely fixed costs or variable costs. Rather, many of the expenses were a combination of fixed and variable costs. Therefore, Jenkins evaluated the overhead of the company and prepared Exhibit 3, which shows her judgment about separately expenses degree of variability. Due to the summationd expenses per consultant, it is also important to study how costs change with the additional consultant.In order to examine the relationship of overhead costs and number of consultants, Jenkins found the amount of the budget, which was deemed variable, and which was deemed fixed. The budgeted variable amount was obtained by multiplying each expenses budgeted amount by the percent in which was expected to be variable. Then, she subtracted the budgeted amount from the budgeted variable amount to find the budgeted fixed amount. These calculations are shown in Exhibit 3A. Next, Jenkins took numbers and calculated the consumption variance and hoi polloi variance.In order to perform a spending va riance, she subtracted the actual amount spent from the budgeted amount. In this case the actual amount spent was $938,560 and the forecasted expenses totaled $877,300. after(prenominal) subtracting those numbers she found that the spending variance was $61,260. This is an unfavorable outcome of the posterior and can be mostly attributable to the eight extra consultants that were hired. The volume variance is determined by subtracting the budgeted quantity from the actual quantity and then multiplying the cost per unit.In this case, the expected number of consultants was 105 but the actual number of consultants was 113. To determine the cost per consultant, she took the total variable cost $525,000 and divide it by the actual number of consultants 113 and got $4,646. Therefore by multiplying $4,646 by 8 Jenkins found the volume variance of $37,168. This is unfavorable and when compared to the spending variance, she determined that one of the major faults in Software Associates ex penditures for the quarter was hiring the extra eight consultants which were not budgeted for.Assignment 4 Billing Percentage Analysis of Revenue Change After analyzing the expense analysis, Jenkins wanted to understand why the actual number of consultants was nearly 8% higher than the budgeted amount when revenues only had increased by 1%. Jenkins knew if she viewed the budgeted amount of hours allocated for consultants versus the actual hours spent towards consultants she would be able to determine if the consultants were being less productive. First Jenkins viewed the billing dowry by analyzing how much the consultants were billed for versus how much they were expected to be billed for.The consultants were billed for 39,000 hours when they supplied 50,850 hours creating an actual billing percentage of 76. 7%. The budget, however, projected to bill for 35,910 hours when really supplied 47,250 hours creating a 76% billing percentage. Jenkins noticed there was a difference of 3,60 0 hours that were billed and supplied for which was not allocated in the budget. Each of these numbers was found by Jenkins referring to Exhibit 4. Jenkins also noticed that the average billing rate per consultant decreased from $90 to $83. 69.Overall Jenkins saw that if she took the actual hours supplied 50,850 hours and multiplied it by the actual billing percentage 76. 7% and then multiplied that by the actual cost per consultant $83. 69 that there was an actual cost of $3,264,073. 1955 spent towards her consultants. Jenkins also noticed that when she recreated this same equation but in retrospect of Software Associates budgeted amount she found that they were only budgeted to spend $3,231,900. 00 on consultants. This was found by taking the budgeted hours supplied 47,250 hours and multiplying it by the actual billing percentage 76. % and then multiplying that by the actual cost per consultant $90. 0. (Each of these numbers was found by Jenkins referring to Exhibit 4. ) After ana lyzing the actual amount versus the budgeted amount of money Software Associates allocated towards consultants, Jenkins noticed there was a $32,173. 1955 increase in spending this quarter. Jenkins noticed that the billing percentage increased and the rate per consultant decreased. Based on the increase of consultants allocated and the increase in salary and fringes per consultant, Jenkins realized she is paying more for consulting.Their work does not fall out to be more productive in the grand scheme of things. Software Associates are paying a lot more money for more consultants and not receiving a high enough overall revenue increase. Jenkins further analyzed Software Associates spending towards their increase in consultants by enjoin her attention towards the increase in hours supplied by the consultants 3,600 hours= 50,850-47,250 and multiplied that by the expected billing percentage 76% and multiplied that by the expected rate per consultant hour $90 and there was a variance o f $246,240. 0. $246,240. 00 defines the amount that would have been spent per consultant. This is an unfavorable outcome for Software Associates because they are spending a considerable amount of money and not receiving a high return on investment per consultant. The quantity of work is not benefiting the company enough to spend more money on maintaining that number of consultants.