I need help with this managerial accounting problem

AutoSave . Of) - - ExcelTemplateAssignment_Ch02 - Excel Search Drew Detmer DD File Home Insert Page Layout Formulas Data Review View Help Share Comments X Cut CB) Copy Liberation Sans 11 ~ A" A" = = =2 ab Wrap Text General Normal 2 Normal TIX AutoSum Fill AP O Paste BIU~ ~ . GEE Merge & Center $ ~ % " Conditional Format as Bad Good Insert Delete Format Sort & Find & deas Format Painter Formatting Table v Clear ~ Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas N10 X V A B C D E F G H J K M N P Q R S T U V W X 1 CD2 - Excel Tutorial 2 w 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 bungees will be attached to the kayak 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 I 10 labor from people who run the oven and trim the plastic, and 3 hours of less-skilled type ll labor from people who attach the 11 hatches and seat and other hardware. The type I employees are paid $15 per hour, and the type ll 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. 13 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. 17 18 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 19 22 Cost for one kayak: 23 Direct Materials Polyethylene powder 26 Finishing kit ? 27 28 Direct Labor 29 More skilled ? Less skilled 31 32 Manufacturing overhead 33 34 Total cost of one kayak 35 36 Cart for ardor of 20 kenwake- E2-1 E2-5 E2-9 P2-3A P2-5A CD2 + 100% Ready Type here to search e X 10:43 PM O C ) 1/30/2020AutoSave . Of) - - ExcelTemplateAssignment_Ch02 - Excel Search Drew Detmer DD File Home Insert Page Layout Formulas Data Review View Help Share Comments X Cut Liberation Sans ab Wrap Text AutoSum 11 ~ A" A" = = =2 General Normal 2 Normal TIX APO Paste CB) Copy Fill Format Painter BIU~ ~. GEE Merge & Center $ ~ % " Conditional Format as Bad Good Insert Delete Format Sort & Find & deas Formatting Table v Clear ~ Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas N10 X V B C D E F G H J K M N P Q R S T U V W X 13 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. 17 18 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 19 Cost for one kayak: Direct Materials Polyethylene powder Finishing kit 28 Direct Labor More skilled ? Less skilled 32 overhead 34 Total cost of one kayak 35 36 37 Cost for order of 20 kayaks: 38 39 Cost per unit x 20 units ? 40 42 43 After you have completed CD2, consider the following additional question. 14 1. Assume that each kayak requires 60 lbs of polyethylene and cost of finishing kit changed to $180 per kit. Also 45 assume that overhead is allocated to all jobs at a rate of 180% of direct labor costs. Show the impact of these changes. 46 47 18 E2-1 E2-5 E2-9 P2-3A P2-5A CD2 + 100% Ready 9 e X 10:43 PM Type here to search O CO [ 1/30/2020