SOC 200 – Case Study Report 1: THREE JAYS CORPORATION (Complete Solution)

SOC 200 - Case Study Report 1:
THREE JAYS CORPORATION;
Complete solution.

Case Study Report 1: THREE JAYS CORPORATION



1. Using the data in case Exhibit 4 and the 2012 annual demand, calculate the EOQ and ROP
j j j j j j j j j j j j j j j j j




quantities for the five SKUs scheduled to be produced in the last week of June. How do these amounts
j j j j j j j j j j j j j j j j j j j




compare with those calculated in 2011? Compare the increases in EOQs with the increases in annual
j j j j j j j j j j j j j j j j




demand. (2.5 points)
j j




The 2012 AnnualDemand is given as
j j j j j j




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 j



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
j Peach Jam j




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
j j



Blueberry Jam j



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
j j j j j j j j j j j j j j j j




SOC 200 - Case Study Report 1:
THREE JAYS CORPORATION;
Complete solution.

,SOC 200 - Case Study Report 1:
THREE JAYS CORPORATION;
Complete solution.
Total Annual
j Carryin Unit
j EOQ
j j ROP
Set up
j Deman j g Cost
j Cost(C) (cases)
j j (cases)
cost(S) d (D)
j (i) %
j j




Strawberry Jam
j 63.7 3869 9% 28.34 440 223
Raspberry Jam
j 63.7 3006 9% 30.52 373 173
Peach Jam
j 63.7 1970 9% 26.86 322 114
Page 1 of 12
j j j




SOC 200 - Case Study Report 1:
THREE JAYS CORPORATION;
Complete solution.

,SOC 200 - Case Study Report 1:
THREE JAYS CORPORATION;
Complete solution.
SOC200 - CaseStudy Report 1:THREEJAYS j j j j j j j j j




CORPORATION; Complete solution. j j




Blueberry Jam j 63.7 1211 9% 29.01 243 70
Apple/Mint Jelly j 63.7 832 9% 26.32 212 48




As Demand increased from 2011 to 2012, the EOQ’s also increased
j j j j j j j j j j




Deman j Deman j Increase j EOQ j EOQ j Increase j




d(2012) in (2010) (2012) in EOQ
d(2010)
j j j




Demand
j




2993 3869 29.27% 387 440 13.70%
2335 3006 28.74% 329 373 13.37%
1492 1970 32.04% 280 322 15.00%
886 1211 36.68% 208 243 16.83%
625 832 33.12% 183 212 15.85%

So, if Annual Demand doubles, the EOQ will increase by sqrt(2)
j j j j j j j j j j




2. Brodie is uncertain if the costs presented in case Exhibit 2 are appropriate for determining the
j j j j j j j j j j j j j j j j




EOQs. What changes would you recommend, and why? Should the cost of the three idle part-time
j j j j j j j j j j j j j j j j




workers be included when the production line is down? Using the 2012 annual demand, and your
j j j j j j j j j j j j j j j j




recommendations, recalculate the EOQs for the five SKUs. (2.5 points) j j j j j j j j j




In set up costs, the cost of part time workers should also be included, as they are idle at that time.
j j j j j j j j j j j j j j j j j j j j j




Assuming the salary of each part time worker to be half that of full time worker
j j j j j j j j j j j j j j j




So, Total salary of 3 part time workers, during idle time of 1 hour = 3*0.5*23.5 = $35.25So,
j j j j j j j j j j j j j j j j j j j




new set up cost = $63.7 + $35.25 = $98.95
j j j j j j j j j




In carrying cost, storage cost was considered as 0%, which should be more because, there is always
j j j j j j j j j j j j j j j j j




an opportunity cost of storing one inventory over another.
j j j j j j j j




SOC 200 - Case Study Report 1:
THREE JAYS CORPORATION;
Complete solution.

, SOC 200 - Case Study Report 1:
THREE JAYS CORPORATION;
Complete solution.
So, considering storage cost as 2%, new carrying cost = 6% + 2% + 3% = 11%
j j j j j j j j j j j j j j j j j




Some of the basic assumptions of EOQ are debated
j j j j j j j j




• The demand is not uniform throughout the year, which may lead to stock outs
j j j j j j j j j j j j j




• The order of new batch takes time and is not done instantly. For this case, the ROP should be adjusted to
j j j j j j j j j j j j j j j j j j j j j




include the lead time to place order
j j j j j j




Page 2 of 12
j j j




SOC 200 - Case Study Report 1:
THREE JAYS CORPORATION;
Complete solution.