Question

4 А в 1 CD2 - Excel Tutorial 3 CURRENT DESIGNS 4) Juegel Hollow Resort has ordered 20 rotomolded kayaks from Current Designs. Each kayak will be formed in 5 the rotomolded oven, cooled, and then the excess plastic trimmed away. Then, the hatches, seat, ropes, and tungees 6 will be attached to the kayak. 7 Dave Thill, the kayak plant manager, knows that manufacturing each kayak requires 54 pounds of polyethylene 8 powder and a finishing kit (rope, seat, hardware, etc.). The polyethylene powder used in these kayaks cost $1.50 per 9 pound, and the finishing Kits cost $170 each. Each kayak will use two kinds of labor: 2 hours of more -skilled type 10 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 11 hatches and seat and other hardware. The type l employees are paid $15 per hour, and the type Il employees are paid $12 per 12 hour. For purposes of this problem, assume that overhead is allocated to all jobs at a rate of 150% of direct labor costs. 14 Instructions 15 Determine the total cost of the Huegel Hollow order and the cost of each individual kayak in the order. Identify costs as 16 direct materials, direct labor, or manufacturing overhead. 10 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 82.1 12.5 12.9 P2JA | P2-SA CO2 O

Answer 1

If you are benefited from the solution then please LIKE , if disliked then please specify the reason.

Cost of one kayak. Normal Additional unformation Diret material Polyethylene powder Finishing kita 82 90 180 70 Diret Laboy more skilled Less skilled 30 36 36 Manufacturing Queshead 118.8 Total cost of one kayak 416 454.8 Cost of ording 20 kayak. cost per unit x 20 Kayak 8320 9096

If you have any doubts then feel free to comment.