Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Greyhound Company is considering changing its current inventory-control system for electronic picture frames. The information regarding one e-frame is given below: Averagedemand=260units/weekLeadtime=4weeksOrdercost=$55/orderUnitcost=$87Carryingchargerate=0.045Desiredservicelevel=85percentStandarddeviationofweeklydemand=43Numberofweeksperyear=52 Use the

image text in transcribed
image text in transcribed
The Greyhound Company is considering changing its current inventory-control system for electronic picture frames. The information regarding one e-frame is given below: Averagedemand=260units/weekLeadtime=4weeksOrdercost=$55/orderUnitcost=$87Carryingchargerate=0.045Desiredservicelevel=85percentStandarddeviationofweeklydemand=43Numberofweeksperyear=52 Use the FPS Safety Stock Excel template in MindTop to compute T and M for a foxed-period inventory system model with and without safety stock. Use the rounded EOQ value in your calculations. Use Appendix A to determine z-value. Round z-value to two decimal places. Do not round intermediate calculations. Round your answer for T up to the nearest whole number and round your answer for M to the nearest whole number. weeks \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hlinez & 0 & 0.01 & 0.02 & 0.03 & 0.04 & 0.05 & 0.06 & 0.07 & 0.08 & 0.09 \\ \hline 0 & 0.50000 & 0.50399 & 0.50798 & 0.51197 & 0.51595 & 0.51994 & 0.52392 & 0.52790 & 0.53188 & 0.53586 \\ \hline 0.1 & 0.53983 & 0.54380 & 0.54776 & 0.55172 & 0.55567 & 0.55962 & 0.56356 & 0.56749 & 0.57142 & 0.57535 \\ \hline 0.2 & 0.57926 & 0.58317 & 0.58706 & 0.59095 & 0.59483 & 0.59871 & 0.60257 & 0.60642 & 0.61026 & 0.61409 \\ \hline 0.3 & 0.61791 & 0.62172 & 0.62552 & 0.62930 & 0.63307 & 0.63683 & 0.64058 & 0.64431 & 0.64803 & 0.65173 \\ \hline 0.4 & 0.65542 & 0.65910 & 0.66276 & 0.66640 & 0.67003 & 0.67364 & 0.67724 & 0.68082 & 0.68439 & 0.68793 \\ \hline 0.5 & 0.69146 & 0.69497 & 0.69847 & 0.70194 & 0.70540 & 0.70884 & 0.71226 & 0,71566 & 0.71904 & 0.72240 \\ \hline 0.6 & 0.72575 & 0,72907 & 0.73237 & 0.73565 & 0.73891 & 0.74215 & 0.74537 & 0.74857 & 0.75175 & 0.75490 \\ \hline 0.7 & 0.75804 & 0.76115 & 0.76424 & 0.76730 & 0.77035 & 0.77337 & 0.77637 & 0.77935 & 0.78230 & 0.78524 \\ \hline 0.8 & 0.78814 & 0.79103 & 0.79389 & 0.79673 & 0.79955 & 0.80234 & 0.80511 & 0.80785 & 0.81057 & 0.81327 \\ \hline 0.9 & 0.81594 & 0.81859 & 0.82121 & 0.82381 & 0.82639 & 0.82894 & 0.83147 & 0.83398 & 0.83646 & 0.83891 \\ \hline 1 & 0.84134 & 0.84375 & 0.84614 & 0.84849 & 0.85083 & 0.85314 & 0.85543 & 0.85769 & 0.85993 & 0.86214 \\ \hline 1.1 & 0.86433 & 0.86650 & 0.86864 & 0.87076 & 0.87286 & 0.87493 & 0.87698 & 0.87900 & 0.88100 & 0.88298 \\ \hline 1.2 & 0.88493 & 0.88686 & 0.88877 & 0.89065 & 0.89251 & 0.89435 & 0.89617 & 0.89796 & 0.89973 & 0.90147 \\ \hline 1.3 & 0.90320 & 0.90490 & 0.90658 & 0.90824 & 0.90988 & 0.91149 & 0.91309 & 0.91466 & 0.91621 & 0.91774 \\ \hline 1.4 & 0.91924 & 0.92073 & 0.92220 & 0.92364 & 0.92507 & 0.92647 & 0.92785 & 0.92922 & 0.93056 & 0.93189 \\ \hline 1.5 & 0.93319 & 0.93448 & 0.93574 & 0.93699 & 0.93822 & 0,93943 & 0.94062 & 0.94179 & 0.94295 & 0.94408 \\ \hline 1.6 & 0.94520 & 0.94630 & 0.94738 & 0.94845 & 0.94950 & 0.95053 & 0.95154 & 0.95254 & 0.95352 & 0.95449 \\ \hline 1.7 & 0.95543 & 0.95637 & 0.95728 & 0.95818 & 0.95907 & 0.95994 & 0.96080 & 0.96164 & 0.96246 & 0.96327 \\ \hline 1.8 & 0.96407 & 0.96485 & 0.96562 & 0.96638 & 0.96712 & 0.96784 & 0.96856 & 0.96926 & 0.96995 & 0.97062 \\ \hline 1.9 & 0.97128 & 0.97193 & 0.97257 & 0.97320 & 0,97381 & 0.97441 & 0.97500 & 0.97558 & 0.97615 & 0.97670 \\ \hline 2 & 0.97725 & 0.97778 & 0.97831 & 0.97882 & 0.97932 & 0.97982 & 0.98030 & 0.9807 & 0.98124 & 0.98169 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management

Authors: Stephen P Robbins, Mary Coulter

11th Edition

9780273752776, 132163845, 273752774, 978-0132163842

More Books

Students also viewed these General Management questions