version 3				version 3
sku	family	margin	price per case	beginning inv	safety stock	cases per shift	line	inventory classification	Description	UOM	08-2023	09-2023	10-2023	11-2023	12-2023	01-2024	02-2024	03-2024	04-2024
LINE 1
P1037	Best Breakfast	53%	$ 30.00	2,771	2,652	9,600	1	B	BBI MAPLE SPOONFUL 12X12OZ CS	CS	2,931	5,153	12,283	4,603	6,245	7,287	5,802	4,652	6,864
P1470	Best Breakfast	53%	$ 30.00	13,660	13,072	9,600	1	A	BB SPNFULS LG MUTL-GRN 14/24O	CS	6,156	27,586	40,567	29,208	27,586	40,567	29,208	27,586	40,567
P1521	Best Breakfast	53%	$ 30.00	1,587	1,518	7,400	1	C	BB GF BERRY PUFFIN 12X283G	CS	-	3,206	4,711	3,393	3,206	4,711	3,393	3,206	4,711
P1523	Best Breakfast	53%	$ 30.00	1,573	1,505	7,400	1	C	BB GF MG PUFFIN 12X283G	CS	-	1,318	4,671	3,363	3,177	4,671	3,363	3,177	4,671
P056	Private Label	53%	$ 23.99	1,599	1,530	960	1	C	FULL CIRCLE WHEAT SQUARE 13OZ	CS	-	1,318	3,934	3,934	3,934	3,934	3,934	3,934	3,934
P1006	Private Label	60%	$ 23.99	40,537	38,791	9,600	1	A	SPF MGRN SQ 10X12.3 OZ CS	CS	23,681	88,510	108,179	98,344	88,510	108,179	98,344	88,510	108,179
P1076	Private Label	50%	$ 23.99	1,453	1,390	7,200	1	C	ULTIMA HF 6X12 OZ CASE	CS	-	-	12,067	12,962	-	-	-	-	-
P1078	Private Label	50%	$ 23.99	385	369	7,200	1	C	ULTIMA POM 6X12 OZ CASE	CS	-	-	-	6,638	-	-	-	-	-
P1198	Private Label	50%	$ 23.99	4,933	4,721	7,200	1	A	365WF ORG FRT RIN10X12.25OZ CS	CS	1,888	9,441	14,162	11,801	9,441	14,162	11,801	9,441	14,162
P1217	Private Label	50%	$ 23.99	1,199	1,147	2,000	1	B	SVAL ORG WHT SQ 10X13OZ CASE	CS	-	-	-	3,442	3,442	3,442	3,442	3,442	3,442
P1326	Private Label	50%	$ 23.99	2,111	2,020	2,000	1	B	PUBLIX GW ORGFRTCIR 10X12.2 CS	CS	-	-	4,209	5,360	4,288	6,432	5,360	4,288	6,432
P1368	Private Label	50%	$ 23.99	987	944	2,000	1	B	NEW FD UNFI ORGWHTSQ 10X13OZCS	CS	6,304	5,665	-	5,665	-	5,665	-	5,665	-
P1386	Private Label	49%	$ 23.99	5,755	5,507	2,000	1	B	GRT VAL WM ORGCINSQ 10X12.2OZ	CS	13,945	11,015	16,522	13,768	11,015	16,522	13,768	11,015	16,522
P1514	Private Label	50%	$ 20.00	308	295	5,200	1	A	JC (CDN)CRAN ALM 60/42.5 CDN	CS	49	1,770	-	1,770	-	1,770	-	1,770	-
P1515	Private Label	50%	$ 20.00	308	295	5,200	1	A	JC MUL-GRN HOOPS 50/42.5 CDN	CS	30	1,770	-	1,770	-	1,770	-	1,770	-
P948	Private Label	50%	$ 20.00	1,028	983	2,000	1	A	TAANUG WHT SQ 12X13 OZ CASE	CS	-	5,547	-	5,901	-	5,901	-	5,901	-
P950	Private Label	50%	$ 20.00	4,818	4,611	2,000	1	B	SWY WHT SQ 12X13 OZ CS	CS	-	-	6,284	12,785	10,228	15,342	12,785	10,228	15,342
P1202	Trader Joe	70%	$ 31.99	10,448	9,998	7,600	1	A	TJ PUMPKIN O'S 24X12OZ CS	CS	-	-	-	127,848	52,123	-	-	-	-
P807	Trader Joe	68%	$ 31.99	9,701	9,284	7,600	1	A	TJ MG O'S 24X12.8 OZ CASE	CS	47,235	23,947	32,621	17,938	12,716	32,326	22,226	27,222	22,059
P874	Whole Foods	46%	$ 31.99	7,194	6,884	7,600	1	A	WF MGO 12X12.8 OZ CS	CS	23,209	13,768	20,652	17,210	13,768	20,652	17,210	13,768	20,652
P876	Whole Foods	46%	$ 31.99	3,267	3,126	2,000	1	C	WF ORG WHT WAF 12X13 OZ CS	CS	-	-	-	6,737	7,927	11,890	9,903	7,927	11,890
TOTAL
LINE 2
P101	Original	70%	$ 25.99	8,534.11	4,267	2,000	2	A	WEETABIX 24/200G	CS	-	-	6,874	7,573	11,851	18,803	14,014	6,904	10,788
P1264	Original	70%	$ 25.99	5,579	2,790	2,000	2	A	ORG WEETABIX CASE 12X14OZ	CS	4,701	5,547	8,654	6,579	5,547	8,654	6,579	5,547	8,654
P1294	Original	75%	$ 25.99	991	496	2,000	2	A	NEW WBX US REG 12X7 OZ CASE	CS	-	-	-	-	-	3,068	2,262	2,675	915
P1295	Original	65%	$ 25.99	28,318	14,159.01	2,000	2	A	NEW WBX US REG 12X14 OZ CASE	CS	53,509	41,521	100,488	72,067	65,291	107,068	56,656	65,429	71,044
P1298	Original	75%	$ 25.99	4,485	2,242	2,000	2	A	NEW CIN PUFFINS 12X285G CASE	CS	-	2,911	5,173	6,333	5,822	7,494	4,829	4,180	6,530
P704	Original	65%	$ 25.99	51,648	25,824	2,000	2	A	WBX 12X400G CASE	CS	-	24,330	77,987	46,183	63,265	75,283	52,998	59,646	89,474
TOTAL
LINE 3
P1472	Best Breakfast	75%	$ 31.99	20,058	18,833	9,500	3	A	SHRDED SPNFUL MLTGRN 12/14OZ	CS	59,695	54,552	72,834	50,923	46,055	39,082	28,402	36,673	65,035
P647	Best Breakfast	75%	$ 31.99	5,627	5,283	4,000	3	A	GRAINSHOP 12X475G CS	CS	1,131	4,721	14,024	11,477	14,004	12,460	12,165	12,087	18,882
P750	Best Breakfast	75%	$ 23.99	936	879	7,500	3	C	ORIGINAL PUFFINS 12X285G CASE	CS	-	2,763	2,527	3,088	2,459	1,652	2,164	1,534	2,400
P1031	Private Label	50%	$ 23.99	4,463	4,191	5,600	3	C	TOPCO ORG BF 10X15 OZ CS	CS	-	-	-	6,589	13,768	13,768	13,768	13,768	13,768
P1044	Private Label	50%	$ 23.99	2,308	2,167	4,000	3	C	CINN SH OATS 6X14 OZ CASE	CS	6,284	4,839	10,995	4,730	6,333	6,687	3,019	2,400	4,839
P1046	Private Label	50%	$ 23.99	20,478	19,228	4,000	3	A	ORIGINAL SH OATS 12X14 OZ CASE	CS	63,698	45,632	67,504	41,177	43,891	45,248	45,927	33,594	68,762
P1048	Private Label	50%	$ 23.99	2,585	2,427	5,000	3	C	VASO 6X14 OZ CASE	CS	-	2,508	9,815	8,969	6,933	5,881	4,396	3,747	3,953
P1307	Private Label	50%	$ 23.99	2,514	2,360	5,600	3	C	BM FLAKES+STRAWB 10X400G CS	CS	11,801	4,721	7,081	5,901	4,721	7,081	5,901	4,721	7,081
P1309	Private Label	50%	$ 23.99	2,095	1,967	5,600	3	C	BM FLAKE TROP MANGO 10X400G CS	CS	9,569	3,934	5,901	4,917	3,934	5,901	4,917	3,934	5,901
P1370	Private Label	50%	$ 23.99	1,508	1,416	5,600	3	C	NEW FDUNFI ORGBRFLK 10X14OZ CS	CS	-	7,789	-	8,497	-	8,497	-	8,497	-
P777	Private Label	50%	$ 23.99	5,446	5,114	4,800	3	A	PC CRNBRY ALM 12X475G CS	CS	6,982	10,228	15,342	12,785	10,228	15,342	12,785	10,228	15,342
P778	Private Label	50%	$ 23.99	4,189	3,934	4,800	3	A	PC MAPLE ALM 12X460G CS	CS	9,156	7,868	11,801	9,834	7,868	11,801	9,834	7,868	11,801
P779	Private Label	50%	$ 23.99	773	726	4,800	3	A	PC MIX BERRY 12X425G CS	CS	-	-	1,269	1,967	1,574	2,360	1,967	1,574	2,360
P780	Private Label	50%	$ 23.99	965	906	4,800	3	A	PC BM CRN ALM 12X460G CS	CS	-	-	-	-	-	1,564	4,917	3,934	5,901
P878	Private Label	50%	$ 23.99	6,703	6,294	6,000	3	B	WF ORG BF 12X15 OZ CS	CS	-	6,668	18,882	15,735	12,588	18,882	15,735	12,588	18,882
P974	Private Label	50%	$ 23.99	1,676	1,574	5,600	3	A	PC MGO 10X390G CS	CS	7,868	3,147	4,721	3,934	3,147	4,721	3,934	3,147	4,721
P1068	Trader Joe	50%	$ 31.99	6,406	6,015	7,500	3	A	TJ CIN PUFFINS 20X16 OZ CASE	CS	-	1,583	19,177	16,276	11,772	15,371	14,388	15,499	15,784
TOTAL
LINE 4
P1060	Best Breakfast	53%	$ 29.99	27,729	25,794	7,400	4	A	ORIGINAL PUFFINS 12X10 OZ CASE	CS	-	33,358	99,407	72,667	62,960	58,987	48,425	44,255	77,594
P1062	Best Breakfast	50%	$ 29.99	5,073	4,719	7,400	4	A	GF H RICE PUFF 12X10 OZ CASE	CS	-	-	-	12,588	13,975	17,102	12,814	11,634	16,827
P1064	Best Breakfast	52%	$ 29.99	19,081	17,750	7,400	4	A	CIN PUFFINS 12X10 OZ CASE	CS	-	-	47,687	51,159	40,862	51,493	40,872	33,437	53,981
P1066	Best Breakfast	50%	$ 29.99	5,191	4,829	7,400	4	A	GF MG PUFFINS 12X10 OZ CASE	CS	-	-	20,662	4,485	13,119	18,823	10,838	8,802	10,198
P1097	Best Breakfast	50%	$ 29.99	1,285	1,195	4,000	4	C	SNACKIMALS CHOC CRSP 12X9OZ CS	CS	-	-	2,449	3,236	2,085	5,370	2,508	2,950	2,921
P1103	Best Breakfast	50%	$ 29.99	848	788	3,400	4	A	ALPEN US CHOC12X11.8 OZ CS	CS	-	-	-	-	2,734	2,980	3,009	2,095	3,373
P1110	Best Breakfast	50%	$ 29.99	1,623	1,510	4,000	4	C	SNACKIMALS VANILLA 12X9OZ CS	CS	-	-	4,770	3,226	3,462	4,740	4,003	3,304	3,668
P1111	Best Breakfast	50%	$ 29.99	1,912	1,778	4,000	4	C	SNACKIMALS CINNAMON 12X9OZ CS	CS	3,059	4,465	6,215	3,963	3,580	5,773	3,344	3,481	5,655
P1116	Best Breakfast	55%	$ 29.99	4,265	3,968	3,400	4	A	CDN ALPEN CHOC 530G/12 CS	CS	-	4,485	11,929	8,556	9,136	12,293	9,343	7,868	12,293
P1192	Best Breakfast	50%	$ 29.99	84	78	3,100	4	C	BBI CHOCO CRNBRY GRANOLA 12X10	CS	-	-	-	1,406	-	-	-	-	-
P1194	Best Breakfast	50%	$ 29.99	1,310	1,219	3,100	4	C	BBI OAT & HONEY GRANOLA12X10OZ	CS	5,871	9,441	14,339	7,602	-	-	-	-	-
P1263	Best Breakfast	50%	$ 29.99	8,678	8,072	7,400	4	A	PUMPKIN PUFFINS 12X10 OZ CASE	CS	-	-	34,421	73,758	37,125	-	-	-	-
P1502	Best Breakfast	50%	$ 29.99	4,111	3,825	7,400	4	A	BB BERRY PUFFINS 12 X 10OZ CS	CS	-	-	7,612	9,185	8,674	12,755	9,185	8,674	12,755
P498	Best Breakfast	55%	$ 30.99	10,740	9,991	3,400	4	A	ALPEN 12X650G CS	CS	30,851	13,758	36,800	17,781	21,675	32,109	20,869	19,748	30,851
P500	Best Breakfast	55%	$ 30.99	16,200	15,070	3,400	4	A	ALPEN NSNS 12X650G CS	CS	42,209	27,536	48,887	27,615	35,699	49,831	31,460	30,349	47,422
P676	Best Breakfast	55%	$ 30.99	5,393	5,017	3,400	4	A	ALPEN US REG 12X14 OZ CS	CS	-	-	19,325	10,474	12,008	18,135	6,855	5,084	18,420
P678	Best Breakfast	55%	$ 30.99	13,923	12,951	3,400	4	A	ALPEN US NSNS 12X14 OZ CS	CS	30,349	33,221	48,592	28,008	30,693	52,644	14,417	11,201	47,569
P1088	Private Label	51%	$ 23.99	7,174	6,673	4,600	4	B	WF CIN TOAST 12X10 OZ CS	CS	16,669	13,345	20,023	16,679	13,345	20,023	16,679	13,345	20,023
P1143	Private Label	51%	$ 23.99	8,035	7,474	4,600	4	A	PC FRUITY O'S 12X580G CS	CS	20,220	14,948	22,423	18,685	14,948	22,423	18,685	14,948	22,423
P1219	Private Label	50%	$ 23.99	302	281	6,000	4	C	AWG ORG CINN SQ 12X10OZ CASE	CS	-	-	-	-	-	5,053	-	-	-
P1324	Private Label	50%	$ 23.99	3,383	3,147	6,000	4	B	PUB GW ORGCINSQ 12X10OZ CS	CS	1,770	6,294	9,441	7,868	6,294	9,441	7,868	6,294	9,441
P1328	Private Label	50%	$ 23.99	2,672	2,486	6,000	4	B	TOPCO FC ORGCINSQ 12X10OZ CS	CS	4,907	6,392	6,392	6,392	6,392	6,392	6,392	6,392	6,392
P1330	Private Label	50%	$ 23.99	2,100	1,953	6,000	4	B	AHOLD ORGCINSQ 12X10OZ CS	CS	18,912	4,180	5,655	4,917	4,180	5,655	4,917	4,180	5,655
P1369	Private Label	50%	$ 23.99	1,269	1,180	6,000	4	C	NEW FDUNFI ORGCINSQ 12X10OZ CS	CS	10,621	-	7,081	-	-	7,081	-	-	7,081
P1465	Private Label	50%	$ 23.99	740	688	4,000	4	C	HUGO CHOC HUGE - O'S 10X10 OZ	CS	-	-	-	-	-	3,540	2,950	2,360	3,540
P1467	Private Label	50%	$ 23.99	1,185	1,102	4,000	4	C	FRUITY PANDAS 10 X 10OZ-NEW	CS	-	-	-	-	1,249	5,311	4,425	3,540	5,311
P1535	Private Label	50%	$ 23.99	1,480	1,377	2,800	4	C	MKT BSKT ORG CINN SQ 12X10OZ	CS	-	-	4,130	3,442	2,754	4,130	3,442	2,754	4,130
P1552	Private Label	50%	$ 23.99	2,820	2,624	6,400	4	B	FRSH THYM ORG CINN SQ 12X10OZ	CS	16,394	5,252	7,868	6,560	5,252	7,868	6,560	5,252	7,868
P1554	Private Label	50%	$ 23.99	2,820	2,624	6,400	4	B	FRSH THYM NGMO FRT CIRCL 10X10	CS	16,394	5,252	7,868	6,560	5,252	7,868	6,560	5,252	7,868
P624	Private Label	50%	$ 23.99	2,960	2,754	5,500	4	A	PC BM FLK & FIBR 12X450G CS	CS	-	4,534	8,261	6,884	5,507	8,261	6,884	5,507	8,261
TOTAL
LINE 5
P1139	Private Label	50%	$ 23.99	21,203	21,636	2,500	5	A	PC CF 12X680G CS	CS	82,383	43,272	64,907	54,089	43,272	64,907	54,089	43,272	64,907
P1141	Private Label	50%	$ 23.99	13,107	13,375	2,500	5	A	PC FF 10X680G CS	CS	56,843	26,750	40,125	33,437	26,750	40,125	33,437	26,750	40,125
P178	Private Label	50%	$ 23.99	10,023	10,228	2,500	5	A	PC BM FIBRE FIRST 12/525G	CS	15,420	20,456	30,683	25,570	20,456	30,683	25,570	20,456	30,683
P207	Private Label	50%	$ 23.99	1,291	1,318	2,500	5	A	PC ORG RAISIN BRAN 12/475 GM	CS	6,589	2,636	3,953	3,295	2,636	3,953	3,295	2,636	3,953
P266	Private Label	50%	$ 23.99	2,506	2,557	2,500	5	A	PC WHEAT SQUARES 12/620 G	CS	6,088	5,114	7,671	6,392	5,114	7,671	6,392	5,114	7,671
P369	Private Label	51%	$ 23.99	16,191	16,522	2,500	5	A	PC BM BRAN FLAKE 10/775 GM	CS	74,673	33,044	49,566	41,305	33,044	49,566	41,305	33,044	49,566
P1072	Trader Joe	50%	$ 31.99	6,974	7,116	10,000	5	A	TJ PUFFINS 14X18 OZ CASE	CS	-	-	-	19,915	17,309	25,963	21,636	17,309	25,963
P1074	Trader Joe	52%	$ 31.99	6,850	6,990	10,000	5	A	TJ SH OATS 20X18 OZ CASE	CS	10,818	14,044	21,616	15,696	14,496	22,914	12,932	23,986	14,171
TOTAL

