[SOLVED] Variance Analysis and Benchmarking

I’m trying to learn for my Accounting class and I’m stuck. Can you help?

Struggling to find relevant content? Order a custom essay on
[SOLVED] Variance Analysis and Benchmarking
Let our experts save you the hassle
Order Now

Option #1: Variance Analysis and Benchmarking

Your supervisor has asked you to prepare some calculations based on the company’s data and then research publicly available similar competitor information to see how your company is performing within the industry. Your company, CarryIt Inc., produces mass quantity, inexpensive tote bags for promotional marketing purposes, which is a very competitive business.

Here is the available data for your company:

  • Labor hours .25;
  • Labor rate $11.75/hour;
  • Materials input .5 yds. fabric;
  • Materials price $1.50/yd.; and
  • Variable overhead rate $5.00 per direct labor hour.

You are also able to find an industry profile report via a Dun & Bradstreet database that has selected data from a few other companies in similar businesses as well as some industry statistics.

Here’s the data available:

Unit Variable Cost Item Star Company GoldBag Corporation PromoTotes LLC Industry Data
Labor hours .35 .20 .30 .30
Labor rate $11.25 $11.95 $12.50 $11.65
Materials input .45 yds. .675 yds. .50 yds. .55 yds.
Materials price $1.65/yd. $1.35/yd. $1.55/yd. $1.50/yd.
Variable OH rate $6.00 per direct labor hour $5.25 per direct labor hour $4.70 per direct labor hour $5.45 per direct labor hour

For your task, in Microsoft Excel, compute the following measures:

  1. Total variable cost per unit for CarryIt, the competitors, and the industry average.
  2. What is the percentage of the total for each component (materials, labor, and variable overhead)?
  3. Assume industry data is your benchmark. What are the price and efficiency variances for direct materials and direct labor for each company?
  4. What is the percentage over standard by company and by variance?

Below the computations in Excel, please summarize your observations about how CarryIt’s performance stacks up to its competition from the benchmarking exercise in 2-3 well written paragraphs. Include suggestions for areas of improvement and comments on areas where the company does well.

Submit your responses in an Excel spreadsheet, neatly organized. Your paper must be formatted according to CSU-Global Guide to Writing and APA Requirements (Links to an external site.). Reference Lynda.com in the CSU-Global Library (Links to an external site.) for Microsoft Excel tutorials or use the Excel Tutorials link found in the classroom if assistance is needed.

Review the Module 6 Critical Thinking Rubric for full details on how you will be graded on this assignment.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*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.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment 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.
Get personalized services with GPA Fix
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Great! Thanks again!
Customer 452707, July 4th, 2022
Customer 452813, July 5th, 2022
Criminal Justice
Thank you for the great paper. I like how the writer structured it.
Customer 452627, October 2nd, 2021
Social Work and Human Services
Great Work!
Customer 452587, November 2nd, 2021
Customer 452813, June 25th, 2022
Great Work!
Customer 452587, March 10th, 2022
Professions and Applied Sciences
Thank you!
Customer 452707, March 4th, 2022
Customer 452813, July 3rd, 2022
Thank you great job
Customer 452813, July 10th, 2022
Criminal law
Thank You!
Customer 452465, January 29th, 2021
Business and administrative studies
Customer 452813, June 20th, 2022
Customer 452813, June 25th, 2022
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
error: Content is protected !!

Save More. Score Better. Use coupon code SPECIAL for a 15%discount