The executive team at Current Designs has gathered to evaluate the company's operations for the last month. One of the topics on the agenda is the special order from Huegel Hollow. Current Designs had a special order to produce a batch of 60 kayaks for a client, and you were asked to determine the cost of the order and the cost per kayak. Mike Cichanowski asked the others if the special order caused any particular problems in the production process Dave Thill, the production manager, made the following comments: "Since we wanted to complete this order quickly and make a good first impression on this new customer, we had some of our most experienced type I workers run the rotomold oven and do the trimming. They were very efficient and were able to determine that part of the manufacturing process even more quickly than the regular crew. However, the finishing on these kayaks required a different technique than what we usually use, so our type II workers took a little longer than usual for that part of the process." Deb Welch, who is in charge of the purchasing function, said, "We had to pay a little more for the polyethylene powder for this order because the customer wanted a color that we don't usually stock. We also ordered a little extra since we wanted to make sure that we had enough to allow us to calibrate the equipment. The calibration was a little tricky, and we used all of the powder that we had purchased. Since the number of kayaks in the order was fairly small we were able to use some rope and other parts that were left over from last year's production in the finishing kits. We've seen a price increase for these components in the last year, so using the parts that we already had in inventory cut our costs for the finishing kits." Instructions (a) Diane Buswell examined some of the accounting records and reported the following actual activity for Huegel Hollow order: Pounds of polyethylene powder purchased # of Finishing kits assembled Type I labor hours Type Il labor hours Cost of polyethylene purchases Cost of assembling finishing kits Total type I labor cost Total type Il labor cost Number of units produced 3,600 60 195 $6,120.00 $9,720.00 $1,710.00 $2,388.75 60 The standards that had been developed for each unit of this model of kayak are as follows: Pounds of polyethylene powder Finishing kits Type I labor hours Type II labor hours 54 $1.50 Cost of polyethylene powder per pound Cost of finishing each kit Type I labor rate per hour Type II labor rate per hour Calculate the following variances for this problem. Indicate Favorable (F) or Unfavorable (U) NOTE: Enter a number in cells requesting a value; enter either a formula in cells with a"?" . $170.00 $15.00 $12.00 (a) Calculate the following variances for this problem. Indicate Favorable (F) or Unfavorable (U) (1) Quantity variance for polyethylene powder AQ Value sQ Value SP Value SP Value AQ X SP)- X SP For U (2) Price variance for polyethylene powder AQ Value AQ Value AP Value SP Value AQ X AP)(AQ X SP For U (3) Quantity variance for finishing kits. AQ Value sQ Value SP Value SP Value AQ X SP)- X SP For U (4) Price variance for finishing kits AQ Value AQ Value AP Value SP Value AQ X AP)(AQ X SP For U (5) Quantity variance for type I workers. AH Value SH Value AH X SR SR Value SR Value SH X SR For U (6) Price variance for type I workers. AH Value AH Value AR Value SR Value AH X SR AH X AR)- For U (7) Quantity variance for type Il workers. AH Value SH Value AH X SR SR Value SR Value SH X SR For U (8) Price variance for typell workers. AH Value AH Value AR Value SR Value AH X SR AH X AR)- For U
