Assignment_5 - Q1 A 50 40 10 B 2 of of items stocked Item...

Info icon This preview shows pages 1–4. Sign up to view the full content.

Q1 % of # of items stocked Item Annual Demand Value ($/Unit) 1245 48 $5.50 2137 52 $4.75 5879 185 $3.55 4258 732 $4.35 9873 215 $3.25 6891 75 $7.50 4281 550 $3.75 1597 95 $8.00 3541 334 $4.95 7413 488 $2.50 9512 92 $5.50 5921 110 $5.25 4832 214 $3.95 2218 12 $9.50 9867 45 $8.75 3247 A) % of # of items stocked Item # Annual Demand Value ($/Unit) 22.54 4258 732 $4.35 50% 16.94 4281 550 $3.75 10.29 3541 334 $4.95 15.03 7413 488 $2.50 6.59 4832 214 $3.95 2.93 1597 95 $8.00 40% 6.62 9873 215 $3.25 5.70 5879 185 $3.55 3.39 5921 110 $5.25 2.31 6891 75 $7.50 2.83 9512 92 $5.50 10% 1.39 9867 45 $8.75 1.48 1245 48 $5.50 1.60 2137 52 $4.75 0.37 2218 12 $9.50 3247 B) Class A inventory has the highest volume of value and should be paid more attention. A Class % of Items # of Items N.I.C.P.D 2) A 7% 630 630/20=31.5 B 33% 2970 2970/60=49.5
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

C 60% 5400 5400/120=45 126 3) i) Q*= √2(5,000)($45)/1.5= 212 steaks ii) Q*/2= 212/2=106 steaks iii) HC=Q*/2(H)= 212/2(1.5)= $70.66 iv) N=(D/Q*)= 5,000/212= $23.59 v) OC=D/Q*xS= (5,000/212)x45=$1,061.32 vi) TC=HC+OC=$70.66+$1,061.32=$1,131.98
Image of page 2
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: vii) T/N=250/23.59=10.6 days viii) ROP=d x L=5,000/250/4= 5 steaks Annual $ Vol. % of Annual $ Vol. $264.00 1.92% $247.00 1.80% $656.75 4.78% $3,184.20 23.17% $698.75 5.08% $562.50 4.09% $2,062.50 15.00% $760.00 5.53% $1,653.30 12.03% $1,220.00 8.88% $506.00 3.68% $577.50 4.20% $845.30 6.15% $114.00 0.83% $393.75 2.86% $13,745.55 Annual $ Vol. % of Annual $ Vol. Class $3,184.20 23.17% A $2,062.50 15.00% 50% A $1,653.30 12.03% A $1,220.00 8.88% B $845.30 6.15% B $760.00 5.53% B $698.75 5.08% B $656.75 4.78% 43% B $577.50 4.20% B $562.50 4.09% B $506.00 3.68% B $393.75 2.86% C $264.00 1.92% C $247.00 1.80% 7% C $114.00 0.83% C $13,745.55 A inventory should be checked and counted more frequently than others. N.I.C.P.D: number of items counter per day...
View Full Document

  • Winter '16
  • Management, class a, 3rd millennium, Annual demand

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern