Using the high-low method, determine the cost function for each cost? Grostein Corporation wants to find an equation to estimate some of their monthly operating costsfor the operating budget for 2020. The following cost and other data were gathered for 2019:MaintenanceМachineHealthNumber ofShippingCostsUnitsMonthCostsHoursInsuranceEmployeesShippedJanuaryFebruary$4,500165$8,60068$25,7767,160$4,452120$8,60075$29,6648,240March$4,600230$8,60092$28,6747,965AprilМay$4,850318$8,600105$23,0586,405$5,166460$8,60089$21,2945,915June$4,760280$8,60087$33,2829,245July$4,910340$8,60093$31,4288,730August$4,960360$8,60088$30,2948,415September$5,070420$8,60095$25,1106,975October$5,250495$8,600102$25,8667,185November$5,271510$8,60097$20,1245,590December$4,760275$8,60094$34,5969,610

High low method of cost estimation says that costs at highest level and lowest level are to be taken…

Answered: Using the high-low method, determine…

Business

Accounting

Using the high-low method, determine the cost function for each cost?

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 33E: A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent...

See similar textbooks

Similar questions

Using the information for Crable and Tesch, the systems consultants in P9-3 and P9-4, prepare a budgeted income statement for the year ended December 31, 2016.
Roman Inc. has the following totals from its operating budgets: Prepare a budgeted income statement for the year ended December 31, 2016, assuming that income from operations is taxed at a rate of 30%.
The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method, express the companys overtime wages as an equation where x represents number of invoices processed. Assume BC has monthly fixed costs of $3,800. Predict the overtime wages if 9,000 invoices are processed. Predict the overtime wages if 6,500 invoices are processed. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense.
CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
Swifty Corporation prepared a 2019 budget for 135000 units of product. Actual production in 2019 was 145000 units. To be most useful, what amounts should a performance report for this company compare?
Gibco Service has budgeted the following time-and-material for 2019: Budgeted Costs For 2019 Time Material Charges Charges Painters' wages and benefits $54,000 Service manager's salary and benefits $44,000 Office employee's salary and benefits 7,400 6,000 Cost of paint 50,000 Overhead (supplies, utilities, etc.) 14,000 22,000 Gibco budgets 2,000 hours of paint time in 2019 and will charge a profit of $8 per hour on the labour rate, in addition to a 12% mark-up on the cost of paint. On February 15, 2019, Gibco is asked to prepare a price estimate to paint a building. Gibco estimates that this job will take 25 labour hours and $900 in paint. 1.Calculate the material loading charge rate % for 2019 2. What is the planned profit for the year? Do not enter $ or commas.
The budget for the plant in 2020 is as follows: Production plant Machine department Assembly department Manufacturing overhead costs 13 597 500 12 271 500 Direct manufacturing labor costs 1 455 000 6 075 000 Direct manufacturing labor-hours 54 000 22 500 Machine-hours 277 500 55 500 What is the budgeted manufacturing overhead rate in the machining and the assembly department? Assume the following amounts appeared at the end of 2020: Production plant Machine department Assembly department Manufacturing overhead costs incurred 15,000,000 11,973,000 Direct manufacturing labor costs 1,545,000 6,150,000 Machine-hours 300,000 51,000 4 Compute the under- or overallocated manufacturing overhead for each department and for the production plant as a whole. 5)Briefly explain why Canadian Company in Dubai uses two different manufacturing overhead cost pools in its job-costing…
Dear Bartleby, can you please assist with solving the following item enclosed, 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, insurance, and property taxes represent $9,600 of the estimated monthly cost of goods…
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…
Using sensitivity analysis Rucker Company prepared the following budgeted income statement for 2019: Requirements Prepare a budgeted income statement with columns for 700 units, 1,300 units, and 1,700 units sold. How might managers use this type of budgeted income statement?
Sunland Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected.Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service.Actual service revenue for 2019 and expected service revenues for 2020 are November 2019, $93,620; December 2019, $83,630; January 2020, $102,120; February 2020, $123,950; and March 2020, $133,630.Purchases of landscaping supplies (direct materials) are paid 60% in the month of purchase and 40% the following month. Actual purchases for 2019 and expected purchases for 2020 are December 2019, $16,410; January 2020, $13,540; February 2020, $18,970; and March 2020, $23,150.(a)Prepare the following schedules for each month in the first quarter of 2020 and for the quarter in total:(1) Expected collections…
Boulders Manufacturing has just hired a new controller, Delado. During his first week on the job, Delado was asked to establish a budget for operating expenses in 2020. Since Delgado was not yet familiar with the operations of Boulder Manufacturing, he decided to budget these expenses using the same procedures as the prior controller. Therefore, in order to establish a budget for operating expenses, Delgado started with actual operating expenses incurred in 2019 and added 4.3 percent. Delgado based this percentage on inflation as measured by the consumer price index. Please comment on the effectiveness of Diana’s budgeting strategy. "budgeting chapter", what budget is to come to your mind as the "starting point" in preparing the master budget? What may result if this budget is inaccurate?