Spreadsheet: 2a42b82e-b2eb-4030-bbbd-3d3d98adb7c4
Sheet: Explanation

Column1 | Column2
Cell Definitions
B5 | Number of bottles the customer would like to have made
 | Inputted number by operator
B8 | The number of cases needed to fill the number of bottles ordered by the customer.
 | This is found by dividing the number of bottles in an order (B5) by the number of bottles in a case(C94)
B10 | Overhead cost associated with process (rent per month)
 | Divide overhead cost (B65) by (30 days/month * 24 hours/day) and multiply that by the number of hours per batch ([NAME])
B11 | Raw material cost to make a batch of 2.5 ounce ID Millennium
 | Multiply the number of bottles (B5) by the cost of raw materials per bottle (B66)
B12 | Labor cost to make a batch of 2.5 ounce ID Millennium
 | Multiply the number of employees working (B68) by the hourly wage of the employees (B67) and by the number of hours per batch ([NAME])
B13 | The cost to make an order of size B5
 | Sum the overhead costs (B10), raw material costs (B11), and labor costs (B12)
B15 | Revenue from order
 | Found by multiplying the number of bottles in an order (B5) by the price of a bottle (C93)
B16 | Profit from order
 | Found by subtracting the cost of the order (B13) by the revenue from the order (B15)
B19 | Seconds required to make the order
 | Multiply the number of bottles in the order (B5) by the sum of label time sec (B85), fill time sec (B86), cap time sec (B87), uncap time sec (B88), recap time sec (B89), wait time sec (B91).  Add this to the box time sec (C90) multiplied by the number of cases in the order (B8).  Add that to the set up time (D84)
C19 | Minutes required to make the order
 | Found by dividing the seconds required to make the order (B19) by 60 (converts seconds to minutes)
[NAME] | Hours required to make the order
 | Found by dividing the minutes required to make the order (C19) by 60 (converts minutes to hours)
B26 | The cost to set up the assembly line for 2.5 ounce ID Millennium
 | Multiply number of employees performing set up (B27) by the hours to perform set up (D28) by the average hourly wage of manufacturing employees (B67)
B27 | Number of operaters performing set up
 | Information provided by Westridge manufacturing employees
B28 | The time (sec) to set up assembly line for 2.5 ounce ID Millennium
 | Fixed time of 20 minutes plus allowances (D84)
C28 | The time (min) to set up assembly line for 2.5 ounce ID Millennium
 | Set up time in seconds (B28) divided by 60 (seconds/minute)
D28 | The time (hours) to set up assembly line for 2.5 ounce ID Millennium
 | Set up time in minutes (C28) divided by 60 (minutes/hour)
B30 | Cost to label the batch of 2.5 ounce ID Millennium
 | Labor - Multiply hours to complete labelling (D32) by number of operators to label (B31) by the average hourly wage of employees (B67). Raw materials - multiply the number of bottles in batch (B5) by the sum of cost of front label (B104) and back label (B103). Sum labor costs and raw material costs.
B31 | Number of operaters labelling a batch
 | Found by observing process
B32 | Time to label (sec)
 | Multiply the number of bottles in batch (B5) by the time (sec) to label a bottle (B85)
C32 | Time to label (min)
 | Divide the time to label sec (B32) by 60 (seconds/minute)
D32 | Time to label (hour)
 | Divide the time to label min (C32) by 60 (minutes/hour)
B34 | Cost to fill the batch of 2.5 ounce ID Millennium
 | Labor - Multiply hours to complete filling (D36) by number of operators to fill (B35) by the average hourly wage of employees (B67). Raw materials - multiply the number of bottles in batch (B5) by the sum of the cost of bottle (B105) and cost of lubricant (B107). Sum labor costs and raw material costs.
B35 | Number of operaters filling a batch
 | Found by observing process
B36 | Time to fill (sec)
 | Multiply the number of bottles in batch (B5) by the time (sec) to fill a bottle (B86)
