Advanced Management Accounting
All provided information is given here. Please show your work or Excel Formulas.
*Hint* work it one part at a time; starting with part a.
9. Jay Thomas runs an automobile service station. The station is housed in facilities leased for $5,800 per month which includes rent on equipment and service bays used for oil changes, tire changes, and weather checks. Approximately 25% of the rent is attributable to service bays and 75% is to gasoline sales. Jay employs 6 employees who are paid on average $8 per hour. Jay realizes that many hazardous substances are handled on a daily basis in his station. He would like to determine the environmental cost associated with each type of service. He needs to know whether his charges are sufficient to cover those environmental costs, or whether the cost is such that the service should be discontinued. Jay has analyzed each ser- vice he provides and assembled the following information. Oil Changes. A complete oil change generally takes a half an hour to perform. For each vehicle, the filter must be replaced, and the old oil drained and placed in a waste oil storage tank. Jay's cost for new filters averages $1.35 each. Most vehicles require 5 quarts of oil at $0.50 per quart. In addition, the oil storage tank, purchased at a cost of $3,500, holds 400 gallons of used oil. Each oil change adds 1.25 gallons of fluid to the tank. Jay estimates that the use of the oil storage tank costs $0.10 per oil change. A local waste hauler empties and disposes of the oil in the tank at a charge of $10 per month. About 10 minutes of each oil change is spent complying with EPA guidelines for oil and filter disposal. The EPA requires Jay to charge and show on the sales ticket) a $1.50 fee for oil and filter disposal. In the past Jay has shown this on the sales ticket, but has discounted his charge an equal amount. This practice is commonly followed by his competitors. Tire Installation. It takes approximately one hour to install 4 new tires. Normally, Jay sells and installs 30 sets of new tires per month. Old tires are placed in a designated area for scrap tires. This area occupies 1/10 of the work bay area. Removal of scrap tires must be done by a registered disposer of scrap tires, who charges $1.00 per tire. Jay passes this cost to his customers. Weather Checks. In the spring, air conditioning and coolant checks become a staple part of Jay's business. A weather check requires 1.5 hours to complete. Freon and coolants, drained during weather checks, are both considered hazardous substances. However, Jay is able to recycle these substances through individual filtration systems. The filtration sys- tems were purchased for a cost of $3,850 each. Jay estimates that the cost of these systems is $1.50 per weather check. The filters in the coolant tank must be replaced once a month; this costs Jay $30. The freon system stores freon until the tank is full and then compresses the freon to remove excess water. This drying process reduces the liquid by 50%. Jay performs the drying process 5 times per year. Each drying uses 2 filters which cost $15 each. The recy- Measuring and Managing Environmental Costs cled freon is stored in another container and used to fill vehicles as needed. The storage tanks for coolants and freon occupy 5% of the work bay areas. Other Training and certification for the handling of hazardous substances is required for all new employees. This is generally accomplished in a 6-hour course offered locally by a national automotive chain. Cost for the course is $100. Jay has an employee turnover rate that requires him to hire around 6 new employees each year. Usually 4 of these have previ- ous experience and certification and do not require the EPA training. Additional information about Jay's sales is provided below. Budgeted Revenue Oil changes320 per month @ $12.95 $4,144.00 Tire changes30 per month @ $19.95 598.50 Tire sales 10,350.00 Weather checks15 per month @ 44.95 674.25 Gasoline sales and other services 12,450.00 Total revenues $28,216.75 Required: a. Compute the total cost per month for each type of service: oil changes, tire changes and weather checks. b. Develop an environmental cost analysis similar to Exhibit 3 of the module classifying the costs from requirement (a) as environmental or nonenvironmental. c. Calculate the amount Jay spends for prevention, assessment, control and failure costs. d. Are there any services Jay should consider discontinuing? 9. Jay Thomas runs an automobile service station. The station is housed in facilities leased for $5,800 per month which includes rent on equipment and service bays used for oil changes, tire changes, and weather checks. Approximately 25% of the rent is attributable to service bays and 75% is to gasoline sales. Jay employs 6 employees who are paid on average $8 per hour. Jay realizes that many hazardous substances are handled on a daily basis in his station. He would like to determine the environmental cost associated with each type of service. He needs to know whether his charges are sufficient to cover those environmental costs, or whether the cost is such that the service should be discontinued. Jay has analyzed each ser- vice he provides and assembled the following information. Oil Changes. A complete oil change generally takes a half an hour to perform. For each vehicle, the filter must be replaced, and the old oil drained and placed in a waste oil storage tank. Jay's cost for new filters averages $1.35 each. Most vehicles require 5 quarts of oil at $0.50 per quart. In addition, the oil storage tank, purchased at a cost of $3,500, holds 400 gallons of used oil. Each oil change adds 1.25 gallons of fluid to the tank. Jay estimates that the use of the oil storage tank costs $0.10 per oil change. A local waste hauler empties and disposes of the oil in the tank at a charge of $10 per month. About 10 minutes of each oil change is spent complying with EPA guidelines for oil and filter disposal. The EPA requires Jay to charge and show on the sales ticket) a $1.50 fee for oil and filter disposal. In the past Jay has shown this on the sales ticket, but has discounted his charge an equal amount. This practice is commonly followed by his competitors. Tire Installation. It takes approximately one hour to install 4 new tires. Normally, Jay sells and installs 30 sets of new tires per month. Old tires are placed in a designated area for scrap tires. This area occupies 1/10 of the work bay area. Removal of scrap tires must be done by a registered disposer of scrap tires, who charges $1.00 per tire. Jay passes this cost to his customers. Weather Checks. In the spring, air conditioning and coolant checks become a staple part of Jay's business. A weather check requires 1.5 hours to complete. Freon and coolants, drained during weather checks, are both considered hazardous substances. However, Jay is able to recycle these substances through individual filtration systems. The filtration sys- tems were purchased for a cost of $3,850 each. Jay estimates that the cost of these systems is $1.50 per weather check. The filters in the coolant tank must be replaced once a month; this costs Jay $30. The freon system stores freon until the tank is full and then compresses the freon to remove excess water. This drying process reduces the liquid by 50%. Jay performs the drying process 5 times per year. Each drying uses 2 filters which cost $15 each. The recy- Measuring and Managing Environmental Costs cled freon is stored in another container and used to fill vehicles as needed. The storage tanks for coolants and freon occupy 5% of the work bay areas. Other Training and certification for the handling of hazardous substances is required for all new employees. This is generally accomplished in a 6-hour course offered locally by a national automotive chain. Cost for the course is $100. Jay has an employee turnover rate that requires him to hire around 6 new employees each year. Usually 4 of these have previ- ous experience and certification and do not require the EPA training. Additional information about Jay's sales is provided below. Budgeted Revenue Oil changes320 per month @ $12.95 $4,144.00 Tire changes30 per month @ $19.95 598.50 Tire sales 10,350.00 Weather checks15 per month @ 44.95 674.25 Gasoline sales and other services 12,450.00 Total revenues $28,216.75 Required: a. Compute the total cost per month for each type of service: oil changes, tire changes and weather checks. b. Develop an environmental cost analysis similar to Exhibit 3 of the module classifying the costs from requirement (a) as environmental or nonenvironmental. c. Calculate the amount Jay spends for prevention, assessment, control and failure costs. d. Are there any services Jay should consider discontinuing
