Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Supply Chain Management A Logistics Perspective

Authors: John coyle, John Langley, Robert Novack, Brain Gibson

9th edition

9780538479189, 9781285400945, 538479191, 538479183, 1285400941, 978-0538479196

More Books

Students also viewed these General Management questions