Scatter Diagrams and High-Low Cost Estimation From April 1 through October 31, Coles County Highway Department hires temporary employees to mow and clean the right-of-way along county roads. The County Road Commissioner has asked you 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 $9,000 300 8800 400 10,400 250 8.000 375 10,000 200 7,200 100 6.200 Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs Monthly labor costs 4,8001 BNX 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 4,800 300 X Adjust the equation developed in requirement (b) to incorporate the effect of an anticipated 8 percent increase in wages Monthly labor cos 4,200 1 300 X

Scatter Diagrams and High-Low Cost Estimation From April 1 through October 31, Coles County Highway Department hires temporary employees to mow and clean the right-of-way along county roads. The County Road Commissioner has asked you 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 $9,000 300 8800 400 10,400 250 8.000 375 10,000 200 7,200 100 6.200 Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs Monthly labor costs 4,8001 BNX 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 4,800 300 X Adjust the equation developed in requirement (b) to incorporate the effect of an anticipated 8 percent increase in wages Monthly labor cos 4,200 1 300 X

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter4: Job-order Costing And Overhead Application

Section: Chapter Questions

Problem 42E: Source Documents For each of the following independent situations, give the source document that...

See similar textbooks

Similar questions

E14-23. Scatter Diagrams and High-Low Cost Estimation From April 1 through October 31, Coles County Highway Department hires temporary em- ployees to mow and clean the right-of-way along county roads. Assume that 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 240 $6,800 305 7,680 325 8,310 275 7,200 220 6,550 200 5,760 75 4,960 REQUIRED a. Use the information from the high- and low-volume months to develop a cost-estimating equa- tion for monthly labor costs. b. Plot the data on a scatter diagram. Hint: In Excel, highlight the data to be included in the chart. Open the insert tab and select the Scatter chart in the Charts group. Using the information from representative high- and low-volume months, use the high-low method to develop a cost-…
A company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950
Please help me by showing your solution in good accounting form. Thank you! MOC Construction Company started work on three job sites during the current year. Any costs incurred are expected to be recoverable. Data relating to the three jobs are given below: Site Contract Price Cost Incurred Estimated Costs to Complete Billings on Contract Collections on Billings 1 5 000 000 3 750 000 - 5 000 000 5 000 000 2 7 000 000 1 000 000 4 000 000 900 000 900 000 3 2 500 000 1 000 000 1 000 000 1 500 000 1 000 000 If the company records revenue over time, how much must be shown as a current asset in the balance sheet of MOC Construction Company as of December 31?A. 5,500,000 C. 250,000B. 500,000 D. 100,000 If the company records revenue at a point in time, how much must be shown as a current asset in the balance sheet of MOC Construction Company as of December 31?A. 5,100,000 C. 250,000B. 500,000 D. 100,000
A. If overhead for the year was $205,000, what were the profits of the residential and commercial services using labor-hours as the allocation base? B. Overhead consists of costs of traveling to the site, using equipment (including vehicle rental), and using supplies, which can be traced as follows.
Dec. Dec. Additional job order activities during this period included: 2 Dec. 12 Dec. Waterways has two major public-parkprojects to provide with comprehensive irrigation in one of its service locations this month. Job J57 and Job K52 involve 15 acres of landscaped terrain which will require special-order sprinkler heads to meet the specifications of the project. Using a job cost system to produce these parts, the following events occurred during December. Dec. 13 1 Purchased raw materials from Durbin Supply Company on account for $46,816. Issued $35,200 of direct materials from the company's inventory to jobs other than K52 and J57 and $2,640 of indirect materials. Raw materials were requisitioned from the company's inventory on December 2 for $4,458; on December 8 for $930; and on December 14 for $3,042. In each instance, two-thirds (2/3) of these materials were for J57 and the rest for K52. 18 Dec. 21 Six time tickets were turned in for these two projects for a total amount of 18…
Required information [The following information applies to the questions displayed below.] Information on Kwon Manufacturing's activities for its first month of operations follows: a. Purchased $100,500 of raw materials on credit. b. Materials requisitions show the following materials used for the month. $ 48,700 24,100 72,800 9,120 Job 201 Job 202 Total direct materials Indirect materials Total materials used $ 81,920 c. Time tickets show the following labor used for the month. $ 39,700 13,100 Job 201 Job 202 Total direct labor 52,800 24,700 $ 77,500 Indirect labor Total labor used d. Applied overhead to Job 201 and to Job 202 using a predetermined overhead rate is 80% of direct materials cost. e. Transferred Job 201 to Finished Goods Inventory. f. (1) Sold Job 201 for $165,260 on credit. (2) Record cost of goods sold for Job 201. g. Incurred the following actual other overhead costs for the month. $ 32, 500 Depreciation of factory equipment Rent on factory building (payable) Factory…
Source Documents For each of the following independent situations, give the source document that would be referred to for the necessary information. Required: 1. Direct materials costing 460 are requisitioned for use on a job. 2. Greiners Garage uses a job-order costing system. Overhead is applied to jobs based on direct labor hours. Which source document gives the number of direct labor hours worked on Job 2004-276? 3. Pasilla Investigative Services bills clients on a monthly basis for costs to date. Job 3-48 involved an investigator following the clients business partner for a week by automobile. Mileage is billed at number of miles times 0.75. 4. The foreman on the Jackson job wonders what the actual direct materials cost was for that job.
CS Company started work on three job sites during the current year. Any costs incurred are expected to be recoverable. Data relating to the three jobs are given below: Site Contract Cost Estimated Costs Billings on Collections on Price Incurred to Complete Contract Billings 5,000,000 1 5,000,000 3,750,000 5,000,000 2 7,000,000 1,000,000 4,000,000 1,000,000 900,000 1,500,000 900,000 1,000,000 3 2,500,000 1,000,000 If the company records revenue at a point in time, how much must be shown as current asset in the balance sheet of MOC Construction Company as of December 31? A. 5,100,000 B. 500,000 C. 250,000 D. 100,000
Sarah Duterte Construction Firm started work on three job sites during the current year. The following data was gathered in relation to the three jobs sites construction: Est. Cost to Billings Complete Site Contract Cost Incurred on Collections Price Contract 500,000 400,000 365,000 100,000 100,000 500,000 100,000 A В 700,000 250,000 400,000 100,000 50,000 C Requirements: 1. If the outcome of all the projects can be estimated reliably, what amount of income should be reported for the current year? 2. If the outcome of all the projects can be estimated reliably, what would be the amount of Construction in Progress to be reported in the Statement of Financial Position for the current year?
Use the following information to answer questions. (Algo) [The following information applies to the questions displayed below.] Information on Kwon Manufacturing's activities for its first month of operations follows: a. Purchased $101,800 of raw materials on credit. b. Materials requisitions show the following materials used for the month. Job 201 Job 202 Total direct materials Indirect materials Total materials used $ 50,000 25,400 75,400 10,420 $ 85,820 c. Time tickets show the following labor used for the month. Job 201 $ 41,000 Job 202 14,400 Total direct labor 55,400 26,000 $ 81,400 Indirect labor Total labor used d. Applied overhead to Job 201 and to Job 202 using a predetermined overhead rate of 80% of direct materials cost. e. Transferred Job 201 to Finished Goods Inventory. f. Sold Job 201 for $169,160 on credit. g. Incurred the following actual' other overhead costs for the month. Depreciation of factory equipment Rent on factory building (payable) Factory utilities…
TB MC Qu. 11-50 (Algo) Steven Parker owns and operates Steven's Septic Service and... Steven Parker owns and operates Steven's Septic Service and Legal Advice. Steven's two revenue generating (production) operations are supported by two service departments: Clerical and Janitorial. Costs in the service departments are allocated in the following order using the designated allocation bases:Clerical:Variable cost: expected number of work orders processedFixed cost: long-run average number of work orders processedJanitorial:Variable cost: labor hoursFixed cost: square footage of space occupiedAverage and expected activity levels for next month (June) are as follows: No. of Work Orders Expected Average Labor Hours Square Footage Septic Service 50 75 1,000 2,295 Legal advice 30 25 1,500 2,805 Clerical 15 15 510 1,710 Janitorial 5 25 310 1,110 Expected costs in the service departments for June are as follows: Clerical Janitorial Variable costs $ 15,400 $ 5,800…
CS Company started work on three job sites during the current year. Any costs incurred are expected to be recoverable. Data relating to the three jobs are given below: Billings on Contract Site Contract Cost Estimated Costs to Complete Collections on Price Incurred 3,750,000 1,000,000 Billings 5,000,000 900,000 1,000,000 1 5,000,000 5,000,000 900,000 2 7.000,000 2.500.000 4,000,000 3 1.000,000 1,000,000 1.500,000 1. If the company recoeds revenue over time, how much must be shown as current asset in the balance sheet of MOC Construction Company as of December 31? A. 5,500,000 B. S00,000 C 250,000 D. 100,000 2. If the company records revenue at a point in time, how much must be shown as current asset in the balance sheet of MOC Construction Company as of December 317 A. 5,100,000 8. S00,000 C 250,000 D. 100,000