Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started