LO.4 & Lo.5 (High-ow method; flexible budget) Tijuana Tile has gathered the following information on its utilitv cost for the past six months. Machine hours Utility cost 1,300 940 1,700 1,075 1,250 900 1,800 1,132 1,900 1,160 1,500 990 a. Using the high-low method, determine the cost formula for utility cost. b. Prepare a flexible budget with separate variable and fixed categories for utdlity cost at 1,325, 1,500, and 1,675 machine hours.

LO.4 & Lo.5 (High-ow method; flexible budget) Tijuana Tile has gathered the following information on its utilitv cost for the past six months. Machine hours Utility cost 1,300 940 1,700 1,075 1,250 900 1,800 1,132 1,900 1,160 1,500 990 a. Using the high-low method, determine the cost formula for utility cost. b. Prepare a flexible budget with separate variable and fixed categories for utdlity cost at 1,325, 1,500, and 1,675 machine hours.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Variable Costing Income Statement for a Service Company The actual and planned data for Broadwater Institute & Technical School for the Fall term were as follows: Actual Planned Enrollment Tuition per credit hour Credit hours Line Item Description Revenue Variable costs Registration, records, and marketing costs Registration, records, and marketing costs per enrolled student Instructional costs per credit hour Depreciation on classrooms and equipment $1,875,000 $1,875,000 Registration, records, and marketing costs vary by the number of enrolled students, while instructional costs vary by the number of credit hours. Depreciation is a fixed cost. Prepare a variable costing income statement showing the contribution margin and operating income for the Fall term Broadwater Institute & Technical School Variable Costing Income Statement For the Fall Term Instructional costs Total variable costs Contribution margin Depreciation on classrooms and equipment Operating income Amount 9.200.000 ✓…
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
Crystal Mining has completed the following data to analyze utility cost:MonthMachine Hours Utility CostJanuary200P 300February325440March400480April410490May525620June680790July820840August900900Required:1.Use the least squaresmethod to develop a formula for budgeting utility cost. (Round off value of b to two decimal places and the value of a to nearest peso.2.Prepare flexible budget with separate variable and fixed categories for utility costs at 350, 500, and 600 machine hours.
Marla Baldwin was a blt anxlous as she created the year-end performance reports. She remembered how management had hoped the economy would make a favorable turn, taking pressure off consumers so they'd feel more comfortable spending on the company's splurge Item-a luxurious hooded cotton robe. Alas, actual production and sales ended at 5,100 units, a whopping 1,000 units shy of the company's original budget. The following Information presents the company's actual Income statement and other key Information for Marla. Sales Varlable costs: DM Actual Income DL Varlable-MOH Contribution margin Fixed costs: Fixed-MOH Fixed SG&A Operating Income Standards are as follows. Direct materials Direct labor Variable-MOH Fixed-MOH $800,700 Selling price Fixed SGSA expense 172,125 (for 11,475 yards purchased and used) 75,276 (for 3,672 hours used) 45,900 O Search 507,399 170,978 243,100 Standard Quantity per Unit 2.30 yards 0.70 DL hours $93.321 Additional master budget Information: 2.30 yards 2.30…
Subject - account Please help me. Thankyou.
Manly Beach Enterprises projects the following information for the coming year. Sales Production 1,900 units 2,000 units Selling price per sewing machine Total variable manufacturing cost Total fixed manufacturing cost Marketing and administrative cost (40% variable based on sales) $200 $160,000 $60,000 $80,000 a. Determine the projected net income using absorption costing: $ b. Determine the projected net income using variable costing: $
Note: for credit you must show your calculations for this problem. The Magenta Company has provided the following information:Planned Production: 220,000 UnitsActual Production: 250,000 Units Selling price per unit $4.00Variable cost per unit $2.00Total fixed costs $220,000What is the Budgeted Net Operating Income using a Flexible Budget Methodology? View keyboard shortcuts EditViewInsertFormatToolsTable 12pt Paragraph
Dawn is preparing a budget for her operation. She has forecasted revenue of $1,200,000 for the budget period and now wants to complete the variable expenses portion for her forecast. Dawn reviewed her historical cost percentage records. She then established her target variable cost percentages for several variable cost categories. Use Dawn's target cost percentages to complete her variable expense forecast.
Hello question is attached, thanks.
Use the given data shown in the graph. A. What is the budgeted fixed cost per period? B. What is the budgeted variance cost per unit? C. What is the value of F (that is, the flexible budget for an activity of 8,000 units)? D. What is the flexible budget cost amount if the actual activity had been 16,000 units?
Please do not give solution in image format thanku
Please help me with all answers thanku