Question

In: Accounting

Wedding Bells Inc. specializes in the rentals and delivery of large tents, tables, chairs, dance platforms...

Wedding Bells Inc. specializes in the rentals and delivery of large tents, tables, chairs, dance platforms and sound systems that are used for outdoor weddings. The company owner, Susan Bells, recently completed a cost study of the firm’s Material-Handling Department in which she used work measurement to quantify the department’s activity. The control factor unit used in the work-measurement study was hundreds of kilograms of equipment loaded off or on the company delivery trucks. Susan has compiled the following data:

Month

Unit of Activity in 000’s of Kg

Material-Handling Costs

January

1,400

$11,350

February

1,200

11,350

March

1,100

11,050

April

2,600

12,120

May

1,800

11,400

June

2,000

12,000

July

2,400

12,550

August

2,200

11,100

September

1,000

10,200

October

1,300

11,250

November

1,600

11,300

December

1,800

11,700

Required:

  1. Estimate the Material-Handling Department’s cost behaviour using the high-low method. Use an equation to express the results of this estimation method.
  2. Construct an Excel spreadsheet and use the Excel functions to estimate the cost behaviour using the least-of-squares method. Use an equation to express the results of this estimation method. Calculate the R-square value and interpret the results.
  3. Using both methods above, predict Wedding Bells’ Material-Handling costs for a month when 2,300 units of activity are recorded.

Why do the results from the two methods of cost prediction above differ? Which method do you recommend? Why

Solutions

Expert Solution


Related Solutions

Party warehouse Inc. rents a wide variety of products (e.g. tables, chairs, tents and storage containers)...
Party warehouse Inc. rents a wide variety of products (e.g. tables, chairs, tents and storage containers) for special events. Upon rental, party warehouse requires a deposit which is forfeited if equipment is not returned at the end of the rental period. Deposit charged or twice the cost of the equipment, and party warehouse keeps equipment and it’s accounting records until deposits are forfeited. On April 5, a customer rented various containers for an event to be held on April 8,...
Party Warehouse Inc. rents a wide variety of products (e.g., tables, chairs, tents, and storage containers)...
Party Warehouse Inc. rents a wide variety of products (e.g., tables, chairs, tents, and storage containers) for special events. Upon rental, Party Warehouse requires a deposit which is forfeited if the equipment is not returned at the end of the rental period. Deposits charged are twice the cost of the equipment, and Party Warehouse keeps the equipment in its accounting records until deposits are forfeited. On April 5, a customer rented various containers for an event to be held on...
Scholastic Furniture, Inc. manufactures a variety of desks, chairs, tables, and shelf units that are sold...
Scholastic Furniture, Inc. manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company’s Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division’s sales manager. April 10,000 desk-and-chair sets May 12,000 desk-and-chair sets June 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of...
Scholastic Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units that are sold...
Scholastic Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company’s Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division’s sales manager. April 10,000 desk-and-chair sets May 12,000 desk-and-chair sets June 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of...
Scholastic Furniture, Inc. manufactures a variety of desks, chairs, tables, and shelf units that are sold...
Scholastic Furniture, Inc. manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company’s Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division’s sales manager. April 10,000 desk-and-chair sets May 12,000 desk-and-chair sets June 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of...
School Days Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units which are...
School Days Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units which are sold to public school systems throughout the midwest. The controller of the company’s Desk Division is currently preparing a budget for the third quarter of the year. The following sales forecast has been made by the division’s sales manager.      July 5,000 desk-and-chair sets   August 6,000 desk-and-chair sets   September 7,500 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5...
Chairvana Inc. manufactures metal tables and chairs at its plant in Paxton, Illinois. Recently hired general...
Chairvana Inc. manufactures metal tables and chairs at its plant in Paxton, Illinois. Recently hired general manager, Bob Behar, is concerned about the large inventories and manufacturing inefficiencies in the plant. The Paxton plant has two separate assembly lines - one for chairs and one for tables. Demand for chairs is significantly larger than tables, so Bob decides to tackle the table assembly process first. Bob has recently hired a summer intern, Eileen Mayer, who he asks to study the...
June Rentals Inc. owns a large commercial storage unit that it had purchased on January 1,...
June Rentals Inc. owns a large commercial storage unit that it had purchased on January 1, 2018 for $6 million cash and is accounted for in a separate account, classified as "Storage Property." The company decided to use the revaluation model to account for its storage properties and revalues them when they recognize that a substantial difference exists between net book value and fair value. June uses the straight-line depreciation method over the asset's 40-yr useful life (no residual value)....
OPRE 605.7BE Inc, Baltimore, has three flagship products: Absolute Sling Chairs, Awesome Tables, and Unbeatable Hammocks....
OPRE 605.7BE Inc, Baltimore, has three flagship products: Absolute Sling Chairs, Awesome Tables, and Unbeatable Hammocks. The unit profit for these products is $45, $90, and $95, respectively. Each type of product requires manufacturing, transportation to warehouse, and marketing. The owners are very ambitious and can work 40 hours each week and so have 200 hours available each month. However, they are unable to spend more than 60 hours on any one activity (manufacturing, transportation, and marketing) in a month....
Absorption- and Variable-Costing Income Statements San Mateo Optics, Inc., specializes in manufacturing lenses for large telescopes...
Absorption- and Variable-Costing Income Statements San Mateo Optics, Inc., specializes in manufacturing lenses for large telescopes and cameras used in space exploration. As the specifications for the lenses are determined by the customer and vary considerably, the company uses a job-order costing system.    Manufacturing overhead is applied to jobs on the basis of direct labor hours, utilizing the absorption- or full-costing method. San Mateo’s predetermined overhead rates for 20x1 and 20x2 were based on the following estimates. 20x1 20x2 Direct...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT