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. 3.(10 points) Download the "Antonio's Italian Restaurant" spreadsheet from Canvas. a. 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.A B C D E F G H Antonio's Italian Restaurant Factor Rating Location Analysis PARAMETERS Factor Scores (1-5 scale)1234567891011121314 Factor Appearance Ease of expansion Proximity to market Customer parking Access Competition Labor supply Location 1 Location 2 Location 3532442235533523245334 Factor Weight 20102015151010 C18: =SUMPRODUCT(C8:C14,$F8:$F14)1516 OUTPUT 171819 Location 1 Location 2 Location 3380305340------------ Weighted Factor Score C20: =MAX(C18:E18) Best Total Score||380 Best Location Location 1 C21: = INDEX(C7:E7, MATCH(C20, C18:E18,0))20212223242526

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!