please complete each part and number 1

A B C D E CD8 Creative Designs As a service to its customers, Creative Designs repairs damaged kayaks. This is especially valuable to customers that have made a significant investment in the composite kayaks. To price the repair jobs, Creative Designs uses time-and-material pricing with a desired profit margin of $20 per labor hour and a 50% materials loading charge. Recently, Bill Johnson, Vice President of Sales and Marketing, received a phone call from a dealer in Brainerd, - Minnesota. The dealer has a customer who recently damaged his composite kayak and would like an estimate of the cost to repair it. After the dealer emailed pictures of the damage, Bill reviewed the pictures with the repair technician and determined that the total materials charges for the repair would be $100. Bill estimates that the job will take 3 labor hours to complete. Following is the budgeted cost data for Creative Designs: Repair technician wages Fringe benefits Overhead $30,000 $10,000 $10,000 s Creative Designs has allocated 2,000 hours of repair time for the upcoming year. The customer has agreed to transport 6 the kayak to the Winona production facility for the repairs. B Instructions 9 Determine the price that Creative Designs would charge to complete the repairs for the customer. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". Per Hour Charge Repair technician's wages Fringe benefits Overhead Total Cost Value Value Value 2 Total Hours Value Value Value Value - Profit margin Rate charged per labor hour A B C D E F G H J K Determine the price that Creative Designs would charge to complete the repairs for the customer NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells w Repair technician's wages Fringe benefits Overhead Total Cost Value Value Value Total Per Hour Hours Charge Value Value Value Value Profit margin Rate charged per labor hour Job: Composite kayak repair Labor charges Material charges Cost of parts and materials Materials loading charge Total price of labor and material Value lolol Assume that the allocated hours of repair time change to 2,500 for the upcoming year. What is the impact of this change on the price charge for the repair job