Explain the variances in the sheet below. Revenues (billed out): - Labor (hrs.) - Labor rate (S/hr.)
Fantastic news! We've Found the answer you've been seeking!
Question:
Explain the variances in the sheet below.
Transcribed Image Text:
Revenues (billed out): - Labor (hrs.) - Labor rate (S/hr.) - Parts (S/hr.) Costs: - Labor (hrs.) - Labor (S/hr.) - Parts (% of revenue) Revenues: - Labor - Parts Costs: - Labor - Parts Gross Margin Overhead: - Space - General & Admin. - Depreciation - Legal & Regulatory Budget 3,456 120 345 414,720 437,760 1,192,320 1,168,092 Total Revenues 1,607,040 1,605,852 Total Overhead 3,840 42 80% 161,280 168,650 953,856 899,431 Total Costs 1,115,136 1,068,080 Net before Taxes Taxes Net after Taxes Actual 3,648 120 320 3,877 44 77% 75,000 35,000 68,500 18,000 196,500 491,904 537,772 75,000 35,000 68,500 18,000 196,500 295,404 341,272 62,035 71,667 233,369 269,605 MRO Department - 2020 Results Fav./(Unfav.) 192 - (25) 37 2 -3% $ Fav./(Unfav.) 23,040 (24,228) (1,188) 7,370 (54,425) (47,056) 45,868 45,868 9,632 36,235 Labor Variance Revenue (hrs.) Rate (S/hr.) Costs (hrs.) Labor (S/hr.) Total Change in Gross Margin 45,868 23,040 (1,610) (5,760) 15,671 Parts Variance Revenue (hrs.) Revenue (S/hr.) Costs (hrs.) Costs (S/hr.) Mark-up Other Total 66,240 (90,468) 52,992 fav (68,565) unf (35,770) unfav (3,082) unfav tie out 30,197 Insert your text explanation of the variances here. Revenues (billed out): - Labor (hrs.) - Labor rate (S/hr.) - Parts (S/hr.) Costs: - Labor (hrs.) - Labor (S/hr.) - Parts (% of revenue) Revenues: - Labor - Parts Costs: - Labor - Parts Gross Margin Overhead: - Space - General & Admin. - Depreciation - Legal & Regulatory Budget 3,456 120 345 414,720 437,760 1,192,320 1,168,092 Total Revenues 1,607,040 1,605,852 Total Overhead 3,840 42 80% 161,280 168,650 953,856 899,431 Total Costs 1,115,136 1,068,080 Net before Taxes Taxes Net after Taxes Actual 3,648 120 320 3,877 44 77% 75,000 35,000 68,500 18,000 196,500 491,904 537,772 75,000 35,000 68,500 18,000 196,500 295,404 341,272 62,035 71,667 233,369 269,605 MRO Department - 2020 Results Fav./(Unfav.) 192 - (25) 37 2 -3% $ Fav./(Unfav.) 23,040 (24,228) (1,188) 7,370 (54,425) (47,056) 45,868 45,868 9,632 36,235 Labor Variance Revenue (hrs.) Rate (S/hr.) Costs (hrs.) Labor (S/hr.) Total Change in Gross Margin 45,868 23,040 (1,610) (5,760) 15,671 Parts Variance Revenue (hrs.) Revenue (S/hr.) Costs (hrs.) Costs (S/hr.) Mark-up Other Total 66,240 (90,468) 52,992 fav (68,565) unf (35,770) unfav (3,082) unfav tie out 30,197 Insert your text explanation of the variances here.
Expert Answer:
Answer rating: 100% (QA)
From the given sheet we can analyze the variances in different categories Labor Variance Labor hrs The actual labor hours worked were 3877 which is 37 ... View the full answer
Related Book For
Horngrens Financial and Managerial Accounting
ISBN: 978-0133866292
5th edition
Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these finance questions
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the companys Pacific region salespeople just returned to the office with a newly designed...
-
In this game, students fence off an area of the drill field and divide it up into a series of equally sized squares. (We will assume there are 500 such squares organized into a 20 by 25 matrix.) Each...
-
The registrar at a prominent northeastern university recently scheduled an instructor to teach two different classes at the same exact time. Help the registrar prevent future mistakes by describing a...
-
Consider a system of particles interacting by magnetic forces. Are Equation 9.11 and 9.31 valid? Explain.
-
Exhibit 5.26 presents risk ratios for Walmart for 2014 and 2013. Exhibits 1.19, 1.20, and 1.21 in Chapter 1 present the financial statements for Walmart. REQUIRED a. Compute the values of each of the...
-
Raynards Jewellery had the following data (in thousands) for a given period. Assume there are no inventories. Fill in the blanks. ales Direct materials irect labour actory overhead Manufacturing cost...
-
Prescott Companys predetermined overhead rate is 200% of direct labor. Information on the companys production activities during September 2013 follows. a. Purchased raw materials on credit, $...
-
Question 2 of 2 -/30 Ivanhoe Willis is the advertising manager for Bargain Shoe Store. She is currently working on a major promotional campaign. Her ideas: include the installation of a new lighting...
-
Jaguar Plastics Company has been operating for three years. At December 31 of last year, the accounting records reflected the following: Cash Investments (short- term) Accounts receivable Inventory...
-
The post-closing trial balance of Juditha Papasin is presented below: P 80,000 100,000 Cash Accounts Receivable Allow. for Doubtful Accounts Merchandise Accounts Payable J. Papasin, Capital 175,000...
-
Larry died on 1 November 2023 leaving an estate valued at 300,000. He had never had a wife or civil partner and he left his estate to his best friend. On 1 October 2015 he had set up a discretionary...
-
A mode is always a value that is in the data set. In Exercises 1316, determine whether the statement is true or false. If the statement is false, rewrite it as a true statement.
-
According to the National Vital Statistics Reports, the mean life expectancy for United States was 78.7 years and the median was 83.5. If a histogram were constructed for the lifespans of all people...
-
Auditors gather a number of different types of evidence in the course of an audit, including physical evidence, third-party representations, documentary evidence, computations, data...
-
What is the Public Oversight Board? What is its purpose?
-
Please show all work, thank you. Red Creek Industrial of Nashville TN purchased automated machinery from Hamburg Manufacturing of Germany for \( ? 5,000,000 \) with payment due in 6 months. The...
-
3.16. For a system with non-identical service rates (see Sect. 3.5) and a limit of N jobs in the system (Eq. 3.13), obtain an expression for the mean service time per job, E[Ts], as a function of the...
-
The adjusted trial balance of Elmo Real Estate Appraisal at June 30, 2016, follows: Requirements 1. Prepare the companys income statement for the year ended June 30, 2016. 2. Prepare the companys...
-
Top managers of Stenback Industries predicted 2016 sales of 14,900 units of its product at a unit price of $7.00. Actual sales for the year were 14,300 units at $10.50 each. Variable costs were...
-
Yeaman expects total sales of $333,000 in January and $407,000 in February. Assume that Yeamans sales are collected as follows: 60% in the month of the sale 30% in the month after the sale 8% two...
-
A bank in California has 13 branches spread throughout northern California, each with its own minicomputer where its data are stored. Another bank has 10 branches spread through- out California, with...
-
Discuss why any distinction between IS auditing and financial auditing is not meaningful.
-
Discuss the key features of Section 404 of the Sarbanes-Oxley Act.
Study smarter with the SolutionInn App