C36 | Time to fill (min)
 | Divide the time to fill sec (B36) by 60 (seconds/minute)
[NAME] | Time to fill (hour)
 | Divide the time to fill min (C36) by 60 (minutes/hour)
B38 | Cost to cap the batch of 2.5 ounce ID Millennium
 | Labor - Multiply hours to complete capping (D40) by number of operators to fill ([NAME]) by the average hourly wage of employees (B67). Raw materials -multiply the number of bottles in batch (B5) by the cost of the cap liner (B108). Sum labor costs and raw material costs.
[NAME] | Number of operaters capping a batch
 | Found by observing process
B40 | Time to cap (sec)
 | Multiply the number of bottles in batch (B5) by the time (sec) to cap a bottle (B87)
C40 | Time to cap (min)
 | Divide the time to cap sec (B40) by 60 (seconds/minute)
D40 | Time to cap (hour)
 | Divide the time to cap min (C40) by 60 (minutes/hour)
B42 | Cost to wait for batch of 2.5 ounce ID Millennium
 | Labor - Multiply hours to complete waiting (D44) by number of operators waiting (B43) by the average hourly wage of employees (B67). Raw materials -none for waiting step. Sum labor costs and raw material costs.
B43 | Number of operaters waiting for a batch
 | Found by observing process
B44 | Time to wait (sec)
 | Multiply the number of bottles in batch (B5) by the time (sec) to wait for a bottle (B91)
C44 | Time to wait (min)
 | Divide the time to wait sec (B44) by 60 (seconds/minute)
D44 | Time to wait (hour)
 | Divide the time to wait min (C44) by 60 (minutes/hour)
B46 | Cost to uncap the batch of 2.5 ounce ID Millennium
 | Labor - Multiply hours to complete capping (D48) by number of operators to fill (B47) by the average hourly wage of employees (B67). Raw materials -none for uncapping step. Sum labor costs and raw material costs.
B47 | Number of operaters uncapping a batch
 | Found by observing process
B48 | Time to uncap (sec)
 | Multiply the number of bottles in batch (B5) by the time (sec) to uncap a bottle (B88)
C48 | Time to uncap (min)
 | Divide the time to uncap sec (B48) by 60 (seconds/minute)
D48 | Time to uncap (hour)
 | Divide the time to uncap min (C48) by 60 (minutes/hour)
B50 | Cost to recap the batch of 2.5 ounce ID Millennium
 | Labor - Multiply hours to complete recapping (D52) by number of operators to recap (B51) by the average hourly wage of employees (B67). Raw materials - multiply the number of bottles in batch (B5) by the sum of the cost of cap (B106). Sum labor costs and raw material costs.
B51 | Number of operaters recapping a batch
 | Found by observing process
B52 | Time to recap (sec)
 | Multiply the number of bottles in batch (B5) by the time (sec) to recap a bottle (B89)
C52 | Time to recap (min)
 | Divide the time to recap sec (B52) by 60 (seconds/minute)
D52 | Time to recap (hour)
 | Divide the time to recap min (C52) by 60 (minutes/hour)
B54 | Cost to box the batch of 2.5 ounce ID Millennium
 | Labor - Multiply hours to complete boxing (D56) by number of operators to box (B55) by the average hourly wage of employees (B67). Raw materials - multiply the number of boxes in batch (B8) by the sum of the cost of the box (B109). Sum labor costs and raw material costs.
B55 | Number of operaters boxing a batch
 | Found by observing process
B56 | Time to box (sec)
 | Multiply the number of boxes in batch (B8) by the time (sec) to box a batch (C90)
C56 | Time to box (min)
 | Divide the time to box sec (B56) by 60 (seconds/minute)
D56 | Time to box (hour)
 | Divide the time to box min (C56) by 60 (minutes/hour)
B58 | Total cost of individual steps ($)
 | Sum the cost to setup (B26), label (B30),  fill (B34), cap (B38), wait (B42), uncap (B46), recap (B50), and box (B54).
