Stein Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2018. The following cost and other data were gathered for 2017: Maintenance Machine Health Number of Shipping Costs Units Month Costs Hours Insurance Employees Shipped 7,160 $4,500 $4,452 $4,600 $4,850 $8,600 $8,600 S8,600 $8,600 $8,600 January February March $25,776 $29,664 165 68 120 75 8,240 $28,674 $23,058 $21,294 $3,282 230 92 7,965 April May 318 105 6,405 $5,166 $4,760 $4,910 $4,960 $5,070 $5,250 $5,271 $4,760 460 89 5,915 $8,600 $8,600 $8,600 $8,6 $8,600 $8,600 $8,600 June 280 87 9,245 340 $31,428 $30,294 $25,110 $25,866 $20,124 $34,596 July August September 93 8,730 8,415 6,975 7,185 5,590 9,610 360 88 420 95 October 495 102 November 510 97 December 275 94

Stein Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2018. The following cost and other data were gathered for 2017: Maintenance Machine Health Number of Shipping Costs Units Month Costs Hours Insurance Employees Shipped 7,160 $4,500 $4,452 $4,600 $4,850 $8,600 $8,600 S8,600 $8,600 $8,600 January February March $25,776 $29,664 165 68 120 75 8,240 $28,674 $23,058 $21,294 $3,282 230 92 7,965 April May 318 105 6,405 $5,166 $4,760 $4,910 $4,960 $5,070 $5,250 $5,271 $4,760 460 89 5,915 $8,600 $8,600 $8,600 $8,6 $8,600 $8,600 $8,600 June 280 87 9,245 340 $31,428 $30,294 $25,110 $25,866 $20,124 $34,596 July August September 93 8,730 8,415 6,975 7,185 5,590 9,610 360 88 420 95 October 495 102 November 510 97 December 275 94

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter9: Cost Accounting For Service Businesses, The Balanced Scorecard, And Quality Costs

Section: Chapter Questions

Problem 5P: Using the information for Crable and Tesch, the systems consultants in P9-3 and P9-4, prepare a...

See similar textbooks

Similar questions

