Question

In: Accounting

Albedo Inc. manufactures high-end replacement telescope lenses for amateur and professional astronomers who are seeking to...

Albedo Inc. manufactures high-end replacement telescope lenses for amateur and professional astronomers who are seeking to upgrade the performance of their telescopes. You have just become employed as a staff accountant at Albedo and Jordan Coleman, the controller, has asked you to help with maintenance cost estimation for the lens manufacturing process. You review the manufacturing process and decide that the best cost driver for maintenance costs is labor hours. The data below are from the previous fiscal year for maintenance expense and labor hours:

Month	Maintenance Cost		Labor Hours
1		$2,870	2,630
2		3,150	2,740
3		3,280	2,840
4		3,825	3,265
5		3,640	3,080
6		4,565	3,770
7		3,940	3,320
8		4,940	4,140
9		4,755	3,940
10		5,010	4,125
11		5,080	4,330
12		4,220	3,480

Required:

What is the cost equation for maintenance cost using the high-low method? (Round "constant" to nearest whole dollar. Round "slope" to 2 decimal places. Negative amounts should be indicated by a minus sign.)

Required:

What is the cost equation for maintenance cost using the high-low method? (Round "constant" to nearest whole dollar. Round "slope" to 2 decimal places. Negative amounts should be indicated by a minus sign.)

Maintenance cost = ______________ + (__________ x __________)

Expert Solution

Under high-low method, the data of highest activity and lowest activity is used for calculating constant and slope.

The highest activity (i.e. highest labor hours) is in 11th month (i.e. 4,330 hours) with maintenance cost of $5,080 and the lowest labor hours is in 1st month (i.e. 2,630 hrs) with maintenance cost of $2,870.

Variable maintenance cost per hour

= (Maintenance cost in 11th month-Maintenance cost in 1st month)/(Lab hrs in 11th month - Labor hrs in 1st month)

= ($5,080-$2,870)/(4,330 hrs-2,630 hrs) = $2,210/1,700 hrs = $1.30 per hour

Slope is equal to variable cost per unit i.e $1.30 per hour in this case.

Constant is equal to fixed cost.

Fixed cost = Total maintenace cost in 1st month - Total Variable cost in 1st month

= $2,870 - ($1.30 per hour*2,630 hrs)

= $2,870 - $3,419 = -$549 per month

Constant is negative (i.e. -549)

The cost equation for Maintenance cost using the high-low method is shown as follows:-

Y = a+bx

Where Y = Maintence cost

a = Constant (i.e. Fixed cost)

b = Slope (i.e. Variable cost per unit)

X = Labor hours used in a particular month.

Y = -549+1.3X

Maintenance cost = -549 + (1.3 *X)

ekkarill92 answered 1 year ago

SPRINT , Inc., manufactures athletic shoes and athletic clothing for both amateur and professional athletes. The...

SPRINT , Inc., manufactures athletic shoes and athletic clothing for both amateur and professional athletes. The company has two product lines (clothing and shoes), which are produced in separate manufacturing facilities; however, both manufacturing facilities share the same support services for information technology and human resources. The following shows total costs for each manufacturing facility and for each support department. Total Costs by Department (in thousands) Information technology (IT) $ 2,000 Human resources (HR) 1,000 Clothing $10,000 Shoes $8,000 Total...

Question: SPRINT , Inc., manufactures athletic shoes and athletic clothing for both amateur and professional athletes....

Question: SPRINT , Inc., manufactures athletic shoes and athletic clothing for both amateur and professional athletes. The company has two product lines (clothing and shoes), which are produced in separate manufacturing facilities; however, both manufacturing facilities share the same support services for information technology and human resources. The following shows total costs for each manufacturing facility and for each support department. Total Costs by Department (in thousands) Information technology (IT) $ 2,000 Human resources (HR) 1,000 Clothing $10,000 Shoes $8,000...

Music-Is-Us, Inc., is a supplier of musical instruments for professional and amateur musicians. The company’s accountants...

