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?

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
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
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,