The controller of the Stump Company is preparing the budget for 2021 and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior 2 months are: LOADING... (Click the icon to view the information.) Requirements 1. Estimate the cost function for delivery. 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. Requirement 1. Estimate the cost function for delivery. Delivery costs = + ( × ) Delivery costs = + ( × ) Requirement 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. The cost function in requirement 1 is an estimate of how costs behave ▼ outside of within the relevant range, not at cost levels ▼ outside within the relevant range. If there are no months with zero miles driven represented in the delivery cost…
Account analysis, high-low. Stein Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2018. The following cost and other data were gathered for 2017:
Statler Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2021. The following cost and other data were gathered for 2020: (Click the icon to view the cost and other data) Read the requirements. Requirement 1. Which of the preceding costs is variable? Fixed? Mixed? Explain. Cost function Mixed Fixed Variable Cost Maintenance Health insurance Shipping costs Requirement 2. Using the high-low method, determine the cost function for each cost. Begin by selecting the general formula that represents the linear cost function for each cost. y = a +bX y = a y = bX Maintenance Health insurance Shipping costs Now determine the cost function for each cost. (Enter all values in the same format as the general linear formula. If an input field is not used in the Cost function Maintenance Explanation The cost neither remains constant in total nor remains constant per unit. Although the cost driver varies from month to month, the total…
Dallus wants to examine the behaviour of maintenance costs for budgeting purpose. The following data on machine hours worked and maintenance costs for the past year are collected: Month Machine Hours Maintenance Cost January 18,000 February 15,000 March 12,750 21,000 April May June 11,880 14,500 July 19,000 August 14,880 September 10,000 October 13,360 November 16,600 December 18,800 $20,600 18,900 15,100 22,010 13,200 19,500 25,000 19,874 12,000 15,500 19,800 13,500 Required: a. Use the high-low method to estimate the variable cost per machine hour and the fixed cost per month. b. Plot and comment on the estimated cost function. C. Develop a formula to express the cost behaviour of ABC's maintenance costs. d. According to the budget, the machine is expected to work 200,000 hours next year. How much is the budgeted maintenance costs?
Using account analysis, Pymble Co. wishes to estimate employees' automobile expenses as a function of miles driven. Costs for the past quarter, during which 58,000 miles were driven, are classified as follows: Item Classification Cost $3,200 11,200 3,900 1,800 2,100 Fuel Variable Fixed Fixed Variable Fixed Depreciation Insurance Maintenance Parking Predict the total cost for the coming quarter for which the employees' auto travel budget would be 65,000 miles: $
Dear Bartleby, can you please help with "calculations for cost of goods sold/operating expenses occured in the following problem, for March, April, May and June, thank you. Following are the budgeted income statements for the second quarter of 2019 for SeaTech Inc.: April May June Sales $ 112,000 $ 136,000 $ 152,000 Cost of goods sold* 76,800 91,200 100,800 Gross profit $ 35,200 $ 44,800 $ 51,200 Operating expenses† 17,600 20,000 21,600 Operating income $ 17,600 $ 24,800 $ 29,600 *Includes all product costs (i.e., direct materials, direct labor, and manufacturing overhead).†Includes all period costs (i.e., selling, general, and administrative expenses).The company expects about 40% of sales to be cash transactions. Of sales on account, 65% are expected to be collected in the first month after the sale is made, and 35% are expected to be collected in the second month after sale. Depreciation,…
The following is the budgeted information of 3Z Company for the year 2021: Service Departments Producing Departments S1 S2 P1 P2 Budgeted overhead before distribution of service costs Direct labor hours Machine hours Number of employees Area occupied (sq ft) P300,000.00 P 150,000.00 P1,500,000.00 P750,000.00 6,000 45,400 25 30,000 33,250 5,000 150 50,000 13 8 4,200 1,500 Actual prime cost for the last quarter Of 2021 in the production of 15,000 units of Product MM is summarized below: P1 P2 11,250 hrs Direct labor hours 1,200 DLh @ P35 6,550 DLH @ P35 Machine hours 1,250 hrs Materials P75 per unit P5 per unit Additional information: • The company computes predetermined overhead rates based on machine hours in P1 and direct labor hours in P2, after distributing service costs using direct method. Sl costs are distributed based on area occupied and S2 costs are based on number of employees. Required: Compute for the total production costs of Product MM.
Shrek & Fiona Company, manufacturer of a single product, is preparing their annual budget for 2021: Requirements: 2. Determine production volume 3. Estimate manufacturing costs and operating expenses a. Purchases (material) budget b. Personnel budget c. Overhead budget d. Selling and administrative budget 4. Determine cash flow and other financial effects a. Cash collection schedule b. Cash disbursement for purchases, factory overhead, and selling and administrative expenses Cash budget С. 5. Formulate Projected Financial Statements (As of December 31, 2021) a. Budgeted Cost of Goods Manufactured b. Budgeted Income Statement c. Budgeted Balance Sheet
Use the information provided below to prepare the Cash Budget for October, November, and December2021. Provide separate monetary columns for each month.INFORMATION1. The following data and estimates are available for a project of Fego Limited for September toDecember 2021:September October November DecemberR R R RSales 130 000 110 000 120 000 140 000Wages 40 000 34 000 38 000 39 000Fixed overheads 16 000 16 000 16 000 16 000Variable overheads 16 000 13 000 15 000 17 000Materials purchases 17 000 14 000 16 000 18 0002. Sixty percent (60%) of the sales are expected to be for cash and the balance on credit. Creditcustomers usually pay in the month after the sale.3. Labour costs are paid for in the month in which they are incurred.4. Fixed overheads include R5 000 each month for depreciation and payment is made monthly.5. Variable overheads are paid for in the month after they are incurred.6. Direct materials are purchased by electronic funds transfers each month.7. The cash balance on 01…
Kobe, Inc. had the following information relating to 2020. Budgeted factory overhead ₱ 74,800 Actual factory overhead ₱ 78,300 Applied factory overhead ₱ 76,500 Estimated labor hours 44,000 If Kobe decides to use the actual results from 2020 to determine the 2021 overhead rate, what will the 2021 overhead rate be? Show solution Group of answer choices ₱1.779 ₱1.740 ₱1.650 ₱1.738
Automatic Irrigation, Inc. is preparing its manufacturing overhead budget for the 2022 year. Relevant data consist of the following: Qtr. 4 Qtr. 1 Qtr. 2 Qtr. 3 Control Units to be produced (by quarters): 6,000 10,000 12,000 9,000 Direct labor time: 1 hour per unit Variable overhead costs per direct labor hour: Indirect Materials $0.90; Indirect Labor $1.40; and Maintenance $0.50. Fixed overhead costs per quarter: Supervisory salaries $27,600; depreciation $4,000; and maintenance $1,900. Required Prepare the manufacturing overhead budget for the 2022 year showing quarterly data.
shown below are the totals from 2018 period budgets. Revenue badget P 100,000 Materials usage from production budget 15,000 Labor cost budget 20,000 Manufacturing overhead budget 20,000 General and administrative budget 30,000 Capital Expenditure budget 20,000 Work in progress inventories Beginning of 2018 10,000 End of 2018 5,000 Finished goods inventory Beginning of 2018 15,000 End of 2018 10,000 Tax Rate 40% 1. prepared a forecasts income statement for the year.