A scheduler's job is to take outputs from S&OP, aggregate planning, MRP and MPS and to make this data usable to the organization in the form of a production schedule. Based on this production schedule other departments can plan human resources, maintenance etc.

Based on the supplied Master Production Schedule and production constraints build a daily (by shift) breakfast cereal production schedule for six weeks in 2023 by line by product.

Include in your submission:

• A summary as to your thinking and strategy. Why did you choose these particular strategies and tactics? Do you have any conclusions regarding the schedule?
• Percentage of demand in total, by family and by sku that you produced by this plan
• The number of changeovers that were necessary to complete plan
• The total dollar contribution if you were able to produce every case and the percentage of that which was actually produced
• What version of the assignment you are working on
• Please save your assignment in the following form "Assignment 4-version x- name"
• Place in Dropbox by due date
• Failure to include the above in the submission will result in significant reduction in grade

The assignment will be marked both objectively and subjectively. Please ensure that your submission contains each of the points above. It will be marked out of 40 (summary worth 24 and Excel worth 16) and is worth 17.5% of the course grade.

Version 3 instructions:

• Choose three of the five production lines to make plans for
• Make a by shift by day by sku (stock keeping unit) by line production plan for the six weeks beginning in September 23 and running through to the end of October
• You must not exceed line capacity
• If you have two weeks in a month to schedule remember to split the monthly volume
• You may encounter situations where you have too much or too little capacity; in the latter it will be up to you to determine priority skus to produce
• Complete the assignment using the Excel template provided

Version 3 constraints:

• Due to freshness concerns one can only build inventory six weeks in advance
• Families need to be run together as much as possible
• Each family change incurs a changeover; each changeover is one half shift (4 hours)
• Each change of families incurs a large changeover worth one full shift (8 hours)
• The plant runs 3 shifts a day 5 days a week. Overtime is available, but overtime costs 1.5 times more than regular shifts and the plant is restricted to two overtime shifts a week
• Due to Christmas vacation the plant is down the last week of December
• Due to New Year's Day there is a vacation day on January 1
• Due to Family Day, there is a vacation day the third Monday of February
• Due to Thanksgiving, there is a vacation day the second Monday of October
• There is one cleaning shift per week, typically the last shift of the week
• Line 1 is down for three days (September 25,26,27) for Maintenance
• Line 2 is down for one week in January for Maintenance
• Line 3 is down for one week in October for Maintenance
• Line 4 is down for one week in February for Maintenance