Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Help me find the estimated overhead cost for part 2 of this question. Please explain in detail. B 1 Meyer Grove Comphny has large overhead
Help me find the estimated overhead cost for part 2 of this question. Please explain in detail.
B 1 Meyer Grove Comphny has large overhead costs relative to its direct material and direct labor costs. Because of the 2 significance of these overhead costs, management is trying to better understand what is driving them. 3 4 The management team has asked the accountant to gather select information for some of the activities 5 and product costs that they believe might be driving the overhead costs. The possible cost drivers 6 that the team is looking at indude direct labor hours, machine hours, direct material costs, and number of material moves. 7 8 Data pertaining to the past 18 months for overhead costs as well as usage information for the possible cost drivers 9 is presented below: 10 #of material 11 DL hours Machine hours DM costs moves Overhead costs 12 Jul-18 4,100 1,950 15,000 6 195,000 13 Aug-18 4,250 2,250 21,500 16 220,000 14 Sep-18 3,500 2,400 14,700 4 170,000 15 Oct-18 4,200 1,950 20,000 18 260,000 16 Nov-18 4,500 2,500 23,500 20 300,000 17 Dec-18 4,100 2,600 20,500 22 275,000 18 Jan-19 3,400 3,100 26,000 12 230,000 19 Feb-19 3,900 2,750 33,000 10 305,000 20 Mar-19 4,300 2,000 31,500 9 320,000 Apr-19 4,200 1,850 34,000 15 315,000 22 May-19 4,450 2,200 33,000 11 340,000 Jun-19 3,850 2,300 32,000 20 280,000 24 Jul-19 3,950 1,800 34,000 22 290,000 25 Aug-19 4,050 2,250 32,000 16 318,000 26 Sep-19 4,300 2,200 27,500 13 315,000 27 Oct-19 4,350 2,500 28,000 21 310,000 Nov-19 4,000 2,100 31,500 28 280,000 29 Dec-19 4,400 2,250 22,000 19 300,000 21 23 28 30 31 32 52 53 2. Using the regression model that you specified in part 1, predict this company's 54 overhead costs for next month if the following cost driver levels are expected: 55 56 direct labor hours 3900 57 machine hours 2400 58 direct material costs 24,000 59 number of material moves 14 60 5 61 62 63 64 165 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started