Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started