CD12 - Excel Tutorial

CURRENT DESIGNS

Juegel Hollow Resort has ordered 20 rotomolded kayaks from Current Designs. Each kayak will be formed in

the rotomolded oven, cooled, and then the excess plastic trimmed away. Then, the hatches, seat, ropes, and bungees

will be attached to the kayak.

Dave Thill, the kayak plant manager, knows that manufacturing each kayak requires 54 pounds of polyethylene

powder and a finishing kit (rope, seat, hardware, etc.). The polyethylene powder used in these kayaks cost $1.50 per

pound, and the finishing kits cost $170 each. Each kayak will use two kinds of labor: 2 hours of more -skilled type I

labor from people who run the oven and trim the plastic, and 3 hours of less-skilled type II labor from people who attach the

hatches and seat and other hardware. The type I employees are paid $15 per hour, and the type II employees are paid $12 per

hour. For purposes of this problem, assume that overhead is allocated to all jobs at a rate of 150% of direct labor costs.

Instructions

Determine the total cost of the Huegel Hollow order and the cost of each individual kayak in the order. Identify costs as

direct materials, direct labor, or manufacturing overhead.

NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" .

Cost for one kayak:

Direct Materials

Polyethylene powder

?

Finishing kit

?

Direct Labor

More skilled

?

Less skilled

?

Manufacturing overhead

?

Total cost of one kayak

?

Cost for order of 20 kayaks:

Cost per unit x 20 units

?

After you have completed CD15, consider the following additional question.

Assume that each kayak requires 60 lbs of polyethylene and cost of finishing kit changed to $180 per kit. Also

assume that overhead is allocated to all jobs at a rate of 180% of direct labor costs. Show the impact of these changes.