StudyDaddy Management Production Planning with Excel

Production Planning with Excel

Region 1 2015 Sales Summary

	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6	Product 7
Jan, 2015
Forecast Sales	10	20		12	20		34
Actual Sales	12	21		12	21		36
Feb, 2015
Forecast Sales	10	22		11	22		35
Actual Sales	11	23		11	23		40
Mar, 2015
Forecast Sales	11	22		14	22		41
Actual Sales	11	22		11	22		45
Apr, 2015
Forecast Sales	12	24	12	12	24	12	47
Actual Sales	13	25	13	13	25	13	50
May, 2015
Forecast Sales	12	24	12	10	24	12	49
Actual Sales	11	23	13	11	23	13	54
Jun, 2015
Forecast Sales	12	23	15	12	23	15	50
Actual Sales	12	24	16	12	24	16	56
Jul, 2015
Forecast Sales	13	23	18	13	23	18	52
Actual Sales	15	24	20	15	24	20	56
Aug, 2015
Forecast Sales	13	24	18	13	24	18	57
Actual Sales	15	24	20	15	24	20	60
Sep, 2015
Forecast Sales	14	23	16	14	23	16	59
Actual Sales	15	25	16	15	25	16	59
Oct, 2015
Forecast Sales	15	24	12	15	24	12	61
Actual Sales	16	26	11	16	26	11	62
Nov, 2015
Forecast Sales	15	25		15	25		65
Actual Sales	16	27		16	27		66
Dec, 2015
Forecast Sales	14	26		14	26		60
Actual Sales	15	28		15	28		61

Region 2 2015 Sales Summary

	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6	Product 7
Jan, 2015
Forecast Sales	12	19			20		35
Actual Sales	13	22		11	22		35
Feb, 2015
Forecast Sales	13	23		10	22		37
Actual Sales	12	24		13	24		40
Mar, 2015
Forecast Sales	12	21		10	21		39
Actual Sales	12	24		14	21		43
Apr, 2015
Forecast Sales	14	23	13	11	25	13	50
Actual Sales	13	21	12	12	23	14	48
May, 2015
Forecast Sales	14	25	13	11	25	14	49
Actual Sales	12	22	14	10	23	13	50
Jun, 2015
Forecast Sales	15	26	14	13	24	15	51
Actual Sales	10	24	16	14	26	17	55
Jul, 2015
Forecast Sales	15	22	17	12	25	17	52
Actual Sales	14	24	21	14	25	21	56
Aug, 2015
Forecast Sales	15	23	18	13	26	18	55
Actual Sales	15	25	19	17	24	21	59
Sep, 2015
Forecast Sales	16	21	19	15	26	16	58
Actual Sales	16	23	15	13	24	17	52
Oct, 2015
Forecast Sales	18	25	13	15	23	13	61
Actual Sales	17	23	12	15	26	12	55
Nov, 2015
Forecast Sales	17	27	10	16	24	10	65
Actual Sales	17	25		16	25	10	66
Dec, 2015
Forecast Sales	15	27		17	25		63
Actual Sales	15	27		14	28		60

Region 3 2015 Sales Summary

	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6	Product 7
Jan, 2015
Forecast Sales	10	20		10	20		34
Actual Sales	12	21		12	21		36
Feb, 2015
Forecast Sales	10	22		10	22		35
Actual Sales	11	23		11	23		45
Mar, 2015
Forecast Sales	11	22		11	22		41
Actual Sales	11	22		11	22		45
Apr, 2015
Forecast Sales	12	24	12	12	24	12	47
Actual Sales	13	25	13	13	25	13	50
May, 2015
Forecast Sales	12	24	12	12	24	12	49
Actual Sales	11	23	13	11	23	13	59
Jun, 2015
Forecast Sales	12	23	15	12	23	15	50
Actual Sales	12	24	16	12	24	16	56
Jul, 2015
Forecast Sales	13	23	18	13	23	18	52
Actual Sales	15	24	20	15	24	20	56
Aug, 2015
Forecast Sales	13	24	18	13	24	18	57
Actual Sales	15	24	20	15	24	20	60
Sep, 2015
Forecast Sales	14	23	16	14	23	16	59
Actual Sales	15	25	16	15	25	16	59
Oct, 2015
Forecast Sales	15	24	12	15	24	12	61
Actual Sales	16	26	11	18	26	11	62
Nov, 2015
Forecast Sales	15	25		15	25		65
Actual Sales	16	27		16	27	12	66
Dec, 2015
Forecast Sales	14	26		14	26		60
Actual Sales	15	28		15	28		61

Region 1 2016 Sales Forecasts

	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6	Product 7
Jan, 2016	14	24		17	24	12	59
Feb, 2016	15	25		18	25	12	65
Mar, 2016	16	26		17	26	15	70

Region 2 2016 Sales Forecasts

	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6	Product 7
Jan, 2016	14	24		15	24	12	61
Feb, 2016	15	25		17	25	12	62
Mar, 2016	16	26		14	26	15	70

Region 3 2016 Sales Forecasts

	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6	Product 7
Jan, 2016	14	24		15	24	12	61
Feb, 2016	15	25		15	25	12	69
Mar, 2016	16	26		14	26	15	70

Have a similar question?

Continue to edit or attach image(s).

Fast and convenient

Simply post your question and get it answered by professional tutor within 30 minutes. It's as simple as that!
Any topic, any difficulty

We've got thousands of tutors in different areas of study who are willing to help you with any kind of academic assignment, be it a math homework or an article.
100% Satisfied Students

Join 3,4 million+ members who are already getting homework help from StudyDaddy!