What is the percentage over standard by company and by variance? Untitled - Paint File Home View
Fantastic news! We've Found the answer you've been seeking!
Question:
What is the percentage over standard by company and by variance?
Transcribed Image Text:
Untitled - Paint File Home View Jx A B C D E F G K9 1 Carrylt Inc AutoSave Off E Tejada_ACT460_mod6 opt 1 - Excel Sign in File Home Insert Page Layout Formulas Data Review View Help O Tell me X fx A B C D E F G H 2 Unit Variable Cost Item Star Goldbag PromoTotes Industry Carrylt 30 3. Price and Efficiency variance 3 Company Corporation LLC Data Inc Efficiency Variance 31 4 Labor Hours 5 Labor Rate ($ per hour) 0.35 0.20 0.30 0.30 0.25 Star Goldbag Company Corporation LLC PromoTotes Carrylt Inc 11.25 11.95 12.50 11.65 11.75 32 Labor 6 Materials Input (yards) 0.45 0.68 0.50 0.55 0.50 33 Actual 0.35 0.20 0.30 0.25 7 Materials Price ($ per yard) 1.65 1.35 1.55 1.50 1.50 34 Standard 0.30 0.30 0.30 0.30 Variable Overhead (OH) rate (per direct 6.00 5.25 4.70 5.45 5.00 35 Standard Rate 11.65 11.65 11.65 11.65 8 labor hour) 36 Variance (actual-standard)*rate 0.5825 -1.165 0 -0.5825 37 Material 9 38 Actual 0.45 0.68 0.50 0.50 10 39 Standard 0.55 0.55 0.55 0.55 11 1. Total variable cost per unit Star Goldbag PromoTotes Industry 40 Standard Rate 1.50 1.50 1.50 1.50 12 13 Labor Hours 14 Labor Rate (cost/hour) Company Corporation LLC Data Carrylt Inc 41 Variance (actual-standard)*rate -0.15 0.1875 -0.075 -0.075 42 Variable Overhead 0.35 0.20 0.30 0.30 0.25 43 Actual 11.25 11.95 12.50 11.65 11.75 15 Labor cost per unit (a) 44 Standard 3.94 2.39 3.75 3.50 2.94 16 Material Input 45 Standard Rate 0.45 0.68 0.50 0.55 0.50 17 Materials Price (cost/yard) 1.65 1.35 1.55 1.50 1.50 46 Variance (actual-standard)*rate 0.35 0.20 0.30 0.25 0.30 0.30 0.30 0.30 5.45 5.45 5.45 5.45 0.2725 -0.545 0 -0.2725 47 18 Materials cost per unit (b) 0.74 0.91 0.78 0.83 0.75 **Negative Variance is favorable, doing better then average 48 19 Labor Hour 0.35 0.20 0.30 0.30 0.25 20 Variable OH per labor hour 6.00 5.25 4.70 5.45 5.00 Price Variance 21 Variable OH per unit (c) 49 2.10 1.05 1.41 1.64 1.25 Star Goldbag PromoTotes Company Corporation LLC Carrylt Inc 22 Variable cost (a+b+c) (d) 50 Labor 6.78 4.35 5.94 5.96 4.94 51 Actual Cost 11.25 11.95 12.50 11.75 23 52 Standard Cost 11.65 11.65 11.65 11.65 24 2. Percentage of total for each component Star Goldbag PromoTotes 25 Company Corporation LLC Industry Data Carrylt Inc 53 Actual Hours 0.35 0.20 0.30 0.25 54 Variance (actual-standard)* actual hrs -0.14 0.06 0.255 0.025 26 Labor cost per unit (a/d) 58.08% 54.93% 27 Materials cost per unit (b/d) 10.95% 20.94% 28 Variable OH per unit (c/d) 30.97% 24.13% 63.18% 58.69% 59.49% 13.06% 13.85% 15.19% 27.46% 23.76% 25.32% 55 Material 56 Actual Cost 1.65 1.35 1.55 1.50 57 Standard Cost 1.50 1.50 1.50 1.50 29 58 Actual Quantity 0.45 0.68 0.50 0.50 30 3. Price and Efficiency variance Sheet1 Select destination and press ENTER or choose Paste < 59 Variance (actual-standard)* actual qty 60 Variable Overhead 0.0675 -0.10125 0.025 0 Sheet1 (+ Ready + E 1920 x 1080px S X Share + 100% Display Settings 100% 2:02 PM 88 11/21/2018 (+ Untitled - Paint File Home View Jx A B C D E F G K9 1 Carrylt Inc AutoSave Off E Tejada_ACT460_mod6 opt 1 - Excel Sign in File Home Insert Page Layout Formulas Data Review View Help O Tell me X fx A B C D E F G H 2 Unit Variable Cost Item Star Goldbag PromoTotes Industry Carrylt 30 3. Price and Efficiency variance 3 Company Corporation LLC Data Inc Efficiency Variance 31 4 Labor Hours 5 Labor Rate ($ per hour) 0.35 0.20 0.30 0.30 0.25 Star Goldbag Company Corporation LLC PromoTotes Carrylt Inc 11.25 11.95 12.50 11.65 11.75 32 Labor 6 Materials Input (yards) 0.45 0.68 0.50 0.55 0.50 33 Actual 0.35 0.20 0.30 0.25 7 Materials Price ($ per yard) 1.65 1.35 1.55 1.50 1.50 34 Standard 0.30 0.30 0.30 0.30 Variable Overhead (OH) rate (per direct 6.00 5.25 4.70 5.45 5.00 35 Standard Rate 11.65 11.65 11.65 11.65 8 labor hour) 36 Variance (actual-standard)*rate 0.5825 -1.165 0 -0.5825 37 Material 9 38 Actual 0.45 0.68 0.50 0.50 10 39 Standard 0.55 0.55 0.55 0.55 11 1. Total variable cost per unit Star Goldbag PromoTotes Industry 40 Standard Rate 1.50 1.50 1.50 1.50 12 13 Labor Hours 14 Labor Rate (cost/hour) Company Corporation LLC Data Carrylt Inc 41 Variance (actual-standard)*rate -0.15 0.1875 -0.075 -0.075 42 Variable Overhead 0.35 0.20 0.30 0.30 0.25 43 Actual 11.25 11.95 12.50 11.65 11.75 15 Labor cost per unit (a) 44 Standard 3.94 2.39 3.75 3.50 2.94 16 Material Input 45 Standard Rate 0.45 0.68 0.50 0.55 0.50 17 Materials Price (cost/yard) 1.65 1.35 1.55 1.50 1.50 46 Variance (actual-standard)*rate 0.35 0.20 0.30 0.25 0.30 0.30 0.30 0.30 5.45 5.45 5.45 5.45 0.2725 -0.545 0 -0.2725 47 18 Materials cost per unit (b) 0.74 0.91 0.78 0.83 0.75 **Negative Variance is favorable, doing better then average 48 19 Labor Hour 0.35 0.20 0.30 0.30 0.25 20 Variable OH per labor hour 6.00 5.25 4.70 5.45 5.00 Price Variance 21 Variable OH per unit (c) 49 2.10 1.05 1.41 1.64 1.25 Star Goldbag PromoTotes Company Corporation LLC Carrylt Inc 22 Variable cost (a+b+c) (d) 50 Labor 6.78 4.35 5.94 5.96 4.94 51 Actual Cost 11.25 11.95 12.50 11.75 23 52 Standard Cost 11.65 11.65 11.65 11.65 24 2. Percentage of total for each component Star Goldbag PromoTotes 25 Company Corporation LLC Industry Data Carrylt Inc 53 Actual Hours 0.35 0.20 0.30 0.25 54 Variance (actual-standard)* actual hrs -0.14 0.06 0.255 0.025 26 Labor cost per unit (a/d) 58.08% 54.93% 27 Materials cost per unit (b/d) 10.95% 20.94% 28 Variable OH per unit (c/d) 30.97% 24.13% 63.18% 58.69% 59.49% 13.06% 13.85% 15.19% 27.46% 23.76% 25.32% 55 Material 56 Actual Cost 1.65 1.35 1.55 1.50 57 Standard Cost 1.50 1.50 1.50 1.50 29 58 Actual Quantity 0.45 0.68 0.50 0.50 30 3. Price and Efficiency variance Sheet1 Select destination and press ENTER or choose Paste < 59 Variance (actual-standard)* actual qty 60 Variable Overhead 0.0675 -0.10125 0.025 0 Sheet1 (+ Ready + E 1920 x 1080px S X Share + 100% Display Settings 100% 2:02 PM 88 11/21/2018 (+
Expert Answer:
Related Book For
Fundamentals of Physics
ISBN: 978-1118230725
10th Extended edition
Authors: Jearl Walker, Halliday Resnick
Posted Date:
Students also viewed these accounting questions
-
Annie works at a pharmacy and teaches guitar lessons on the side. Should Annie report her income from both jobs on her federal tax return
-
use a census website that posts information on variables observed in the city where you live. Here is the website address....
-
TranscribedText: Account Receivables Accounts Payable Sales Revenue Raw Materials Salaries and Wages Payable Cost of Goods Sold Work In Process Salaries and Wages Expense Finished Goods Advertising...
-
You borrowed $325000 using a 30- year fixed rate mortgage with a 5.25% interest rate: A) What is your schedule monthly payment? B) What is the amount of interest and principal paid with the first...
-
Consider the following exotic option whose payoff at maturity is given by the square root of the stock price less the strike price if it has a positive value, zero otherwise: max[ S(2) K,0]. Using...
-
D-Threose can exist in a furanose form but not in a pyranose form. Explain. Draw the b-furanose structure.
-
Ithalid Company began business on January 1, 2006, with assets of $150,000 cash and equity of $150,000 capital shares. In 2006 it manufactured some inventory at a cost of $60,000, including $12,000...
-
The Northern Division of Shea Corporation makes and sells tables and beds. The following estimated revenue and cost information from the divisions ABC system is available for 2013. Additional...
-
A health magazine reported that 27% of adult males smoke cigarettes. To test this claim, they select 40 adult males at random and record if they smoke cigarettes. They calculate a 95% confidence...
-
Calculate P Ltd's cost of investment in S Ltd on the acquisition date (Round the discount factor to 7 decimal places and final answer to the nearest dollar amount). Calculate the amount of goodwill...
-
Select two video games that you will play for the week. They must be similar genres and must be similar type of game. They must be from similar platforms. There is a difference between mobile games...
-
1. Review the types of secret tests. For each type, provide an example from your own life in which you have engaged in the secret test or observed a friend doing so. For each example, state whether...
-
Encode the beq instruction below: bs_for_start: bge sll add 1w lw slt beq SW SW li bs_if_end: addi j $t1, $al, bs_for_end $t2, $t1, 2 $t2, $t2, $a0 $t3, -4($t2) $t4, 0($t2) $at, $t3, $t4 $at, $zero,...
-
A proposal is a plan or suggestion that you put forward to be considered by others. Think of your proposal as a "brainstorm", or a planning guide for your transfer assignment. You can always change...
-
1-Outline of policies and procedures managing the administration of medication SCHOOL SETTING 2- a description of your own responsibilities as a teaching assistant and accountabilities in relations...
-
three recent industry examples of a successful change in leadership approach within the tourism and hospitality sector.
-
Graph the following conic sections, labeling vertices, foci, directrices, and asymptotes (if they exist). Give the eccentricity of the curve. Use a graphing utility to check your work. 10 5 + 2 cos 0
-
The April 17, 2001, issue of the Wall Street Journal includes an article by James Bandler and Mark Maremont entitled "How Xerox's Plan to Reduce Taxes While Boosting Earnings Backfired." Instructions...
-
Ann Osborne recently graduated from college with a degree in landscape architecture. Her father runs a tree, shrub, and perennial-flower uursery, and her brother has a business delivering lopsoil,...
-
Net income is $132,000. During the year,counts payable increased $10,000, inventory decreased $6,000, and accounts receivable in- creased $12,000. Under the indirect method, net cash provided by...
Study smarter with the SolutionInn App