Fizzy & Crispy Co. The beverage and snacks company “Fizzy & Crispyâ" is one of the largest juices, drinks, and snacks producers in Norway. Their products are famous over all Europe. They are mainly known for their soft drinks and salty chips. Their oldest factory is now due for renewal because of quality control issues. Your team has been hired to help in the overhaul by assessing the conditions in the factory, and to work also as a consultant for their operations of that same factory. The team faced a difficult challenge and asked you, the Industrial Engineer, to help them out with it. The Challenge: The company is celebrating the 300* national day of Norway and wants to include monetary prizes inside the potato chips bags sold at the oldest branch of a famous Norwegian supermarket. The bags will have a unique new design that celebrates the occasion. Any bag sold, regardless of whether it contain a prize or not, is immediately replaced with another one on the shelf so that the number of potato chips bags on display is always the same. The chips aisle is maintained so that at any time, 3 bags have a prize inside them. Each of those bags will have a check with a prize money of 10,000 euros inside it. What is the number of bags the company should make available on display for sale at a time to ensure that 40% of the time, the first bag with the prize is at least the 5000* bag sold?

Algebra: Structure And Method, Book 1
(REV)00th Edition
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Chapter2: Working With Real Numbers
Section2.3: Rules For Addition
Problem 8P
icon
Related questions
Question

for this question, im stuck in the excel part where i need to make an MS excel solution for it. i have done the normal calculation in a word file but i need the excel solution of it. note: use of megastat isnt allowed as per the question requirements.

Fizzy & Crispy Co.
The beverage and snacks company “Fizzy & Crispyâ" is
one of the largest juices, drinks, and snacks producers in
Norway. Their products are famous over all Europe. They are
mainly known for their soft drinks and salty chips. Their oldest
factory is now due for renewal because of quality control issues.
Your team has been hired to help in the overhaul by assessing
the conditions in the factory, and to work also as a consultant for
their operations of that same factory. The team faced a difficult
challenge and asked you, the Industrial Engineer, to help them
out with it.
The Challenge:
The company is celebrating the 300* national day of
Norway and wants to include monetary prizes inside the potato
chips bags sold at the oldest branch of a famous Norwegian
supermarket. The bags will have a unique new design that
celebrates the occasion. Any bag sold, regardless of whether it
contain a prize or not, is immediately replaced with another one
on the shelf so that the number of potato chips bags on display is
always the same. The chips aisle is maintained so that at any
time, 3 bags have a prize inside them. Each of those bags will
have a check with a prize money of 10,000 euros inside it. What
is the number of bags the company should make available on
display for sale at a time to ensure that 40% of the time, the first
bag with the prize is at least the 5000* bag sold?
Transcribed Image Text:Fizzy & Crispy Co. The beverage and snacks company “Fizzy & Crispyâ" is one of the largest juices, drinks, and snacks producers in Norway. Their products are famous over all Europe. They are mainly known for their soft drinks and salty chips. Their oldest factory is now due for renewal because of quality control issues. Your team has been hired to help in the overhaul by assessing the conditions in the factory, and to work also as a consultant for their operations of that same factory. The team faced a difficult challenge and asked you, the Industrial Engineer, to help them out with it. The Challenge: The company is celebrating the 300* national day of Norway and wants to include monetary prizes inside the potato chips bags sold at the oldest branch of a famous Norwegian supermarket. The bags will have a unique new design that celebrates the occasion. Any bag sold, regardless of whether it contain a prize or not, is immediately replaced with another one on the shelf so that the number of potato chips bags on display is always the same. The chips aisle is maintained so that at any time, 3 bags have a prize inside them. Each of those bags will have a check with a prize money of 10,000 euros inside it. What is the number of bags the company should make available on display for sale at a time to ensure that 40% of the time, the first bag with the prize is at least the 5000* bag sold?
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Factorization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell