Estimate manufacturing overhead costs

Assignment Help Managerial Accounting

Reference no: EM13918283

Problem 1 : Analyze cost behavior

Renkas Industries is in the process of analyzing its manufacturing overhead costs. Renkas Industries is not sure if the number of units produced or number of direct labor (DL) hours is the best cost driver to use for predicting manufacturing overhead (MOH) costs. The following information is available:

*Month*	Manufacturing Overhead Costs	Direct Labor Hours	Units Produced	MOH Cost per DL Hour	MOH Cost per Unit Produced
July	$457,000	23,200	3,580	$19.70	$127.65
August	$512,000	26,600	4,290	$19.25	$119.35
September	$421,000	19,000	4,240	$22.16	$ 99.29
October	$449,000	21,500	3,430	$20.88	$130.90
November	$571,000	31,000	5,730	$18.42	$ 99.65
December	$434,000	19,700	3,220	$22.03	$134.78

Requirements

1. Are manufacturing overhead costs fixed, variable, or mixed? Explain.

2. Graph Renkas Industries' manufacturing overhead costs against DL hours. Use Excel or graph by hand.

3. Graph Renkas Industries' manufacturing overhead costs against units produced. Use Excel or graph by hand.

4. Do the data appear to be sound, or do you see any potential data problems? Explain.

5. Use the high-low method to determine Renkas Industries' manufacturing overhead cost equation using DL hours as the cost driver. Assume that management believes all data to be accurate and wants to include all of it in the analysis.

6. Estimate manufacturing overhead costs if Renkas Industries incurs 25,000 DL hours in January.

Problem 2:

Regression analysis Refer to Renkas Industries in Problem 1.

Requirements

1. Use Excel regression analysis to determine Renkas Industries' manufacturing overhead cost equation using DL hours as the cost driver. Comment on the R-square. Estimate manufacturing overhead costs if Renkas Industries incurs 25,500 DL hours in January.

2. Use Excel regression analysis to determine Renkas manufacturing overhead cost equa¬tion using number of units produced as the cost driver. Use all of the data provided. Project total manufacturing overhead costs if Renkas Industries produces 4,900 units. Which cost equation is better-this one or the one from Requirement 1? Why?

3. Use Excel regression analysis to determine Renkas Industries' manufacturing overhead cost equation using number of units produced as the cost driver. This time, remove any potential outliers before performing the regression. How does this affect the R-square? Project total manufacturing overhead costs if 4,900 units are produced.

4. In which cost equation do you have the most confidence? Why?

Reference no: EM13918283

Questions Cloud

Preparing to conduct business research : Develop or select the instruments your team will use to collect data. Write a 700- to 1,050-word paper that addresses the following questions:

What variables could be chosen to use in the modeling : Need to develop a monthly forecast using a regression model, for one year. What variables could be chosen to use in the modeling?

Confidence interval for the population average : Find a 90% confidence interval for the population average μ of the percentage of hospitals providing at least some charity care. (Round your answers to one decimal place.)

Preparing to conduct business research : Which design (qualitative or quantitative) will become the primary research design? How can you most effectively use the power of both designs?

Estimate manufacturing overhead costs : Are manufacturing overhead costs fixed, variable, or mixed? Explain and graph Renkas Industries' manufacturing overhead costs against DL hours. Use Excel or graph by hand.

Which better, and agency employee or independent contractor : Many agents and agencies sell only a few suppliers, called preferred suppliers. Is this a good idea? What are some of the advantages and disadvantages?

Quantitative and qualitative result reporting : Develop the overall data analysis approach and quantitative and qualitative result reporting:

Basic concepts of hypothesis testing : Prepare a maximum of 4 page report.I want you to use JMP and put those figures in the report and the report has to look like the last years sample report that I put here. Basic concepts of hypothesis testing, What is Statistics

Advantages of established click-and-mortar companies : Discuss the advantages of established click-and-mortar companies such as Walmart over pure-play e-tailers such as Amazon.com. Conversely, what are the disadvantages of click-and-brick retailers as compared with pure-play e-tailers?

User Account

All Pages