Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
Document preview thumbnail
Preview 2 out of 13 pages
Exam (elaborations)

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

Document preview thumbnail
Preview 2 out of 13 pages

Summary SOC 200 - Case Study Report 1: THREE JAYS CORPORATION; Complete solutionSummary SOC 200 - Case Study Report 1: THREE JAYS CORPORATION; Complete solution1. 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 Label Type Ja n Fe b Mar Apr Ma y June July Aug Sept Oc t Nov Dec Year Total 3Js Strawberry Jam , 631 616 2,868 Marran Markets Raspberry Jelly ,,856 Kerry's Marts Peach Jam ,970 Dom's Food Stores Blueberry Jam ,211 AAA Grocers Apple/Mint Jelly The EOQ and ROP quantities for the five SKU’s based on 2012 annual demand is given as Total Set up cost (S) Annual Deman d (D) Carryin g Cost (i) % Unit Cost (C) EOQ (cases) ROP (cases) Strawberry Jam 63.7 3869 9% 28. Raspberry Jam 63.7 3006 9% 30. Peach Jam 63.7 1970 9% 26. Page 1 of 12 A+ Case Study 1 – Three Jays Corporation Blueberry Jam 63.7 1211 9% 29.01 243 70 Apple/Mint Jelly 63.7 832 9% 26.32 212 48 As Demand increased from 2011 to 2012, the EOQ’s also increased Deman d (2010) Deman d (2012) Increase in Demand EOQ (2010) EOQ (2012) Increase in EOQ .27% .70% 2335 3006 28.74% .37% .04% .00% .68% .83% .12% .85% So, if Annual Demand doubles, the EOQ will increase by sqrt(2) 2. Brodie is uncertain if the costs presented in case Exhibit 2 are appropriate for determining the EOQs. What changes would you recommend, and why? Should the cost of the three idle part-time workers be included when the production line is down? Using the 2012 annual demand, and your recommendations, recalculate the EOQs for the five SKUs. (2.5 points) In set up costs, the cost of part time workers should also be included, as they are idle at that time. Assuming the salary of each part time worker to be half that of full time worker So, Total salary of 3 part time workers, during idle time of 1 hour = 3*0.5*23.5 = $35.25 So, new set up cost = $63.7 + $35.25 = $98.95 In carrying cost, storage cost was considered as 0%, which should be more because, there is always an opportunity cost of storing one inventory over another. So, considering storage cost as 2%, new carrying cost = 6% + 2% + 3% = 11% Some of the basic assumptions of EOQ are debated • The demand is not uniform throughout the year, which may lead to stock outs • The order of new batch takes time and is not done instantly. For this case, the ROP should be adjusted to include the lead time to place order Page 2 of 12 A+ Case Study 1 – Three Jays Corporation

Content preview

Summary SOC 200 -
b b b




CaseStudyReport1:
b b b b




THREEJAYS
b b




CORPORATION;
b




Completesolution.
b

, Stuvia.com - The Marketplace to Buy and Sell your Study Material
b b b b b b b b b b




Case Study 1 – Three Jays Corporation
b b b b b b 831512392



Case Study Report 1: THREE JAYS CORPORATION
b b b b b b




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




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




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




demand. (2.5 points)
b b b




The 2012 Annual Demand is given as
b b b b b b




Exhibit 5: Monthly Sales Data
b b b b




Fe Year
Label Type
Jan b Mar Apr May June July Aug Sept Oct Nov Dec Tota
b




3Js Strawberry Jam b
l

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 b



Markets
b




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




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 b



Blueberry Jam b



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




Total Annual Carryin Unit EOQ ROP
Set up
b b Deman
b g Cost
b b Cost (C)
b b (cases) (cases)
cost (S) d (D) (i) %
b b b




Strawberry Jam b 63.7 3869 9% 28.34 440 223
Raspberry Jam b 63.7 3006 9% 30.52 373 173

Page 1 of 12 b b b




Downloaded by: proved | b b b b




Distribution of this document is illegal b b b b b

Document information

Uploaded on
October 15, 2025
Number of pages
13
Written in
2025/2026
Type
Exam (elaborations)
Contains
Questions & answers
$21.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
STUVINTAGE
4.7
(6)
Sold
46
Followers
2
Items
911
Last sold
1 week ago


Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions