AutoSave (CF) o H2-0- File Betty's Bats Production v. 2 (7) (3) - Protected ViewSaved to this PC O Search (Alt+Q) Home Insert Draw Design Layout References Mailings Review View Add-ins Help PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit. it's safer to stay in Protected View. Enable Editing Betty's Bats Production Sheet 5 YEAR forecast: Page 1 of 2 244 words Text Predictions: On - Type here to search Yr 1: 875,000 Yr 2: 920,000 Yr 3: 1,000,000 Yr 4: 950,000 Yr 5: 990,000 Throughput: (per piece) [CPM, Critical Path] A: Slugging: 3 minutes B: First Extrusion: 2.5 minutes C: Second Extrusion: 4 minutes D: Finishing: 3.5 minutes E: Total handling time (added to process): 1.0 minutes [Excepting handling time, once the cue is full, you produce a bat every 5 minutes total] 3 Manufacturing Plants O P Desktop Danny King DK Focus GO 71F Sunny ca 0 x Comments Share X 7:33 PM 6/15/2022 O 12096 AutoSave Of H U Betty's Bats Production v. 2 (7) (2) Saved to this PC* Search (Alt+Q) File Home Insert Draw Design Layout References Mailings Review View Add-ins Help Calibri (Body) E-E- E-EE X Out Paste Copy AaBbccDd AaBbccud AaBbC AaBbcc AaB ABECCD AaBbccDd 11 A A Aa A A D A BIUX, x' a B = 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em.... Format Painter Clipboard Font G Paragraph Styles [Excepting handling time, once the cue is full, you produce a bat every 5 minutes total] 3 Manufacturing Plants Each plant has 6 production lines 50 production weeks 40 hours per week x 50 weeks [1 shift,1 line] - (2,000 hours or 120,000 minutes) 120,000 minutes divided by 5 minutes per bat - 24,000 bats per shift per line annually 3 shifts = 72,000 bats x 6 lines = 432,000 bats x 3 plants = 1,296,000 bats produced Page 1 of 2 H K Text Predictions: On 244 words Type here to search Accessibility: Good to go O www wwwwww E 0 Desktop Danny King DK Focus DE Find Replace Select Editing 71F Sunny ca Comments Editor 10 Reuse Files Editor Reuse Fres Dictate Voice QA Share D 110% 7:35 PM 6/15/2022 AutoSave Of H U Betty's Bats Production v. 2 (7) (2) Saved to this PC* Search (Alt+Q) File Home Insert Draw Design Layout Add-ins Help Mailings Review E E 1616-12- Calibri (Body) References 11 A A Aa A ADA X Out Paste Copy AaBbccud AaBbccud AaBbC AaBbcc AaB AaBbCCD AaBbceld BIUX, x' a 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em.... Format Painter Clipboard Font G Paragraph la Styles Transportation & Distribution Problem [Each plant can produce 132,000 bats annually] Warehouse 1 can handle 350,000 bats Warehouse 2 can handle 500,000 bats Warehouse 3 can handle 450,000 bats Page 2 of 2 - + 244 words K Text Predictions: On Type here to search Accessibility: Good to go O www View Plant 1 to Warehouse 16 miles Plant 1 to warehouse 2 = 19 miles Plant 1 to Warehouse 3 - 22 miles Plant 2 to Warehouse 1 - 19 miles Plant 2 to Warehouse 2 = 18 miles Plant 2 to Warehouse 3- 28 miles Plant 3 to Warehouse 1- 25 miles Plant 3 to Warehouse 2 = 24 miles Plant 3 to Warehouse 3 = 29 miles E 0 P Desktop Danny King DK DE Find Replace Select Editing Focus 70F Sunny ca Comments Editor Dictate Voice Share 10 Reuse Files Editor Reuse Fres 110% 7:42 PM P 6/15/2022 AutoSave Off H File Home Insert X Out Copy Paste Format Painter Clipboard G Betty's Bats Production v. 2 (7) (2) Saved to this PC Draw Design Layout References Calibri (Body) BIU Search (Alt+Q) Mailings Review View Add-ins 11 A A Aa AEE- x, x' . E-6-5- == 88 y Font Fa Paragraphi Plant 3 to Warehouse 2-24 miles Plant 3 to Warehouse 3 - 29 miles Linear Programming Problem [Tropic Sun like] Objective: Minimize "Bat Miles" Danny King DK Help AaBbccDd AaBbccud AaBbC AaBbcc AaB AaBbCED AaBbccDd 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em... Styles Find Replace Select Editing ca Comments Editor Editor Dictate Voice Share LO Reuse Files Reuse Fres