Mario Armando Perez is the kitchen manager at the Asahi Sushi House. Mario’s restaurant offers five popular types of sushi roll. Mario keeps careful records of the number of each roll type sold, from which he computes each item’s popularity index. For March 1, Mario estimates 150 guests will be served. Based on his experience, and to ensure he does not run out of any item, Mario would like to have extra servings (planned overage) of selected menu items available for sale. Using planned overage, the popularity index of his menu items, and his prior day’s carryover information, help Mario determine the amount of new production needed and the total available for the day. At the end of the day, Mario also records his actual number sold in order to calculate his carryover amount for the next day. Using all of the information given, help Mario complete his kitchen production schedule for March 1. With formulas.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
100%

Mario Armando Perez is the kitchen manager at the Asahi Sushi House. Mario’s restaurant offers five popular types of sushi roll. Mario keeps careful records of the number of each roll type sold, from which he computes each item’s popularity index. For March 1, Mario estimates 150 guests will be served. Based on his experience, and to ensure he does not run out of any item, Mario would like to have extra servings (planned overage) of selected menu items available for sale. Using planned overage, the popularity index of his menu items, and his prior day’s carryover information, help Mario determine the amount of new production needed and the total available for the day. At the end of the day, Mario also records his actual number sold in order to calculate his carryover amount for the next day. Using all of the information given, help Mario complete his kitchen production schedule for March 1. With formulas.   

Mario's Kitchen Production Schedule: March 1
Menu Item
Spicy Tuna Roll
Salmon Special Roll
Spicy Shrimp Roll
California Roll
BBQ Eel Roll
Total to Serve
Popularity Sales
Index
34%
10%
30%
20%
6%
100%
Forecast
150
Planned
Overage
5
5
5
5
0
20
Prior Day
Carryover
6
2
5
2
0
New
Production
Total
Available
Number
Sold
52
12
50
30
5
Carryover
Transcribed Image Text:Mario's Kitchen Production Schedule: March 1 Menu Item Spicy Tuna Roll Salmon Special Roll Spicy Shrimp Roll California Roll BBQ Eel Roll Total to Serve Popularity Sales Index 34% 10% 30% 20% 6% 100% Forecast 150 Planned Overage 5 5 5 5 0 20 Prior Day Carryover 6 2 5 2 0 New Production Total Available Number Sold 52 12 50 30 5 Carryover
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.