B59 | Total hours to complete individual steps (hours)
 | Sum the time to setup (D28), label (D32), fill ([NAME]), cap (D40), wait (D44), uncap (D48), recap (D52), and box (D56).
B65 | Overhead cost associated with process (rent per month)
 | Multiply standard rate of $155 (D65) by the sq foot for manufacturing facility (C65)
C65 | The square footage of the manufacturing facility
 | provided by [NAME]
D65 | Standard rate of rent for a manufacturing facility
 | provided by [NAME]
B66 | The total cost of raw material per case of 2.5 ounce ID Millennium
 | Sum cost of back label (B103), front label (B104), bottle (B105), cap (B106), product (B107), cap liner (B108), and box (B109) per case
B67 | Average hourly wage of manufacturing employees
 | provided by [NAME]
B68 | Average number of employees working on assembly line for 2.5 ounce bottle of ID Millennium
 | Found by determing the necessary steps to run assembly line
B69 | Allowances of time studies
 | Found by observing working conditions and using a table to provide a percentage value
D73 | Normal time to set up the assembly line for the 2.5 ounce bottle of ID Millennium
 | Provided by manufacturing employees at Westridge Labs
B74 | Normal time (sec) to label a 2.5 ounce bottle of ID Millennium
 | Found by dividing 60 by the average number of bottles labeled per minute ([NAME])
[NAME] | Normal time (sec) to label a case of 2.5 ounce ID Millennium
 | Found by multiplying the normal time to label a 2.5 ounce bottle of ID Millennium (B74) by the number of bottles in a case (C94)
B75 | Normal time (sec) to fill a 2.5 ounce bottle of ID Millennium
 | Found by dividing 60 by the average number of bottles filled per minute (B97)
C75 | Normal time (sec) to fill a case of 2.5 ounce ID Millennium
 | Multiply the normal time to fill a 2.5 ounce bottle of ID Millennium (B75) by the number of bottles in a case (C94)
B76 | Normal time (sec) to cap a 2.5 ounce bottle of ID Millennium
 | Found by dividing 60 by the average number of bottles capped per minute (B98)
C76 | Normal time (sec) to cap a case of 2.5 ounce ID Millennium
 | Multiply the normal time to cap a 2.5 ounce bottle of ID Millennium (B76) by the number of bottles in a case (C94)
B77 | Normal time (sec) to uncap a 2.5 ounce bottle of ID Millennium
 | Found by dividing 60 by the average number of bottles uncapped per minute (B99)
C77 | Normal time (sec) to uncap a case of 2.5 ounce ID Millennium
 | Multiply the normal time to uncap a 2.5 ounce bottle of ID Millennium (B77) by the number of bottles in a case (C94)
B78 | Normal time (sec) to recap a 2.5 ounce bottle of ID Millennium
 | Equal to the normal time to cap a 2.5 ounce bottle of ID Millennium (B76)
C78 | Normal time (sec) to recap a case of 2.5 ounce ID Millennium
 | Equal to normal time to cap a case of 2.5 ounce ID Millennium (C76)
C79 | Normal time (sec) to box a case of 2.5 ounce ID Millennium
 | Divide 60 by the average number of boxes filled per minute (B100)
B80 | The normal time (sec)a bottle spends on the conveyer before being uncapped
 | Found by timing the amount of time a bottle spends on the line before it is uncapped
C72 | The time (sec) a case (24 bottles) of 2.5 ounce ID Millennium spends on the assembly line before being uncapped
 | Multiply the time a bottle spends on the conveyer before being uncapped (B72) by the number of bottles in a case (C86)
[NAME] | The standard time it takes to set up the assembly line for the 2.5 ounce ID Millennium (includes allowance)
 | Multiply the normal time to set up the assembly line (D73) by 1 plus the allowance (B69)
B85 | The standard time it takes to label a bottle of 2.5 ounce ID Millennium (includes allowance)
 | Multiply the normal time to label a bottle (B74) by 1 plus the allowance (B69)
