(Solved)Fixed Interval Ordering 4. Create a spreadsheet called “Fix
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.778
Expert Answer
Answer to Fixed Interval Ordering 4. Create a spreadsheet called “Fix. . .
OR