Question: The Greyhound Company is considering changing its current inventory-control system for electronic picture frames. The information regarding one e-frame is given below: Average demand =

The Greyhound Company is considering changing itsThe Greyhound Company is considering changing itsThe Greyhound Company is considering changing its

The Greyhound Company is considering changing its current inventory-control system for electronic picture frames. The information regarding one e-frame is given below: Average demand = 210 units/week Lead time = 3 weeks Order cost = $55/order Unit cost = $78 Carrying charge rate = 0.065 Desired service level = 90 percent Standard deviation of weekly demand = 49 Number of weeks per year = 52 Use the FPS Salety Stock Excel template in MindTap to compute T and M for a fixed-period inventory system model with and without safety stock. Use the rounded EOQ value in your calculations. Use Appendix A to determine 2-value. Round 2-value to two decimal places. Do not round intermediate calculations. Round your answer for up to the nearest whole number and round your answer for M to the nearest whole number. T: weeks M: Average Annual Demand Ordering Cost Unit Cost Carrying Charge Rate Lead time (weeks) Standard deviation of weekly demand Service level 15000.00 $45.00 $3.801 0.20 2.00 71.00 0.95 Economic Order Quantity 1332.78) Order cost $506.46 Inventory cost $506.46 Total cost $1,012.92 Review period (weeks, rounded up) Optimal replenishment level without safety stock Standard deviation of demand during T+L z-value Safety stock M-Level 5 2019.23 187.85 1.64 309 2328 N 0 0.01 0.02 0.03 0.04 0.05 0.06 0.07 0.08 0.09 0 0.50000 0.50399 0.50798 0.51197 0.51595 0.51994 0.52392 0.52790 0.53188 0.53586 0.1 0.57142 0.57535 0.539830.54380 0.54776 0.55172 0.55567 0.55962 0.56356 0.56749 0.57926 0.58317 0.58706 0.59095 0.59483 0.59871 0.60257 0.60642 0.2 0.61026 0.61409 0.3 0.61791 0.62172 0.62552 0.62930 0.63307 0.63683 0.64058 0.64431 0.64803 0.65173 0.4 0.65542 0.65910 0.66276 0.66640 0.67003 0.67364 0.67724 0.68062 0.68439 0.68793 0.5 0.69146 0.69497 0.69847 0.70194 0.70540 0.70884 0.71226 0.71566 0.71904 0.72240 0.6 0.72575 0.72907 0.73237 0.73565 0.73891 0.74215 0.74537 0.74857 0.75175 0.75490 0.7 0.75804 0.76115 0.76424 0.76730 0.77035 0.77337 0.77637 0.77935 0.78230 0.78524 0.8 0.78814 0.79103 0.79389 0.79673 0.79955 0.80234 0.80511 0.80785 0.81057 0.81327 0.9 0.81594 0.81859 0.82121 0.82381 0.82639 0.82894 0.83147 0.83398 0.83646 0.83891 1 0.84134 0.84375 0.84614 0.848490.85083 0.85314 0.85543 0.85769 0.85993 0.86214 1.1 0.86433 0.86650 0.86864 0.87076 0.87286 0.87493 0.87698 0.87900 0.88100 0.88298 1.2 0.88493 0.88686 0.88877 0.89065 0.89251 0.89435 0.89617 0.89796 0.89973 0.90147 1.3 0.90320 0.90490 0.90658 0.90824 0.90988 0.91149 0.91309 0.91466 0.91621 0.91774 1.4 0.91924 0.92073 0.92220 0.92364 0.92507 0.92647 0.92785 0.92922 0.93056 0.93189 1.5 0.93319 0.93448 0.93574 0.93699 0.93822 0.93943 0.94062 0.94179 0.94295 0.94408 1.6 0.94520 0.94630 0.94738 0.94845 0.94950 0.95053 0.95154 0.95254 0.95352 0.95449 0.95543 0.95637 0.95728 0.95818 0.95907 0.95994 0.96080 0.96164 0.96246 0.96327 1.7 1.8 0.96407 0.96485 0.96562 0.96638 0.96712 0.96784 0.96856 0.96926 0.96995 0.97062 1.9 0.97128 0.97193 0.97257 0.97320 0.97381 0.97441 0.97500 0.97558 0.97615 0.97670 2 0.97725 0.97778 0.97831 0.97882 0.97932 0.97982 0.98030 0.98077 0.98124 0.98169

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!