7BOBO-dHHHHHH-d H-h-:..( - -Z`*$@.@Q@..@J.ƀ..@ Q@..Q@.. Q@..@ƀ..d@..@d@..AH@..@H@..:..@..@.@.8@@.@.UH@.@.D.@.nH@.@.xHH(FG(HH(d'@.xtTBItalicI UnlD/hruIOutlEShad$Conde--pt+ S ript-ext Color-ne StylesG* IC<*-TI.h9v  -|!(DSET((Vs.&|-L-T-Py-<3v8y-ߐ/l !y-2xy-ߔ-vy-0xy-2x#'y-.p(y-8-v)7y-4/r.y-T/n5y-,3l<y-\3vBy-ߘ3vHy-3xOpy-l0lS y-4vXy-.o\y-0vby-4rgy-h4rny-\4rsy-X$H()Dg*+,-^_`a2345678$GH_       9 : ; < = >           !5vwxyzsabcde;IJKLM  ! "y # # # # # #' $ $ & ' ' ' ' ' ' ' ' ' ' ' ' (p (q (r (s (t (u (v (w ( ( (((((((((((((()))))))))))) )!)")#)$)%)&)')()))*)+),)-).)/)0)1)2)3)4)5)6)7,, , , , , , - - - - -( -* -+ -, - - - - - - - - - - - . . ..1Y4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 555557:;;;;;;;<4<5<6<7<8<9<:<<<<@@@@@AAAAAAA AAAAAAAAAAAAAAABBFYGGGGGHHHHHHHHHHHHHHHHHHHHNN@NANBNCNtNuNvNwNxNyNzNNNNNNNNNNNNNOlOmOnOoOpP[P\P]P^P_P`PaPPPPPPPPPPQQQQQR#R$R%R'R(RRRRRRRSSSSS T!T6TPTpTTTTUoUUUUUUUUUUUUVpVVVVVW*W+W,W-WWWWWWWWWXXXYPYYZ6ZZ[y[z[[[[[[[[\1\2\3\4\5\6\7\8\9\:\;\<\=\>\\\\\\^-^2^B^^^^_?_`p`aaaabbbb b!bbbbbbbbbbbbbbbbcdddQd~ddeeeeeeeeeef f f f fffffffg`ggggggggggggghhhhhhiiAipiiijj1jTjjjjknkkklll=ldllmmmmmmmmmmmmmnnnnnooopppppppppppppppppppppq:qr0sssss s s s s sssss G                 a  5 ;      + ? J U e ~               #        !      z {      e         1 2 ; > @ C E H J M O R T W Y _           y I J                       2 ! ! ! " " " #  #& #' %> %K %m %n %v % % % ' (r (s ( ( ( ( ( ( ( ) *$ *- *< * * * +1 +: , - - - - - - .  .  .  . . / / / 0 0 4 4 4 5 5 5 5 6 7  7 7 7$ 7* 77 7= 7 7 7 7 7 7 7 7 7 7 7 7 7 7 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 ;a < >y > > > > > > > > > @ @ @ A A A A A A A A B B B B B C C  D D Ej Ek E E G H H H H KY N N@ NA N N Oh Oo Op O O O O Pa P P P P Q: Q; Q S  S T T  U V W W X X X{ X| Y YS Y Y Y Y Y Y Y Y Y Y Z7 [z \5 \9 \ \ \ \ ] ] ] ^7 ^e ^i ^w ^ a a b b b b b c d d' d0 d7 dA dE dQ dT e e f  f g g g g g h h h h i k{ k k k k k l  l= lG lP lR lc li mW m] m^ mk m m n n oB oE s s  s  s s s s s s% s% |%-H% -DE-@-< -8 -4J-0)y-,-(-$J- "7N-#-&-)y-,{- 0)-3G-5-7-;-?-CE-GE--Jr-N-R-U-Y-[-^-aqW-d-h-j-lv-oI-q9-% UNIT 5: DEALING WITH DATA ODD QUESTIONS 1-39 1. Al and Cindy are trying to reduce their total utility costs. They first want to know what their utilities are costing them now. Their monthly bills are paid to the electric company, the gas company, the water/sewer company, and to the city garbage department. They have collected and organized the data shown below. Month Electric Gas Water/Sewer Garbage 1 $92.89 $89.00 $28.47 $ 7.50 2 105.89 68.92 33.96 7.50 3 121.52 54.84 35.80 7.50 4 135.49 43.20 40.87 7.50 5 139.61 29.12 44.26 7.50 6 141.94 22.11 46.46 7.50 7 140.33 26.95 44.11 7.50 8 140.52 23.11 43.20 7.50 9 137.45 27.19 41.88 7.50 10 129.16 37.54 35.56 7.50 11 118.36 48.79 36.76 7.50 12 105.61 62.59 32.11 7.50 a. Find the average monthly utility costs for each type of utility. (The average monthly cost is the total cost per year divided by 12.) b. Some electric utilities offer an averaging plan. With this plan, your bill each month is the average of the previous 12 months (including the current month). If Al and Cindy chose this plan, what would their electric bill require them to pay for the 12th month? c. If their average electric bill is reduced by one third, how much can Al and Cindy hope to save during a month? During a year? What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 3. Joshua has just received his first monthly pay check at his new job, for the month of January. He wants to determine if his employer is withholding enough taxes. Examine the data below. Pay check stub for: Joshua Rogers For the month of: January GROSS WAGES NET PAY $1119.95 $872.15 SALARY INCOME FED INCOME TAX $1100.00 $118.80 COMMISSION STATE INCOME TAX $19.95 $46.50 SOCIAL SECURITY $82.50 a. Interpret the data in this paycheck stub to determine Joshuas estimated annual gross wages, federal income tax, and state income tax for the current year. b. Joshua has determined that he should owe about $1400 federal income tax at the end of the year. Is his employer withholding enough federal income tax each month? c. In Joshuas home state, the annual state income tax is calculated to be $440 plus 8% of gross wages over $11,250. Interpret the annual wages to find the amount of state income tax due from Joshua at the end of the year. Is his employer withholding enough state tax each month? What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and units used are correct): 5. Juanita needs to replace the carpeting in her home. Presently, her floors are covered as follows: * Living room, bedrooms, and closets are carpeted. * Front entry is covered with ceramic tile. * Kitchen and bath are covered with linoleum. Juanita needs to collect prices from local merchants for the carpet and select one. Carpet is stocked in 12 foot wide rolls, and she wants a solid brown color. a. Collect the data from the floor plan drawn below, as well from the facts given above. Obtain a reasonable price for Juanitas carpet style from carpet dealers, newspaper ads, or from your instructor. place picture (page 25) here b. Interpret the floor plan to determine how much carpet Juanita must purchase to recarpet her house. c. Calculate the total cost of carpet needed. What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and units used are correct): 7. Chuck and Shirley Moore own four wheat fields. They are farmed by Anderson, Davis, Fisher, and Reed. Andersons 180 acres yielded 36 bushels per acre. Daviss 320 acres yielded 42 bushels per acre. Fishers 90 acres yielded 34 bushels per acre. And Reeds 160 acres yielded 34 bushels per acre. The selling price for wheat is $4y.25 a bushel. a. Organize the Moores wheat data into a table. Show each farmers name, acreage, and average yield per acre. b. Compute the total number of acres farmed, and the total number of bushels of wheat that were harvested by the four farmers. c. Determine the total money received from the sale of wheat. What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and units used are correct): 9. Carl monitors an Agricultural Weather Station that records the daily maximum temperature. Carl collects this piece of data from the equipment each day, and posts it on a calendar. Carls calendar for this month is shown below. Agricultural weather station Maximum daily temperature (oF) SUN MON TUE WED THU FRI SAT 80 79 69 78 82 82 84 83 86 84 85 83 84 88 85 87 86 88 87 86 85 86 87 87 86 83 84 87 89 90 a. Carl has collected the data in a convenient calendar format. Organize the data using a simple graph showing the temperature changing over the span of the month. (Use the bottom axis for the day of the month, 1 through 30, and the side axis for the temperature, from 60oF to 100oF.) b. Interpret the graph to determine the highest and lowest maximum temperature for the month. c. Find the average maximum temperature for the month. (Notice that neither the calendar format nor the graph is very helpful in calculating the average. Is there a better way to organize the data to do this?) What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and units used are correct): 11. Kent is a clerk in an automotive parts store. A customer has come in with a list of items needed. You have identified the part numbers for his list, as shown below. Customers parts needed Part no. Quantity Description 318439731 12 Spark plug set 847990617 23 Condenser 422540343 10 Distributor points 918705818 17 Carburetor kit 637423525 8 Needle valve 562251154 31 1 in. hose clamp 246522724 7 Ignition coil wire 853464136 13 Flywheel spring 247013296 2 Flywheel 943414322 12 Spark plug wire set A quick look at the companys computer inventory screen revealed the partial parts list shown below. Parts on hand Part no. Quantity Description 101898762 9 Car polish 246522724 12 Ignition coil wire 247013296 1 Flywheel 318439731 32 Spark plug set 368472091 5 Metric wrench set 422540343 15 Distributor points 562251154 39 1 in hose clamp 637423525 3 Needle valve 653981653 12 O- ring 762439408 75 Engine oil 847990617 23 Condenser 853464136 1 Flywheel spring 918705818 4 Carburetor kit 943414322 6 Spark plug wire set 976286119 34 Headlamp a. Interpret the data to determine what parts (if any) need to be back ordered (that is, there is insufficient quantity to fill the Norder). How many of each should Kent back order? b. What would Kent have to do if he didnt have the computer screen showing the store inventory data? 13. Kathy works in a mail order department store as a sales clerk. She frequently must mail packages to customers. Kathy is required to figure the amount of postage, insurance, and other fees for these packages. The packages from her store normally are sent as fourth-class mail. She collects her data from charts supplied by the postal service, shown below. (Please refer to chart, next page.) Kathy is preparing the shipping charges for three customers packages. She has collected data for each package. Package 1: 20 pounds, Parcel Post, to Zone 4 Package 2: 15 pounds, Parcel Post, Insured for $50.00, to Zone 6 Package 3: 4 pounds 3 ounces, Special Handling, insured for $75.00, to Zone 2 a. Organize the data for each of the three packages that Kathy must mail. b. Calculate the total cost of mailing each package. c. What appears to be the biggest portion of the cost of mailing packages - postage, insurance, or handling fees? d. Kathys postage data may be out-of-date. Where might you go to find more current data of this type? What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 13. (continued) Place charts on this page. 15. Philip is responsible for verifying the contents of the cash drawers at the end of the working day for the three cash registers. As each drawer is delivered to him, Philip records the quantities of currency, as shown below. Drawer 1: 12 $10 bills, 10 $5 bills, 16 $1 bills, 3 half-dollars, 28 quarters, 16 dimes, 15 nickels, 19 pennies Drawer 2: 9 $20 bills, 7 $10 bills, 2 $5 bills, 20 $1 bills, 21 quarters, 6 dimes, 8 nickels, 14 pennies Drawer 3: 2 $20 bills, 10 $10 bills, 11 $5 bills, 19 $1 bills, 2 half-dollars, 18 quarters, 25 dimes, 25 nickels, 38 pennies a. Collect and organize the data from the cash drawers into a table. b. Interpret the table to find the total value of the money in the three cash drawers. Add the totals  for each drawer and the grand total to your table of data. What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 17. Whit works as a sales clerk in Johnsons TV shop. His supervisor asks him to prepare a report showing the percent of sales by product line for last month. His supervisor wants to compare the data with the sales from the same month last year for presentation at a stockholders meeting. Whit collects his data from the weekly sales records. He organizes his data into a table as shown below. Weekly sales summary Product line Week 1 Week 2 Week 3 Week 4 Portable radios $ 900 $ 760 $ 895 $ 445 Miniature radios 300 3,550 2,495 2,955 Color TV sets 9,000 11,500 14,000 11,500 B/W TV sets 0 289 214 146 Stereo consoles 1,500 2,875 1,045 580 a. Using the weekly data, create a table showing the monthly totals by product line, and the grand total sales. b. For each product line, calculate the percent of the months grand total. c. Whit located a similar report from the same month last year that shows the monthly sales totals for each category. Portable radio sales amounted to $4200, miniature TV sets $1230, color TV sets $39,700, black and white TV sets $860, and stereo consoles $8700. Add this data to your table, in the appropriate product line. d. Calculate the percent of the months grand total sales for each product line from last years sales dala. e. Interpret the percentages to determine what shift in sales has taken place since last year? f. Do you think the stockholders will be pleased with the change? What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 19. Rose is a payroll clerk at a hardware store. Rose calculates the weekly wages, commission, and total earnings for the sales employees. She collects a wealth of data, as follows, summarizing last weeks hours worked and sales. Hourly pay and commission rate Name Pay/Hour Commission % Smith 3.50 10% Zales 4.00 15% Travler 3.65 15% Jones 3.85 12% Hall 3.90 8% Daily hours worked Name Mon Tue Wed Thu Fri Smith 8.0 8.0 7.5 8.5 8.0 Zales 7.0 7.0 7.0 8.0 7.0 Travler 8.0 8.0 8.0 7.5 8.5 Jones 9.0 9.0 9.0 9.0 4.0 Hall 7.0 7.0 7.0 7.0 7.0 Daily sales Name Mon Tues Wed Thu Fri Smith $150.00 $ 80.00 $ 27.00 $ 45.00 $ 59.00 Zales 100.00 100.00 75.00 100.00 25.00 Travler 95.00 105.00 100.00 150.00 50.00 Jones 100.00 90.00 85.00 95.00 200.00 Hall 70.00 65.00 105.00 100.00 45.00 a. Organize Roses data, by employee, into a table of totals for the week. b. Interpret the data to compute for each employee: 1. Gross wages (hours worked times pay/hour) 2. Commission earnings (commission % times total sales) 3. Total gross earnings (gross wages plus commission earnings) What are you looking for? What do you need to answer the question?  Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 21. Roxanne is working as an Emergency Medical Technician for the fire department. Roxanne not only responds to emergency calls, but also transports patients who are unable to travel without medical attention. Roxanne must keep mileage records for all such travel. These reports are then submitted to the Fire Chief on a weekly basis. The fire department charges a $65.00 fee for such services, plus $1.50 per mile. This weeks log appears below. Weekly nonemergency travel log Patient Travel (from/to) Miles Smith J.C. Home to hospital 14 Truston, F. Home to nursing home 24 Hart, M.M. Hospital to regional care facility 84 Philips, S. Home to hospital 10 Johnson, R.L. Hospital to nursing home 15 Kincaid, G.A. Hospital to nursing home 15 Callahan, C. Home to hospital 4 a. Calculate the charge to each patient, and place it in a table. b. Determine the total mileage and total charges for this weeks transportation of patients. What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 23. Rosemarie is a medical technician working in a blood bank. Her job is to screen potential blood donors. Donors are expected to meet the following basic conditions: Blood donor requirements Body weight over 50 kilograms (110). Oral temperature not over 99.6o F. Pulse rate regular, between 60 and 120 beats per minute. Systolic blood pressure between 100 and 200 mm. Diastolic blood pressure between 50 and 100 mm. Hemoglobin at least 12.5g for female, 13.5g for male. Rosemarie is considering Jimmy, Daniel, and Gloria, three potential donors. She interviews and examines each in turn. * Jimmy weighs 157 pounds, temperature of 99.2oF, regular pulse rate of 70, blood pressure of 220/110 (systolic /diastolic), hemoglobin value of 12.9g. * Daniel weighs 185 pounds, temperature of 98.4oF, regular pusle rate of 92, blood pressure 120/80, hemoglobin value of 14.2g. * Gloria weighs 112 pounds, temperature of 100.4oF, irregular pulse rate of 110, blood pressure 116/70, hemoglobin value of 12.8g. a. Organize Rosemaries interview data for the three potential blood donors. b. Interpret the data, comparing each candidates statistics with the blood donor requirements. You may want to circle those statistics that ar-e unacceptable. c. Identify which potential donors Rosemarie should accept and which she should reject. What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 25. Jackie is working for the public health department. She is helping control an outbreak of measles (Rubeola) in the city schools. Part of her job is to discover when a child was exposed, and identify other children who also were exposed. Jackie knows that children who have measles are contagious from 4 days before the rash appears, to 5 days after. This type of measles takes from 10 to 12 days to develop into a rash. A large group of children attended a birthday party on April 3. On April 6, Johnny, one of the children at the party, broke out with the measles rash. a. Organize the data to disply the time periods involved. Use a calendar format. Indicate the day of the party and the day that Johnnys rash appeared. b. Interpret the data to find the days when Johnny was contagious. Indicate these days on the calendar with a C1. c. Consider the children who were exposed at the party. Interpret the data to determine when they might break out with the measles rash. Indicate these days on the calendar with Breakout. d. Determine when these children (who may contract the measles) would be contagious to others, and should be isolated. Indicate these days on the calendar with a C2. What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 27. Jeff and Liz kept a record of their meals for a 24- hour period. Using Calories and Carbohydrates by Barbara Kraus (or any accepted calorie counter), they wish to compare their calorie intakes. Their food log is shown below. Please put food log, page 41, here. a. Collect and organize the calorie data for the foods eaten by Jeff and Liz at each meal. b. Calculate the total calories consumed by each Jeff and Liz. c. Can you think of any other way that Jeff and Liz could determine their calorie intake without collecting this kind of date? What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 29. Nancy and Bob are trying to keep the food budget for their family of five under $500 per month. They also want to ensure that everybody has a balanced diet. So theyve set up the following guidelines for spending their $500: Food type % of total $ Meat 30% Produce 20% Dairy products 15% Breads & pastries 6% Canned goods 20% Miscellaneous items 9% a. Using the data provided above, organize a table and calculate the amount of money that Nancy and Bob can spend each month on each food type. b. Nancy summarizes their actual purchases for last month, as shown below. Insert purchase list,page 43, here.  Using the actual purchase data from Nancys records, compute the total purchases for each food type. c. Interpret the table of actual purchases. Are any items over budget during the last month? What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 31. Floyd is servicing a high-temperature oven for a laboratory. The oven operates around 800oC. The customer wants Floyd to recommend the correct type of thermocouple wire to sense the temperature in the oven during certain experiments. Floyd checks some catalogs and collects the data as follows. Thermocouple wire characteristics and prices Type Temp range (oC)  Cost per foot T 0 to 350 $0.50 J 0 to 750 0.55 E 0 to 900 0.67 K 0 to 1250 0.73 a. Interpret the data to determine which type of thermocouple wire will meet the customers needs. b. For the wires that Floyd recommends, what would it cost to purchase 125 feet? c. Use the calculated purchase costs to determine which wire Floyd should recommend for minimum cost to the customer. What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 33. Gene works in an electronics repair shop. On his current work order, a customer reports an unstable performance of the equipment. Gene decides to monitor the voltage output of the 24 - volt power supply. The specification manual states that the power supply must be stable to 24 volts + 0.25 volts (that is, 23.75 to 24.25 volts). He collects data every hour, shown below. WO #05237 Power supply voltage Time Voltage (V) (power on) 9:10 AM 23.56 10:00 AM 23.80 11:00 AM 23.92 12:10 AM 24.10 1:10 PM 24.12 2:05 PM 24.28 a. Gene already has collected and organized the data. Use the data to determine the average output of the power supply during the test period. b. Interpret the test data to find the range of the voltage readings during the test period (that is, the highest minus the lowest reading). c. Should Gene report a problem with the power supply? d. Plot Genes data, using time as the bottom axis (9 AM to 2 PM), and voltage as the side axis (22 V to 26 V). Does there appear to be any trend in the output of the power supply through tWhe day? If so, indicate the trend on the graph. Is there any good reason to plot the data? What are you looking for? What do you need to answer the question? Write out the methods that you will use to solve the problem and show your work in calculating the answer(s). Your answer(s) are (make sure you are close to your estimate and the units used are correct): 35. Becky supervises the assembling of custom radio kits. The assembly job requires cutting and packaging a number of different wire lengths and quantities. The bill of materials for this kit gives the following information. Radio kit HX2400 Wire material list Wire code Quantity Length (cm) 1354 17 6.0 1354 6 10.0 2269 10 10.0 3196 1 50.0 6002 6 18.0 8259 25 4.5 9271 14 12.0 Becky wishes to investigate the cost of this radio kit. She has a pricing guide that identifies the price per unit length of wire for the different types of wire. With this list she can create a cost sheet for the wire. Place wire pricing chart,page 48,here. a. Collect the data from the bill of materials and the pricing chart, and organize it in a table. Show, for each wire code needed in the radio kit, the total length needed and price per centimeter. b. Use this data to determine the total cost of each wire code in the kit, and the total wire cost for the kit. c. If a wrong wire is used in the kit, what effect would this have on the cost of wire in the radio kits? 37. Craig is analyzing the current drain on an automotive electric system. Craig has found a chart that shows the current required by various components. The chart is shownbelow. Current drain for automotive components Equipment item Current required (amps) 1. Turn signal lights 5 2. Door lights (courtesy/dome) 3 3. Headlights (hi-beam) 14 4. Headlights (lo-beam) 13 5. Electric window (up or down) 5 6. Air conditioner 10 7. Heater, low 8 8. Heater, high 10 9. Deicer 16 10. Power seat 15 11. Radio 1 12. Emergency warning lights 14 Craig wants to check the current required by several combinations of components. His plan is listed in the following table. Test plan for current checks Test no. Items to turn ON 1 3,6,7,9 2 2,6,11,12 3 3,5,6,12 4 4,7,10,11 Test data for current checks Test no. Measured current 1 46 amps 2 32 amps 3 44 amps 4 39 amps a. Collect the current data for each vof Craigs tests and organize it in a table. b. Interpret Craigs test data to determine which (if any) of the tests resulted in more than one amp over the specified current drain. c. Why do you think that Craig selected the combinations of equipment shown above? Are other 39. Maurice works as an estimators helper for a plumbing contractor. The blueprint calls for the installation of several different pumps. He lists the number required and pump descriptions, as shown below. 2 each: 3000 gallons per minute, 10 inch suction, 150 horsepower 1 each: 500 gallons per minute, 2 1/2 inch suction, 25 horsepower 3 each: 1200 gallons per minute, 6 inch suction, 60 horsepower 1 each: 6000 gallons per minute, 14 inch suction, 300 horsepower He has an hourly estimation chart for installation of pumps and motors shown below. The chart lists how many labor hours are needed to perforn the necessary electrical work. a. Collect the data for quantities and descriptions of the required pumps. Organize the data into convenient tabular form. b. Compute the total labor hours required to install and wire each pump (that is, pump and electrical). Add this to your table of data. c. How many total labor hours will be r9equired to install all the pumps and motors for this job? d. If the deadline for having the electrical work finished is only three weeks away, how many electricians are needed to finish the job in time? (Assume each will work only 40 hours per week.) DSET|(Ht-89 **>"9h989DSET(H@P-9>96*=9DSETR - ---    -Unit 5 Odd Questions