Question: B D E 22 24 25 26 27 28 23 Part 2: Enter the requested information into the yellow cells. Round off to 1 decimal

B D E 22 24 25 26 27 28 23 Part 2: Enter the

B D E 22 24 25 26 27 28 23 Part 2: Enter the requested information into the yellow cells. Round off to 1 decimal point (Use the data given below for questions referring to Part 2) EOQ 250 units Daily Demand 25 units per day Lead time in days 10 days Desired service level should be at least 95.50% (note: Look up z-value in table) Standard Deviation of Demand during lead time and re 10 see note below (note this is not the daily sd of demand, but the sd over the entire review period + lead time) Inventory Position 212 units in stock Part 2, Question 1: What is the optimal review period days Part 2, Question 2: What is the target Inventory level? units Part 2, Question 3: How much should ordered? units 29 30 31 32 33 34 35 36 37 39 40 41 Grading Rubric Possible Earned Comments 15 15 15 15 15 15 20 20 20 20 15 15 100 100 P1 Quest1 P1 Quest2 P1 Quest3 P2 Quest 1 P2 Quest 2 P2 Quest 3 Totals 42 43 44 45 46 47 48

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!

D Hawk entered the market in early 2018. D Hawk manufactures camera drones, selling primarily to retailers. D Hawk is pleased with its financial performance over its first few years of operations,...

I & S Apparel Industries has provided its Balance Sheet and Financial Statement Notes on the first tab of the Excel Simulation below. The Controller has asked you to prepare the Statement of Cash...

In the tables below, cells that have a white background are to be hard coded with data. Cells with a yellow background must be populated with formulas. You are given a 30-year bond with 4 years...

Health Care Finance - week 3 financial excercises parts 1-3 hes385_V4_wk3_financial_exercises_worksheet - Excel Home Insert Drave Page Layout Formulas Data Review View Help O Search Times New Roma -...

help me to do excel project Part 3 You are providing an example analysis tool for off-site instruction. The data is from one of the community colleges in California. Complete the following: 1. Using...

Noah and Joan Arc live with their family in Dayton, OH. Noahs Social Security number is 434-11-3311. Noah was born on February 22, 1984, and Joan was born on July 1, 1985. Both enjoy good health and...

hello, please see attached I need help with. I only need the 2 tax memos since I already prepared the tax forms. I need an original paper with proper references APA format. Thanks ACC 700 Milestone...

Using the information provided in the chapter background and gathered from the exercise on CS2-15, Complete the following: a. Perform a risk assessment of BUS?s growth-related change initiatives,...

The pulp density formula gives: C = P (Pp-1) Pp (P-1) Where Cs is the solids concentration by mass, ps is the solids specific gravity, pp is the pulp specific gravity. Measurement of a thickener feed...

On October 3, 2014, Allarco Inc. issued 4,000 of its preferred shares for cash of $15 each. On November 19 the company issued 3,400 preferred shares in exchange for land with a fair market value of...

4 zet Concepts erg L . P . A French corporation imports goods from the United States and expects to pay in U . S . dollars in six months. To hedge against potential exchange rate fluctuations, the...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...