Question: Please put into excel. 3 . ( 1 0 points ) Download the Antonio's Italian Restaurant spreadsheet from Canvas. a . Create a Data Table
Please put into excel. points Download the "Antonio's Italian Restaurant" spreadsheet from Canvas. a Create a Data Table that shows what happens to the Location Weighted Factor Score as the Factor Weight for Proximity to market" varies from to incrementing by at a time. b Create a second Data Table that indicates the Best Location from cell C as the Factor Weight for Proximity to market" varies from to incrementing by at a time. You should see the winning location change at some point.A B C D E F G H Antonio's Italian Restaurant Factor Rating Location Analysis PARAMETERS Factor Scores scale Factor Appearance Ease of expansion Proximity to market Customer parking Access Competition Labor supply Location Location Location Factor Weight C: SUMPRODUCTC:C$F:$F OUTPUT Location Location Location Weighted Factor Score C: MAXC:E Best Total Score Best Location Location C: INDEXC:E MATCHC C:E
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