C85 | The standard time it takes to label a case of 2.5 ounce ID Millennium (includes allowance)
 | Multiply the standard time it takes to label a bottle of 2.5 ounce of ID Millennium (B85) by the number of bottles in a case (C94)
B86 | The standard time it takes to fill a bottle of 2.5 ounce ID Millennium (includes allowance)
 | Multiply the normal time to fill a bottle (B75) by 1 plus the allowance (B69)
C86 | The standard time it takes to fill a case of 2.5 ounce ID Millennium (includes allowance)
 | Multiply the standard time it takes to fill a bottle of 2.5 ounce of ID Millennium (B86) by the number of bottles in a case (C94)
B87 | The standard time it takes to cap a bottle of 2.5 ounce ID Millennium (includes allowance)
 | Multiply the normal time to cap a bottle (B76) by 1 plus the allowance (B69)
C87 | The standard time it takes to cap a case of 2.5 ounce ID Millennium (includes allowance)
 | Multiply the standard time it takes to cap a bottle of 2.5 ounce of ID Millennium (B87) by the number of bottles in a case (C94)
B88 | The standard time it takes to uncap a bottle of 2.5 ounce ID Millennium (includes allowance)
 | Multiply the normal time to uncap a bottle (B77) by 1 plus the allowance (B69)
C88 | The standard time it takes to uncap a case of 2.5 ounce ID Millennium (includes allowance)
 | Multiply the standard time it takes to uncap a bottle of 2.5 ounce of ID Millennium (B88) by the number of bottles in a case (C94)
B89 | The standard time it takes to recap a bottle of 2.5 ounce ID Millennium (includes allowance)
 | Equal to the standard time to cap a 2.5 ounce bottle of ID Millennium (B87)
C89 | The standard time it takes to recap a case of 2.5 ounce ID Millennium (includes allowance)
 | Equal to the standard time to cap a case of 2.5 ounce ID Millennium (C87)
C90 | Standard time (sec) to box a case of 2.5 ounce ID Millennium
 | Multiply the normal time (sec) to box a case of 2.5 ounce ID Millennium (C79) by 1 plus the allowance (B69)
B91 | The standard time (sec)a bottle spends on the conveyer before being uncapped
 | Multiply the normal time a bottle spends on the conveyer before being uncapped (B80) by 1 plus the allowance (B69)
C91 | The standard time (sec) a case (24 bottles) of 2.5 ounce ID Millennium spends on the assembly line before being uncapped
 | Multiply the standard time a bottle spends on the conveyer before being uncapped (B91) by the number of bottles in a case (C94)
C93 | MSRP Cost of a bottle of 2.5 ounce ID Millennium
 | from Westridge Labs website
C94 | Number of bottles in each case of 2.5 ounce ID Millennium
 | from Westridge Labs website
B86 | Average number of bottles filled per minute
 | Found by counting the number of bottles filled every minute for 6 cycles and averaging them
B87 | Average number of bottles placed on line per minute (number of bottles capped per minute)
 | Found by counting the number of bottles placed on the line every minute for 6 cycles and averaging them
B98 | Average number of bottles uncapped per minute
 | Found by counting the number of bottles uncapped every minute for 6 cycles and averaging them
B99 | Average number of boxes filled per minute
 | Found by counting the number of boxes filled per minute during periods where boxes were being filled and averaging them
B100 | Average number of bottles labeled per minute
 | Found by counting the number of bottles labeled every minute for 6 cycles and averging them
B103 | Cost of one back label ($)
 | Provided by [NAME]
B104 | Cost of one front label ($)
 | Provided by [NAME]
B105 | Cost of one Bottle ($)
 | Provided by [NAME]
B106 | Cost of one [NAME] ($)
 | Provided by [NAME]
B107 | Cost of product ($) per bottle including waste and overfill
 | Provided by [NAME]
B108 | Cost of one cap liner ($)
 | Provided by [NAME]
B109 | Cost of one case box (one for every 24 bottles)
 | Provided by [NAME]