SHOW ALL WORKINGS !

Please use excel for all graphs

Attached are pictures of the original graph

But please use the numbers attached here as all the 8s and 2s were changed .

1. Daudi owns and manages a restaurant featuring Middle Eastern cuisine. He tracks his sales on a daily basis and in the past had waited until the end of the week to sum his weekly sales. Last week Daudi's operation achieved these daily sales: Daudi's Daily Sales Record Week Day Sales ($) Monday 1757.75 Tuesday 7157.44 Wednesday 1976.33 Thursday 7154.44 Friday 7677.99 Saturday 3457.73 Sunday 1375.55 After attending a managerial accounting seminar held at the annual meeting of his state restaurant association, Daudi now wants to modify the way he records his sales to create an improved sales history record. Help Daudi begin using the improved sales history record he has created by completing the daily/weektodate sale spreadsheet he has prepared, and then answer the questions that follow. Daudi's Improved Weekly Sales History Week Day Sales / Sales to Date/ % of Weekly Sales Monday Tuesday Wednesday Thursday Friday Saturday Sunday

a .What were Daudi's sales as of Wednesday's closing? b. What were Daudi's sales as of Friday's closing? c.What were Daudi's sales for this week? D.On what night did Daudi achieve the greatest percentage of his weekly sales? E. On what night did Daudi achieve the lowest percentage of his weekly sales? F. Why do you think Daudi decided to add the % of Weekly Sales column to his improved weekly sales history record?

2. I'm telling you the average is about $18.00, said Maya Stafford, the head server at the Mountain Grill. Maya and Raktida were talking about the check average achieved by the Grill on the previous two nights. Look, continued Maya, on Saturday night the check average was about $77.00. People drink on Saturday night. On Sunday, it was about $14.00 because they don't drink as much. $77.00 plus $14.00 is $36.00. $36.00 divided by 2 equals $18.00. Say, didn't you tell me you went to restaurant management school? Didn't you learn anything there?!

Raktida, the new dining room supervisor (and an honor hospitality school graduate), was unconvinced by Maya's logic. While Maya was a great server, Raktida thought she was dead wrongby at least $2.00! To find out who is right, complete the Mountain Grill's sales history record below, and then answer the questions following it. Mountain Grill TwoDay Sales History Sales ($) Guests Served Average Sales Per Guest (Check Average)

Saturday. 770 (guests served ) Sunday. 1450 (sale $) TwoDay Total and (Weighted) Average 7700 (sales) 375(guests served )

A.What were the Grill's total sales on Saturday night? B.What was the Grill's check average on Saturday night? C.How many guests did the Grill serve on Sunday night? D.What was the Grill's check average on Sunday night? E.What was the Grill's twoday check average? F. Who was right, Maya or Raktida? Based on your answer in question (f) above, what was her error in logic as she mentally computed the combined days' check average?

3. Tony Lombardo owns four Pizza New York franchise units located in four different cities. Tony has compiled the yearend sales figures for each operation. He wants to know more about the change in sales achieved by his operations, so he has begun preparing a sales recap sheet. Help Tony complete the sales recap, and then answer the questions that follow. Tony's Pizza New York Units: Sales Recap Unit Location Sales Last Year ($) Sales This Year ($) $ Variance % Variance Allentown 675,470 720,025 Greenville 495,770 511,730 Springfield 711,570 745,770 Raeville 705,230 751,340 Total Which unit achieved the greatest dollar increase in sales? Which unit achieved the greatest percentage increase in sales? Which unit achieved the smallest dollar increase in sales? Which unit achieved the smallest percentage increase in sales? What was the total dollar amount of Tony's increase in sales in all of his units? What was the overall percentage of sales increase Tony achieved in all of his units? 4. Tina Bonina owns and operates the Cancun Amigos Mexican Cantina. Business is good and getting better. In fact, based on her carefully maintained sales histories, Tina predicts her sales will increase in the upcoming first quarter by 6.7%. Complete her firstquarter forecast below, and then answer the questions that are important to Tina. Cancun Amigos Cantina FirstQuarter Sales Forecast Month Sales Last Year ($) % Increase Estimate Increase Amount ($) Sales Forecast ($) January 145,231.00 6.7 February 126,337.00 6.7 March 164,285.00 6.7 FirstQuarter Total 6.7

A.What is Tinas sales forecast for January? B.What is Tinas sales forecast for February? C. What is Tinas sales forecast for March? D. What is the total dollar amount of sales the Cantina has been forecasted to achieve in the first quarter?

