In Principles of Accounting: 12th EditionBelverd E. + 5 othersPublisher: Cengage LearningISBN: 9781133593102 Please answer part three. Data on utilities for the year follow:MonthNumber of JobsCostHours WorkedJanuary42$ 3,950840February373,550740March444,090880AprilMay494,410980544,7201,080June625,2401,240July715,8201,420AugustSeptember735,8901,460635,3701,260October484,340960November454,210900December403,830800Totals628$55,42012,560REQUIRED1. Classify the costs as variable, fixed, or mixed.2. Using the high-low method, separate mixed costs into their variable and fixed com-ponents. Use total hours worked as the basis.3. Compute the average cost per job for the year. (Hint: Divide the total of all costsfor the year by the number of jobs completed.) Use estimated hours to determineutilities costs. (Round to two decimal places.) Cost Behavior and Projection for a Service BusinessP1. Wabash Company specializes in refurbishing exterior painted surfaces that havebeen hard hit by humidity and insect debris. It uses a special technique, called pressurecleaning, before priming and painting the surface. The refurbishing process involves thefollowing steps:1. Unskilled laborers trim all trees and bushes within two feet of the structure.2. Skilled laborers clean the building with a high-pressure cleaning machine, usingabout 6 gallons of chlorine per job.3. Unskilled laborers apply a coat of primer.4. Skilled laborers apply oil-based exterior paint to the entire surface.On average, skilled laborers work 12 hours per job, and unskilled laborers work 8 hours.The refurbishing process generated the following operating results during the year on500 jobs:Skilled labor$20 per hour$8 per hour3,000 gallons at $5.50 per gallonUnskilled laborGallons of chlorine usedPaint primer7,536 gallons at $15.50 per gallon6,280 gallons at $16.00 per gallon$600 per month depreciation$800 per month total$421 per monthPaintDepreciation of paint-spraying equipmentLease of two vansRent on storage building(Continued)

Since part three was asked to be answered, only the third subpart from the first question is being…

Data on utilities for the year follow: Month Number of Jobs Cost Hours Worked January 42 $ 3,950 840 February 37 3,550 740 March 44 4,090 880 980 April May 49 4,410 54 4,720 1,080 June 62 5,240 1,240 July 71 5,820 1,420 August September 73 5,890 1,460 63 5,370 1,260 October 48 4,340 960 November 45 4,210 900 December 40 3,830 800 Totals 628 $55,420 12,560 REQUIRED 1. Classify the costs as variable, fixed, or mixed. 2. Using the high-low method, separate mixed costs into their variable and fixed com- ponents. Use total hours worked as the basis. 3. Compute the average cost per job for the year. (Hint: Divide the total of all costs for the year by the number of jobs completed.) Use estimated hours to determine utilities costs. (Round to two decimal places.)

Data on utilities for the year follow: Month Number of Jobs Cost Hours Worked January 42 $ 3,950 840 February 37 3,550 740 March 44 4,090 880 980 April May 49 4,410 54 4,720 1,080 June 62 5,240 1,240 July 71 5,820 1,420 August September 73 5,890 1,460 63 5,370 1,260 October 48 4,340 960 November 45 4,210 900 December 40 3,830 800 Totals 628 $55,420 12,560 REQUIRED 1. Classify the costs as variable, fixed, or mixed. 2. Using the high-low method, separate mixed costs into their variable and fixed com- ponents. Use total hours worked as the basis. 3. Compute the average cost per job for the year. (Hint: Divide the total of all costs for the year by the number of jobs completed.) Use estimated hours to determine utilities costs. (Round to two decimal places.)

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter2: Building Blocks Of Managerial Accounting

Section: Chapter Questions

Problem 4EA: Hicks Contracting collects and analyzes cost data in order to track the cost of installing decks on...

See similar textbooks

In Principles of Accounting:

12th Edition

Belverd E. + 5 others

Publisher: Cengage Learning

ISBN: 9781133593102

Please answer part three.

