Flipped Assignment 5

Fair Trades

Benny Reyna

Carlos Sandoval

Daniel Ibarra

1)      How many entries are in the datafile?

Answer: 6275201

Observations<-readRDS("D:/TTU/Fall 2023/IE-2341/R Work/FairTraders_Receipts_and_StorageBins.rds")

2)      What percentage of product was received by each business unit?

Answer:

15.3% ECOMMERCE

82.3% FESTIVAL

2.3% WHOLESALE

prop.table(table(Observations$CustGroup))

## 
##  ECOMMERCE   FESTIVAL  WHOLESALE 
## 0.15319015 0.82290687 0.02390298

3)      What percentage of orders were Purchase Orders?

Answer: 15.3%

prop.table(table(Observations$SourceType))

## 
## Purchase Order Supplier Order 
##      0.1531902      0.8468098

4)      What percentage of orders were received by the eCommerce business unit through a Purchase Order?

Answer: 15.3%

prop.table(table(Observations$SourceType))

## 
## Purchase Order Supplier Order 
##      0.1531902      0.8468098

prop.table(table(Observations$CustGroup))

## 
##  ECOMMERCE   FESTIVAL  WHOLESALE 
## 0.15319015 0.82290687 0.02390298

5)      What percentage of orders were received by the Wholesale business unit through a Purchase Order?

Answer: 0%

prop.table(table(Observations$CustGroup,Observations$SourceType))

##            
##             Purchase Order Supplier Order
##   ECOMMERCE     0.15319015     0.00000000
##   FESTIVAL      0.00000000     0.82290687
##   WHOLESALE     0.00000000     0.02390298

6)      What percentage of orders were stored as a Pallet?

Answer: 49.7%

prop.table(table(Observations$BinSize))

## 
##       BASKET   CHICKENBOX   HALFPALLET    ODDSIZE3A       PALLET   TALLPALLET 
## 0.0020321261 0.4639943804 0.0252838116 0.0005806985 0.4971510873 0.0109578960

7)      What percentage of orders were received as a Purchase Order and stored in a Chicken Box? 

Answer: 7.5%

prop.table(table(Observations$SourceType,Observations$BinSize))

##                 
##                        BASKET   CHICKENBOX   HALFPALLET    ODDSIZE3A
##   Purchase Order 0.0002200726 0.0717017670 0.0018459966 0.0001958503
##   Supplier Order 0.0018120535 0.3922926134 0.0234378150 0.0003848482
##                 
##                        PALLET   TALLPALLET
##   Purchase Order 0.0754847534 0.0037417128
##   Supplier Order 0.4216663339 0.0072161832

8)      What percentage of orders were received as a Purchase Order or stored in a Chicken Box? 

Answer: 54.5% =(15.3%+(7.1%+39.2%)-7.1%)

prop.table(table(Observations$SourceType,Observations$BinSize))

##                 
##                        BASKET   CHICKENBOX   HALFPALLET    ODDSIZE3A
##   Purchase Order 0.0002200726 0.0717017670 0.0018459966 0.0001958503
##   Supplier Order 0.0018120535 0.3922926134 0.0234378150 0.0003848482
##                 
##                        PALLET   TALLPALLET
##   Purchase Order 0.0754847534 0.0037417128
##   Supplier Order 0.4216663339 0.0072161832

prop.table(table(Observations$SourceType))

## 
## Purchase Order Supplier Order 
##      0.1531902      0.8468098