5. Sharon Cronin is the manager of the Wok and Egg Roll oriental buffet located in the food court of a shopping mall. Sharon monitors her daily customer counts and has calculated her fourweek customer count average for each day of the week. She has also calculated the percentage change in daily customer counts she has experienced from the prior fourweek period. It is that percentage change she will use to estimate next week's daily customer counts. Help Sharon estimate her customer counts for the upcoming week based on her sales histories and percentage change from her prior operating period, and then answer the questions that will help her better plan for next week's volume. Round your answers to one decimal place. Week Day FourWeek Average % Change from Prior Period Estimated Change in Guest Count Estimated Total Guests Sunday 375 7.00 Monday 410 1.50 Tuesday 475 3.00 Wednesday 575 7.30 Thursday 675 0.50 Friday 750 4.70 Saturday 950 3.70 Week Total Percentage Change in Guest Count %

A. What was the average number of guests Sharon served each week in the past four weeks? B. What would be Sharon's best estimate of the total number of additional guests she will serve next week when compared to her prior fourweek average number of guests served? C. What would be Sharon's best estimate of the total number of guests she will serve next week? D. What will be Sharon's best estimate of percentage change in the number of guests she will serve next week?

6. Mikel Nordsem is the front office manager at the Plaza Hotel. The hotel has 750 rooms and its market consists primarily of business travelers. Mikel has determined to do a better job of forecasting the number of rooms he will sell and occupancy percentage he will have each day. With a better forecast, he reasons that he can have the appropriate number of staff on hand to quickly serve all the guests who arrive. Complete the following forecast, and then answer Mikel's important questions. Date: May 1Day: Wednesday Total rooms available 750 Outoforder rooms 10 Net Availability Stayovers 104 Reservations (Arrivals) 376 Rooms Sold or Reserved Forecasted Adjustments: Noshows 75 Early departures 17 Overstays 15 Total Forecast Sold or Reserved After Adjustments Occupancy Forecast %

A. What is Mikel's net availability for rooms on May 1? B. How many rooms sold or reserved will Mikel have? C. After he makes adjustments for noshows, early departures, and overstays, what will be Mikel's total forecast in rooms? d. Based on his calculations, what is Mikel's occupancy forecast for May 1?

E. Use excel to extrapolate the forecast to 7 days after Wednesday.

7. Sherri Lamar is the manager in charge of room sales at the 700room Bradford Inn. The Inn has five different room types, each with a rack rate that reflects its guests' view of each room type's value. Sherri knows that she cannot upsell guests who stay in her highestrated rooms; however, she feels that there is good potential to impact her hotel's revenue performance via upsells to guests who originally reserved one of the four lowerpriced room types but would actually prefer a higherpriced room.

To improve revenue, Sherri created and implemented a comprehensive upsell training program for her hotel's front desk staff. The program helped the desk staff stress the benefits to arriving guests of each higherpriced room type. At the end of the first week of the program's implementation, Sherri found that her clerks were successful in upselling approximately 1 of every 10 guests arriving at the hotel. A summary of the Inn's guest reservation/actual stay records is displayed here. Complete the revenue summary for Sherri and then, based on her first week's data, provide the answers she needs for the questions that follow. Room Type Rack Rate ($) Nights Reserved Reserved Revenue ($) Actual Night Usage Actual Revenue ($) Superior Parlor Suite 799.99 75 75 Parlor Suite 749.99 100 110 Jr. Parlor Suite 719.99 175 140 Deluxe 159.99 750 775 Standard 109.99 450 400 Total Nights 1000 1000 Total Room Revenue ADR A.What would be the Inn's ADR if all arriving guests had been assigned to their originally reserved rooms? B.What was the ADR actually achieved by the Inn as a result of the upsell program? C.What would be the Inn's room revenue if all arriving guests had been assigned to their originally reserved rooms? D.What was the total room revenue actually achieved by the Inn as a result of the upsell program? E.What was the amount of the increased room revenue that resulted from Sherri's upsell program? F.What was the percent increase (rounded to one decimal place) in room revenue achieved by the Inn as a result of the program? G. Assume that this first week represents the typical week for the upsell program. What would be the hotel's 52week room revenue increase resulting from the upsell program's implementation?

