Case Study 1 – Three Jays Corporation Dinh Phan - 831512392
ECN 253 Case Study Report 1: THREE JAYS CORPORATION
(complete solution)
(Due: 11:55 PM, June 26th)
Hi Dihn:
Please find this annotated write-up and my Excel spreadsheet. My comments are in RED font
below. I suggested them for Q1-Q2 and Q3-Q4 together for better flow of logic. Your final score
(now available on Canvas) is shown at the end of this document. As this was the first case
analysis of the course, I have graded your write-up based on your ideas and supporting logic, not
whether your answers are right or wrong.
Make a cover page next time.
1. Using the data in case Exhibit 4 and the 2012 annual demand, calculate the EOQ and ROP
quantities for the five SKUs scheduled to be produced in the last week of June. How do these
amounts compare with those calculated in 2011? Compare the increases in EOQs with the increases
in annual demand. (2.5 points)
The 2012 Annual Demand is given as
Exhibit 5: Monthly Sales Data
Ja Fe Ma Oc Year
Label Type
n b Mar Apr y June July Aug Sept t Nov Dec Total
3Js Strawberry Jam
2012 345 301 325 299 344 296 329 334 349 325 289 333 3,869
2013 566 671 384 631 616 2,868
Marran
Raspberry Jelly
Markets
2012 229 270 236 279 273 255 236 232 235 276 244 241 3,006
2013 744 737 425 379 571 2,856
Kerry's Marts Peach Jam
2012 156 176 174 144 160 178 155 159 178 166 176 148 1,970
2013 167 146 78 84 117 592
Dom's Food
Blueberry Jam
Stores
2012 92 109 98 99 102 111 103 99 94 104 107 93 1,211
2013 100 99 80 139 108 526
AAA Grocers Apple/Mint Jelly
2012 66 77 79 69 65 66 68 67 62 74 71 68 832
2013 73 63 110 146 88 480
The EOQ and ROP quantities for the five SKU’s based on 2012 annual demand is given as
Page 1 of 10
, Case Study 1 – Three Jays Corporation Dinh Phan - 831512392
Page 2 of 10
ECN 253 Case Study Report 1: THREE JAYS CORPORATION
(complete solution)
(Due: 11:55 PM, June 26th)
Hi Dihn:
Please find this annotated write-up and my Excel spreadsheet. My comments are in RED font
below. I suggested them for Q1-Q2 and Q3-Q4 together for better flow of logic. Your final score
(now available on Canvas) is shown at the end of this document. As this was the first case
analysis of the course, I have graded your write-up based on your ideas and supporting logic, not
whether your answers are right or wrong.
Make a cover page next time.
1. Using the data in case Exhibit 4 and the 2012 annual demand, calculate the EOQ and ROP
quantities for the five SKUs scheduled to be produced in the last week of June. How do these
amounts compare with those calculated in 2011? Compare the increases in EOQs with the increases
in annual demand. (2.5 points)
The 2012 Annual Demand is given as
Exhibit 5: Monthly Sales Data
Ja Fe Ma Oc Year
Label Type
n b Mar Apr y June July Aug Sept t Nov Dec Total
3Js Strawberry Jam
2012 345 301 325 299 344 296 329 334 349 325 289 333 3,869
2013 566 671 384 631 616 2,868
Marran
Raspberry Jelly
Markets
2012 229 270 236 279 273 255 236 232 235 276 244 241 3,006
2013 744 737 425 379 571 2,856
Kerry's Marts Peach Jam
2012 156 176 174 144 160 178 155 159 178 166 176 148 1,970
2013 167 146 78 84 117 592
Dom's Food
Blueberry Jam
Stores
2012 92 109 98 99 102 111 103 99 94 104 107 93 1,211
2013 100 99 80 139 108 526
AAA Grocers Apple/Mint Jelly
2012 66 77 79 69 65 66 68 67 62 74 71 68 832
2013 73 63 110 146 88 480
The EOQ and ROP quantities for the five SKU’s based on 2012 annual demand is given as
Page 1 of 10
, Case Study 1 – Three Jays Corporation Dinh Phan - 831512392
Page 2 of 10
