Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order-Processing Costs 1 3,000 $ 99,240 1,500 4,400 2 3 4 5 6 7 2,800 2,300 1,200 2.000 60,450 144,840 98,280 83,730 51,720 75,000 NOTE: Round variable cost per unit answers to two decimal places, if appropriate. (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. S+S X

Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order-Processing Costs 1 3,000 $ 99,240 1,500 4,400 2 3 4 5 6 7 2,800 2,300 1,200 2.000 60,450 144,840 98,280 83,730 51,720 75,000 NOTE: Round variable cost per unit answers to two decimal places, if appropriate. (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. S+S X

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

Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order-Processing Costs 3,000 $ 165,400 1,500 4,400 2,800 2,300 1,200 2,000 1 2 3 4 5 6 7 100,750 241,400 163,800 139,550 86,200 125,000 NOTE: Round variable cost per unit answers to two decimal places, if appropriate. (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. $ 28,000 +$48.5 ✔ X (b.) Plot the data on a scatter diagram. Hint: In Excel, highlight the data to be included in the chart. Open the insert tab and select the Scatter chart in the Charts group. Using the information from representative high- and low- volume months, develop a cost-estimating equation for monthly order-processing costs. $ 47.864 * + $ 28,405 X X
8. Day Mail Order Co. applied the high-low method of cost estimation to customer order data for the first four months of 2020. What is the estimated variable order filing cost component per order? Orders 1,200 1,300 1,800 1,700 Costs Р3,120 3,185 January February March 4,320 3,895 April а. Р2.00 b. P2.42 с. Р2.48 d. P2.50 e. None of these; answer is
Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?
Total cost method of product pricing Based on the data presented in Exercise 17, assume that Smart Stream Inc. uses the total cost method of applying the cost-plus approach to product pricing. A. Determine the total costs and the total cost amount per unit for the production and sale of 10,000 cellular phones. B. Determine the total cost markup percentage (rounded to two decimal places) for cellular phones. C. Determine the selling price of cellular phones. (Round markup to the nearest dollar.)
Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.
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?
When prices are rising (inflation), which costing method would produce the highest value for gross margin? Choose between first-in, first-out (FIFO); last-in, first-out (LIFO); and weighted average (AVG). Evansville Company had the following transactions for the month. Calculate the gross margin for each of the following cost allocation methods, assuming A62 sold just one unit of these goods for $10,000. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
Calculate Economic Order Quantity (EOQ), number of orders, annual ordering costs, annual carrying costs and total inventory costs from the following:Annual consumption: 6000 units ; Cost of placing one Order: RO 60Carrying cost per unit: RO 2 cost per unit: RO 10
The activity driver for the shipping activity of Withstand Inc. is the number of orders shipped. Product A uses 30 orders, and Product B uses 70 orders. Calculate the consumption ratios for each product. (Note: Round your answers to two decimal places.) a.0.30; 0.70 b.0.25; 0.75 c.0.20; 0.80 d.0.65; 0.35
1. When prices are rising (inflation), which costing method would produce the highest value for gross margin? Choose between first-in, first-out (FIFO); last-in, first-out (LIFO); and weighted average (AVG). Evansville Company had the following transactions for the month. Cost per Unit $6,000 7,000 7,500 Number of Units Purchase 2 Purchase Purchase 4 Calculate the gross margin for each of the following cost allocation methods, assuming A62 sold just one unit of these goods for $10,000. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
E15-19. Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order Processing Costs 1 3,300 $90,970 2 1,650 55,412 3 4,840 132,770 4 3,080 90,090 5 2,530 76,752 6 1,320 47,410 7 2,200 68,750 Required a. Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. b. Plot the data on a scatter diagram. Using the information from representative high- and low-volume months, develop a cost-estimating equation for monthly production costs. c. What factors might have caused the difference in the equations developed for requirements (a) and (b)?
Customers as a Cost ObjectMorrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, mediumbalances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Required:(Note: Round answers to two decimal places.)1. Calculate a cost per account per year by dividing the total cost of processing andmaintaining checking accounts by the total number of accounts. What is the average feeper month that the bank should charge to cover the costs incurred because of checkingaccounts?2. Calculate a cost per account by customer category by using activity rates.3. Currently, the bank offers free checking to all of its customers. The interest revenuesaverage $90 per account; however, the interest revenues earned per account by categoryare $80, $100, and $165 for the low-, medium-, and high-balance…