# The following quarterly information is available for Tons Mined Quarter Tons Mined Utility Cost Year 1-First 15,000 50,000 Year 1-Second 11,000 45,000 Year 1--Third 21,000 60,000 Year 1--Fourth 12,...

The following quarterly information is available for Tons Mined Quarter Tons Mined Utility Cost Year 1-First 15,000 50,000 Year 1-Second 11,000 45,000 Year 1--Third 21,000 60,000 Year 1--Fourth 12,000 75,000 Year 2-First 18,000 100,000 Year 2-Second 25,000 105,000 Year 2--Third 30,000 \$85,000 Year 2--Fourth 28,000 120,000
The following quarterly information is available for Direct Labor Hours Quarter DLH's Utility Cost Year 1-First 5,000 50,000 Year 1-Second 3,000 S 45,000 Year 1--Third 4,000 \$ 60,000 Year 1--Fourth 6,000 75,000 Year 2-First 10,000 100,000 Year 2-Second 9,000 105,000 Year 2--Third 8,000 \$ 85,000 Year 2--Fourth 11,000 120,000
Hard Rock is trying to estimate Utility Cost of the First quarter of Year 3. If Hard Rock uses Direct Labor Hours as the independent variable and 7,000 DLH's are anticipated, compute the amount of Utility Cost. Show computations.

Variable utility cost per direct labor hour = Difference in high low cost/Difference in high low activity

= (120,000 - 45,000)/(11,000 - 3,000)

= 75,000/8,000

= \$9.375

Hence, total variable utility cost at 3,000 direct labor hours = 3,000 x 9.375

= \$28,125

Fixed utility cost at 3,000 direct labor hours = Total utility cost at 3,000 direct labor hours - Total variable utility cost at 3,000 direct labor hours

= 45,000 - 28,125

= \$16,875

Total utility cost at 7,000 direct labor hours = 16,875 + 7,000 x 9.375

= 16,875 + 65,625

= \$82,500

Kindly comment if you need further assistance. Thanks

##### Add Answer of: The following quarterly information is available for Tons Mined Quarter Tons Mined Utility Cost Year 1-First 15,000 50,000 Year 1-Second 11,000 45,000 Year 1--Third 21,000 60,000 Year 1--Fourth 12,...
Similar Homework Help Questions
• ### Rochester Heating Systems, Inc. calculates its predetermined overhead rate on a quarterly basis. The following estimates...

Rochester Heating Systems, Inc. calculates its predetermined overhead rate on a quarterly basis. The following estimates were made for the current year Quarterly Predetermined Overhead Estimated Estimated Rate (per Manufacturing Direct-Labor direct-labor Hours 25,000 16,000 Overhead hour) First quarter 75,000 Second 96,000 quarter Third quarter 37,500 Fourth 12,500 84,000 14,000 quarter Total \$292,500 67,500 The firm's main product, part number SC71, requires \$200 of direct material and 20 hours of direct labor per unit. The labor rate is \$15 per...

• ### The Hard Rock Mining Company is developing cost formulas for management planning and decision-mak...

The Hard Rock Mining Company is developing cost formulas for management planning and decision-making purposes. The company’s cost analyst has concluded that utilities cost is a mixed cost, and he is attempting to find a base with which the cost might be closely correlated. The controller has suggested that tons mined might be a good base to use in developing a cost formula. The production superintendent disagrees; she thinks that direct labor-hours would be a better base. The cost analyst...

• ### Gulf Corporation manufactures and sells a seasonal product that has peak sales in the third quarter of the fiscal year. The following information concerns operations for Year 2017 and for the firs...

Gulf Corporation manufactures and sells a seasonal product that has peak sales in the third quarter of the fiscal year. The following information concerns operations for Year 2017 and for the first two quarters of Year 2018 2018 Quarter 2017 Quarter ed Unit Sales40 60,000 100,000 50,000 70,00080,000 a) The company's single product sells for AED 8 per unit (all sales are on credit). b) Credit sales are collected in the following pattern: 75% in the quarter the sales are...

