Answer simulation questions and get solution in Python

Question

Vicky · Accepted Answer

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np
",
    "import pandas as pd
",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "
",
       "
",
       "    .dataframe tbody tr th:only-of-type {
",
       "        vertical-align: middle;
",
       "    }
",
       "
",
       "    .dataframe tbody tr th {
",
       "        vertical-align: top;
",
       "    }
",
       "
",
       "    .dataframe thead th {
",
       "        text-align: right;
",
       "    }
",
       "
",
       "
",
       "  
",
       "    
",
       "      
",
       "      Vaccine Demand
",
       "    
",
       "  
",
       "  
",
       "    
",
       "      0
",
       "      782996
",
       "    
",
       "    
",
       "      1
",
       "      656583
",
       "    
",
       "    
",
       "      2
",
       "      1650651
",
       "    
",
       "    
",
       "      3
",
       "      116585
",
       "    
",
       "    
",
       "      4
",
       "      2690810
",
       "    
",
       "  
",
       "
",
       ""
      ],
      "text/plain": [
       "   Vaccine Demand
",
       "0          782996
",
       "1          656583
",
       "2         1650651
",
       "3          116585
",
       "4         2690810"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_excel('ourx.xlsx')
",
    "data.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "A. For a order quantity of 500,000 doses, what is the net profit when demand is 400,000 doses and 600,000 doses, respectively?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Profit = $ 2000000
"
     ]
    }
   ],
   "source": [
    "# net profit when demand is 400,000 doses
",
    "demand = 400000
",
    "orders = 500000
",
    "price = 20
",
    "unit_cost = 12
",
    "
",
    "if demand >= orders:
",
    "    net_profit = orders*(price-unit_cost)
",
    "else:
",
    "    net_profit = (demand*price)-(orders*unit_cost)
",
    "    
",
    "print('Profit = $',net_profit)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Profit = $ 4000000
"
     ]
    }
   ],
   "source": [
    "# net profit when demand is 600,000 doses
",
    "demand = 600000
",
    "orders = 500000
",
    "price = 20
",
    "unit_cost = 12
",
    "
",
    "if demand >= orders:
",
    "    net_profit = orders*(price-unit_cost)
",
    "else:
",
    "    net_profit = (demand*price)-(orders*unit_cost)
",
    "    
",
    "print('Profit = $',net_profit)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "B. Plot a histogram of the demand data. What distribution seems appropriate for modelling demand?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(array([475.,  12.,   7.,   3.,   1.,   1.,   0.,   0.,   0.,   1.]),
",
       " array([3.15700000e+03, 3.73965890e+06, 7.47616080e+06, 1.12126627e+07,
",
       "        1.49491646e+07, 1.86856665e+07, 2.24221684e+07, 2.61586703e+07,
",
       "        2.98951722e+07, 3.36316741e+07, 3.73681760e+07]),
",
       " )"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png":

Answer simulation questions and get solution in Python

Solution