Answered step by step
Verified Expert Solution
Question
1 Approved Answer
indu 423 labThe table in Sheet Q1 provides daily data regarding the inventory movement of a product for a six month period. For any given
indu 423 labThe table in Sheet Q1 provides daily data regarding the inventory movement of a product for a six month period. For any given date the table provides information on the observed demand, whether an order placed or received from the supplier, end of day on-hand inventory level, and end of day backorder level. Using excel functions (including lookup&reference), extract the following information from this data set. a. Average and standard deviation of on-hand inventory and backorder levels. b. The dates and values when maximum on hand inventory and maximum backorder levels are observed. c. The fraction of the days that the on- hand inventory and backorder levels are more than their "average + 1*standard deviation". (Calculate for on-hand inventory and backorder levels separately) d. The fraction of the days the item was out of stock over this period. e. The fraction of the demand that is satisfied from available inventory. f. The average daily demand
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started