You are running a Zamazon.com fulfillment center. You have to decide every day h

Question

You are running a Zamazon.com fulfillment center. You have to decide every day how many temp

workers to hire in order to complete the tasks that need to be done. These workers will do three things:

Stow items into shelves from boxes that are received into the warehouse

Stow items into shelves that are individual units (from pallets)

Pick items that are queued up from customer orders

You have historical data from 2013.

Look at files: ZamazonHistoricalData.csv, ZamazonHolidays.csv

( Here are two Links) :

https://drive.google.com/file/d/0B4gY0toGAj-IYS01NDRGLUU1NWc/view?usp=sharing

https://drive.google.com/file/d/0B4gY0toGAj-ISEt5OVBrTmFmX0k/view?usp=sharing

Date: What day of the year was it

NumPackagesInQueueToStow: How many boxes are in receiving that need to be stowed into

shelves

NumLooseItemsInQueueToStow: How many loose items (from pallets) are there to stow into

shelves

NumItemsToPick: How many items are there to waiting to be picked from shelves for customer

orders (to be later mailed to the customers’ homes)

TrucksScheduled: How many trucks are scheduled on the inbound and outbound loading docks

today

WorkersNeeded: On that day, how many workers were required to do the work that had to be

done

Create a regression model that describes the number of workers required as a function of the above

inputs as well as holiday and day of week. Specifically, do the following:

Create 6 additional columns, one for Monday, Tuesday, Wednesday, Thursday, Friday, and Saturday (not

Sunday). Put a “1” in this column if the day of the year corresponds to that day of the week, and a zero

otherwise. In this way, the “Monday” column will have a “1” in each row that is a Monday. This is a

dummy variable for day of wee (and so on). We don’t need “Sunday” because we are measuring the

effect of Mon-Sat against Sunday.

Create a column for “Holiday”. Look at the list of holidays. Put a “1” for each day that is a holiday, and a

“0” in the rest of the rows.

Make sure everything you think is a predictor (X-variable) is together. You may have to move columns

around. (When you do regression, Excel cannot highlight non-contiguous cells).

Perform a regression of “Total Workers” on all of your input (Independent, or X) variables (11 in total):

Mon (0/1)

Tue (0/1)

Wed (0/1)

Thu (0/1)

Fri (0/1)

Sat (0/1)

Holiday (0/1)

NumPackagesInQueueToStow

NumLooseItemsInQueueToStow

NumItemsToPick

TrucksScheduled

Look at your coefficients. Which coefficients have p-values > 0.05? Remove all these from your model

and rerun the regression. (Hint: To validate your model, try to use the coefficients to predict the

number of workers. On January 1, 2014, if there are 2000 Packages to be stowed, 30000 items to be

stowed, and 35000 items to be picked, and 10 trucks scheduled, then you should get 339.05 workers

predicted: Remember 1/1/2014 is in 2014 and it’s a holiday)

Explanation / Answer

NumPackagesInQueueToStow: How many boxes are in receiving that need to be stowed into

shelves

NumLooseItemsInQueueToStow: How many loose items (from pallets) are there to stow into

shelves

NumItemsToPick: How many items are there to waiting to be picked from shelves for customer

orders (to be later mailed to the customers’ homes)

TrucksScheduled: How many trucks are scheduled on the inbound and outbound loading docks

today

WorkersNeeded: On that day, how many workers were required to do the work that had to be

done

Create a regression model that describes the number of workers required as a function of the above

inputs as well as holiday and day of week. Specifically, do the following:

Create 6 additional columns, one for Monday, Tuesday, Wednesday, Thursday, Friday, and Saturday (not

Sunday). Put a “1” in this column if the day of the year corresponds to that day of the week, and a zero

otherwise. In this way, the “Monday” column will have a “1” in each row that is a Monday. This is a

dummy variable for day of wee (and so on). We don’t need “Sunday” because we are measuring the

effect of Mon-Sat against Sunday.

Create a column for “Holiday”. Look at the list of holidays. Put a “1” for each day that is a holiday, and a

“0” in the rest of the rows.

Make sure everything you think is a predictor (X-variable) is together. You may have to move columns

around. (When you do regression, Excel cannot highlight non-contiguous cells).

Perfor

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.