4 The primary purpose of this assignment is to give you practice calculating variances. The 5...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
4 The primary purpose of this assignment is to give you practice calculating variances. The 5 variances you need to calculate are described under the "REQUIRED" heading below. 6 The secondary purpose of this assignment is to improve your proficiency in using Excel as a tool 7 for analysis (as opposed to word processing software). 8 9 REQUIRED: 10 All yellow cells in this template (right) must be completed with formulas referencing other cells. 11 For example, do not just type the number $661,254 in cell F9. Instead, you must enter the formula 12 in the cell to calculate this number. Indicate whether variances are favorable (FAV) or unfavorable (UNF) 13 in the "green" cells beside each amount. Some formulas will reference the problem; other formulas will 14 use cells in the template. Variances should not have a minus sign or parentheses. 15 16 SUBMISSION: You must submit your Excel file (1) with the yellow and green cells completed and 17 (2) submit a witten report in Word according to Instructions included in the Canvas assignment. You must 18 name the file in this format: ACC3365 Calculations [1st initial, last name] and 19 ACC3365 Letter_[1st initial, last name). Be certain to include your full name in the cell in the upper right comer 20 of the first line (above) in this file. 21 Assignment will not be accepted late other than due to emergency situations as described in the syllabus. 22 23 PROBLEM: Mascot Mfg. makes awnings for athletic team taligating and uses a standard costing system. 24 The company recognizes (isolates) materials price varances at the time the materials are purchased. 25 They allocate (apply) OH based on # of DL hours. 26 Folowing are this year's cost and standards data; assumes 52 weeks per year. 27 SUBMISSION: You must submit your Excel file (1) with the yelow and green cels completed and (2) submit a wntten report in Word according to instructions included in the Canvas assignment. You must name the fle in this format: ACC3365_Calculations_[1st Initial, last name] and ACC3365 Letter (1st initial, last name]. Be certain to include your full name in the cell in the upper right comer of the first line (above) in this file Assignment wil not be accepted late other than due to emergency situations as described in the syllabus. PROBLEM: Mascot Mfg. makes awnings for athletic team tailgating and uses a standard costing system, The company recognizes (isolates) materials price vanances at the time the materials are purchased. They allocate (apply) OH based on # of DL hours. 5 Folowing are this year's cost and standards data; assumes 52 weeks per year. 3 Standards (for a planned level of production of 2,200 units per month) Direct Materials Yards per awning Price per yard$ 22 13 Direct Labor Hours per awning Rate por hour$ Varable MOH standard rate per direct labor hour $ Fixed MOH standard rate per direct labor hour $ Total budgeted fixed MOH cost$ 15 7. 63,500 9 Actual cost and data from the current month: Number of yards purchased Cost of yards purchased $ Number of yards used Number of awnings produced Actual direct labor hours Actual direct labor costS Actual varlable MOH $ 51,260 661,254 $ 12.90 per yd 47,500 2,200 10,850 168,175 $ 15.50 per hr 93,310 67,500 -2 -3 14 15 Actual fixed MOH S 18 19 Calculate these varlances using the templates to the right. 1. Drect material varlances 50 2. Drect lebor veriences 52 3. Variable MOH varances 53 4. Fixed MOH variances 54 Templates Direct Materials Actual Input Quantity x Budgeted (Std) Price Actual Flexible Cost Budget (Applied) Purchases Usage Example: $ 661,254 Price Varlance Efficiency Variance NOTE: There is NO "lotal" variance because Price & Efficiency Variances are measured at different times for DM. Actual Cost Direct Labor Actual Input Quantity x Budgeted (Std) Rate Flexible Budget (Applied) Price Variance Efficiency Variance Flexible Budget (TOTAL) Variance Variable Manufacturing Overhead Actual Input Quantity x Budgeted (Std) Rate Actual Flexible Cost Incurred Budget (Applied) Allocated Spending Variance Efficiency Varience Flexible Budget (TOTAL) Varance Fixed Manufacturing Overhead Actual Flexible Budget (Same as Static) Cost Incumed Static FOH Budget Allocated ser yd per hr Spending Varance Production Volume Variance TOTAL Fixed OH Varlance 4 The primary purpose of this assignment is to give you practice calculating variances. The 5 variances you need to calculate are described under the "REQUIRED" heading below. 6 The secondary purpose of this assignment is to improve your proficiency in using Excel as a tool 7 for analysis (as opposed to word processing software). 8 9 REQUIRED: 10 All yellow cells in this template (right) must be completed with formulas referencing other cells. 11 For example, do not just type the number $661,254 in cell F9. Instead, you must enter the formula 12 in the cell to calculate this number. Indicate whether variances are favorable (FAV) or unfavorable (UNF) 13 in the "green" cells beside each amount. Some formulas will reference the problem; other formulas will 14 use cells in the template. Variances should not have a minus sign or parentheses. 15 16 SUBMISSION: You must submit your Excel file (1) with the yellow and green cells completed and 17 (2) submit a witten report in Word according to Instructions included in the Canvas assignment. You must 18 name the file in this format: ACC3365 Calculations [1st initial, last name] and 19 ACC3365 Letter_[1st initial, last name). Be certain to include your full name in the cell in the upper right comer 20 of the first line (above) in this file. 21 Assignment will not be accepted late other than due to emergency situations as described in the syllabus. 22 23 PROBLEM: Mascot Mfg. makes awnings for athletic team taligating and uses a standard costing system. 24 The company recognizes (isolates) materials price varances at the time the materials are purchased. 25 They allocate (apply) OH based on # of DL hours. 26 Folowing are this year's cost and standards data; assumes 52 weeks per year. 27 SUBMISSION: You must submit your Excel file (1) with the yelow and green cels completed and (2) submit a wntten report in Word according to instructions included in the Canvas assignment. You must name the fle in this format: ACC3365_Calculations_[1st Initial, last name] and ACC3365 Letter (1st initial, last name]. Be certain to include your full name in the cell in the upper right comer of the first line (above) in this file Assignment wil not be accepted late other than due to emergency situations as described in the syllabus. PROBLEM: Mascot Mfg. makes awnings for athletic team tailgating and uses a standard costing system, The company recognizes (isolates) materials price vanances at the time the materials are purchased. They allocate (apply) OH based on # of DL hours. 5 Folowing are this year's cost and standards data; assumes 52 weeks per year. 3 Standards (for a planned level of production of 2,200 units per month) Direct Materials Yards per awning Price per yard$ 22 13 Direct Labor Hours per awning Rate por hour$ Varable MOH standard rate per direct labor hour $ Fixed MOH standard rate per direct labor hour $ Total budgeted fixed MOH cost$ 15 7. 63,500 9 Actual cost and data from the current month: Number of yards purchased Cost of yards purchased $ Number of yards used Number of awnings produced Actual direct labor hours Actual direct labor costS Actual varlable MOH $ 51,260 661,254 $ 12.90 per yd 47,500 2,200 10,850 168,175 $ 15.50 per hr 93,310 67,500 -2 -3 14 15 Actual fixed MOH S 18 19 Calculate these varlances using the templates to the right. 1. Drect material varlances 50 2. Drect lebor veriences 52 3. Variable MOH varances 53 4. Fixed MOH variances 54 Templates Direct Materials Actual Input Quantity x Budgeted (Std) Price Actual Flexible Cost Budget (Applied) Purchases Usage Example: $ 661,254 Price Varlance Efficiency Variance NOTE: There is NO "lotal" variance because Price & Efficiency Variances are measured at different times for DM. Actual Cost Direct Labor Actual Input Quantity x Budgeted (Std) Rate Flexible Budget (Applied) Price Variance Efficiency Variance Flexible Budget (TOTAL) Variance Variable Manufacturing Overhead Actual Input Quantity x Budgeted (Std) Rate Actual Flexible Cost Incurred Budget (Applied) Allocated Spending Variance Efficiency Varience Flexible Budget (TOTAL) Varance Fixed Manufacturing Overhead Actual Flexible Budget (Same as Static) Cost Incumed Static FOH Budget Allocated ser yd per hr Spending Varance Production Volume Variance TOTAL Fixed OH Varlance
Expert Answer:
Answer rating: 100% (QA)
From the given information Direct material variance has two types whi... View the full answer
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these marketing questions
-
The purpose of this assignment is to give you practice working with arrays, passing them to functions, sorting, searching and reading and writing text files. In this program you will read two files...
-
Write a blog post of no more than 800 words . The blog post should include five elements; particularly, it should -have a title and an image -have a logical structure and be targeted for a specific...
-
A Quality Circle leader is confused about the seven basic quality tools, and approaches you to help him in using a tool for identifying the root cause of the problem. Discuss with example what tool...
-
Decide whether solutions of the following salts are acidic, neutral, or basic. a. Ammonium cyanate b. Anilinium cyanate
-
Carly Simon wishes to invest \($18,000\) on July 1, 2025, and have it accumulate to \($50,000\) by July 1, 2035. Use a financial calculator to determine at what exact annual rate of interest Carly...
-
Describe various types of cooling towers.
-
Janes Company provided the following information on intangible assets : a. A patent was purchased from the Lou Company for $700,000 on January 1, 2009. Janes estimated the remaining useful life of...
-
Emily bought 2,000 shares of FMI Fund at an NAVPS of $14.59 with a front-end load of 3%. The fund paid and reinvested a distribution of $1.17 per share. What is her total adjusted cost base?
-
Mr. T makes a good recovery and is discharged from the hospital, but a few weeks later you meet him again in the outpatient clinic complaining of headache, blurred vision, and pinkeye. His eyes are...
-
Simplify x + -5 x
-
Which of the following three functional interfaces is not equivalent to the other two? A. BiFunction B. BinaryOperator C. DoubleFunction D. None of the above. All three are equivalent.
-
Fill in the blanks so this code prints *8.0-8.0*? (Choose two.) A. averageAsDouble() in the first blank B. average().getAsDouble() in the first blank C. getAverage().get() in the first blank D....
-
Which of the following is not a functional interface in the java.util.function package? (Choose two.) A. BiPredicate B. DoubleUnaryOperator C. IntUnaryOperator D. ObjectDoubleConsumer E....
-
Which functional interface, when entered into the following blank, allows the class to compile? A. Consumer. B. Consumer C. DoubleConsumer D. Supplier E. None of the above. } package groceries;...
-
Suppose that you need to read data that consists of serialized int, double, boolean, and String values from a file. You also want the program to be performant on large files. Which three java.io...
-
The current asset conversion cycle is the number of days it takes to purchase, produce, and sell an item, and then to collect on that item. Explain
-
A superior criticized a sales manager for selling high-revenue, low-profit items instead of lower-revenue but higher-profit items. The sales manager responded, My income is based on commissions that...
-
Display all subassemblies and their components where the subassembly contains the words "Top Handle"?
-
What is a relation schema? What is the difference between a relation, a relation schema, and a relational schema?
-
Display only the total number of pounds of milk produced in each region and in each year. Order the results by the totals generated?
-
In 2018, Bert Richards transferred a \(\$ 100,000\) savings account to his wife in trust. The terms of the trust are that income is to be distributed annually to his wife, Mary Beth, the remainder to...
-
In 2018, Mr. Colburn created a trust for the benefit of his five adult children and transferred \(\$ 300,000\) to it. The trustee may decide how much income to pay to each child each year. The trust...
-
In problem 49, when does the estate's taxable year end? problem 49, John Henry died on May 1, 2018. When does his final 1040 have to be filed?
Study smarter with the SolutionInn App