Narp. Ine, is preparing a budget for next vear and requires a breakdown of the costof steam used in its factory into fixed and variable components. The following data on thecost of steam used and the units produced are available for the last six months:25)Cost of SteamUnits ProducedJulyAugustSeptember.October$ 15,85013,00016,37020,00017,60018.5003,000c22,0002,9003,7502,6702.65016.970November.December.Total....S101.320 ansSharp uses the high-low method of analysis.Required: Show your work in answering the question. Failure to do so results inzero pointsa. What is the estimated variable cost of steam per unit produced?b. What is the total fixed cost?c. If there were 2,500 units produced the cost of steam would be?

Using the high-low method, the variable cost can be calculated by using the given formula: Variable…

Answered: Narp. Ine, is preparing a budget for…

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

The production department of Headstrong Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 8,100 9,100 7,100 6,100 In addition, the beginning raw materials inventory for the first quarter is budgeted to be 1,950 kilograms and the beginning accounts payable for the first quarter are budgeted to be $3,490. Each unit requires 3.1 kg of raw material that costs $2.50 per kilogram. Management desires to end each quarter with an inventory of raw materials equal to 10% of the following quarter’s production needs. The desired ending inventory for the fourth quarter is 2,325 kilograms. Management plans to pay for 80% of raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires 0.6 direct labour-hours, and direct labour-hour workers are paid $19.5 per hour. Required: 1-a. Prepare the company's direct…
Harrison, Inc. is preparing their budget for the upcoming year and requires a breakdown of the costs of power used in its factory into the fixed and variable components. They have determined the number of direct labor hours worked affects the cost of power. The following data on the cost of power used and direct labor hours worked are available for the last six months of this year: Month July August September October High-Low Method November December Total Cost of Power $ 14,850 15,400 16,370 19,800 17,600 18,500 $102.520 Direct Labor Hours 3,000 2,050 2,900 3,650 2,670 2,650 16.920 1. Assuming that Harrison uses the high-low method of analysis, calculate the cost function to be used to estimate the power costs. 2. They have determined that production needs will require 8,467 direct labor hours. Using the cost function calculated above, what is the estimated cost of power?
Scotch Brand Products produces packaging tape and has determined the following to be its standard cost of producing one case of budget packaging tape: Material (3.50 ounces at $1.30 per ounce) $4.55 Labor (0.30 hour at $12.00 per hour) 3.60 Overhead 2.40 Total $10.55 At the start of 2021, Scotch Brand planned to produce 80,000 cases of tape during the year. Overhead is allocated based on the number of cases of tape produced. Annual fixed overhead is budgeted at $64,000 and the variable overhead costs are budgeted at $1.60 per case. The following information summarizes the results for 2021: Actual production, 81,000 cases Purchased 275,000 ounces of material at a total cost of $343,750 Used 266,250 ounces of material in production Employees worked 22,000 hours, total labor cost $275,000 Actual overhead incurred,…
Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiner's master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employer's share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the company's union contract calls for an increase in direct labor wages that is included in the direct labor rate. Greiner expects to have 6,600 glare filters in inventory on December 31 of the current year, and has a policy of carrying 35 percent of the following month's projected sales in inventory. Information on the first four months of the coming year is as follows: January February March April Estimated unit sales 37,200 35,400 40,000 40,000 Sales price per unit $80 $80 $75 $75 Direct labor…
Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $16.20q Indirect labor $4,700 + $1.40q Utilities $5,700 + $0.50q Supplies $1,700 + $0.20q Equipment depreciation $18,600 + $2.50q Factory rent $8,400 Property taxes $2,600 Factory administration $13,100 + $0.70q The Production Department planned to work 4,100 labor-hours in March; however, it actually worked 3,900 labor-hours during the month. Its actual costs incurred in March are listed below: Actual Cost Incurred in March Direct labor $ 64,740 Indirect labor $ 9,620 Utilities $ 8,140 Supplies $ 2,730 Equipment depreciation $ 28,350 Factory rent $ 8,800 Property taxes $ 2,600 Factory…
Static budget versus flexible budget The production supervisor of the Machining Department for Hagerstown Company agreed to the following monthly static budget for the upcoming year: Hagerstown Company Machining Department Monthly Production Budget Wages Utilities Depreciation Total $1,090,000 49,000 82,000 $1,221,000 The actual amount spent and the actual units produced in the first three months in the Machining Department were as follows: Amount Spent Units Produced 100,000 91,000 82,000 May June July The Machining Department supervisor has been very pleased with this performance because actual expenditures for May-July have been significantly less than the monthly static budget of 1,221,000. However, the plant manager believes that the budget should not remain fixed for every month but should "flex" or adjust to the volume of work that is produced in the Machining Department. Additional budget information for the Machining Department is as follows: $1,150,000 1,095,000 1,042,000…
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: Units to be produced Each unit requires 0.75 direct labor-hours, and direct laborers are paid $16.00 per hour. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11,000 8,000 8,500 10,800 Required: 1. Prepare the company's direct labor budget for the upcoming fiscal year. (Round "Direct labor time per unit (hours)" answers to 2 decimal places.) Required production in units Direct labor time per unit (hours) Total direct labor-hours needed Direct labor cost per hour Total direct labor cost Rordan Corporation Direct Labor Budget 2nd Quarter 8,000 1st Quarter 11,000 8,250✔✔ Answer is not complete. $ 132,000 6,000 3rd Quarter 8,500 6,375 4th Quarter 10,800 S 96,000 $ 102,000 $ 8,100 129,600 Year
Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $16.50q Indirect labor $4,100 + $1.60q Utilities $5,100 + $0.70q Supplies $1,200 + $0.40q Equipment depreciation $18,000 + $2.50q Factory rent $8,500 Property taxes $3,000 Factory administration $13,500 + $0.80q The Production Department planned to work 4,400 labor-hours in March; however, it actually worked 4,200 labor-hours during the month. Its actual costs incurred in March are listed below: Actual Cost Incurred in March Direct labor $ 70,920 Indirect labor $ 10,320 Utilities $ 8,570 Supplies $ 3,170 Equipment depreciation $ 28,500 Factory rent $ 8,900 Property taxes $ 3,000 Factory…
Tannin Products Inc. prepared the following factory overhead cost budget for the Trim Department for July of the current year, during which it expected to use 12,000 hours for production: Variable overhead cost: Indirect factory labor $31,200 Power and light 9,120 Indirect materials 20,400 Total variable overhead cost $ 60,720 Fixed overhead cost: Supervisory salaries $45,600 Depreciation of plant and equipment 12,000 Insurance and property taxes 22,400 Total fixed overhead cost 80,000 Total factory overhead cost $140,720 Tannin has available 16,000 hours of monthly productive capacity in the Trim Department under normal business conditions. During July, the Trim Department actually used 11,000 hours for production. The actual fixed costs were as budgeted. The actual variable overhead for July was as follows: Actual variable factory overhead cost: Indirect factory labor $27,890 Power and…
Aaron's Chairs is in the process of preparing a production cost budget for August. Actual costs in July for 120 chairs were as follows. Materials cost = $4,680 Labor cost = $2,630 Rent = $1,500 Depreciation = $2,500 Other fixed costs = $3,200 Materials and labor are the only variable costs. If production and sales are budgeted to change to 130 chairs in August, how much is the expected total variable cost on the August budget?
ABC Corporation has prepared the following overhead budget for next month. Activity level Variable overhead costs: Supplies Indirect labor Fixed overhead costs: Supervision Utilities Depreciation Total overhead cost 3,700 machine-hours $ 21,090 35,520 18,100 7,100 8,100 $ 89,910 The company's variable overhead costs are driven by machine-hours. What would be the total budgeted overhead cost for next month if the activity level is 3,600 machine-hours rather than 3,700 machine-hours? (Round your intermediate calculations to 2 decimal places.)
S Craftmore Machining reports the following budgeted overhead cost and related data for this year. Budgeted Activity Usage Budgeted Cost $ 555,750 85,500 28,500 Activity Cost Driver Direct labor hours (DLH) Engineering hours (EH) Machine hours (MH) 13,000 1,500 11,400 570 71,250 Setups $ 741,000 Activity Assembly Product design Electricity Setup Total Required: 1. Compute a single plantwide overhead rate assuming the company allocates overhead cost based on 13,000 direct labor hours. 2. Job 31 used 320 direct labor hours and Job 42 used 680 direct labor hours. Allocate overhead cost to each job using the single plantwide overhead rate from part 1. 3. Compute an activity rate for each activity using activity-based costing. 4. Allocate overhead costs to Job 31 and Job 42 using activity-based costing. Activity Cost Driver Direct labor hours (DLH) Engineering hours (EH) Machine hours (MH) Setups Required 1 Required 2 Activity Usage Job 31 Required 3 320 43 56 6 Complete this question by…

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS