\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H \\ \hline 1 & \multicolumn{2}{|c|}{ Antonio's Italian Restaurant } & & & & & & \\ \hline 2 & \multicolumn{2}{|c|}{ Factor Rating Location Analysis } & & & & & & \\ \hline 3 & PARAMETERS & & & & & & & \\ \hline 4 & & & \multicolumn{3}{|c|}{ Factor Scores (1-5 scale) } & & & \\ \hline 5 & & & & & & Factor & & \\ \hline 6 & & Factor & Location 1 & Location 2 & Location 3 & Weight & & \\ \hline 7 & & Appearance & 5 & 3 & 2 & 20 & & \\ \hline 8 & & Ease of expansion & 4 & 4 & 2 & 10 & & \\ \hline 9 & & Proximity to market & 2 & 3 & 5 & 20 & & \\ \hline 10 & & Customer parking & 5 & 3 & 3 & 15 & & \\ \hline 11 & & Access & 5 & 2 & 3 & 15 & & \\ \hline 12 & & Competition & 2 & 4 & 5 & 10 & & \\ \hline 13 & & Labor supply & 3 & 3 & 4 & 10 & & \\ \hline 14 & & & & C1 & 20 & CB:C & 14) & \\ \hline 15 & OUTPUT & & & & & & & \\ \hline 16 & & & Location 1 & cation 2 & Location 3 & & & \\ \hline 17 & & Weighted Factor Score & 380 & 305 & 340 & & & \\ \hline 18 & & & & C20:=M & X(C18:E18) & & & \\ \hline 19 & & Best Total Score & 380 & & & & & \\ \hline 20 & & Best Location & Location 1 & & F & & & \\ \hline 21 & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline 1 & \multicolumn{6}{|c|}{ Beta Technologies Emploget Salary Structure } \\ \hline 2 & & & & & & \\ \hline 3 & Gender & Age & 'Trior_Experience' & 'Beta_Experience' & Education' & 'Annual_Salary' \\ \hline 4 & Female & 39 & 5 & 12 & 4 & $38,450 \\ \hline 5 & Male & 44 & 12 & 8 & 6 & $50,912 \\ \hline 6 & Male & 24 & 0 & 2 & 4 & $29,356 \\ \hline 7 & Female & 25 & 2 & 1 & 4 & $27,750 \\ \hline 8 & Male & 56 & 5 & 25 & 8 & $109,285 \\ \hline 9 & Female & 41 & 9 & 10 & 4 & $48,442 \\ \hline 10 & Female & 33 & 6 & 2 & 6 & $40,207 \\ \hline 11 & Male & 37 & 11 & 6 & 4 & $42,331 \\ \hline 12 & Female & 51 & 12 & 16 & 6 & $87,489 \\ \hline 13 & Male & 23 & 0 & 1 & 4 & $26,118 \\ \hline 14 & Male & 31 & 5 & 4 & 6 & $41,956 \\ \hline 15 & Female & 27 & 0 & 8 & 0 & $17,439 \\ \hline 16 & Male & 47 & 11 & 9 & 4 & $49,638 \\ \hline 17 & Female & 35 & 5 & 5 & 6 & $43,184 \\ \hline 18 & Female & 29 & 5 & 4 & 0 & $14,371 \\ \hline 19 & Male & 46 & 4 & 15 & 6 & $54,613 \\ \hline 20 & Female & 50 & 10 & 17 & 4 & $76,927 \\ \hline 21 & Male & 30 & 3 & 6 & 4 & $38,556 \\ \hline 22 & Female & 34 & 10 & 1 & 4 & $37,183 \\ \hline 23 & Female & 42 & 11 & 8 & 4 & $50,712 \\ \hline 24 & Female & 51 & 10 & 15 & 8 & $90,473 \\ \hline 25 & Male & 63 & 16 & 20 & 4 & $93,588 \\ \hline 26 & Male & 28 & 0 & 5 & 4 & $36,901 \\ \hline 27 & Female & 32 & 4 & 1 & 4 & $33,100 \\ \hline 28 & Male & 55 & 11 & 16 & 6 & $89,867 \\ \hline 29 & Female & 45 & 20 & 2 & 4 & $51,259 \\ \hline 30 & Male & 34 & 2 & 12 & 2 & $19,106 \\ \hline 31 & Male & 33 & 2 & 7 & 4 & $39,224 \\ \hline 32 & Female & 23 & 0 & 1 & 4 & $28,743 \\ \hline 33 & Male & 40 & 4 & 13 & 6 & $54,965 \\ \hline 34 & Female & 48 & 6 & 15 & 4 & $53,388 \\ \hline 35 & Female & 27 & 0 & 6 & 0 & $18,014 \\ \hline 36 & Female & 36 & 5 & 5 & 6 & $39,205 \\ \hline 37 & Male & 58 & 9 & 22 & 4 & $88,763 \\ \hline 38 & Male & 31 & 1 & 1 & 6 & $35,829 \\ \hline 39 & Female & 21 & 0 & 1 & 2 & $17,784 \\ \hline 40 & Male & 47 & 5 & 16 & 4 & $54,199 \\ \hline 41 & Female & 35 & 3 & 7 & 4 & $36,932 \\ \hline 42 & Female & 52 & 12 & 14 & 8 & $93,278 \\ \hline 43 & Male & 29 & 3 & 3 & 2 & $22,100 \\ \hline 44 & Female & 42 & 11 & 7 & 4 & $49,987 \\ \hline 45 & Male & 60 & 10 & 21 & 4 & $85,471 \\ \hline 46 & Female & 50 & 8 & 13 & 4 & $51,194 \\ \hline 47 & Female & 33 & 1 & 2 & 6 & $36,109 \\ \hline 48 & Male & 26 & 0 & 5 & 2 & $21,750 \\ \hline 49 & Male & 38 & 6 & 6 & 6 & $39,455 \\ \hline 50 & Female & 44 & 7 & 12 & 4 & $49,861 \\ \hline 51 & Male & 25 & 0 & 3 & 4 & $30,327 \\ \hline 52 & Female & 37 & 8 & 5 & 4 & $31,008 \\ \hline 53 & Male & 53 & 13 & 13 & 6 & $90,874 \\ \hline 54 & Male & 46 & 7 & 18 & 4 & $57,966 \\ \hline 55 & Femal & 20 & a & & & 515945 \\ \hline \end{tabular} 1. (10 points) Download the "Fast Feet Shoes" spreadsheet from Canvas. Using the "Scenario Manager," create three scenarios of your own that each vary the three parameters (unit price, fixed cost, and variable cost) in some way. Present the results in a Scenario Summary sheet. 2. (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. 3. ( 5 points) Take a clean (different) version of "Antonio's Italian Restaurant," and rename it "Antonio's Restaurant Modified." Add an entry in Cell C22 that identifies the "Worst Location" by using a single formula. 4. (10 points) Download a clean (different) version of the "Fast Feet Shoes" spreadsheet from Canvas. Create a two-variable Data Table that shows what happens to Profit as the Annual Fixed Cost varies from $30,000 to $75,000, incrementing by $3,000 at a time; while Unit Variable Cost varies from $5.00 to $12.00, incrementing by $1.00 at a time. Put your Annual Fixed Cost values down the rows and put your Unit Variable Cost values across the columns. For the next two problems, download the Betaxlsx file from Canvas. 5. ( 5 points) Sort the "Beta" file by education, from most to least. Have the first tiebreaker be Beta experience (highest to lowest) and have the second tiebreaker be annual salary (lowest to highest). 6. (10 points) Place some data filters on the "Beta" file. Specifically, show only those records of employees earning no more than $60,000, having an education level of exactly 4 years, are between 20 and 39 years old (inclusive), and are female. Then show only those with "below average" prior experience. Copy-paste the values from your remaining data set to another sheet so that you can calculate the average salary of this group using a simple "AVERAGE" function. \begin{tabular}{|c|c|c|c|} \hline A & B & C & D \\ \hline \multicolumn{4}{|l|}{ Fast Feet Shoes } \\ \hline \multicolumn{4}{|c|}{ Profit/Loss Analysis } \\ \hline \multicolumn{4}{|l|}{ PARAMETERS } \\ \hline & Unit Sales Price & $25.00 & \\ \hline & Annual Fixed Cost & $52,000 & \\ \hline & Unit Variable Cost & $9.00 & \\ \hline \multicolumn{4}{|l|}{ DECISION } \\ \hline & Quantity & 2,500 & \\ \hline \multicolumn{4}{|l|}{ OUTPUT } \\ \hline & Annual Profit (Loss) & ($12,000) & \\ \hline \multirow[t]{4}{*}{ CALCULATIONS } & & & C16: \\ \hline & Annual Revenue & $62,500 & C17: \\ \hline & Annual Variable Cost & $22,500 & C18: \\ \hline & Annual Total Cost & $74,500 & \\ \hline \end{tabular}