生产计划排程表

更新-顺排 订单号 产品编号 订单数量 开始生产日期 完成生产日期 生产天数 预估日生产量 日期 累计数量 42,370 42,371 42,372 42,373 42,374 42,375 42,376 42,377 42,378 42,379 42,380 42,381 42,382 42,383 42,384 42,385 42,386 42,387 42,388 42,389 42,390 42,391 42,392 42,393 42,394 42,395 42,396 42,397 42,398 42,399 42,400 42,401 42,402 42,403 42,404 42,405 42,406 42,407 42,408 42,409 42,410 42,411 42,412 42,413 42,414 42,415 42,416 42,417 42,418 42,419 42,420 42,421 42,422 42,423 42,424 42,425 42,426 42,427 42,428 42,429 42,430 42,431 42,432 42,433 42,434 42,435 42,436 42,437 42,438 42,439 42,440 42,441 42,442 42,443 42,444 42,445 42,446 42,447 42,448 42,449 42,450 42,451 42,452 42,453 42,454 42,455 42,456 42,457 42,458 42,459 42,460 42,461 42,462 42,463 42,464 42,465 42,466 42,467 42,468 42,469 42,470 42,471 42,472 42,473 42,474 42,475 42,476 42,477 42,478 42,479 42,480 42,481 42,482 42,483 42,484 42,485 42,486 42,487 42,488 42,489 42,490 42,491 42,492 42,493 42,494 42,495 42,496 42,497 42,498 42,499 42,500 42,501 42,502 42,503 42,504 42,505 42,506 42,507 42,508 42,509 42,510 42,511 42,512 42,513 42,514 42,515 42,516 42,517 42,518 42,519 42,520 42,521 42,522 42,523 42,524 42,525 42,526 42,527 42,528 42,529 42,530 42,531 42,532 42,533 42,534 42,535 42,536 42,537 42,538 42,539 42,540 42,541 42,542 42,543 42,544 42,545 42,546 42,547 42,548 42,549 42,550 42,551 42370.0 42371.0 42372.0 42373.0 42374.0 42375.0 42376.0 42377.0 42378.0 42379.0 42380.0 42381.0 42382.0 42383.0 42384.0 42385.0 42386.0 42387.0 42388.0 42389.0 42390.0 42391.0 42392.0 42393.0 42394.0 42395.0 42396.0 42397.0 42398.0 42399.0 42400.0 42401.0 42402.0 42403.0 42404.0 42405.0 42406.0 42407.0 42408.0 42409.0 42410.0 42411.0 42412.0 42413.0 42414.0 42415.0 42416.0 42417.0 42418.0 42419.0 42420.0 42421.0 42422.0 42423.0 42424.0 42425.0 42426.0 42427.0 42428.0 42429.0 42430.0 42431.0 42432.0 42433.0 42434.0 42435.0 42436.0 42437.0 42438.0 42439.0 42440.0 42441.0 42442.0 42443.0 42444.0 42445.0 42446.0 42447.0 42448.0 42449.0 42450.0 42451.0 42452.0 42453.0 42454.0 42455.0 42456.0 42457.0 42458.0 42459.0 42460.0 42461.0 42462.0 42463.0 42464.0 42465.0 42466.0 42467.0 42468.0 42469.0 42470.0 42471.0 42472.0 42473.0 42474.0 42475.0 42476.0 42477.0 42478.0 42479.0 42480.0 42481.0 42482.0 42483.0 42484.0 42485.0 42486.0 42487.0 42488.0 42489.0 42490.0 42491.0 42492.0 42493.0 42494.0 42495.0 42496.0 42497.0 42498.0 42499.0 42500.0 42501.0 42502.0 42503.0 42504.0 42505.0 42506.0 42507.0 42508.0 42509.0 42510.0 42511.0 42512.0 42513.0 42514.0 42515.0 42516.0 42517.0 42518.0 42519.0 42520.0 42521.0 42522.0 42523.0 42524.0 42525.0 42526.0 42527.0 42528.0 42529.0 42530.0 42531.0 42532.0 42533.0 42534.0 42535.0 42536.0 42537.0 42538.0 42539.0 42540.0 42541.0 42542.0 42543.0 42544.0 42545.0 42546.0 42547.0 42548.0 42549.0 42550.0 42551.0 预估 20131008005 4511923 2500000 42,370 70000 0 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 70000 50000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 实际 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 输入数据部分 输出数据部分 特点：1.根据输入开始日期自动选择排产日期 2.根据输入订单量、计划每日排单量自动排生产数量 3.可变的每日排单量更加灵活，可根据需求使总产能分配给多个产品 4.每日超负荷提醒 特点：5.根据输入开始日期自动选择排产日期 =IF(OR($E4>I$3,$D4=SUM($H4:H4)),0,IF($D4SUM($H4:H4)>$F4,$F4,$D4-SUM($H4:H4))) 特点：7.根据输入开始日期自动选择排产日期 特点：8.根据输入开始日期自动选择排产日期 特点：9.根据输入开始日期自动选择排产日期