Data on utilities for the year follow:
Month
Number of Jobs
Cost
Hours Worked
January
42
$ 3,950
840
February
37
3,550
740
March
44
4,090
880
April
May
49
4,410
980
54
4,720
1,080
June
62
5,240
1,240
July
71
5,820
1,420
August
September
73
5,890
1,460
63
5,370
1,260
October
48
4,340
960
November
45
4,210
900
December
40
3,830
800
Totals
628
$55,420
12,560
REQUIRED
1. Classify the costs as variable, fixed, or mixed.
2. Using the high-low method, separate mixed costs into their variable and fixed com-
ponents. Use total hours worked as the basis.
3. Compute the average cost per job for the year. (Hint: Divide the total of all costs
for the year by the number of jobs completed.) Use estimated hours to determine
utilities costs. (Round to two decimal places.)

Cost Behavior and Projection for a Service Business
P1. Wabash Company specializes in refurbishing exterior painted surfaces that have
been hard hit by humidity and insect debris. It uses a special technique, called pressure
cleaning, before priming and painting the surface. The refurbishing process involves the
following steps:
1. Unskilled laborers trim all trees and bushes within two feet of the structure.
2. Skilled laborers clean the building with a high-pressure cleaning machine, using
about 6 gallons of chlorine per job.
3. Unskilled laborers apply a coat of primer.
4. Skilled laborers apply oil-based exterior paint to the entire surface.
On average, skilled laborers work 12 hours per job, and unskilled laborers work 8 hours.
The refurbishing process generated the following operating results during the year on
500 jobs:
Skilled labor
$20 per hour
$8 per hour
3,000 gallons at $5.50 per gallon
Unskilled labor
Gallons of chlorine used
Paint primer
7,536 gallons at $15.50 per gallon
6,280 gallons at $16.00 per gallon
$600 per month depreciation
$800 per month total
$421 per month
Paint
Depreciation of paint-spraying equipment
Lease of two vans
Rent on storage building
(Continued)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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

