- Shopping Sheet E Dashboard 9 3 E 80 Y 3 Erau Instructure Com Courses 143577 Assignments 2813528 Choose Payment Hi 6 3 1 (453.92 KiB) Viewed 89 times
Shopping Sheet E Dashboard 9 3 E 80 y 3 erau.instructure.com/courses/143577/assignments/2813528 Choose Payment Hi... 6.3 Problem Set 3 Due: Sun Jul 3, 2022 11:59pm Attempt 1 . > . Settings E Home IN PROGRESS Next Up: Submit Assignment Product cost is $350 with a holding cost of 20 percent. . Fixed cost for each order your organization places with the vendor is $4,000. Respond to the prompts below using the following data set: Problem Set 3 - Q1 Data Set (XLXS) Problem 3 Download, open, and save each data set to your computer (must be saved to produce your uniq Open the data set saved on your computer, copy the table containing the data set, and then righ Al save the table as 'values' (very important) to produce your unique data set. Paste the table in a se worksheet for the problem. Work the problem from the data pasted in the new worksheet. Problem 1 Your organization sells X (provided in the data set below) units of a product every month. Data d product is as follows: Gmail YouTube Maps • Product cost is $250 with a holding cost of 24 percent. • Fixed cost for each order your organization places with the vendor is $1,000 . The production rate is 5,000. Problem Set 3 - Q2 Data Set (XLXS) tuqur Fotail Respond to the following questions: . What is the optimal order size for your organization? What is the annual holding cost of the optimal policy? How many orders per year does your organization place? 9 10 . What is the annual ordering cost? 11 12 Problem 2 13 14 Given the below data set, calculate the optimal production batch size, the annual set up and hol 15 16 17 18 19 20 norm 2 3 4 $ AutoSave Off 5 6 7 8 File Paste Clipboard Ready LA Home A 5 HC 7 Insert Arial BIU Font X B Input Demand, D Fixed cost per order, S= Cost per unit, C = Holding cost, h= Output EOQ= # of orders per year Annual order cost Page Layout 16 ✔ A A A- Cycle inventory (units) Cycle inventory (value) Annual holding cost Total inventory cost Question 1 Accessibility: Good to go fx 4 F C Problem S... Formulas % Alignment Number D 3,288 Data Problem Set 3 - Question 1. E and a standard deviation of 90 c Microsoft Search (Alt+Q) Just start typing here to bring Ffeatures to your fingertips and get help. Kaiser Anderson F Tell me more G KA H 1 0 8 4 F P Comments O liting J db LIN Analyze Data Analysis (please note demand provided to you is per month) K 0 L Share + 84%