FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Topic Video
Question
The following information is available about electricity costs for the first six months of the year. Management think that electricity costs are likely to be related to how long machines are running.
|
Machine |
Electricity |
January |
2,800 |
$2,925 |
February |
5,600 |
$5,526 |
March |
6,200 |
$5,980 |
April |
3,500 |
$3,620 |
May |
2,300 |
$2,470 |
June |
4,500 |
$4,450 |
You may wish to refer to the formula sheet to answer this question. If you haven't already downloaded it, you can download it here.
Required:
Using the high-low method,
(a) calculate the fixed costs
b. state the cost formula for estimating the electricity cost based on the machine hours
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Scatter Diagrams and High-Low Cost Estimation From April 1 through October 31, Will County Highway Department hires temporary employees to mow and clean the right-of-way along county roads. The County Road Commissioner has asked you to help her in determining the variable labor cost of mowing and cleaning a mile of road. The following information is available regarding current-year operations: Month April May June July August September October Miles Mowed Labor and Cleaned Costs 350 $4,000 300 3,750 400 4,500 250 2,750 375 4,250 200 2,500 100 2,400 Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs. Monthly labor costs = $ 1,700 + $ 7 X Plot the data on a scatter diagram. Using the information from representative high- and low volume months, use the high-low method to develop a cost- estimating equation for monthly labor costs. Monthly labor costs $ 0 + $ ox Adjust the equation developed in requirement (b) to…arrow_forwardJake's Roof Repair has provided the following data concerning its costs: Fixed Cost per Month $ 20,900 Cost per Repair-Hour. $ 15.00 $ 7.78 $8.35 $ 1.80 Wages and salaries. Parts and supplies Equipment depreciation Truck operating expenses Rent Administrative expenses For example, wages and salaries should be $20,900 plus $15.00 per repair-hour. The company expected to work 2,500 repair-hours In May, but actually worked 2,400 repair-hours. The company expects its sales to be $45.00 per repair-hour. Revenue Expenses: $ 2,760 $ 5,790 $ 4,640 $ 3,850 Required: Compute the company's activity variances for May. (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.e., zero variance). Input all amounts as positive values.) Jake's Roof Repair Activity Variances For the Month Ended May 31 Wages and salaries Parts and supplies Equipment depreciation Truck operating expenses Rent Administrative expenses Total expense Net operating…arrow_forwardFinch Company began its operations on March 31 of the current year. Finch has the following projected costs: June $201,000 Manufacturing costs" Insurance expense** April May $157,200 $197,600 970 970 2,200 420 2,200 420 970 Depreciation expense Property tax expense*** "Of the manufacturing costs, three-fourths are paid for in the month they are incurred; one-fourth is paid in the following month. **Insurance expense is $970 a month; however, the insurance is paid four times yearly in the first month of the quarter, (.e., January, April, July, and October). ***Property tax is paid once a year in November. The cash payments expected for Finch Company in the month of May are O&$187.500 b. $39,300 Oe5148,200 Od $226,800 2,200 420arrow_forward
- Marlin Company has the following projected costs for manufacturing and selling and administrative expenses: (Click the icon to view the projected costs.) Prepare a schedule of cash payments for Marlin for January, February, and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31. (Assume the company started operations in January. If an input field is not used in the table leave the input field empty; do not enter a zero.) Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March Total payments for direct materials Direct Labor: Total payments for direct labor January February March Total Data table Direct materials purchases Direct labor costs Depreciation on plant Utilities for plant Property taxes on plant Depreciation on office Utilities for office Property taxes on office Office salaries Print January February…arrow_forwardNeed answer the questionarrow_forwardGreen Earth Landscaping Company provides monthly and weekly landscaping and maintenance services to residential customers in the tri-city area. Green Earth has no variable administrative expense. Fixed administrative expenses for June, July, and August include: Salaries $9,400 Insurance 2,250 Depreciation 4,000 Accounting services 600 Required: Question Content Area 1. Construct an administrative expense budget for Green Earth Landscaping Company for the three summer months. Show total amounts by month and in total for the three-month period. Green Earth Landscaping CompanyAdministrative Expense BudgetFor the Summer Months June July August Total Salaries $___ $___ $___ $___ Insurance ____ ____ ____ ____ Depreciation ____ ____ ____ ____ Accounting services ____ ____ ____ ____ Total administrative expense $_____ $____ $____ $____ Question Content Area 2. What if Green Earth Landscaping Company's insurance rates increased at the beginning…arrow_forward
- Joseph is working on the budget for his summer window-washing business, trying to figure out what his total costs are going to be for the season. He has monthly data from last summer, so he decided to start with that. Using the observations below, use the high-low method to estimate a total monthly cost function for Joseph's business. Month 1 2 3 Number of Labor Hours Spent Y = $ 60 105 85 (Round answers to 2 decimal places, e.g. 15.25.) X + $ Total Cost $196 $322 $250arrow_forwarde & Exit The following information is available for a company's utility cost for operating its machines over the last four months. Month Machine hours Utility cost January 1,040 $6,590 February 1,940 $7,180 March 2,680 $8,100 April 740 $4,650 Using the high-low method, the estimated variable cost per machine hour for utilities is: Multiple Choice O $6.28. $3.02. $1.78. $6.47. $4.14.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
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