全部
搜索
稻壳儿首页 >

表格模板

 >当前作品

医药行业单品项生产统计模板

收藏
  • 医药行业单品项生产统计模板-表格模板,,使用说明,生产信息即时查询，物料消耗自动计算，收率、损耗率指标计算，自动汇总,1、日报表：每日生产信息录入，批号、产量、物料消耗、人工工时、设备工时等。,2、月度工时产量：输入月份和批号，根据日报表自动汇总每月每批每工序的产量工时合计。,3、批次汇总表：输入批号，根据日报表自动汇总各批号物料消耗量，并可计算各批原料投入产出收率。,4、批次损耗表：输入BOM配比，根据批次汇总表结合产品BOM，自动计算各批次各物料的物料损耗率，可进行时时物耗控制。,5、批次收率：自动计算各批次收率。,6、此套模板需准备的数据：该品项每日的生产情况（批号、产量、物料消耗、人工工时、设备工时）、该品项的BOM配比,,岗位/人员配置/工时当日产量制粒岗位总混岗位压片岗位瓶装线外包,维生素片A00001A00002A00003A00004A00005ZL00001A00006A00007A00008A00009ZH00001YP00001A00010A00011A00012A00013A00015A00016A00017,制粒总混压片入瓶外包物料1物料2物料3物料4物料5制粒半成品物料6物料7物料8物料9总混半成品可回收片压片半成品塑料瓶干燥剂瓶贴外盒盒缩膜包装箱封箱胶带,日期星期批号制粒产量总混产量压片内包产量（瓶）常态外包产量（盒)自主外包产量(瓶）入库数量外包批号,44013.0746.54369.1593.6869.417.15,44014.017.017.0746.54369.1593.6869.417.15,44015.052.0675.0664.58756.96225.0232.39361.7626.2267.4630.6438.761.215.95,44016.052.0665.0291.94233.73128.0325.3542.1129.878.890.8515.1,44017.0735.53675.0512.46254.48250.0179.79198.2419.49122.6223.060.890.6214.48,44018.041.0215.52152.44102.0453.93144.315.76116.866.8354.060.2314.25,44019.0734.12600.0514.28187.76180.36238.9519.4497.4223.0531.010.7313.52,44020.02.5215.4152.4335.3353.93185.025.7691.666.8524.160.2213.3,44021.035.33-11.0174.0291.66-0.523.6613.3,44022.0480.56800.0361.5525.0125.5313.7516.570.7227.0429.22,44023.0965.086.2720.779.7319.490.190.2119.4720.53,44024.06.279.870.1919.76,44025.0852.21125.0606.49992.34213.16360.3323.0254.8927.2354.860.9211.66,44026.076.9655.1319.52.082.470.08,44027.0951.05951.056.3744.149.897.80.240.9219.77,44028.0453.38465.71465.718.21,44029.0812.01565.24198.521.524.80.83,44030.0949.52949.526.3626.779.8634.010.1897.43119.762.16,44031.0356.9345.78345.782.393.550.0716.88,44032.0491.95499.37499.374.3661.27,44033.0964.979.07,44034.053.0489.79369.6344.2227.75121.3312.9918.3215.4112.180.4610.29358.43358.432.421.983.7826.680.057.317.0348.25,44035.0456.96316.64375.0111.3711.9914.150.4721.9826.687.3148.25,44036.01020.47986.98986.986.610.280.220.53,44037.0965.947.7378.07,44038.0969.418.099244.09244.041600.041600.02320.02320.0,44039.079.513364.06650.020200116A01A967.3967.313432.014562.013480.028120.027759.06700.021334.021200.06770.016750.0324.0111.0231.0,44040.031.56394.02640.020200117A02A460.4460.46409.08153.06420.021700.02640.018694.02680.014070.0187.0,44041.06660.020200116A01A8153.021700.018694.014070.0187.0,44042.018.56150.03586.06226.020200117A02A453.9453.96229.014424.06250.015450.03620.015074.08190.03670.018590.0127.0,44043.015.013.05070.02460.0374.2374.25083.09341.05100.010350.02484.012590.02460.016130.041.086.0,44044.08291.02400.03840.0606.9606.98341.019750.016000.08340.018010.04000.02420.014170.010600.02500.024230.0198.0244.0,44045.037.513058.06480.0840.020200118A04955.8955.86250.013090.012910.013100.04910.06540.07630.06630.017600.0109.0135.0,44046.05640.020200118A04A763.5763.525000.010355.027555.040000.010370.034540.07630.017600.0135.0,44047.018561.04835.01920.0591.6591.68241.019314.08300.026240.05040.04990.091.0,44048.010006.0732.4732.410026.010056.0,44049.0975.68990.26990.268.4394.59,44050.0380.87387.11387.113.3697.95,44051.01398.11419.821419.8213.74111.69,44052.01379.9814.12,44053.06.5642.62625.0454.15731.96150.0159.17275.4617.3339.020.5152.520.669.16,44054.013.0261.64192.96539.068.26207.27.331.78.6443.880.288.88,44055.0802.33481.6557.35169.238.018.3313.3721.5722.310.69,44056.0-57.35-38.0-13.372.30926389122e-14-22.31,44057.01050.222.30926389122e-141020.291020.296.8833.510.65.80.156.9621.146.58,44058.02.51361.221361.229.0424.4614.212.60.486.4827.2229.36,44059.0276.38266.43266.431.7922.672.779.830.056.435.5423.82,44060.0551.72535.9535.92.674.150.111.1312.69,44061.0-12.69,44062.0815.778310.08300.020200121A08A828.1828.17.13132.94608.3608.38338.0950.08440.07744.0,44063.04.59125.09137.019257.020200119A06A132.94668.0668.09257.04193.044000.09340.042404.0,44064.09144.018958.020200120A07A-132.94669.3669.39210.013733.09500.032904.0,44065.09700.08750.0710.0710.09730.09950.0,44066.011.51740.01740.01800.010810.0,44067.08750.0-10810.0,44068.010120.020200119A06A,44069.02750.02717.020200121A08A203.0203.02860.019893.02760.020194.0,44070.0-19893.0-20194.0,44071.024.024.0,44072.0475.0475.0175.0175.0,44073.0548.8507.35385.03597.32188.0134.37228.6363.3714.3174.0672.3117.3379.980.587.6129.034.68,44074.0670.3725.8468.61128.71165.7662.8717.756.3620.9958.990.696.92701.48701.484.7115.297.3227.366.1914.5445.46,44075.0278.3900.0192.42836.29325.066.54321.337.5748.799.0249.970.336.5915.2927.366.1945.46,44076.047.0155.14696.98110.26726.0339.0282.334.1644.634.9445.030.166.43672.76672.764.5310.7620.256.0514.0131.45,44077.0763.56551.88174.15189.2793.0619.8524.7824.7420.290.815.6210.7620.256.0531.45,44078.0237.261097.16165.3358.56.27.510.261062.241062.240.2121.96,44079.0,44080.01213.31227.121227.12,44081.0,44082.0190.02195.66195.663.08,44083.0246.9255.44255.444.52,44084.0,44085.0,44086.0823.02841.72841.7214.38,44087.080.8855.133.6919.515.062.0816.52.4710.310.085.28,44088.0869.881150.0606.01211.523.0527.00.9,44089.05.5296.12302.8302.83.1,44090.0688.24533.34663.2663.24.4724.186.922.330.135.7113.7555.74540.67540.671.2,44091.0504.88737.39358.45189.23126.7626.813.5754.8816.1167.20.523.86711.56711.564.787.410.1514.8,44092.0423.92800.0303.02686.21104.09272.7111.5543.3313.7153.490.513.35,44093.0289.82206.71479.572.36200.357.6935.649.2444.250.33.05,44094.0302.82479.5200.3535.6444.253.05293.08293.081.9917.413.0421.880.065.56.0934.85,44095.0653.0743.34454.8324.67160.8939.4617.1918.4520.3723.880.682.37713.74713.744.787.4614.85,44096.0297.52975.0206.56793.1171.37318.097.9185.549.4114.480.342.03,44097.07.5492.38344.19121.0913.1115.480.539826.09826.010571.010571.0,44098.019035.018987.010150.020200225B01A1404.81404.819050.03276.020000.019060.011511.0,44099.035.035.08837.020200225B01A12000.015276.011511.0,44100.016330.05140.05140.020200226B02A1205.21205.216350.020000.016400.0,44101.010815.06300.020200227B02A,44102.0578.72413.4835.44146.2650.7417.0855.3522.8476.160.760.74,44103.0B06A137.6975.095.96914.4832.25368.493.6951.664.3471.8220.6,,产品名称月份批号制粒产量(kg）总混产量(kg）压片产量内包产量（盒）外包产量（盒）,33.0,A01A936.2452.0965.08945.3344.013364.06650.079.5,A02A949.6452.0979.44964.9712544.085.013.56226.050.08.5,A03A951.0581.016.5979.51965.9422.05070.02460.013.0,A04A949.5232.0983.42.0969.41,A05A1332.76107.017.01377.37,A06A1378.76103.018.5369.62.0,A07A456.96,A08A,6954.93460.073.55654.421.08.53845.6566.026.030978.0130.015336.0142.520.5,108.024.0,A01A,A02A,A03A8291.04140.025.56.5,A04A13058.06480.037.5,A05A1356.5538.018561.04835.032.0,A06A1050.221398.119131.085.014.5,A07A904.2688.01402.161379.9822.018844.0,A08A802.33828.1815.7711060.080.011.0,1706.59196.03280.484950.4100.088945.0313.045.515455.095.024.0,60.019.035.0,B01A155.1447.0696.981403.3244.013.019035.0,B02A1360.080.01399.981366.0438.010.516330.0,B03A1374.7650.01425.63533.34,B04A1366.7471.014.0743.34,B05A1368.6274.016.5,B06A137.6,5762.86382.063.54265.9323.03302.7101.023.535365.0145.018.0,,原料合计收率%包材合计,产量物料编码A00001A00002A00003A00004A00005A00006A00007A00008A00009投料量产出量产成品率A00010A00011A00012A00013A00014,生产批号制粒产量总混产量压片产量内包产量外包产量物料1物料2物料3物料4物料5物料6物料7物料8物料9物料10物料11物料12物料13物料14,总计15643.4813926.6112098.7577644.030791.010957.063839.66417.02497.0816.5589.41138.942.84278.2316236.794544.75160.279904562417156001.0156866.031184.031500.0528.0,A01A936.24965.08945.336682.06650.0664.58232.3926.2230.641.26.279.730.1919.47990.69981.540.99076401296113432.013480.06700.06770.0111.0,A02A949.64979.44964.976272.06226.0665.02233.7325.3529.870.856.279.870.1919.76990.91918.95760.92738755285512638.012670.06260.06350.0104.0,A03A951.05979.51965.946680.56600.0664.9233.7225.2529.830.856.379.890.219.77990.78974.160.98322533761313424.013440.06644.06760.0113.0,A04A949.52983.4969.416529.06480.0666.71234.2925.229.90.956.369.860.18919.76993.219956.4480.96297795350323445.023470.06540.06630.0109.0,A05A1332.761377.371356.559280.54835.0967.99338.6936.7743.81.648.9913.830.27127.411439.391713.6460.4957971808918241.08300.05040.04990.091.0,A06A1378.761419.821398.19565.5964.59339.3336.5742.681.379.2814.380.228.171436.5719283.019396.0,A07A1361.221402.161379.989422.0963.75338.836.6243.31.419.0414.20.4827.221434.8218940.019450.0,A08A802.33828.1815.775530.0481.65169.218.3321.570.694.466.920.1516.67719.6411198.011200.0,B01A1374.241422.781403.329517.5963.9339.1336.1743.261.439.2414.430.2828.551436.3919050.019060.0,B02A1360.01399.981366.048165.0964.76333.8135.743.741.489.114.040.2728.051430.9516350.016400.0,B03A1374.761425.63533.34964.46338.2636.6243.111.429.2514.330.2828.551436.28,B04A1366.74743.34964.56337.3436.4343.321.494.787.460.1414.851410.37,B05A1368.62964.23338.7238.147.721.631390.4,B06A137.695.9632.253.694.340.14136.38,,批产量,生产批号,备注：以各工序产量来计算损耗率制粒产量15643.48936.24949.64951.05949.521332.761378.761361.22802.331374.241360.01374.761366.741368.62137.6,总混产量13926.61965.08979.44979.51983.41377.371419.821402.16828.11422.781399.981425.63743.34,压片产量12098.75945.33964.97965.94969.411356.551398.11379.98815.771403.321366.04533.34,内包产量77644.06682.06272.06680.56529.09280.59565.59422.05530.09517.58165.0,外包产量30791.06650.06226.06600.06480.04835.0,物料名称批次报表用量,10957.06664.58665.02664.9666.71967.99964.59963.75481.65963.9964.76964.46964.56964.2395.96,3839.66232.39233.73233.72234.29338.69339.33338.8169.2339.13333.81338.26337.34338.7232.25,417.0226.2225.3525.2525.236.7736.5736.6218.3336.1735.736.6236.4338.13.69,497.0830.6429.8729.8329.943.842.6843.321.5743.2643.7443.1143.3247.724.34,16.551.20.850.850.951.641.371.410.691.431.481.421.491.630.14,89.416.276.276.376.368.999.289.044.469.249.19.254.78,138.949.739.879.899.8613.8314.3814.26.9214.4314.0414.337.46,2.840.190.190.20.1890.2710.20.480.150.280.270.280.14,278.2319.4719.7619.7719.7627.4128.1727.2216.6728.5528.0528.5514.85,156001.013432.012638.013424.023445.08241.019283.018940.011198.019050.016350.0,156866.013480.012670.013440.023470.08300.019396.019450.011200.019060.016400.0,31184.06700.06260.06644.06540.05040.0,42.219.07188.5099.05848.88426.6866,528.0111.0104.0113.0109.091.0,批次理论用量,产品名称BOM,0.6710481.1316627.2808636.2588637.2035636.1784892.9492923.7692912.0174537.5611920.7408911.2921.0892915.7158916.975492.192,0.2373707.50476221.88888225.06468225.39885225.03624315.86412326.76612322.60914190.15221325.69488322.32325.81812323.91738324.3629432.6112,0.0253395.78004423.68687224.02589224.06156524.02285633.71882834.88262834.43886620.29894934.76827234.40834.78142834.57852234.6260863.48128,0.03469.304428.087228.489228.531528.485639.982841.362840.836624.069941.227240.841.242841.002241.05864.128,0.00115.643480.936240.949640.951050.949521.332761.378761.361220.802331.374241.361.374761.366741.368620.1376,0.006590.5229656.273026.366366.3668156.39218.9529059.228839.114045.382659.248079.099879.2665954.83171,0.01139.26619.65089.79449.79519.83413.773714.198214.02168.28114.227813.999814.25637.4334,0.00022.7853220.1930160.1958880.1959020.196680.2754740.2839640.2804320.165620.2845560.2799960.2851260.148668,0.02278.532219.301619.588819.590219.66827.547428.396428.043216.56228.455627.999628.512614.8668,2.0155288.013364.012544.013361.013058.018561.019131.018844.011060.019035.016330.0,2.0155288.013364.012544.013361.013058.018561.019131.018844.011060.019035.016330.0,1.030791.06650.06226.06600.06480.04835.0,0.001340.02838.6458.09388.588.4246.2855,0.0166666666667513.183333333110.833333333103.766666667110.0108.080.5833333333,批原材料损耗率,产品名称,0.04540811223090.0594617275070.04520361840180.04346570601070.04799219841480.08403703144590.04418939276170.0567232598852-0.104008828020.0468744298070.05877963125550.04708642767710.05333991179360.05153311637370.040871225269,0.03564533252280.04732603093950.03850146544540.0369174465620.04112119896780.0722648713630.0384491513380.050187232761-0.1101865184740.04125063310790.03564780342520.03818658090590.04143840629980.0442623315722-0.0110759493671,0.05366606104070.1069422758730.05511171031650.04939142570320.04900100137970.09048867297520.04837284622020.0633335023284-0.09699758347090.04031629757150.03754940711460.05286073935780.05354416247170.1003264995070.0599549590955,0.05918461450610.09088837619980.04846748943460.04551110176470.04965315808690.09547105255260.03184503950410.0603233373983-0.1038600077270.04930725346370.07205882352940.04527335680410.05652867407110.1622412844080.0513565891473,0.05794874286280.281722635222-0.104923971189-0.1062509857530.0005055185778080.230529127525-0.006353535060490.0358355005069-0.1400047362060.04057515426710.08823529411760.03290756204720.09018540468560.1909806958830.0174418604651,-0.0122948359016-0.000481426808778-0.01513580758860.000500250125063-0.005021823813770.004143347885410.00554458149083-0.00812372998144-0.17141185104-0.0008726145022691.42859183703e-05-0.00179084118816-0.0107022151578,-0.002341560508980.008206573548310.007718696397940.009688517728250.002643888549930.004087500090750.01280443999940.0127232270212-0.1643521313850.01421161388270.002871469592420.005169644297610.00357844324266,0.0196307644143-0.0156256476147-0.03005799232210.0209186225766-0.039048200122-0.0162410971634-0.2956853685680.71164489074-0.0943122811255-0.0160109082219-0.0357005100073-0.0179780167365-0.0583044098259,-0.001084973299320.008724665312720.008739687984970.009178058416960.00467764897295-0.00498776654058-0.00797284162781-0.02935470987620.00652095157590.003317448937990.001800025714650.00131170079193-0.00113003470821,0.004591468754830.005088296917090.007493622448980.004715215926950.795451064482-0.5560045256180.007945219800320.005094459774990.01247739602170.0007880220646180.0012247397428,0.01016176394830.008680035917390.01004464285710.0059127310830.797365599632-0.5528258175740.01385186346770.03215877732970.01265822784810.00131337010770.00428658909982,0.01276346984510.007518796992480.005460970125280.006666666666670.009259259259260.0423991726991,0.05450393846350.04936957779060.05129852479680.05575757575760.05462962962960.0638135390979,0.02887207300830.00150375939850.002248634757470.02727272727270.009259259259260.129265770424,,备注：以各工序产量来计算收率，产品规格按1.22g/片*60片*2瓶/盒来计算，投入产出比,批产量生产批号,制粒产量15643.48936.24949.64951.05949.521332.761378.761361.22802.331374.241360.01374.761366.741368.62137.6,总混产量13926.61965.08979.44979.51983.41377.371419.821402.16828.11422.781399.981425.63743.34,压片产量12098.75945.33964.97965.94969.411356.551398.11379.98815.771403.321366.04533.34,内包产量77644.06682.06272.06680.56529.09280.59565.59422.05530.09517.58165.0,外包产量30791.06650.06226.06600.06480.04835.0,投料量,制粒投料量15727.37955.03954.82954.55957.051388.891384.541383.88691.441383.891379.491383.871383.141390.4136.38,总混投料量509.4235.6636.0936.2336.16950.50152.0350.9428.252.551.4652.4127.23,压片投料量13926.61965.08979.44979.51983.41377.371419.821402.16828.11422.781399.981425.63743.34,内包投料量12098.75945.33964.97965.94969.411356.551398.11379.98815.771403.321366.04533.34,外包投料量77644.06682.06272.06680.56529.09280.59565.59422.05530.09517.58165.0,收率%,制粒收率0.9946659867480.9803252253860.9945748936970.9963333507940.9921320725140.9595864323310.9958253282680.9836257478971.160375448340.9930269024270.9858715902250.9934170117140.9881429211790.9843354430381.0089455932,总混收率0.8621739749520.9929828171620.9936189423070.9921298922290.9976777665170.9957412230950.9923329069950.9929186494450.9970741574660.9972244417340.991866577870.9989209414440.533253943772,压片收率0.8687505430250.9795353753060.9852262517360.9861461342920.9857738458410.9848842358990.9847022862050.9841815484680.9851104939020.9863225516240.9757567965260.374108288967,内包收率0.9395252898031.034818317410.9515537270591.012511336110.9860075716161.001559249571.0016373650.9995657908090.9924267869620.9929039705840.875051975052,外包收率0.3965663798880.9952110146660.9926658163270.9879500037420.9924950222090.520984860729
  • 医药行业单品项生产统计模板-表格模板
  • 医药行业单品项生产统计模板-表格模板
  • 医药行业单品项生产统计模板-表格模板
模板介绍：
这个模板还没有相关介绍

关注稻壳领福利

相关推荐 查看更多
生产指令单.xlsx
生产指令单.xlsx

生产指令单

生产统计报表.xlsx
生产统计报表.xlsx

生产统计报表

生产过程统计表.xls
生产过程统计表.xls

生产过程统计表

生产计划报表.xls
生产计划报表.xls

生产计划报表

生产任务执行单.xlsx
生产任务执行单.xlsx

生产任务执行单

生产程序工艺单.xlsx
生产程序工艺单.xlsx

生产程序工艺单

生产计划跟踪单.xlsx
生产计划跟踪单.xlsx

生产计划跟踪单

生产指令单.xlsx
生产指令单.xlsx

生产指令单

生产调度单.xlsx
生产调度单.xlsx

生产调度单

工厂生产计划表.xlsx
工厂生产计划表.xlsx

工厂生产计划表

生产任务统计表.xlsx
生产任务统计表.xlsx

生产任务统计表

生产统计报表.xlsx
生产统计报表.xlsx

生产统计报表

模板单价：￥14.99
开通会员可免费下载任意模板与19项权益包
登录后使用
以14.99元购买此模板
  • 页数：6页
  • 时间：2020-10-28
  • 编号：20482568
  • 类型：VIP模板
  • 格式：et
  • 提示：数字产品不支持退货
    数字产品本身（包括但不限于文字模板、表格模板、演示模板等）及其包含的全部素材 （包括但不限于字体、图片、图标、文本框、艺术字等）均不支持商用，仅能为个人学习、研究或欣赏目的使用。

逆风而舞

设计作品150 独家高品质原创文档

举报

猜你在找

    我的

    关注稻壳领福利

    福利

    反馈

    微信咨询在线客服

    客服