File size: 3,992 Bytes
c73a3e0
 
 
 
 
 
f2b92ef
b9483ac
 
 
 
e6f15f9
b9483ac
11ba886
 
f2b92ef
ee6bd21
33c70f3
 
b898d29
33c70f3
 
c73a3e0
b898d29
670c918
b898d29
 
 
670c918
b898d29
 
 
 
 
 
 
 
 
97985f2
fa1e2d7
b898d29
 
6c915d6
7c11ab5
b898d29
ae91796
352d214
b898d29
 
 
 
352d214
b898d29
 
 
 
8434edd
 
 
 
 
 
352d214
eddefd4
 
b898d29
 
9c24e16
fa1e2d7
6634da1
 
b898d29
 
19e516e
b898d29
6634da1
ae91796
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
import streamlit as st
import matplotlib.pyplot as plt
import numpy as np
import pandas as pd
import math


st.set_page_config(
     page_title="Ex-stream-ly Cool App",
     page_icon="🧊",
     layout="wide",
     initial_sidebar_state="expanded"
 )


st.title("Калькулятор Toyota 📦")

st.subheader('Toyota Material Handling')
st.write("""
тут информация про калькулятор
""")


col1, col2 = st.columns(2)

Number_of_incoming_pallets = st.number_input('Количество поступаемых паллет, паллет/месяц', value=40)
Number_of_pallets_shipped = st.number_input('Количество отгружаемых паллет, паллет/месяц', value=40)
The_average_cost_of_one_product = st.number_input('Средняя стоимость одного товара, руб.', value=3000)

with col1:
    The_cost_of_warehouse_maintenance_services = st.number_input('Стоимость услуг по обеспечению склада, руб./месяц', value=50000)
    Average_salary = st.number_input('Средняя зарпала, сотрудник', value=50850)
    Equipment_breakdown_rate_in_stock = st.number_input('Коэффициент поломки оборудования на складе, %', value=5)
    The_cost_of_equipment_repair_in_the_warehouse = st.number_input('Стоимость ремонта оборудования на складе, руб./шт.', value=20000)
    The_cost_of_warehouse_information_support = st.number_input('Стоимость информационной поддержки склада, руб./месяц', value=20000)
    Spoilage_coefficient = st.number_input('Коэффициент порчи, %', value=0.1)
    Number_of_working_hours_per_month = st.number_input('Количество рабочих часов в месяц, час', value=176)
    Average_number_of_goods_per_pallet = st.number_input('Среднее количество товаров в одном паллете, шт./палелт', value=120)
    Productivity_of_one_employee = st.number_input('Производительность одного сотрудника, паллетомест/час', value=0.2)
    
with col2:
    Price_for_processing_ont_pallet = st.number_input('Цена за обработку 1 паллета, руб.', value=300)
   
    
def get_average_number_of_damaged_goods():
    return (Number_of_incoming_pallets + Number_of_pallets_shipped) * Spoilage_coefficient * Average_number_of_goods_per_pallet / 100

def get_cnt_emplyes_and_equipment():
    The_number_of_pallets_processed_by_one_employee = Productivity_of_one_employee * Number_of_working_hours_per_month
    Number_of_employees = math.ceil((Number_of_incoming_pallets + Number_of_pallets_shipped) / The_number_of_pallets_processed_by_one_employee)
    return Number_of_employees, Number_of_employees

def get_insource_cost():
    Wage_fund = Number_of_employees * Average_salary
    The_cost_of_repairing_broken_equipment = Number_of_equipment * The_cost_of_equipment_repair_in_the_warehouse * Equipment_breakdown_rate_in_stock / 100
    Spoilage = Average_number_of_damaged_goods * The_average_cost_of_one_product
    return [The_cost_of_warehouse_maintenance_services,
            Wage_fund,
            The_cost_of_warehouse_information_support,
            The_cost_of_repairing_broken_equipment,
            Spoilage,
            The_cost_of_warehouse_maintenance_services + Wage_fund + The_cost_of_repairing_broken_equipment + The_cost_of_warehouse_information_support + Spoilage]
    
    
    
def get_outsource_cost():
    pass
    
    
if st.button('Расчет эффективности'):
    
    Number_of_employees, Number_of_equipment = get_cnt_emplyes_and_equipment()
    Average_number_of_damaged_goods = get_average_number_of_damaged_goods()
    
    insource_cost = get_insource_cost()
    
    st.write(f'Затраты Insource склад {insource_cost}')