Question: table 1 Category Table 2 - DC Equipment Capacity / Labor Plan and Annual Expense Budget jan feb mar apr may jun jul aug sep
table 1 Category Table 2 - DC Equipment Capacity / Labor Plan and Annual Expense Budget jan feb mar apr may jun jul aug sep oct nov dec Total Toys 55,000 75,000 65,000 75,000 85,000 80,000 90,000 90,000 85,000 100,000 250,000 185,000 1,235,000 Home Dcor 78,000 80,000 80,000 85,000 125,000 135,000 140,000 100,000 80,000 70,000 150,000 125,000 1,248,000 Electronics 15,000 17,000 16,000 20,000 25,000 23,000 39,000 42,000 45,000 27,000 98,000 45,000 412,000 Fashion 75,000 82,000 109,000 125,000 147,000 125,000 133,000 108,000 96,000 115,000 187,000 165,000 1,467,000 Total 223,000 254,000 270,000 305,000 382,000 363,000 402,000 340,000 306,000 312,000 685,000 520,000 4,362,000 Assumptions Table 1 Days per month 24 2 Mx number of shifts per month 72 3 Sorter capacity per shift - units 6945 4 # of shifts each employee works/month 20 5 Training cost per new employee - Assume all employees in Jan are trained and any hire is new $ 296.00 6 Employee salary per month $ 3,200.00 7 Pick Rate Units - Toys - per person per shift 400 8 Pick Rate Units - Home Decor - per person per shift 350 9 Pick Rate Units - Electronics - per person per shift 550 10 Pick Rate Units - Fashion - per person per shift 500 11 Packing Rate Units - per person per shift 750 12 DC operational fixed costs - per month - Apr, May, June, July, Aug, Sep $ 75,000.00 13 DC operational fixed costs - per month - Oct, Nov, Dec, Jan, Feb, Mar $ 95,000.00 14 Reminder - We cannot have factions per employee solve this table using above information Category Table 2 - DC Equipment Capacity / Labor Plan and Annual Expense Budgetd CAT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL Toys Sorter Capacity Used # of Picking Labor required Training expense Labor expense Home Dcor Sorter Capacity Used # of Picking Labor required Training expense Labor expense Electronics Sorter Capacity Used # of Picking Labor required Training expense Labor expense Fashion Sorter Capacity Used # of Picking Labor required Training expense Labor expense GRAND TOTAL Sorter Capacity Used ToTal Picking Labor required Total Packing Labot Required Total Training Expense Total Labor Expense Total Fixed Expense GRAND TOTAL EXPENSE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
