*Please include excel formulas used* Fixed Interval Ordering 4. Create a spreads
ID: 379363 • Letter: #
Question
*Please include excel formulas used*
Fixed Interval Ordering 4. Create a spreadsheet called "Fixed Interval" and make a calculator that allows the user to enter the values in the bold boxes shown and computes annual demand, optimal order size and order cycle length. Hint: There is a helpful video that reminds you how to compute a Z 1 Fixed Interval Order 3 Daily demand value from a cumulative percentage under the standard normal cuve. 4 StdDev of demand Prod Days/y 6 Order Cost 7 Holding cost /unit/yr 8 Lead Time 10 Inventory 11 Service Lv 12 13 Annual demand 14 OrderSize 5 Order Cycle 23400 1200 12 5. Create a spreadsheet called "EPQ and make a calculator that allows EPQ the user to enter the values in the bold boxes shown and computes the other values. 3 Demand per day units produced per day ProdDays 6 Setup Costs Holding Costs/unit/y 10 Total annual demand 23400 12 EPQ 13 14 Eprod runs per year 9 79489326 15 6 Max inventory 17 8 Carrying Cost 19 Setup Cost 20 Total inventory Costs 5876 937978 21 22 Prod Cycle 23 24 Prod Run Time 2389 1958.98 2938.47 2938.467978 6. Be sure to fully close the Excel application after saving your file. Then submit your file to the dropbox and download it from the dropbox to make sure that your downloaded file is readable in Excel. If you do not do fully complete this step, your assignment MAY be assigned a zero. 26.54444444 4.778Explanation / Answer
Fixed Interval Daily Demand 90 StdDev of Demand 10 Prod Days /yr 260 Order Cost 75 Holding cost/ Unit/ yr 3 Lead Time 6 Inventory 500 Service Lvl 97% Annual Demand 23400 OrderSize 1200 Order Cycle 12 EPQ Demand per day 90 units produced per day 500 ProdSDays 260 Setup Costs 300 Holding Costs/ unit/ yr 3 Total annual demand 23400 EPQ 2389 #prod runs per year 9.794893261 Max Inventory 1958.98 Carrying Cost 2938.47 Setup Cost 2938.467978 Total Inventory Cost 5876.937978 Prod Cycle 26.54444444 Prod Run TIme 4.778
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.