Please Show the equations for each cell in Excel.

Ken Stark is an operations analyst for an

insurance company in Muncie, Indiana. Over the next $6$ weeks the company

needs to send $2,028,415$ pieces of marketing literature to customers in the

following $16$ states:

In order to coordinate with other marketing efforts, all the mailings for a given

state must go out the same week $($i$.$e$.,$ if Ken decides to schedule mailings for

Georgia in week $2,$ then all of the $136,562$ pieces of mail for Georgia must be

sent that week$).$ Ken 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$.$ Create a spreadsheet model to determine which states should be processed

each week in order to achieve Ken's objective.

b$.$ What is the optimal solution?