• ### 1.2. Weller Company's budgeted unit sales for the upcoming fiscal year are provided below. 1st Quarter...

1.2. Weller Company's budgeted unit sales for the upcoming fiscal year are provided below. 1st Quarter 34,800 2nd Quarter 36,00 3rd Quarter 27, cee 4th Quarter 3 2,888 Budgeted unit sales The company's variable selling and administrative expense per unit is \$3.30. Fixed selling and administrative expenses Include advertising expenses of \$11,000 per quarter, executive salaries of \$53,000 per quarter, and depreciation of \$33,000 per quarter. In addition, the company will make Insurance payments of \$4,000 in the first quarter...

• ### DUE SOON, PLEASE HELP!!! Sales for the final quarter of the prior year total 800 units. Expected sales in units) for the...

DUE SOON, PLEASE HELP!!! Sales for the final quarter of the prior year total 800 units. Expected sales in units) for the current year are: 720 (Quarter 1), 480 (Quarter 2), 640 (Quarter 3), and 640 (Quarter 4). Sales for the first quarter of the following year total 960 units. The selling price is \$660 per unit in the first three quarters of the year, and \$690 per unit in the final quarter. Company policy calls for a given quarter's...

• ### create the initial documents for the master budget: • sales budget • production budget • direct...

create the initial documents for the master budget: • sales budget • production budget • direct materials purchases budget • direct labor budget • overhead budget • selling and administrative expense budget • cash budget include a schedule of cash collections and payments • finished goods inventory calculation Then, Create the following schedules, financial statements, and calculations A) Pro forma cost of goods manufactured B) Pro forma Cost of goods sold- both financial and variable cost basis C) Pro forma...

• ### The Trolley Trolley Toy Company manufactures toy building block sets for children. Trolley Trolley is planning...

The Trolley Trolley Toy Company manufactures toy building block sets for children. Trolley Trolley is planning for 2019 2019 by developing a master budget by quarters. Trolley Trolley​'s balance sheet for December December 31 31​, 2018 2018​, ​follows: Trolley Toy Company Balance Sheet December 31, 2018 Assets Current Assets: Cash 58,000 Accounts Receivable 22,000 Raw Materials Inventory 1,200 5,400 Finished Goods Inventory Total Current Assets 86,600 Property, Plant, and Equipment Equipment 142,000 (47,000) 95,000 Less: Accumulated Depreciation 181,600 Total Assets...

• ### Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...

Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to deckers manufacturing s operation Current Assets as of December 31 (prior year): Cash 4600 Accounts receivable, net 47000 Inventory 15100 Property, plant, and equipment, net 123000 Accounts payable. 43000 Capital stock. 123500 Retained earnings. 23100 a. Actual sales in December were \$71,000. Selling price per unit is projected to remain stable at \$12 per unit throughout the budget period. Sales...

• ### Just need help with tying out summary cash budget to \$107,750 for 3rd quarter (check figure) Cost...

Just need help with tying out summary cash budget to \$107,750 for 3rd quarter (check figure) Cost Accounting Master Budget Project Walter Bond, president of Denmark Company, was just concluding a budget meeting with his senior staff. It was November of 20x0, and the group was discussing preparation of the firm’s master budget for 20x1. “I’ve decided to go ahead and purchase the industrial robot we’ve been talking about. We’ll make the acquisition on January 2 of next year, and...

• ### Master Budget Project Okay Company is preparing to build its master budget. The budget will detail each quarter's a...

Master Budget Project Okay Company is preparing to build its master budget. The budget will detail each quarter's activity and the activity for the year in total. The master budget will be based on the following information: a. This will be the first year of operation for Okay Company b. Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,300, Second quarter 6,100, Third quarter 6,100 & Fourth quarter 6,450. First and second quarter 2018 budgeted...

Need Online Homework Help?