8. Trisha Metzger purchased Casa del Sol, an 85room fullservice hotel on the Pacific coast in Nicaragua, in 20x1. She then felt that she was ahead of her time when she made the purchase and now she is convinced of it. As more tourists discover the San Juan Del Sur area and its lowcost vacation benefits, Trisha's business is booming. Now as she begins fiscal year 20x5, she wants to secure a bank loan to double the size of her property, and she needs to project her sales forward for the next three years to meet the bank's loan submission requirements. Help Trisha predict her sales for each of the coming three fiscal years using trend line analysis. Casa del Sol Sales Data in Millions Fiscal Year Sales in Millions ($) FY 20x1 18.4 FY 20x2 21.4 FY 20x3 22.4 FY 20x4 25.3 FY 20x5 Forecasted FY 20x6 Forecasted FY 20x7 Forecasted

Use excel for all graphs

A.Create a line graph of sales for the Casa del Sol for FY 20x1 through FY 20x4. B.Add a trend line (from 20x5 through 20x7) to Trisha's sales line graph. C. If you were a bank, would you likely give Trisha the loan? Why or why not?

8. Trisha Metzger purchased Casa del Sol, an 85-room full-service hotel on the Pacific coast in Nicaragua, in 20x1. She then felt that she was ahead of her time when she made the purchase and now she is convinced of it As more tourists discover the San Juan Del Sur area and its low-cost vacation benefits, Trisha's business is booming. Now as she begins fiscal year 205, she wants to secure a bank loan to double the size of her property, and she needs to project her sales forward for the next three years to meet the bank's loan submission requirements Help Trisha predict her sales for each of the coming three fiscal years using trend line analysis Casa del Sol Sales Data in Millions a. Create a line graph of sales for the Casa del Sol for FY 201 through FY 204 b Add a trend line (from 205 through 20x7) to Trisha's sales line graph c. If you were a bank, would you likely give Trisha the loan? Why or why not? tars nve unerem toomtypes, eacm wir a rack rate mar telects ies guesis viaw or eadr type's value. Sherri knows that she cannot upsell guests who stay in her highostrated rooms, however, she feels that there is good potential to impact her hoters revenue perlormance via upsells to guests who originally reserved one of the four lower-priced room types but would actually prefer a higher-priced room. To improve revenue, Shern created and implemented a comprehensive upsell training program for her hotel's front desk staff. The program helped the desk staff stress the benefits to arriving guests of each higher-priced room type. At the end of the first week of the program's implementation, Shern found that her clerks were successful in upselling approximately 1 of every 10 guests arriving at the hotel. A summary of the Inn's guest reservation/actual stay records is displayed here. Complete the revenue summary for Sherri and then, based on her first week's data, provide the answers she needs for the questions that follow. 6. Mikel Nordsem is the front ollice manager at the Plaza Hotel. The hotel has 850 rooms and its market consists primanly of business travelers. Miket has deternined to do a better job of forecasting the number of rooms he will sell and occupancy percentage he will have each day With a belter forecast, he reasons that he can have the appropriate number of staff on hand to quickly serve all the guests who arrive. Complete the following forecast, and then answer Mikel's important questions 5. Sharon Cronin is the manager of the Wok and Egg Roll oriental bulfet located in the food court of a shopping mall. Sharon monitors her daily customer counts and has calculated her four-week customer count average for each day of the week. She has also calculated the percentage change in daily customer counts she has experienced from the prior four-week period. It is that percentage change she will use to estimate next week's daily customer counts Help Sharon estimate her customer counts for the upcoming week based on her sales histories and percentage change from her prior operating period, and then answer the questions that will help her better plan for next week's volume Percentage Change in Guest Count a. What was the average number of guests Sharon served each week in the past four weeks? b. What would be Sharon's best estimate of the total number of additionar guests she will serve next week when compared to her prior four-week average number of guests served? F. What whuld ho Shamon's hoct octimato af tho fofal numher of ailocte cho will canus novt e. What was the total dollar amount of Tony's increase in sales in all of his units? f. What was the overal percentage of sales increase Tony achieved in all of his units? 4. Tina Bonina owns and operales the Cancun Amigos Mexican Cantina. Business is good and getting better, In fact, based on her carefully maintained sales histories, Tina predicts her sales will increase in the upcoming first quarter by 6.2%. Complete her first-quarter forecast below, and then answer the questions that are important to Tina Cancun Amigos Cantina First Quarter Sales Forecast a. What is Tina's sales forecast for January? b. What is Tina's sales forecast for February? c. What is Tina's sales forecast for March? d. What is the total dollar amount of sales the Cantina has been forecasted to achieve in the first quarter? 5. Sharon Cronin is the manager of the "Wok and Egg Roil oriental buffet located in the food court of a shopping mall: Sharon monitors her daily customer counts and has caiculated her four-week customer count average for each day of the week. She has also calculated the d. What was the Gilis check average on Sunday night? e. What was the Grilis two-day check average? f. Who was right, Maya or Raktida? 9. Based on your answer in question ( ) above, what was her error in logic as she mentally computed the combined days' check average? 3. Tony Lombardo owns four "Pizza New York" franchise units located in four different cities. Tony has compiled the year-end sales figures for each operation. He wants to know more about the change in sales achieved by his operations, so he has begun preparing a sales recap sheot. Help Tony complete the sales recap, and then answer the questions that follow Tony's Pizza New York Units: Sales Recap didn't you tell me you went to restaurant management school? Didrit you leam anylhing there? Raktida, the new dining room supervisor (and an honor hospitality school graduate), was unconvinced by Maya's logic. While Maya was a great server, Raktida thought she was dead wrong by at least $2.001 To find out who is nght, complefe the Mountain Grill's sales history record below, and then answer the questions following it. Mountain Grill Two Day Sales History a. What were the Gril's total sales on Saturday night? b. What was the Gril's check average on Saturday night? c. How many guests did the Grill serve on Sunday night? d. What was the Grill's check average on Sunday night? e. What was the Grill's two-day check average? f. Who was night, Maya or Raktida? g Based on your answer in question (f) above, what was her error in logic as she mentaly computed the combined days' check average? After attending a managerial accounting seminar held at the annual meeting of his state restaurant association, Daudi now wants to modify the way he records his sales to create an improved sales history record. Help Daudi begin using the improved sales history record he has created by completing the daily'week to-date sale spreadsheet he has prepared, and then answer the questions that follow Daudi's Improved Weekly Sales History a. What were Daudi's sales as of Wednesday's closing? b. What were Daudi's sales as of Friday's closing? c. What were Daudi's sales for this week? d. On what night did Daudi achieve the greatest percentage of his weekly sales? e. On what night did Daudi achieve the lowest percentage of his weekly sales? f. Why do you think Daudi decided to add the \% of Weekly Sales column to his improved weekly sales history record? Test Your Skills 1. Daudi owns and manages a restaurant featuring Middle Eastem cuisine. He tracks his sales on a daily basis and in the past had wailed until the end of the week to sum his weekty sales Last week Daudi's operation achieved these daily sales: Daudi's Daily Sales Record Atter attending a managerial accounting seminar held at the annual meeting of his state restaurant association. Daudi now wants to modify the way he records his sales to create an improved sales history record Help Daudi begin using the improved sales history record he has created by completing the daily week-to-date sale spreadsheet he has prepared and then. answer the questions that follow Daudi's Improved Weekly Sales History 8. Trisha Metzger purchased Casa del Sol, an 85-room full-service hotel on the Pacific coast in Nicaragua, in 20x1. She then felt that she was ahead of her time when she made the purchase and now she is convinced of it As more tourists discover the San Juan Del Sur area and its low-cost vacation benefits, Trisha's business is booming. Now as she begins fiscal year 205, she wants to secure a bank loan to double the size of her property, and she needs to project her sales forward for the next three years to meet the bank's loan submission requirements Help Trisha predict her sales for each of the coming three fiscal years using trend line analysis Casa del Sol Sales Data in Millions a. Create a line graph of sales for the Casa del Sol for FY 201 through FY 204 b Add a trend line (from 205 through 20x7) to Trisha's sales line graph c. If you were a bank, would you likely give Trisha the loan? Why or why not? tars nve unerem toomtypes, eacm wir a rack rate mar telects ies guesis viaw or eadr type's value. Sherri knows that she cannot upsell guests who stay in her highostrated rooms, however, she feels that there is good potential to impact her hoters revenue perlormance via upsells to guests who originally reserved one of the four lower-priced room types but would actually prefer a higher-priced room. To improve revenue, Shern created and implemented a comprehensive upsell training program for her hotel's front desk staff. The program helped the desk staff stress the benefits to arriving guests of each higher-priced room type. At the end of the first week of the program's implementation, Shern found that her clerks were successful in upselling approximately 1 of every 10 guests arriving at the hotel. A summary of the Inn's guest reservation/actual stay records is displayed here. Complete the revenue summary for Sherri and then, based on her first week's data, provide the answers she needs for the questions that follow. 6. Mikel Nordsem is the front ollice manager at the Plaza Hotel. The hotel has 850 rooms and its market consists primanly of business travelers. Miket has deternined to do a better job of forecasting the number of rooms he will sell and occupancy percentage he will have each day With a belter forecast, he reasons that he can have the appropriate number of staff on hand to quickly serve all the guests who arrive. Complete the following forecast, and then answer Mikel's important questions 5. Sharon Cronin is the manager of the Wok and Egg Roll oriental bulfet located in the food court of a shopping mall. Sharon monitors her daily customer counts and has calculated her four-week customer count average for each day of the week. She has also calculated the percentage change in daily customer counts she has experienced from the prior four-week period. It is that percentage change she will use to estimate next week's daily customer counts Help Sharon estimate her customer counts for the upcoming week based on her sales histories and percentage change from her prior operating period, and then answer the questions that will help her better plan for next week's volume Percentage Change in Guest Count a. What was the average number of guests Sharon served each week in the past four weeks? b. What would be Sharon's best estimate of the total number of additionar guests she will serve next week when compared to her prior four-week average number of guests served? F. What whuld ho Shamon's hoct octimato af tho fofal numher of ailocte cho will canus novt e. What was the total dollar amount of Tony's increase in sales in all of his units? f. What was the overal percentage of sales increase Tony achieved in all of his units? 4. Tina Bonina owns and operales the Cancun Amigos Mexican Cantina. Business is good and getting better, In fact, based on her carefully maintained sales histories, Tina predicts her sales will increase in the upcoming first quarter by 6.2%. Complete her first-quarter forecast below, and then answer the questions that are important to Tina Cancun Amigos Cantina First Quarter Sales Forecast a. What is Tina's sales forecast for January? b. What is Tina's sales forecast for February? c. What is Tina's sales forecast for March? d. What is the total dollar amount of sales the Cantina has been forecasted to achieve in the first quarter? 5. Sharon Cronin is the manager of the "Wok and Egg Roil oriental buffet located in the food court of a shopping mall: Sharon monitors her daily customer counts and has caiculated her four-week customer count average for each day of the week. She has also calculated the d. What was the Gilis check average on Sunday night? e. What was the Grilis two-day check average? f. Who was right, Maya or Raktida? 9. Based on your answer in question ( ) above, what was her error in logic as she mentally computed the combined days' check average? 3. Tony Lombardo owns four "Pizza New York" franchise units located in four different cities. Tony has compiled the year-end sales figures for each operation. He wants to know more about the change in sales achieved by his operations, so he has begun preparing a sales recap sheot. Help Tony complete the sales recap, and then answer the questions that follow Tony's Pizza New York Units: Sales Recap didn't you tell me you went to restaurant management school? Didrit you leam anylhing there? Raktida, the new dining room supervisor (and an honor hospitality school graduate), was unconvinced by Maya's logic. While Maya was a great server, Raktida thought she was dead wrong by at least $2.001 To find out who is nght, complefe the Mountain Grill's sales history record below, and then answer the questions following it. Mountain Grill Two Day Sales History a. What were the Gril's total sales on Saturday night? b. What was the Gril's check average on Saturday night? c. How many guests did the Grill serve on Sunday night? d. What was the Grill's check average on Sunday night? e. What was the Grill's two-day check average? f. Who was night, Maya or Raktida? g Based on your answer in question (f) above, what was her error in logic as she mentaly computed the combined days' check average? After attending a managerial accounting seminar held at the annual meeting of his state restaurant association, Daudi now wants to modify the way he records his sales to create an improved sales history record. Help Daudi begin using the improved sales history record he has created by completing the daily'week to-date sale spreadsheet he has prepared, and then answer the questions that follow Daudi's Improved Weekly Sales History a. What were Daudi's sales as of Wednesday's closing? b. What were Daudi's sales as of Friday's closing? c. What were Daudi's sales for this week? d. On what night did Daudi achieve the greatest percentage of his weekly sales? e. On what night did Daudi achieve the lowest percentage of his weekly sales? f. Why do you think Daudi decided to add the \% of Weekly Sales column to his improved weekly sales history record? Test Your Skills 1. Daudi owns and manages a restaurant featuring Middle Eastem cuisine. He tracks his sales on a daily basis and in the past had wailed until the end of the week to sum his weekty sales Last week Daudi's operation achieved these daily sales: Daudi's Daily Sales Record Atter attending a managerial accounting seminar held at the annual meeting of his state restaurant association. Daudi now wants to modify the way he records his sales to create an improved sales history record Help Daudi begin using the improved sales history record he has created by completing the daily week-to-date sale spreadsheet he has prepared and then. answer the questions that follow Daudi's Improved Weekly Sales History