Music-Is-Us, Inc., is a supplier of musical instruments for professional and amateur musicians. The company’s accountants make adjusting entries monthly, and they make all closing entries annually . The company is growing rapidly and prides itself on having no long-term liabilities. The company has provided the following trial balance dated December 31, 2018. MUSIC-IS-US, INC. TRIAL BALANCE DECEMBER 31, 2018 Cash. . . . . . . . . . . . . . . . . . . ....

HepTones, Inc., is a U.S. based firm that designs and manufactures high-end stereo speakers. They have...

HepTones, Inc., is a U.S. based firm that designs and manufactures high-end stereo speakers. They have been successfully manufacturing and selling their speakers in the U.S. for the last five years. Although they are still somewhat small, their U.S. sales have been growing at a rate of 20% annually and HepTones has achieved an excellent reputation for providing high-quality products at reasonable prices. Based on their success in the U.S., HepTones would like to expand their production and sales to...

Lens Care Inc. (LCI) manufactures specialized equipment for polishing optical lenses. There are two models -...

Lens Care Inc. (LCI) manufactures specialized equipment for polishing optical lenses. There are two models - one mainly used for fine eyewear (F-32) and another for lenses used in binoculars, cameras, and similar equipment (B-13). The manufacturing cost of each unit is calculated using activity-based costing, using the following manufacturing cost pools: Cost Pools Allocation Base Costing Rate Materials handling Number of parts $ 2.40 per part Manufacturing supervision Hours of machine time $ 14.80 per hour Assembly Number of...

Arctic Gear Inc. manufactures jackets and other cold weather clothing. A popular high end ski parka...

Arctic Gear Inc. manufactures jackets and other cold weather clothing. A popular high end ski parka requires the following: Direct materials standard 2 square metres at $13.50 per metre Direct manufacturing labour standard 1.5 hours at $20.00 per hour During the third quarter, the company made 1,500 parkas and used 3,150 square metres of fabric costing $36,225. Direct labour totaled 2,100 hours for $47,250. Required: a. Compute the direct materials price and efficiency variances for the quarter. b. Compute the direct manufacturing labour rate...

Ingenious Measurement Systems Inc. (IMS) is a Canadian public company that manufactures high-end measuring devices used...

Ingenious Measurement Systems Inc. (IMS) is a Canadian public company that manufactures high-end measuring devices used primarily in the oil and natural gas industries. In 2013, it had sales of $100 million and earnings before income tax of $5 million. The company has a December 31 year end. Ted Pollock, IMS's CEO, is a proponent of strong corporate governance. He has spent the last year strengthening IMS's internal control environment. He believes that organizations that demonstrate good corporate governance practices...

Oakwood Inc. manufactures end tables, armchairs, and other wood furniture products from high-quality materials. The company...

Oakwood Inc. manufactures end tables, armchairs, and other wood furniture products from high-quality materials. The company uses a standard costing system and isolates variances as soon as possible. The purchasing manager is responsible for controlling direct material price variances, and production managers are responsible for controlling usage variances. During November, the following results were reported for the production of American Oak armchairs: Unit produced 1540 armchairs Direct materials purchased 19000 board feet Direct materials issued into production 17350 board feet...

Oakwood, Inc., manufactures end tables, armchairs, and other wood furniture products from high-quality materials. The company...

Oakwood, Inc., manufactures end tables, armchairs, and other wood furniture products from high-quality materials. The company uses a standard costing system and isolates variances as soon as possible. The purchasing manager is responsible for controlling direct material price variances, and production managers are responsible for controlling usage variances. During November, the following results were reported for the production of American Oak armchairs: Units produced 1,670 armchairs Direct materials purchased 18,500 board feet Direct materials issued into production 17,250 board feet...

Pale Blue Eyes, Inc., manufactures contact lenses, and accounts for production using a FIFO process costing...

Pale Blue Eyes, Inc., manufactures contact lenses, and accounts for production using a FIFO process costing system. The main material involved is glass, and the production process is mainly done in the grinding process center, hence all materials are added at the beginning of the production process and one work in process center is used, Grinding. Selected data regarding the grinding department during the month of September are as follows: Production data: Total % complete as to DM CC Units...