Sales and planning help? Operations Management problems

Need step by step, all work shown-all excel work shown step by step by 02/04/2016 no later than 9:25a.m. Thursday morning central standard time. Please put all final work in word, 12 font, times new roman, outside of what you add from excel as screen shot.

no incomplete work, all four problems I need to be completed with all work shown. no plagiarism no incomplete work, all original please and must be exact functions, tools, and charts needed for every question.