Question: The Bakers Dozen Restaurant is considering opening a new location. It has considered many factors and identified the ones that are most important. Two locations are being evaluated based on these factors, using factor rating. Each location has been evaluated relative to the factors on a 5-point scale. These numbers are shown here. Use factor rating to help the restaurant decide on the better location.

a. Calculate the total weighted score for Location 1 by hand.

b. Create an excel spreadsheet to calculate the total weighted score for both locations. Submit two printouts of your spreadsheet. The first printout should show your solution, and the second should display the formulas, gridlines, and the row and column headings.

c. Recommend which location should be chosen based on these total weighted scores.