Need help doing an aggregated production plan in excel

Need help looking  for some help with this group assignment. For Ops/571