NEED HELP ON PART 2 USING 3 MODELS PLEASE SHOW HOW TO DO IN EXCEL

AutoSave . Off EliOrchid_361B_ P (1) (1) - Excel Search Dillon Ly File Home Insert Page Layout Formulas Data View Hel Share Comments From Text/CSV Recent Sources Queries & Connections O + Clear Flash Fill Data Analysis LEEFrom Web 24 72 Consolidate La Existing Connections Properties Data From Table/Range Stocks Currencies Geography Automatic Anatomy Animals Cities Locations Medical Movies Foods 21 Sort Filter Reapply Text to Ex Remove Duplicates Relationships What-If Forecast ?, Solver Group Ungroup Subtotal All ~ , Edit Links Advanced Columns E Data Validation Manage Data Model Analysis ~ Sheet Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analyze H5 X V A B D E G H K M N o P Q R S T U V w X Y Z AA AB AC AD AE AF AG AH Al AJ AK AL AM Day Date Weekday Daily Demand Weekend 2 1 4/25/2016 Mon 297 0 2 4/26/2016 Tue 293 3 4/27/2016 Wed 327 4 4/28/2016 Thu 315 6 5 4/29/2016 Fri 348 6 4/30/2016 Sat 447 8 7 5/1/2016 Sun 431 9 8 5/2/2016 Mon 283 10 9 5/3/2016 Tue 326 11 10 5/4/2016 Wed 317 12 11 5/5/2016 Thu 345 13 12 5/6/2016 Fri 355 14 13 5/7/2016 Sat 428 15 14 5/8/2016 Sun 454 16 15 5/9/2016 Mon 305 17 16 5/10/2016 Tue 310 18 17 5/11/2016 Wed 350 19 18 5/12/2016 Thu 308 20 19 5/13/2016 Fri 366 21 20 5/14/2016 Sat 460 22 21 5/15/2016 Sun 427 23 22 5/16/2016 Mon 291 23 5/17/2016 Tue 325 25 24 5/18/2016 Wed 354 OC 26 25 5/19/2016 Thu 322 26 5/20/2016 Fri 405 28 27 5/21/2016 Sat 442 28 5/22/2016 Sun 454 29 5/23/2016 Mon 318 31 30 5/24/2016 Tue 298 loc 32 31 5/25/2016 Wed 355 o 32 5/26/2016 Thu 355 34 33 5/27/2016 Fri 374 OC 35 34 5/28/2016 Sat 447 36 35 5/29/2016 Sun 463 37 36 5/30/2016 Mon 291 o 38 37 5/31/2016 Tue 319 39 38 6/1/2016 Wed 333 40 39 6/2/2016 Thu 339 O 40 6/3/2016 Fri 416 41 6/4/2016 Sat 475 43 42 6/5/2016 Sun 459 44 43 6/6/2016 Mon 319 45 44 6/7/2016 Tue 326 46 45 6/8/2016 Wed 356 47 46 6/9/2016 Thu 340 48 47 6/10/2016 Fri 395 49 48 6/11/2016 Sat 465 50 49 6/12/2016 Sun 453 50 6/13/2016 Mor 307 52 51 6/14/2016 Tue 324 Demand Sheet1 Sheet3 Edit 360 X W OAutoSave . Of EliOrchid_361B_ P (1) (1) - Excel Search Dillon Ly File Home Insert Page Layout Formulas Data View Hel Share Comments From Text/CSV Lo Recent Source Queries & Connections O + 24 72 Clear Flash Fill Consolidate LEE From Web Data Analysis La Existing Connections Properties Data From Table/Range All ~ , Edit Links Stocks Currencies Geography Automatic Anatomy Animals Cities Reapply Ex Remove Duplicates Relationships ?, Solver Locations Medical Movies Foods 21 Sort Filter Text to What-If Forecast Group Ungroup Subtotal Advanced Columns E Data Validation Manage Data Model Analysis ~ Sheet Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analyze H5 X V A B D E G H K M N o P Q R S T U V w X Y Z AA AB AC AD AE AF AG AH Al AJ AK AL AM 10 9 5/3/2016 Tue 326 0 11 10 5/4/2016 Wed 317 0 12 11 5/5/2016 Thu 345 o 13 12 5/6/2016 Fri 355 OC 14 13 5/7/2016 Sat 428 15 14 5/8/2016 Sun 454 16 15 5/9/2016 Mon 305 OH 17 16 5/10/2016 Tue 310 18 17 5/11/2016 Wed 350 19 18 5/12/2016 Thu 308 20 19 5/13/2016 Fri 366 21 20 5/14/2016 Sat 460 22 21 5/15/2016 Sun 427 23 22 5/16/2016 Mon 291 DO 23 5/17/2016 Tue 325 25 24 5/18/2016 Wed 354 OC 26 25 5/19/2016 Thu 322 26 5/20/2016 Fri 405 28 27 5/21/2016 Sat 442 28 5/22/2016 Sun 454 29 5/23/2016 Mon 318 31 30 5/24/2016 Tue 298 loc 32 31 5/25/2016 Wed 355 o 32 5/26/2016 Thu 355 34 33 5/27/2016 Fri 374 OC 35 34 5/28/2016 Sat 447 36 35 5/29/2016 Sun 463 37 36 5/30/2016 Mon 291 38 37 5/31/2016 Tue 319 39 38 6/1/2016 Wed 333 40 39 6/2/2016 Thu 339 40 6/3/2016 Fri 416 41 6/4/2016 Sat 475 43 42 6/5/2016 Sun 459 44 43 6/6/2016 Mon 319 45 44 6/7/2016 Tue 326 46 45 6/8/2016 Wed 356 47 46 6/9/2016 Thu 340 48 47 6/10/2016 Fri 395 49 48 6/11/2016 Sat 465 50 49 6/12/2016 Sun 453 50 6/13/2016 Mon 307 52 51 6/14/2016 Tue 324 53 52 6/15/2016 Wed 350 o 53 6/16/2016 Thu 348 55 54 6/17/2016 Fri 384 OC 56 55 6/18/2016 Sat 474 57 56 6/19/2016 Sun 485 58 59 60 Demand Sheet1 | Sheet3| Edit 360 X W OAutoSave . Of EliOrchid_361B_P for BABA - Word 9 Search Dillon Ly X File Home Insert Design Layout References Mailings Review View Help Share Comments Calibri (Body) 11 ~ A A Aa A EF EE 21 1 Find LOCopy AaBbCCDc AaBbCCD