• So is this a homework assignment? There are missing details here, like what is the type of accounting periods are they expecting, calendar based or something like a 4-4-5 accounting? It if is calendar, then a solution is not too bad you just use a case statement for the January month in terms of changing some of its values. Then of the remaining you need to compensate for the offset.