Bookmarks People Tab Window Help ce How to Bu x Microsoft X A1.pdf Free Excex Ask a Que x d An Excel agon/Downloads/A1.pdf labeled "Main", in your Excel submission (e) VBA Code. Please copy and paste your code as an appendix. Here is a good thread on how to neatly copy and paste your code in Microsoft Word. 2. A Macro Enabled excel file labeled A1.xls In this assignment we are are creating an automated system for generating a mini dashboard for the use of the manager in the Production Planning problem, please refer to the file "Production Planning Problem.pdf" for more information about the production planning problem. The data file PPP A1.xlsx includes all the required data for this assignment. This assignment's objective is to create three buttons which generates the following graphs. A line chart of the historical demand. Aline chart of the historical inventory levels. A line chart of the historical production unit along with the demand. Below is an illustration of how the main sheet, and the graph sheet should look like. JEJER DOWS X8ROGO art row Page Layout Formulas Data Review View Developer I This Spreadsheet alows the manager in the Production Planning Problem to see the folloin visualizations of the data. -A line chart of the historical demand. - A line chart of the historical Inventory levels. Aline chart of the historical production cost along with the demand. Please click the ppropriate button to see the corresponding chart. Demand Inventory levels Production VS Demand Figure 1: The main sheet. NSO AXE8 BREAGO I ZEKI Figure 1: The main sheet. Production VS Demand AAAAMM Figure 2: An illustration of one of the graph sheets. WSO AX8*AXO RIJLI ory Bookmarks People Tab Window Help BX How to BX Microsoft X A1.pdf X Free Excex Ask a Quix d Ant mondragon/Downloads/A1.pdf The VBA functions/functionalities that you need to complete this assignment are the follow- ings. How to format cells (or ranges). How to activate a worksheet. How to delete an existing worksheet. How to refer to a chart in a worksheet. Note: The current data file include 51 observations. Once your are done with the above implementation, make sure that your Excel file can handle any number of observations That is, if the data files' observations increase or decrease your Excel file still works and creates the appropriate outputs. DOROWS@X8 IDRO ARRER Abc x V fx sual Macros Record Add-ins Excel Button Group Combo Label Check Scroll List Option Spinner Macro Add-ins Box Box Box Bar Box Button 1 I OB D E F H month production unites production cost holding cost demand production cap 12/1/15 10.79149308 5.293255748 4.104469428 8.57034189 15.6937834 1/1/16 8.104472635 5.136113325 4.980119624 7.97119426 13.7279718 2/1/16 9.970023428 5.2310813 4.27992791 14.3195456 15.6184353 3/1/16 8.732582251 5.456842898 4.711211329 17.1658191 16.9927378 4/1/16 9.14063002 5.70732852 4.293255748 12.7453296 14.1771231 5/1/16 10.52371526 5.627023201 4.979437007 17.6398139 15.0472463 6/1/16 17.62600534 5.890980557 4.18586368 9.00632625 13.0605482 7/1/16 12.84437771 5.199752092 4.924257752 11.9446367 16.5438765 8/1/16 14.75535357 5.653773739 4.94269116 15.4770232 17.7971223 9/1/16 18.05953471 5.859942966 4.136113325 13.2970625 18.270464 10/1/16 16.00199826 5.291738999 4.994513934 14.9629963 17.2358947 11/1/16 15.4515415 5.322436473 4.366868798 14.8812449 19.130892 12/1/16 12.10566767 5.619652748 4.061540391 16.4914506 18.5533937 1/1/17 21.94936663 5.858912342 4.056453011 16 3659564 21 1358894 2/1/17 18.62293848 5.637197744 4.2310813 19.2464993 22.5734163 3/1/17 15.09452191 5.469461564 4.653585555 22.996166 22.7575024 4/1/17 19.90734634 5.402154167 4.087616282 19.2671396 20.431529 5/1/17 19.33752622 5.255293186 456999354 22.7822548 22 6158852 6/1/17 22.14905449 5.568242039 4.158179695 17.1178301 20.9971706 7/1/17 25.49018202 5.277659303 4.456842898 23.1609844 22.8895128 8/1/17 20.79720322 5.743150498 4332639537 25.3431121 21 8519594 9/1/17 16 9851964 5 BRO87207 4320948337 19 OORS96 20 5116375 10/1/17 18.79380394 5.667082301 4.020647519 17.3409672 22.3738204 11/1/17 22.18581747 5.439147951 4.989916503 28.5936455 27.0902013 12/1/17 27.67873029 5.317549826 4.70732852 244991229 549887 1/1/18 23.84482224 5.268974045 4.676425228 19.219515 25.6178267 2/1/18 16.38496589 5.746579155 4.99 R246599 15.7026863 21.8745547 3/1/18 26.21015422 5.65740668 4.619265667 20.4628937 22.6607297 4/1/18 26.92302887 5.444113646 4.455341632220253251 30.5253089 1/18 29 00748964 532109 4.527021201 29 1712496 29.247646 6/1/18 21.52394204 5.512562214 4.59045014 21.873524 25.5048101 33 7/1/18 22.70872943 5.915461597 4.932100276 24.2716109 27.9235404 DATA + Ready 11 1970 DSP AWS X88XQG Add-ins In Group Combo Label Check Scroll Box Box Box Bar List Box Option Spinne Button B54 Macro x V fx G H 23 9/1/17 10/1/17 11/1/17 12/1/17 1/1/18 2/1/18 3/1/18 4/1/18 5/1/18 6/1/18 7/1/18 8/1/18 9/1/18 10/1/18 11/1/18 12/1/18 11/19 2/1/19 3/1/19 4/1/19 5/ 19 6/1/19 7/1/19 8/1/19 9/1/19 43 10/1/19 11/1/19 12/1/19 1/1/20 2/1/20 16.98619-444 18.79380394 22.18581747 28.67873029 23.84482224 16.38496589 26.21015422 26.92302887 29.00748964 21.52394204 22.70872943 25 67818545 28.33116367 32.87713074 24.43394557 23.38535915 28.45615556 33.96673398 30.92648196 2768186371 29.44101928 31.27861481 33.93990457 31.01506562 32.93256197 3370095518 32.66625379 41.58765807 36.54941891 32.00913564 5.348087207 5.667082301 5.439147951 5.317549826 5.268974045 5.746579155 5.65740668 5.444113646 5.321496554 5.512562214 5.915461597 5.98752141 5.714646992 5.606447625 5.443402959 5.303521728 5.245247815 5.300239437 5.185348338 5.719162107 5.200700665 5.865374739 5.617261599 5.833881154 5.3900R3477 5.33138935 5.010577567 5.574624471 5.59916887 5. 6851225 D E F 4.320948337 19.0088596 20.5116376 4.020647519 17 3409672 22.3738204 4.989916503 28.5936455 27.0902013 4.70732852 24.429912 29.5449887 4.675425228 19.219515 25.6178267 4.998246599 15.7028863 21.8745547 4.619265667 20.4628937 22.6607797 4.455341632 22.0253251 30.6253089 4,627023201 29.1732496 29.2476946 4.859045014 21.873524 25.5068101 4.932100276 24.2716109 27.9235404 4.494005513 23.5475349 27.9924672 4.762590153 25.0811224 31.9152712 4.890980557 30.3737748 34.3021612 4.963219275 24.53313 28.2841127 4.765280213 26.9564286 28.555791 4063903429 30.2463962 32.7389651 4.157122027 34 79594) 35.4569521 4.199752092 31.3742537 35.4971967 4.41949179132.1547619 30.4731933 4284186289 29.581267 30 3521591 4.078832706 32 652557 33 1558747 4.288566627 35.7505776 36 8190496 4.653721739 31 2710876 36.7110842 4,387441859 26.4193943 36.1669078 4.74649787232.7567022 29.752525 4,625749707 31.0809722 34.2497448 4.78440699 37.250 1959 4859942966 39.745898139.7622172 4077150041 30 2950313 37.93.19208 DATA Ready IT GOODPOWS XSREDOGO. Bookmarks People Tab Window Help ce How to Bu x Microsoft X A1.pdf Free Excex Ask a Que x d An Excel agon/Downloads/A1.pdf labeled "Main", in your Excel submission (e) VBA Code. Please copy and paste your code as an appendix. Here is a good thread on how to neatly copy and paste your code in Microsoft Word. 2. A Macro Enabled excel file labeled A1.xls In this assignment we are are creating an automated system for generating a mini dashboard for the use of the manager in the Production Planning problem, please refer to the file "Production Planning Problem.pdf" for more information about the production planning problem. The data file PPP A1.xlsx includes all the required data for this assignment. This assignment's objective is to create three buttons which generates the following graphs. A line chart of the historical demand. Aline chart of the historical inventory levels. A line chart of the historical production unit along with the demand. Below is an illustration of how the main sheet, and the graph sheet should look like. JEJER DOWS X8ROGO art row Page Layout Formulas Data Review View Developer I This Spreadsheet alows the manager in the Production Planning Problem to see the folloin visualizations of the data. -A line chart of the historical demand. - A line chart of the historical Inventory levels. Aline chart of the historical production cost along with the demand. Please click the ppropriate button to see the corresponding chart. Demand Inventory levels Production VS Demand Figure 1: The main sheet. NSO AXE8 BREAGO I ZEKI Figure 1: The main sheet. Production VS Demand AAAAMM Figure 2: An illustration of one of the graph sheets. WSO AX8*AXO RIJLI ory Bookmarks People Tab Window Help BX How to BX Microsoft X A1.pdf X Free Excex Ask a Quix d Ant mondragon/Downloads/A1.pdf The VBA functions/functionalities that you need to complete this assignment are the follow- ings. How to format cells (or ranges). How to activate a worksheet. How to delete an existing worksheet. How to refer to a chart in a worksheet. Note: The current data file include 51 observations. Once your are done with the above implementation, make sure that your Excel file can handle any number of observations That is, if the data files' observations increase or decrease your Excel file still works and creates the appropriate outputs. DOROWS@X8 IDRO ARRER Abc x V fx sual Macros Record Add-ins Excel Button Group Combo Label Check Scroll List Option Spinner Macro Add-ins Box Box Box Bar Box Button 1 I OB D E F H month production unites production cost holding cost demand production cap 12/1/15 10.79149308 5.293255748 4.104469428 8.57034189 15.6937834 1/1/16 8.104472635 5.136113325 4.980119624 7.97119426 13.7279718 2/1/16 9.970023428 5.2310813 4.27992791 14.3195456 15.6184353 3/1/16 8.732582251 5.456842898 4.711211329 17.1658191 16.9927378 4/1/16 9.14063002 5.70732852 4.293255748 12.7453296 14.1771231 5/1/16 10.52371526 5.627023201 4.979437007 17.6398139 15.0472463 6/1/16 17.62600534 5.890980557 4.18586368 9.00632625 13.0605482 7/1/16 12.84437771 5.199752092 4.924257752 11.9446367 16.5438765 8/1/16 14.75535357 5.653773739 4.94269116 15.4770232 17.7971223 9/1/16 18.05953471 5.859942966 4.136113325 13.2970625 18.270464 10/1/16 16.00199826 5.291738999 4.994513934 14.9629963 17.2358947 11/1/16 15.4515415 5.322436473 4.366868798 14.8812449 19.130892 12/1/16 12.10566767 5.619652748 4.061540391 16.4914506 18.5533937 1/1/17 21.94936663 5.858912342 4.056453011 16 3659564 21 1358894 2/1/17 18.62293848 5.637197744 4.2310813 19.2464993 22.5734163 3/1/17 15.09452191 5.469461564 4.653585555 22.996166 22.7575024 4/1/17 19.90734634 5.402154167 4.087616282 19.2671396 20.431529 5/1/17 19.33752622 5.255293186 456999354 22.7822548 22 6158852 6/1/17 22.14905449 5.568242039 4.158179695 17.1178301 20.9971706 7/1/17 25.49018202 5.277659303 4.456842898 23.1609844 22.8895128 8/1/17 20.79720322 5.743150498 4332639537 25.3431121 21 8519594 9/1/17 16 9851964 5 BRO87207 4320948337 19 OORS96 20 5116375 10/1/17 18.79380394 5.667082301 4.020647519 17.3409672 22.3738204 11/1/17 22.18581747 5.439147951 4.989916503 28.5936455 27.0902013 12/1/17 27.67873029 5.317549826 4.70732852 244991229 549887 1/1/18 23.84482224 5.268974045 4.676425228 19.219515 25.6178267 2/1/18 16.38496589 5.746579155 4.99 R246599 15.7026863 21.8745547 3/1/18 26.21015422 5.65740668 4.619265667 20.4628937 22.6607297 4/1/18 26.92302887 5.444113646 4.455341632220253251 30.5253089 1/18 29 00748964 532109 4.527021201 29 1712496 29.247646 6/1/18 21.52394204 5.512562214 4.59045014 21.873524 25.5048101 33 7/1/18 22.70872943 5.915461597 4.932100276 24.2716109 27.9235404 DATA + Ready 11 1970 DSP AWS X88XQG Add-ins In Group Combo Label Check Scroll Box Box Box Bar List Box Option Spinne Button B54 Macro x V fx G H 23 9/1/17 10/1/17 11/1/17 12/1/17 1/1/18 2/1/18 3/1/18 4/1/18 5/1/18 6/1/18 7/1/18 8/1/18 9/1/18 10/1/18 11/1/18 12/1/18 11/19 2/1/19 3/1/19 4/1/19 5/ 19 6/1/19 7/1/19 8/1/19 9/1/19 43 10/1/19 11/1/19 12/1/19 1/1/20 2/1/20 16.98619-444 18.79380394 22.18581747 28.67873029 23.84482224 16.38496589 26.21015422 26.92302887 29.00748964 21.52394204 22.70872943 25 67818545 28.33116367 32.87713074 24.43394557 23.38535915 28.45615556 33.96673398 30.92648196 2768186371 29.44101928 31.27861481 33.93990457 31.01506562 32.93256197 3370095518 32.66625379 41.58765807 36.54941891 32.00913564 5.348087207 5.667082301 5.439147951 5.317549826 5.268974045 5.746579155 5.65740668 5.444113646 5.321496554 5.512562214 5.915461597 5.98752141 5.714646992 5.606447625 5.443402959 5.303521728 5.245247815 5.300239437 5.185348338 5.719162107 5.200700665 5.865374739 5.617261599 5.833881154 5.3900R3477 5.33138935 5.010577567 5.574624471 5.59916887 5. 6851225 D E F 4.320948337 19.0088596 20.5116376 4.020647519 17 3409672 22.3738204 4.989916503 28.5936455 27.0902013 4.70732852 24.429912 29.5449887 4.675425228 19.219515 25.6178267 4.998246599 15.7028863 21.8745547 4.619265667 20.4628937 22.6607797 4.455341632 22.0253251 30.6253089 4,627023201 29.1732496 29.2476946 4.859045014 21.873524 25.5068101 4.932100276 24.2716109 27.9235404 4.494005513 23.5475349 27.9924672 4.762590153 25.0811224 31.9152712 4.890980557 30.3737748 34.3021612 4.963219275 24.53313 28.2841127 4.765280213 26.9564286 28.555791 4063903429 30.2463962 32.7389651 4.157122027 34 79594) 35.4569521 4.199752092 31.3742537 35.4971967 4.41949179132.1547619 30.4731933 4284186289 29.581267 30 3521591 4.078832706 32 652557 33 1558747 4.288566627 35.7505776 36 8190496 4.653721739 31 2710876 36.7110842 4,387441859 26.4193943 36.1669078 4.74649787232.7567022 29.752525 4,625749707 31.0809722 34.2497448 4.78440699 37.250 1959 4859942966 39.745898139.7622172 4077150041 30 2950313 37.93.19208 DATA Ready IT GOODPOWS XSREDOGO
