Chapter 11 Running Case Template Make calculations in yellow and blue cells. Bill of Materials: Moto 300 Brake System Component Brake cable Brake pedal Brake pad Front brake pump Rear brake pump Front brake caliper Rear brake caliper Front brake disc Rear brake disc Brake pipe Brake lever cover Component No. M0593 M0546 M3203 M0959 M4739 M5930 M7942 M3920 M0588 M0943 M1059 Total brake system materials cost Front brake caliper cost 27 Brake pipe cost 28 29 27 Brake pipe cost 28 29 103 104 105 106 107 Total materials cost Front brake caliper cost Source Unit Cost Quantity Nissin 27.81 1 Harrison Billet 6.03 2 Russell 27.05 2 Brembo 66.05 1 Brembo 54.00 1 Nissin 105.20 1 Nissin 106.78 1 Russell 143.80 1 Russell 56.42 1 Harrison Billet 28.52 1 Brembo 2.62 1 TOTAL BRAKE SYSTEM MATERIALS COST 103 104 105 106 107 Extended Cost 30 30 1. Write queries to produce the following reports: and 2. Consider the following courses that could be completed by employees: CAD CAD Advanced Excel Intro Excel Intermediate Excel Advanced PowerPoint Word for Dummies Selling Yourself Project Management Web Design with Flash Emp_SS# (key) 012-34-5678 123-45-6789 234-56-7890 345-67-8901 456-78-9012 Last_Name Munoz Lattimore Artis Renaldo Norwick 567-89-0123 First_Name Luis Joseph Patricia Carlos Robert Street 11 Ram Ridge 302 Garden St. 45 William St. 793 Ridge Rd. 10 Webb St. City Carbondale Carbondale Basalt Basalt Carbondale O'Donnell James 56 Mountainview Carbondale 678-90-1234 789-01-2345 890-12-3456 Morrissey Kamp Franz Richard Timothy George 93 Pond Drive 39 Brook Dr. 8 Powder Tr. Basalt Basalt Carbondale 901-23-4567 Collins Dawn 9 Young Ave. Glenwood Spring 987-65-4321 Stokes Brian 5 Saddle Tr. Carbondale State Zip CO CO CO CO CO 81623 81623 81621 81621 81623 Telephone 970-945-4338 970-945-7002 970-945-0087 970-945-1883 970-945-5654 Birth_Date 29-Aug-71 M 03-Jul-72 S 11-Apr-73 S 08-May-69 M 01-Sep-70 M CO 81623 970-945-3021 09-Feb-69 M CO CO CO 81621 81621 81623 970-945-2838 970-945-5944 970-945-9304 30-Jan-60 D 27-Jun-64 M 21-Sep-64 S CO 81602 970-945-2648 03-Nov-74 S CO 81623 970-945-8943 14-May-63 D Marital Position Assembler Painter Secretary Welder Shipping Clerk Salary $39,000.00 $35,000.00 $29,000.00 $41,200.00 $32,500.00 Tester $37,000.00 Engineer Sales Rep Designer $51,000.00 $43,500.00 $55,000.00 Assembler $32,000.00 Marketing $49,500.00