Ken Stark is an operations analyst for an insurance company in Muncie,
Indiana. Over the next 6 weeks, the company needs to send 930,089 mailing pieces to customers in 7 states:State Mailing Pieces
To coordinate with other marketing efforts, all the mailings for a given state must go out in the same week (i.e., if TAMUC decides to schedule mailings for AZ in week 2, then all of the 82,380 pieces of mail for AZ must be sent that week). TAMUC would like to balance the work load in each week as much as possible and, in particular, would like to minimize the maximum amount of mail to be processed in any given week during the 6-week period.
A. Implement the model in Excel and suggest an optimal solution?