2. Al-Bustan Co. gathered the following information on total costs and factory machine usage for the last six months: Month January February March Total Cost RO. 14,810 29,210 29,000 19,340 29,810 14,910 Factory Machine Hours 13,900 16,600 6,600 13,200 16,500 6,800 April May June Instructions Using the high-low method of analyzing costs, answer the following questions and show computations to support your answers. (a) What is the variable portion of the mixed costs? What is the fixed portion of the mixed costs? (b) (c) If it is estimated that 5,000 factory machine hours will be run in July, what is the expected total cost for July?

2. Al-Bustan Co. gathered the following information on total costs and factory machine usage for the last six months: Month January February March Total Cost RO. 14,810 29,210 29,000 19,340 29,810 14,910 Factory Machine Hours 13,900 16,600 6,600 13,200 16,500 6,800 April May June Instructions Using the high-low method of analyzing costs, answer the following questions and show computations to support your answers. (a) What is the variable portion of the mixed costs? What is the fixed portion of the mixed costs? (b) (c) If it is estimated that 5,000 factory machine hours will be run in July, what is the expected total cost for July?

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 61P: Method of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a...

See similar textbooks

Similar questions

The following product costs are available for Kellee Company on the production of eyeglass frames: direct materials, $32,125; direct labor, $23.50; manufacturing overhead, applied at 225% of direct labor cost; selling expenses, $22,225; and administrative expenses, $31,125. The direct labor hours worked for the month are 3,200 hours. A. What are the prime costs? B. What are the conversion costs? C. What is the total product cost? D. What is the total period cost? E. If 6.425 equivalent units are produced, what is the equivalent material cost per unit? F. What is the equivalent conversion cost per unit?
Cushing, Inc., costs products using a normal costing system. The following data are available for last year: Overhead is applied on the basis of direct labor hours. What was last years per unit product cost? a. 1.39 b. 4.40 c. 4.43 d. 3.01
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:
Method of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. However, assume that Tracy has used the method of least squares on the receiving data and has gotten the following results: Required: 1. Using the results from the method of least squares, prepare a cost formula for the receiving activity. 2. Using the formula from Requirement 1, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? (Note: Round your answer to the nearest dollar.) 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?
I. PROBLEM SOLVINGAnswer the following items on the space provided. Show your computations.At the beginning of 201A, ABC Company had the following standard costs for one (1) of its chemical products:Direct material (3 pounds at P3.20) P9.60Labor standard (0.9 hours at P9.00) 8.10Variable overhead (0.9 hours at P1.50) 1.35Fixed overhead (0.9 hours at P4.00) 3.60Total P22.65ABC computes its overhead rates using budgeted capacity, which is 144,000 units. Actual results for 201Aare:Units produced 140,000 unitsMaterials purchased 421,175 lbs. at P3.30Materials used 421,000 lbs.Direct labor 128,750 hrs at P8.90Fixed overhead P517,525Variable overhead 218,000Required: Indicate whether conditions are favorable or unfavorable. 1. Material purchase price variance (MPPV)2. Material price usage variance (MPUV)3. Material quantity variance (MQV)4. Labor rate variance (LRV)5. Labor efficiency variance (LEV)6. Variable overhead (VOH) rate variance7. VOH efficiency variance8. Fixed overhead (FOH)…
*(A)The Mortise Company has assembled the following data pertaining to certain costs that cannot be easily identified as either fixed or variable. Mortise has heard about a method of measuring cost functions called the high-low method and has decided to use it in this situation.Month Cost HoursJanuary $40,000 3,600 February 38,500 3,000 March 36,280 3,300 April 38,000 3,500 May 69,850 5,850 June 45,000 4,250Required:a. What is the slope coefficient?b. What is the constant for the estimated cost equation?c. What is the estimated cost function for the above data? d. What is the estimated total cost at an operating level of 3,100 hours? *(B) The XYY company has received an initial order for eight of its products (GGG). The information about products as follows: - Direct material cost per (GGG) $ 100,000 - Direct- assembly labor time for first GGG 4,000 labor-hours - Learning curve for assembly labor time per GGG 80% cumulative average time- Direct -assembly labor cost $ 50 per hour-…
I. PROBLEM SOLVINGAnswer the following items on the space provided. Show your computations.At the beginning of 201A, ABC Company had the following standard costs for one (1) of its chemical products:Direct material (3 pounds at P3.20) P9.60Labor standard (0.9 hours at P9.00) 8.10Variable overhead (0.9 hours at P1.50) 1.35Fixed overhead (0.9 hours at P4.00) 3.60Total P22.65ABC computes its overhead rates using budgeted capacity, which is 144,000 units. Actual results for 201Aare:Units produced 140,000 unitsMaterials purchased 421,175 lbs. at P3.30Materials used 421,000 lbs.Direct labor 128,750 hrs at P8.90Fixed overhead P517,525Variable overhead 218,000Required: Indicate whether conditions are favorable or unfavorable. 4. Labor rate variance (LRV)5. Labor efficiency variance (LEV)6. Variable overhead (VOH) rate variance7. VOH efficiency variance8. Fixed overhead (FOH) spending variance9. FOH volume variance
Shown below are units produced and total manufacturing costs for the pastfour months at Minda Manufacturing Corporation: Units Produced Total CostJul 120 P446,000Aug 150 P508,000Sep 180 P638,000Oct 170 P668,000What is Minda's cost formula for total manufacturing costunder the high-lowmethod?
Determine fixed and variable costs using the high-low method and prepare graph. E2.26 (LO 3) The controller of Furgee Industries has collected the following monthly expense data for use in analyzing the cost behaviour of maintenance costs. Total Maintenance Costs Total Machine Hours Month January February March April May June $2,500 3,000 3,600 4,500 3,200 4,900 300 350 500 690 400 700 Instructions a. Determine the fixed and variable cost components using the high-low method. b. Prepare a graph showing the behaviour of maintenance costs, and identify the fixed and variable cost components. Use 100-hour increments and $1,000 cost increments.
HELP ME
Neelopak Berhad prepared the standard cost data for one of their products.Direct Labour (0.65 hours @ RM11) RM7.15Direct Materials (5 meters @ RM5) RM25Variable Overhead (0.65 hours @ RM7) RM4.55Fixed Overhead (0.65 hours @ RM3) RM1.95Standard cost per unit RM38.65There is the actual cost data information:Production 7,500 unitDirect materials used (23500 meter) RM124,550Direct materials purchasing (24,000 meter) RM132,000Direct labor (3000 hours) RM34,500Variable overhead RM21,600Fixed overhead RM7,800Budgeted activities are 2,600 hours.You are required to calculate:iv) Variance of direct labors’ efficiencyv) Variance of variable overhead expensesvi) Variance of variable overhead’s efficiencyvii) Variance of fixed overhead expensesviii) Variance of fixed overhead volume
Neelopak Berhad prepared the standard cost data for one of their products.Direct Labour (0.65 hours @ RM11) RM7.15Direct Materials (5 meters @ RM5) RM25Variable Overhead (0.65 hours @ RM7) RM4.55Fixed Overhead (0.65 hours @ RM3) RM1.95Standard cost per unit RM38.65There is the actual cost data information:Production 7,500 unitDirect materials used (23500 meter) RM124,550Direct materials purchasing (24,000 meter) RM132,000Direct labor (3000 hours) RM34,500Variable overhead RM21,600Fixed overhead RM7,800Budgeted activities are 2,600 hours.You are required to calculate:vii) Variance of fixed overhead expensesviii) Variance of fixed overhead volume