File Home Insert Page Layout Formulas Data Review View Help Share Comments Define Name fx Insert Function ? A 2 e AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library Use in Formula Name Manager E Create from Selection Defined Names Ey Trace Precedents V Show Formulas a Trace Dependents Error Checking FRemove Arrows ~ Evaluate Formula Formula Auditing Loa Watch Window Calculate Now Calculation Calculate Sheet Options Calculation E10 : for Production per Day using MID function (Correct) 0 P Q R S A B D E F G H 1 J K L M N 1 2 In a textile company, machine ID incorporates its capacity (in pounds, of fiber produced per batch). 3 For example, machine ID of 1BBV 250 means that this machine can produce 250 pounds of fiber, per batch. 4 Joey has been asked by the Production Manager to calculate the total production per day by each machine. Joey knows the Machine ID (column A) and 5 how many batches of fiber are produced each day by each machine (column B). 6 Joey, however, did not have any experience with data analysis and has wrong calculations in column C and D. 7. We have to calculate the correct production output in pounds per day by each machine. We also have to calculate the total production capacity (in pounds) of this textile factory. 8 9 Total Factory Capacity in Pounds = 0 Machine Machine capacity in Production per Production per Alternate Solution ID Batches pounds per batch Day (Wrong Day using MID Using RIGHT function 10 Number Per Day (Wrong analysis) analysis) function (Easier and Correct) 11 1BBV 250 4 25 100 (Correct) 12 2 BBV 250 4 25 100 13 3BBV 500 4 50 200 14 4BBV 500 4 50 200 15 5BBV 750 3 75 225 16 6BBV 750 3 75 225 17 1MCBV 15 5 15 75 18 2 MCBV 52 4 52 208 19 3MCBV 52 4 52 208 20 1MCPV 11 3 110 330 21 2 MCPV 11 3 110 330 22 3MCPV 15 3 155 465 23 4MCPV 15 3 155 465 Homework Name Logic HW Practice2 + 14 ... Edit 90 E10 fo Production per Day using MID function (Correct) 1 K 0 P o R S B C D D E F G H J L M N 1 2 In a textile company, machine ID incorporates its capacity (in pounds, of fiber produced per batch). 3 For example, machine ID of 1BBV 250 means that this machine can produce 250 pounds of fiber, per batch. 4 Joey has been asked by the Production Manager to calculate the total production per day by each machine. Joey knows the Machine ID (column A) and 5 how many batches of fiber are produced each day by each machine (column B). 6 Joey, however, did not have any experience with data analysis and has wrong calculations in column C and D. 7 We have to calculate the correct production output in pounds per day by each machine. We also have to calculate the total production capacity (in pounds) of this textile factory. 8 9 Total Factory Capacity in Pounds = 0 Machine Machine capacity in Production per Day using MID Alternate Solution ID Batches pounds per batch Day (Wrong function Using RIGHT function 10 Number Per Day (Wrong analysis) analysis) (Correct) (Easier and Correct) 11 1BBV 250 4 25 100 12 2BBV 250 4 25 100 13 3BBV 500 50 200 14 4BBV 500 50 200 15 5BBV 750 3 75 225 16 6BBV 750 3 75 225 17 1MCBV 15 5 15 75 18 2 MCBV 52 52 208 19 3MCBV 52 4 52 208 20 1 MCPV 11 3 110 330 21 2 MCPV 11 3 110 330 22 3MCPV 15 3 155 465 23 4MCPV 15 3 155 465 Homework Name Logic HW Practice2 + 4 4 4 4 File Home Insert Page Layout Formulas Data Review View Help Share Comments Define Name fx Insert Function ? A 2 e AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library Use in Formula Name Manager E Create from Selection Defined Names Ey Trace Precedents V Show Formulas a Trace Dependents Error Checking FRemove Arrows ~ Evaluate Formula Formula Auditing Loa Watch Window Calculate Now Calculation Calculate Sheet Options Calculation E10 : for Production per Day using MID function (Correct) 0 P Q R S A B D E F G H 1 J K L M N 1 2 In a textile company, machine ID incorporates its capacity (in pounds, of fiber produced per batch). 3 For example, machine ID of 1BBV 250 means that this machine can produce 250 pounds of fiber, per batch. 4 Joey has been asked by the Production Manager to calculate the total production per day by each machine. Joey knows the Machine ID (column A) and 5 how many batches of fiber are produced each day by each machine (column B). 6 Joey, however, did not have any experience with data analysis and has wrong calculations in column C and D. 7. We have to calculate the correct production output in pounds per day by each machine. We also have to calculate the total production capacity (in pounds) of this textile factory. 8 9 Total Factory Capacity in Pounds = 0 Machine Machine capacity in Production per Production per Alternate Solution ID Batches pounds per batch Day (Wrong Day using MID Using RIGHT function 10 Number Per Day (Wrong analysis) analysis) function (Easier and Correct) 11 1BBV 250 4 25 100 (Correct) 12 2 BBV 250 4 25 100 13 3BBV 500 4 50 200 14 4BBV 500 4 50 200 15 5BBV 750 3 75 225 16 6BBV 750 3 75 225 17 1MCBV 15 5 15 75 18 2 MCBV 52 4 52 208 19 3MCBV 52 4 52 208 20 1MCPV 11 3 110 330 21 2 MCPV 11 3 110 330 22 3MCPV 15 3 155 465 23 4MCPV 15 3 155 465 Homework Name Logic HW Practice2 + 14 ... Edit 90 E10 fo Production per Day using MID function (Correct) 1 K 0 P o R S B C D D E F G H J L M N 1 2 In a textile company, machine ID incorporates its capacity (in pounds, of fiber produced per batch). 3 For example, machine ID of 1BBV 250 means that this machine can produce 250 pounds of fiber, per batch. 4 Joey has been asked by the Production Manager to calculate the total production per day by each machine. Joey knows the Machine ID (column A) and 5 how many batches of fiber are produced each day by each machine (column B). 6 Joey, however, did not have any experience with data analysis and has wrong calculations in column C and D. 7 We have to calculate the correct production output in pounds per day by each machine. We also have to calculate the total production capacity (in pounds) of this textile factory. 8 9 Total Factory Capacity in Pounds = 0 Machine Machine capacity in Production per Day using MID Alternate Solution ID Batches pounds per batch Day (Wrong function Using RIGHT function 10 Number Per Day (Wrong analysis) analysis) (Correct) (Easier and Correct) 11 1BBV 250 4 25 100 12 2BBV 250 4 25 100 13 3BBV 500 50 200 14 4BBV 500 50 200 15 5BBV 750 3 75 225 16 6BBV 750 3 75 225 17 1MCBV 15 5 15 75 18 2 MCBV 52 52 208 19 3MCBV 52 4 52 208 20 1 MCPV 11 3 110 330 21 2 MCPV 11 3 110 330 22 3MCPV 15 3 155 465 23 4MCPV 15 3 155 465 Homework Name Logic HW Practice2 + 4 4 4 4