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...
-
Safety Chemical produces and sells an ice-melting granular used on roadways and sidewalks in winter. It annually produces and sells about 100 tons of its granular. In its nine-year history, the...
-
Riana Miren and Trinh are 28 and 37 years old, respectively. Based on a normal distribution with mean 52.8 years and standard deviation 10.3, what is the probability that a skydiver will be between...
-
A six cylinder, four-stroke, spark ignition engine of bore \(10 \mathrm{~cm}\) and stroke \(12 \mathrm{~cm}\) with a compression ratio of 6 is tested at \(4800 \mathrm{rpm}\) on a dynamometer of arm...
-
Allocating costs of service centers to operating departments step method Hardy Health Care Center, Inc., has three clinics servicing the Seattle metropolitan area. The companys legal services...
-
A positively charged particle Q 1 = + 4 5 nC is held at fixed position. A second charge Q 2 of mass m = 3 . 5 mu g is located a distance d = 3 5 cm directly above charge Q 1 . The net force on Q 2 is...
-
Jill Beaver was an employee at RGIS Inventory Specialists. She became ill while on vacation with acute sinusitis, bronchitis, and an ear infection. She was prescribed an antibiotic by a physician,...
-
Johnson Manufacturing company, a manufacturer of custom-made drones, uses a job order cost system to accumulate costs in its manufacturing plant. The company allocates manufacturing overhead on the...
-
Civil or criminal? This assignment is designed to help you remember the difference. You will make a poster highlighting the differences between civil and criminal law. The poster should be arranged...
-
How much has innovation reduced the effects of coronavirus disease?
-
Property can be acquired for private development via Will. In some cases, the court will intervene to vary the provisions of the Will. Here is an example of that - what are your views about this?...
-
A basketball player makes a jump shot. The 0.600-kg ball is released at a height of 2.06 m above the floor with a speed of 7.35 m/s. The ball goes through the net 3.10 m above the floor at a speed of...
-
Many of the writers that we have examined in this term make use of various Rhetorical Strategies and Devices to support the main themes of their work. Discuss and analyse how Jonathan Swift uses...
-
You are employed as a senior analyst in a private investment firm that focuses on companies in the information technology industry. The Chief Investment Officer (CIO) has asked you to compare and...
-
Citing a scientific article, explain in your own words, how DNA fingerprinting has been used in forensic science to solve crimes and why it may not always be accurate or effective.
-
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...
-
When and why should exchange rates change under a fixed-exchange-rate system?
-
Using the diagram in exercise 5, illustrate the effect of the change in Japanese tastes if exchange rates are fixed. What will happen to the foreign exchange market equilibrium? Data from in exercise...
-
How does a currency speculator profit from exchange-rate changes? Give an example of a profitable speculation.
Study smarter with the SolutionInn App