Joss is a small, 58-seat restaurant that offers a reasonably broad range of Mexican food prepared and presented in a traditional Mexican style. It is located in New England in a mature business district on the edge of a large metropolitan area. The site is adjacent to a central artery and offers limited free off-street parking. The restaurants interior decoration promotes the Mexican theme: The walls appear to be made of adobe and are draped with serapes, the furniture is SpanishMexican style, and flamenco guitar and mariachi alternate as background music.

Patrons enter the restaurant through a small vestibule that opens directly into the dining area; there is no separate waiting area. Upon arrival, patrons are greeted by a host and either seated directly or apprised of the expected wait. Seating at Joss is usually immediate except for Friday and Saturday nights, when waits of as long as 45 minutes can be encountered. Because space inside for waiting is very limited, patrons must remain outside until their party is called. Joss does not take reservations.

After seating patrons, the host distributes menus and fills glasses with water. If standards are being met, the server assigned to the table greets the patrons within 1 minute of their being seated. The server introduces himself or herself, announces the daily specials, and takes the beverage orders. After delivering the bev

Visual Benchmark Demonstrate Your Proficiency USE LOOKUP, STATISTICAL, AND MATH FUNCTIONS IN A BILLING SUMMARY 1. Open BillHrsOct5to9.xlsx. 2. Save the workbook and name it EL2-C2-VB1-Bill HrsOct5to9. 3. Review the worksheet shown in Figure 2.8. The gray shaded cells require formulas to complete the worksheet. Use the following information to create the required formulas. Create range names to use in all of the formulas so that the reader can easily interpret the formula: In column F. create a formula to look up the attorney's hourly rate from the table located at the bottom right of the worksheet. In column G, calculate the legal fees billed by multiplying the billable hours times the hourly rate. . In J6:19, calculate the total legal fees billed by attorney. In J13:J16, calculate the average hours billed by attorney. 4. Save, print, and then close EL2-C2-VB1-Bill HrsOct5to9.xlsx Figure 2.8 Visual Benchmark 1 File Client 5 FL-325 6 EP-652 Total 7 CL-413 10125 8 IN-745 10310 EL-63 10225 20 RE 475 10985 11 CL-90! 10341 12 CL-521 30334 13 PL-348 10450 14 RE-493 10429 15 EL 632 10225 16 PL-512 10290 IN245 3030 18 FL-38530375 19 CL-412 10125 20 CL-45010358 IN-BO: 10346 EP-68510495 23 RE-30310984 Date 10/5/2015 30/5/2015 10/5/2015 10/6/2015 10.6.2015 10/6/2015 30/7/2015 3072015 30/7/2015 307.2015 10/8/2015 10/8 2015 308305 10/8/2005 10/9/2005 10/2015 10/9/2015 10/9/2015 10/02055 D O'DONOVAN & SULLIVAN LAW ASSOCIATES BILLING SUMMARY OCTOBER 5 TO 9, 2015 Attorney Code Billable Hous Hourly Rate Legal Fees Billing Statistics 1 36.5 85.00 227373 Total Legal Fees Billed by Attorney 1 12:10 8500 105.50 1 Marty O Donovan $5.34.25 2 3325 7500 2.493.75 2 Toni Sullivan $ 8,062.50 3 24-25 300.00 225.00 3 Rosa Martinez $15.906.00 3 100.00 D. 4 Kyle Williams 57.067.50 4 42.30 100.00 3.80700 TOTAL $35.798.25 : 15.25 5.00 15525 2 20.25 75.00 1518.75 Average Sillable Hours by Attorney 3 25 00 300.00 2.500.00 2 Marty O Donovan 20.05 4 2270 90.00 2.043.00 Toni Sullivan 21.30 3 23.00 200.00 2.300.00 3 Rosa Martinez 10-13 3 100.00 1620.00 + Kyle Williams 26.25 3 14.50 100.00 1.450.00 1 14.00 85.00 2.040.00 Attorney Code Table 2 1525 75.00 2.34375 Code Attorney Hourly Rate 2 23.30 75.00 1.76.50 1 Marty O Donovan 35.00 3 135 300.00 1455.00 2 Toni Sullivan 75.00 3 2375 200.00 2-375.00 3 Roy Martinez 100.00 4 33.33 00.00 123750 . Kyle Williams 00.00 16.30 Chapter 2 Advanced Functions and Formulas 67 B E Industry averag 2017 2015 65.26% 20.65% 50.20% 20.63% 14.40% 5.76% 5.79% 23.04% 22.81% $1.80 st 1.30 1.20 A 1 1. Using Microsoft financial data, calculate the following financial ratios 2 3 Microsoft 4 2017 2016 5 Profitability ratios 6 Gross profit margin 62.22% 60.59% 7 Operating profit margin 25.15% 22.52% 8 Net profit margin 9 ROA (typical) 10 ROA (accounting) 11 ROE (typical) 12 ROE (accounting) 13 Diluted EPS 14 Liquidity ratios 15 Current ratio 16 Quick ratio 17 Activity ratios 18 Asset turnover (typical) 19 Asset turnover (accounting) 20 Inventory turnover (typical) 21 Inventory turnover (accounting) 22 Average days of inventory (typical) 23 Average days of inventory (accounting) 24 Average collection period 25 Average payment period (approach 2) 26 Solvency/debt-management ratios 27 Debt to assets ratio 28 Debt to equity ratio 29 Financial leverage multiplier (FLM) 3.33 2.69 30 Market ratios 31 Market to book ratio 32 PE ratio (use diluted EPS) inc statement balance sheet cash flow statement 0.40 0.42 14.50 14.30 25.17 25.52 80.00 85.00 75% 200% 4.00 2.18 4.38 12.96 valuation data financial ratic Visual Benchmark Demonstrate Your Proficiency USE LOOKUP, STATISTICAL, AND MATH FUNCTIONS IN A BILLING SUMMARY 1. Open BillHrsOct5to9.xlsx. 2. Save the workbook and name it EL2-C2-VB1-Bill HrsOct5to9. 3. Review the worksheet shown in Figure 2.8. The gray shaded cells require formulas to complete the worksheet. Use the following information to create the required formulas. Create range names to use in all of the formulas so that the reader can easily interpret the formula: In column F. create a formula to look up the attorney's hourly rate from the table located at the bottom right of the worksheet. In column G, calculate the legal fees billed by multiplying the billable hours times the hourly rate. . In J6:19, calculate the total legal fees billed by attorney. In J13:J16, calculate the average hours billed by attorney. 4. Save, print, and then close EL2-C2-VB1-Bill HrsOct5to9.xlsx Figure 2.8 Visual Benchmark 1 File Client 5 FL-325 6 EP-652 Total 7 CL-413 10125 8 IN-745 10310 EL-63 10225 20 RE 475 10985 11 CL-90! 10341 12 CL-521 30334 13 PL-348 10450 14 RE-493 10429 15 EL 632 10225 16 PL-512 10290 IN245 3030 18 FL-38530375 19 CL-412 10125 20 CL-45010358 IN-BO: 10346 EP-68510495 23 RE-30310984 Date 10/5/2015 30/5/2015 10/5/2015 10/6/2015 10.6.2015 10/6/2015 30/7/2015 3072015 30/7/2015 307.2015 10/8/2015 10/8 2015 308305 10/8/2005 10/9/2005 10/2015 10/9/2015 10/9/2015 10/02055 D O'DONOVAN & SULLIVAN LAW ASSOCIATES BILLING SUMMARY OCTOBER 5 TO 9, 2015 Attorney Code Billable Hous Hourly Rate Legal Fees Billing Statistics 1 36.5 85.00 227373 Total Legal Fees Billed by Attorney 1 12:10 8500 105.50 1 Marty O Donovan $5.34.25 2 3325 7500 2.493.75 2 Toni Sullivan $ 8,062.50 3 24-25 300.00 225.00 3 Rosa Martinez $15.906.00 3 100.00 D. 4 Kyle Williams 57.067.50 4 42.30 100.00 3.80700 TOTAL $35.798.25 : 15.25 5.00 15525 2 20.25 75.00 1518.75 Average Sillable Hours by Attorney 3 25 00 300.00 2.500.00 2 Marty O Donovan 20.05 4 2270 90.00 2.043.00 Toni Sullivan 21.30 3 23.00 200.00 2.300.00 3 Rosa Martinez 10-13 3 100.00 1620.00 + Kyle Williams 26.25 3 14.50 100.00 1.450.00 1 14.00 85.00 2.040.00 Attorney Code Table 2 1525 75.00 2.34375 Code Attorney Hourly Rate 2 23.30 75.00 1.76.50 1 Marty O Donovan 35.00 3 135 300.00 1455.00 2 Toni Sullivan 75.00 3 2375 200.00 2-375.00 3 Roy Martinez 100.00 4 33.33 00.00 123750 . Kyle Williams 00.00 16.30 Chapter 2 Advanced Functions and Formulas 67 B E Industry averag 2017 2015 65.26% 20.65% 50.20% 20.63% 14.40% 5.76% 5.79% 23.04% 22.81% $1.80 st 1.30 1.20 A 1 1. Using Microsoft financial data, calculate the following financial ratios 2 3 Microsoft 4 2017 2016 5 Profitability ratios 6 Gross profit margin 62.22% 60.59% 7 Operating profit margin 25.15% 22.52% 8 Net profit margin 9 ROA (typical) 10 ROA (accounting) 11 ROE (typical) 12 ROE (accounting) 13 Diluted EPS 14 Liquidity ratios 15 Current ratio 16 Quick ratio 17 Activity ratios 18 Asset turnover (typical) 19 Asset turnover (accounting) 20 Inventory turnover (typical) 21 Inventory turnover (accounting) 22 Average days of inventory (typical) 23 Average days of inventory (accounting) 24 Average collection period 25 Average payment period (approach 2) 26 Solvency/debt-management ratios 27 Debt to assets ratio 28 Debt to equity ratio 29 Financial leverage multiplier (FLM) 3.33 2.69 30 Market ratios 31 Market to book ratio 32 PE ratio (use diluted EPS) inc statement balance sheet cash flow statement 0.40 0.42 14.50 14.30 25.17 25.52 80.00 85.00 75% 200% 4.00 2.18 4.38 12.96 valuation data financial ratic