20225-SP 3043 Assignment 3-Student Copy Excel (ProductActivation) TM Home Page Layout Formulas Data Review View Help Tell me what you want to d Who General Copy Formal Paster Merge & %. Conditional format Cell Formatting Table o Delete Fomar E " G H Manish Shaman So Select M Athe 1 Your Name: 2 Your Student ID: 4 Category Table 2-DC Equipment Capacity/Labor Plan and Annual Expense Budget 5 jan feb mar fuys 35,000 75,000 65,000 apr 75,000 7 Home Deco 78,000 80,000 80,000 85,000 may 85,000 125,000 Jun 80,000 135,000 jud 50,000 sap oct nov dec Total 90,000 5,000 100,000 140,000 100,000 80,000 70,000 250,000 150,000 15,000 1,235,000 125,000 4 Electronics 1248,000 15,000 17.000 15,000 20,000 25,000 23,000 39,000 42,000 45,000 27,000 9.000 75,000 2000 109,000 125,000 147000 125,000 133,000 10,000 96,000 115,000 187,000 10 Total 223.000 254,000 270,000 305,000 12,000 363,000 402,000 340,000 106.000 312,000 685,000 45,000 155,000 50,000 412,000 1,467,000 1,362,000 32 Assumptions Table 13 1Day per month 14 Manunda of shifts per mont 15 Sorter capacity per shift-uits 24 22 6945 20 17 Strand and any line in new 530.00 Replace with last 1 g of your den be 30 Pick Rate -Toys per person per shi Employee salary per month Rat Us Hume Dar per person per shift Rat Usity-Bedric pre per sha 21 11kg ke Use per person or h DC anal fed costs per For, May, Sep DC operational fiend cuts pin morth O, N, Der, 25 11th, Mal 2% 14 We can be factions per employee 3,200.00 400 350 550 500 250 15 9.000.00 Never Settle ING 1300 15/04/2013 29 20225 SUP 3043 Assignment 3-Student Copy Excel Product Actio Tell me what you bert Page Layout Forma Cata Review View Help W Formal P DZU Category CAT Tays B Sorter Capacity ed Home Decor Electronics Fashion of Picking Labor required Tning expe Laber expense Sorter Capacity Used of Picking Labor required Training expose Labor expense Sorter Capacity ed of Picking Laboried Training expense Labor expense Sorter Capacity Used But Picking Laborregand Training capene GRAND TOTAL GRAND TOTAL EXPENSE Sorter Capacity Used Total Picking Labor required Total Packing Labot Required Total Training Expense Total Labor sjeme Total Fixed Experne Sheet2 Alge Genal 9 Conditional Fa Formattinge Styles- Delete Format Nue Manik Salama D F G L M N Table 2-DC Equipment Capacity/Labor Plan and Annual Expense Budget Jan Feb Mar Apr May Jun Aug Sep Ort M Dec TOTAL Never Settle