Software Associates

Assignment 1: Variance Analysis Report In order to perform a variance analysis report Jenkins calculated the actual revenues and expenses 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 variance amount in turn is $309,960 under budget. Also, the variance amount for revenues is $32,100. This number is favorable due to the fact that they made more than what they had budgeted for. But on the contrary, the variance amount for expenses was $342,060, which was unfavorable because they spent far more than what they had budgeted for.

This information would not be sufficient in order to explain to Norton why their profit percentage is nearly half of what they budgeted. This variance analysis report only shows the raw numbers and not any details to why they spent more on expenses than what they budgeted. Jenkins would have 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 actual amount 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 Exhibit 2. She will use the numbers on the budget and actual income statement to identify revenue quantity, which is provided in number of hours. She will then identify actual and expected quantity.

The actual number of consultant hours exceeded the expected number of consultant hours. Then Jenkins subtracted the actual amount of hours from the expected amount of hours and then multiplied by the expected 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 billing rate was $90 as expected; however the average rate per consultant amounted to $83. 69. Next, Jenkins determined the average billing rate variance by subtracting the actual price from the expected price.

She then multiplied the difference in price and the quantity of work done. Jenkins found that they had a deficit of $246,090. This is unfavorable because Software Associates is losing money due to the actual rate drop 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 more revenue.

Jenkins then determined whether or not the additional revenue would cover the additional costs 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 costs, $37, Jenkins found a cost of $133,200. $133,200 is the amount they paid over the expected cost due to the increase 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. Overall 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 company in an awful position. The budget was not planned out very well. The price of the billed labor decreased while more labor was done and less was billed for. This is an equation for disaster as you can see. More planning must 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: Expense 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 each expenses degree of variability. Due to the increased 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 expense’s 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 spending variance and volume variance.

In order to perform a spending variance, 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 subtracting those numbers she found that the spending variance was $61,260. This is an unfavorable outcome of the quarter 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 divided 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 Associate’s expenditures 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 percentage 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 actually supplied 47,250 hours creating a 76% billing percentage. Jenkins noticed there was a difference of 3,600 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 analyzing 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 appear 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 Associate’s spending towards their increase in consultants by directing 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 of $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.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyStudyWriters
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Business and administrative studies
Perfect
Customer 452773, February 23rd, 2023
Business and administrative studies
excellent job!
Customer 452773, May 25th, 2023
History
Looks great and appreciate the help.
Customer 452675, April 26th, 2021
fin571
EXCELLEN T
Customer 452773, March 21st, 2024
ACC/543: Managerial Accounting & Legal Aspects Of Business
EXCELLENT JOB
Customer 452773, January 10th, 2024
Business and administrative studies
excellent job thank you Your Score 166.25/ 175- A 1. Current Culture 15% of total grade 18.37 Criterion "1. Current Culture" has textual feedback Criterion Feedback I see interesting points, though, in general they are not about the culture.
Customer 452773, June 4th, 2023
10th grade English
very good
Customer 452773, March 26th, 2023
Criminal Justice
The paper was not accused of plagiarism and was written very well. I will let you know the grade once it is graded. Thank you
Customer 452671, April 26th, 2021
Human Resources Management (HRM)
excellent work
Customer 452773, July 3rd, 2023
Humanities
Thank youuuu
Customer 452729, May 30th, 2021
DATA565
The support team was late responding , my paper was late because the support team didn't respond in a timely manner. The writer of the paper finally got it right but seems there was a problem getting the revisioin to me.
Customer 452773, April 7th, 2024
Business and administrative studies
Thank you for your hard work and effort. Made a 96 out of 125 points Lacked information from the rubic
Customer 452773, October 27th, 2023
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Close

Sometimes it is hard to do all the work on your own

Let us help you get a good grade on your paper. Get professional help and free up your time for more important courses. Let us handle your;

  • Dissertations and Thesis
  • Essays
  • All Assignments

  • Research papers
  • Terms Papers
  • Online Classes
Live ChatWhatsApp