Dee's Trinkets collected the following data over six months: Month | Units produced | Total costs March 12,000 | $28,400 April | 15,000 | $29,600 May | 20,000 | $31,500 June | 14,000 | $29,200 July 13,000 $28,800 August | 16,000 | $30,000 Using high-low method, what is variable cost per unit?

Dee's Trinkets collected the following data over six months: Month | Units produced | Total costs March 12,000 | $28,400 April | 15,000 | $29,600 May | 20,000 | $31,500 June | 14,000 | $29,200 July 13,000 $28,800 August | 16,000 | $30,000 Using high-low method, what is variable cost per unit?

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter3: Cost Behavior And Cost Forecasting

Section: Chapter Questions

Problem 67P: Refer to the information for Farnsworth Company (p. 139) for the first 10 months of data on...

See similar textbooks

Similar questions

Harbor Images has collected the following cost data for various levels of activity: Images Created Total Cost $5,700 $6,320 $9,210 $5,250 Month 6,000 7,750 8,100 4,500 August September October November a. Using the high-low method, determine the variable cost per image created and the total fixed cost. (Round your variable cost to 2 decimal places.) Variable Cost Per Image Fixed Cost Per Month b. Estimate the total costs when 6,500 images are created. (Do not round your intermediate calculations.) Total Costs
a) Determine the variable cost per unit and the fixed cost using the high-low method.b) What is the equation of the total mixed cost function?c) Prepare the scatter diagram and insert the trendline or line of best-fit. Use a scaleof 2 cm to represent 1,000 units on the x-axis & 2 cm to represent $50,000 on the yaxis.
Refer to the information for Farnsworth Company (p. 139) for the first 10 months of data on receiving orders and receiving cost. Now suppose that Tracy has gathered 2 more months of data: Note: For the following requirements, round the intercept terms to the nearest dollar, round the variable rates to the nearest cent, and R2 to two decimal places. Required: 1. Run two regressions using a computer spreadsheet program such as Excel. First, use the method of least squares on the first 10 months of data. Then, use the method of least squares on all 12 months of data. Write down the results for the intercept, slope, and R2 for each regression. Compare the results. 2. CONCEPTUAL CONNECTION Prepare a scattergraph using all 12 months of data. Do any points appear to be outliers? Suppose Tracy has learned that the factory suffered severe storm damage during Month 11 that required extensive repairs to the receiving areaincluding major repairs on a forklift. These expenses, included in Month 11 receiving costs, are not expected to recur. What step might Tracy, using her judgment, take to amend the results from the method of least squares? 3. CONCEPTUAL CONNECTION Rerun the method of least squares, using all the data except for Month 11. (You should now have 11 months of data.) Prepare a cost formula for receiving based on these results, and calculate the predicted receiving cost for a month with 1,450 receiving orders. Discuss the results from this regression versus those from the regression for 12 months of data.
Scattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated? Use the following information for Problems 3-60 and 3-61: Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controllers department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:
If the indirect costs for each duration are $300 for 27 weeks, $240 for 26 weeks, $180 for 25 weeks, $120 for 24 weeks, $60 for 23 wowowo (weeks, and $50 for 22 weeks, compute the direct, indirect, and total costs for each duration. What is the optimum cost-time INCONDUGULILE T DONDO schedule? waiting thalin www.tomamilionima Ellenton Act. = m ---- B Crash Cost (Slope) 80 30 40 50 100 30 Maximum Crash Time Normal Time 23124= 10 855560 15 Normal Cost 40 10 80 51 50 TUT 100 20 $300 Time unit 1 wook
A known manufacturing company has estimated the ff. Component for a new product. Fixed cost= 50,000 Material cost per unit= 2.15 Labor cost per unit = 2 Revenue per unit= 7.50 Vary the production volume from 0 to 100,000 in increments of 10,000. The five different material costs are 1.50,1.95,2.15,2.85 and 3.25. Using the spreadsheet model, what will be the resulting profit if the company decides to make 70,000 units of the new product. Choices: A.623,018 B.176,400 C.45,705 D.No choice given E.138,430
Given the following data: Contribution margin per unit: Product A $11Product B $12 Machine hours required for one unit: Product A 2 hoursProduct B 2.5 hours A. Compute the contribution margin per unit of limited resource for each product.
sing the following data, apply the high-low method of cost analysis to the three cost data groups: Volume Alpha Beta Gamma 2,000 $6,600 $2,400 $8,000 6,000 $9,800 $7,000 $8,000 13,000 $13,000 $12,000 $8,000 20,000 $21,000 $24,000 $8,000 What cost behavior patterns are apparent for Beta? Select one: a. Fixed b. Variable c. Mixed d. Semi-fixed e. None of the above
Global Publishers has collected the following data for recent months: Month March April May June Issues published 20,500 21,800 17,750 21,200 Total cost Variable cost per unit $ Total fixed costs $ Required: a. Using the high-low method, find variable cost per unit, total fixed costs, and the total cost equation. Round the variable cost to two decimal places. $20,960 22,464 18,495 21,395 per unit Total cost = $ x Number of issues published) b. What is the estimated cost for a month in which 19,000 issues are published?
Compute the breakeven point and verify it from the following data: Fixed Costs: $140,000 Variable Cost Percentage: 60 percent
What are the estimated direct labor costs?
Voltar has collected the following data for recent months Month Miles Driven Total Cost March 41,00O 30,690 April 43,600 44,234 May 35,500 37,000 June 42,400 31,593 Required: a) Using the high-low method, find variable cost per unit, total fixed cost, and total cost equation? b) What is the estimated cost for a month in which 38,000 miles are driven