Assignment_5

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

• Homework Help
• 4
• 100% (1) 1 out of 1 people found this document helpful

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

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

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

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

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern