servioe, sanitation, and manspernemt. She wants to devilop a sales per labor hour atanilard for cach of her labor cateporiea. She believes this wil help Mer develop foture labor bodgets based on forecavted sales. Help Jenfifer calculate this standard kased oe her current usage of lahe hane. c. Now that Jennifer has calculated her probuctivity standards, stie woold like to ase them fo develop a labor hoiar buifet foc each day beat week. Ste bas forecasted 8,000 goests, and she wasts to use the gaests served per labor hour standard that was calculated in part x. Use this information to develop a labor hours budget foe Jennifer. 4. Jennifer operates Joe Bob's Bar-B-Q Restaurant. She specializes in beef brisket and blackberry cobbler. Her operation is very popular. The following dati is taken from her last month's operation. She would like to establish labor standards for the entire year based on last month's figures becases she believes that a month represents a good level of both customer service and profitability for her operation. Jenaifer bas an average guest check of $12 and an overall average payroll cost of $8 per hour. a. Use Jennifer's last month's operating results to calculate the following productivity standards; labor cost percentage, sales per labor bour, labor dollars per guest served, gaests served per Labor dollar, and guests served per labor bour, (Spreadsheet hine Use the ROUND function to two decimal places for "Gests Served per Labor Hour" because you will use it in part e.) Calculate: a. Use Jennifer's last month's operating results to calculate the following productivity standards: labor cost percentage, sales per labor hour, labor dollars per guest served, guests served per labor dollar, and guests served per labor hour. (Use the ROUND function to two decimal places for "Guests Served per Labor Hour" because you will use it in part c.) b. Jennifer has subdivided her employees into the following categories: meat production, bakery production, salad production, service, sanitation, and management. She wants to develop a sales per labor hour standard for each of her labor categories. She believes this will help her develop future labor budgets based on forecasted sales. Help Jennifer calculate this standard based on her current usage of labor hours. c. Now that Jennifer has calculated her productivity standards, she would like to use them to develop a labor hours budget for each day next week. She has forecasted 8,000 guests, and she wants to use the guests served per labor hour standard that was calculated in part a. Use this information to develop a labor hours budaet for Jennifer