Identification. Pocket Umbrella, Inc., is considering producing a new type of umbrella. This newpocket-sized umbrella would fit into a coat pocket or purse. Classify the following costs of thisnew product as direct materials, direct labor, manufacturing overhead, selling expense, oradministrative expense.6. The salary of the supervisor of the people who assembled the product7. Wages of the product tester who stands in a shower to make sure the umbrellas do not leak8. Cost of market research survey9. Salary of the company’s sales managers10. Depreciation of administrative office buildingB. Essay. Answer below questions as required.1. Identify the three elements of cost incurred in manufacturing a product and indicate thedistinguishing characteristics of each. 2. What is the general content of a statement of cost of goods manufactured? 3. What is the relationship of the cost of goods manufactured to the income statement? 4. How did you cope up with your studies in this “new normal”…
Cost Estimation; Machine Replacement; Ethics Hardison Inc. manufactures glass for officebuildings in Florida. As a result of age and wear, a critical machine in the production process hasbegun to produce quality defects. Hardison is considering replacing the old machine with a newmachine, either brand A or brand B. The manufacturer has provided Hardison with the following dataon the costs of operation of each machine brand at various levels of output:Output(square yards)Brand AEstimated Total CostsBrand BEstimated Total Costs2,000 $ 97,000 $ 120,0004,000 125,000 160,0008,000 180,000 200,00016,000 225,000 260,00032,000 280,000 300,00064,000 438,000 368,000Required1. Graph the data for the two brands of machines.2. Use the high-low method to determine the cost equation for each brand of machine and use the results tocalculate the costs of operating each machine if Hardison’s output is expected to be 25,000 square yards
Relevant Cost Analysis—Quality Improvements Destin Company produces water control valves, made of brass, which it sells primarily to builders for use in commercial real estateconstruction. These valves must meet rigid specifications (i.e., the quality tolerance is small).Valves that, upon inspection, get rejected are returned to the Casting Department; that is, theyare returned to stage 1 of the four-stage manufacturing process. Rejected items are melted andthen recast. As such, no new materials in Casting are required to rework these items. However,new materials must be added in the Finishing Department for all reworked valves. As the costaccountant for the company, you have prepared the following cost data regarding the productionof a typical valve:[LO 17-5]Cost Casting Finishing Inspection Packing TotalDirect materials $200 $ 12 $-0- $ 8 $220Direct labor 110 120 20 20 270Variable manufacturing overhead 100 150 20 20 290Allocated fixed overhead 70 80 40 10 200$480 $362 $80 $58…
Nizam Company produces speaker cabinets. Recently, Nizam switched from a traditional departmental assembly line system to a manufacturing cell in order to produce the cabinets. Sup-pose that the cabinet manufacturing cell is the cost object. Assume that all or a portion of the following costs must be assigned to the cell:a. Depreciation on electric saws, sanders, and drills used to produce the cabinetsb. Power to heat and cool the plant in which the cell is locatedc. Salary of cell supervisord. Wood used to produce the cabinet housingse. Maintenance for the cell’s equipment (provided by the maintenance department)f. Labor used to cut the wood and to assemble the cabinetsg. Replacement sanding beltsh. Cost of janitorial services for the planti. Ordering costs for materials used in productionj. The salary of the industrial engineer (she spends about 20 percent of her time on work forthe cell)k. Cost of maintaining plant and grounds l. Cost of plant’s personnel officem. Depreciation on…
Due to the increased intensity of competition, the company is contemplating the activitybased costing method to help understand and control its costs better. The following are the costing and operating details collected for the pilot testing purpose. Material Handling QA Total Documentation $750,000 $1,100,000 $1,850,000 Fork Lift Truck Depreciation $500,000 $250,000 $750,000 Palletizing $1,250,000 - $1,250,000 Inspection - $650,000 $650,000 Total $2,500,000 $2,000,000 $4,500,000 Number of process checklist forms 7 17 13 37 Fork Lift Truck Hours 15 35 25 75 Number of pallets 25 145 80 250 Number of inspection hours 400 1,100 1,000 2,500 Question 1. Compute the activity-based cost allocated to all products. Would you recommend for the change to ABC? Explain
Pocket Umbrella, Inc. is considering producing a new type of umbrella. This new pocket-sized umbrella would fit into a coat pocket or purse. Classify the following costs of this new product as direct materials, direct labor, manufacturing overhead, or selling and administrative. Cost of advertising the product Fabric used to make the umbrellas Maintenance of cutting machines used to cut the umbrella fabric so it will fit the umbrella frame Wages of workers who assemble the product Presidents salary The salary of the supervisor of the people who assemble the product Wages of the product tester who stands in a shower to make sure the umbrellas do not leak Cost of market research survey Salary of the companys sales managers Depreciation of administrative office building
Assume you are the leather department manager at the Famous Football Factory. The leather department is a cost center and you are reviewing the scrap costs for the previous year, shown here: A. Using Microsoft Excel or another spreadsheet application, create a line chart with markers showing the leather scrap expense. Describe your observations. B. Knowing that leather is susceptible to indoor temperature, you decide to talk with the maintenance manager and obtain the following information: Using Microsoft Excel or another spreadsheet application, create individual line charts with markers showing the indoor temperature, spare parts inventory, and breakdowns. Describe your observations and actions you might consider.
Life Force Fitness, Inc., assembles and sells treadmills. Activity-based product information for each treadmill is as follows: All of the activity costs are related to labor. Management must remove 2.00 of activity cost from the product in order to remain competitive. Rework involves disassembling and repairing a unit that fails testing. Not all units require rework, but the average is 0.40 hour per unit. Presently, the testing is done on the completed assembly; but much of the rework has been related to motors, which can be tested independently prior to adding the motor to the treadmill during final assembly. Thus, motor issues can be diagnosed and solved without having to disassemble the complete treadmill. This change will reduce the average rework per unit by one-quarter. a.Determine the new activity cost per unit under the rework improvement scenario. b.If management had the choice of doing the rework improvement in (a) or cutting the moving activity in half by improving the product flow, which decision should be implemented? Why?
Ethics in Action Danielle Hastings was recently hired as a cost analyst by CareNet Medical Supplies Inc. One of Danielles first assignments was to perform a net present value analysis for a new warehouse. Danielle performed the analysis and determined a present value index of 0.75. The plant manager, Jerrod Moore, is very intent on purchasing the warehouse because he believes that more storage space is needed. Jerrod asks Danielle into his office and the following conversation takes place: Jerrod: Danielle, youre new here, arent you? Danielle: Yes, I am. Jerrod: Well, Danielle, Im not at all pleased with the capital investment analysis that you performed on this new warehouse. I need that warehouse for my production. If I dont get it, where am I going to place our output? Danielle: Well, we need to get product into our customers hands. Jerrod: I agree, and we need a warehouse to do that. Danielle: My analysis does not support constructing a new warehouse. The numbers dont lie; the warehouse does not meet our investment return targets. In fact, it seems to me that purchasing a warehouse does not add much value to the business. We need to be producing product to satisfy customer orders, not to fill a warehouse. Jerrod: The headquarters people will not allow me to build the warehouse if the numbers dont add up. You know as well as I that many assumptions go into your net present value analysis. Why dont you relax some of your assumptions so that the financial savings will offset the cost? Danielle: Im willing to discuss my assumptions with you. Maybe I overlooked something. Jerrod: Good. Heres what I want you to do. I see in your analysis that you dont project greater sales as a result of the warehouse. It seems to me that if we can store more goods, then we will have more to sell. Thus, logically, a larger warehouse translates into more sales. If you incorporate this into your analysis, I think youll see that the numbers will work out. Why dont you work it through and come back with a new analysis. Im really counting on you on this one. Lets get off to a good start together and see if we can get this project accepted. What is your advice to Danielle?
Kagle design engineers are in the process of developing a new green product, one that will significantly reduce impact on the environment and yet still provide the desired customer functionality. Currently, two designs are being considered. The manager of Kagle has told the engineers that the cost for the new product cannot exceed 550 per unit (target cost). In the past, the Cost Accounting Department has given estimated costs using a unit-based system. At the request of the Engineering Department, Cost Accounting is providing both unit-and activity-based accounting information (made possible by a recent pilot study producing the activity-based data). Unit-based system: Variable conversion activity rate: 100 per direct labor hour Material usage rate: 20 per part ABC system: Labor usage: 15 per direct labor hour Material usage (direct materials): 20 per part Machining: 75 per machine hour Purchasing activity: 150 per purchase order Setup activity: 3,000 per setup hour Warranty activity: 500 per returned unit (usually requires extensive rework) Customer repair cost: 25 per repair hour (average) Required: 1. Select the lower-cost design using unit-based costing. Are logistical and post-purchase activities considered in this analysis? 2. Select the lower-cost design using ABC analysis. Explain why the analysis differs from the unit-based analysis. 3. What if the post-purchase cost was an environmental contaminant and amounted to 10 per unit for Design A and 40 per unit for Design B? Assume that the environmental cost is borne by society. Now which is the better design?
Freidrich is working with the operations manager to determine what the standard material cost is for a spice chest. He has watched the process from start to finish and taken detailed notes on what material is used. The easiest material to measure is the wood. Each chest uses 5 board feet and produces 1.5 feet of scrap. He is not sure what to do with the scrap that is produced; the company cannot buy the boards in any other dimensions. What amount of materials should be included in the standard for material costs?
Hicks Contracting collects and analyzes cost data in order to track the cost of installing decks on new home construction jobs. The following are some of the costs that they incur. Classify these costs as fixed or variable costs and as product or period costs. Lumber used to construct decks ($12.00 per square foot) Carpenter labor used to construct decks ($10 per hour) Construction supervisor salary ($45,000 per year) Depreciation on tools and equipment ($6,000 per year) Selling and administrative expenses ($35,000 per year) Rent on corporate office space ($34,000 per year) Nails, glue, and other materials required to construct deck (varies per job)