Question: Please explain how to solve each question throughly with a formula. Ignore answers. (Excel work preferred) Yellow Press, Inc., buys paper in large rolls for
Please explain how to solve each question throughly with a formula. Ignore answers. (Excel work preferred)
Yellow Press, Inc., buys paper in large rolls for printing. Annual demand (D) for the paper-rolls is 2,250 units. It costs Yellow Inc. $875 to buy a roll. The annual holding cost (H) is 16 percent of the purchase cost of the roll. The cost to place an order (S) is $45. a. If Yellow Inc. want to minimize their total annual inventory costs, they should order rolls at a time. (Enter your response rounded up to the nearest whole number.) b. If Yellow Press Inc. places order as per the EOQ, their total annual inventory cost (i.e. sum of holding costs and ordering costs) is (Enter your response rounded to one decimal place.) c. Assuming 275 workdays per year, if Yellow Press Inc. places order as per the EOQ, the number of orders placed in a year are orders. (Enter your response rounded to one decimal place.) d. Assuming 275 workdays per year, if Yellow Press Inc. places order as per the EOQ, the time between orders is days. (Enter your response rounded to one decimal place.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
