Answer must be in VBA code

B D E F G 1 Antonio's Italian Restaurant Factor Rating Location Analysis 2 3 4 PARAMETERS 5 Factor Scores (1-5 scale) 6 7 Location 1 5 Location 2 Location 3 3 2 4 2 8 9 10 11 4 Factor Weight 20 10 20 15 2 3 Factor Appearance Ease of expansion Proximity to market Customer parking Access Competition Labor supply 5 5 3 3 12 5 2 3 15 2 4 5 10 13 14 3 3 4 10 15 16 OUTPUT 17 Location Location Location 1 18 Weighted Factor Score 305 340 19 20 Best Total Score 380 Best Location Location 1 21 22 23 24 25 26 27 28 a. a 2. (10 points) Download the "Antonio's Italian Restaurant spreadsheet from Canvas. Create a Data Table that shows what happens to the Location 3 Weighted Factor Score as the Factor Weight for Proximity to market varies from 10 to 40, incrementing by 2 at a time. b. Create a second Data Table that indicates the Best Location (from cell C21) as the Factor Weight for Proximity to market varies from 10 to 40, incrementing by 2 at a time. You should see the winning location change at some point