Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your company is producing Magic Liquid, a drink that helps people stay awake and pay attention during technical presentations or classes. The consumers of this

Your company is producing Magic Liquid, a drink that helps people stay awake and pay attention during technical presentations or classes. The consumers of this product are mainly university students and managers working in tech companies. To produce a bottle of Magic Liquid you need a can of Magic Beans that another company is selling. Your company is ordering Magic Beans every 30days. The maximum supply of Magic Beans every 30 days follows a random distribution with minimum 15000, and maximum 25000. The cost per can is $5 for the full order, and is only $4.8 if the supplier do not have enough to fulfill your order. Your company needs to process Magic Beans to turn it into Magic Liquid, the variable cost of this process is random and provided in the excel file. The fixed cost for managing the company is $10,000 for every 30 days. The selling price for Magic Liquid is $15 per bottle. The demand of Magic liquid for every 30days is random and also given in the excel file. Run a simulation to decide on what would be your optimal order size of Magic Beans every 30days to maximize expected profit with the constraint that

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computer Organization

Authors: V Carl Hamacher, Carl Hamacher, Zvonko G Vranesic, Safwat G Zaky

5th Edition

0072320869, 9780072320862

More Books

Students also viewed these General Management questions

Question

Food supply

Answered: 1 week ago

Question

Mortality rate

Answered: 1 week ago