Rubric for Online Discussion and discussion 3 answers
docx
keyboard_arrow_up
School
Purdue University *
*We aren’t endorsed by this school
Course
57000
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by AdmiralWolverine1375
Question 1
(10 points)
No initial posting exists to evaluate. 0 Points
Your final answer is incorrect but the work shows one or more steps that are correct. 1-6 Points
The final answer is incorrect but most of the work is correct. 7 Points
The final answer is incorrect with only a minor calculation error, or the final answer is correct but the work needs more detail. 8 Points
The final answer is correct and the work is complete. 10 points
Question 2 (10 points)
No initial posting exists to evaluate. 0 Points
Your final answer is incorrect but the work shows one or more steps that are correct. 1-6 Points
The final answer is incorrect but most of the work is correct. 7 Points
The final answer is incorrect with only a minor calculation error, or the final answer is correct but the work needs more detail. 8 Points
The final answer is correct and the work is complete. 10 points
Participation in Discussion (10 points)
No responses to other classmates were posted in this discussion forum.
0 Points
May include one or more of the following: 1-5 Points
Comments to only one other student's post.
Comments are not substantive, such as just one line or saying, “Good job” or “I agree.
Comments are off topic.
Comments to two or more classmates’ initial posts but only on one day of the week. Comments are substantive, meaning they reflect and expand on what the other student wrote.
6-7 Points
Comments to two or more classmates’ initial posts on more than one day. Comments are substantive, meaning they reflect and expand on what the other student wrote.
8-9 Points.
Comments to two or more classmates’ initial posts and to the instructor's comment (if applicable) on two or more days. Responses demonstrate an analysis of peers’ comments,
building on previous posts. Comments extend and deepen meaningful conversation and may include a follow-up question.
10 Points
Chap15 Prob12: In August of the current year, a car dealer is trying to determine how many cars of the
next model year to order. Each car ordered in August costs $20,000. The demand for the dealers next year models has the probability distribution shown in file P15_12.xlsx. Each car sells for $25,000. If demand for the next years cars exceeds the number of cars ordered in August, the dealer must reorder at a cost of $22,000 per car. Excess cars can be disposed of at $17,000 per car. Use simulation to determine how many cars to order in August. For your optimal order quantity, find a 95% confidence interval for the expected profit. Step 1: Enter all given values from problem into excel spreadsheet.
Step 2: Create table one entering in demand, full price sells revenue, disposal sales revenue, initial order
cost, reorder cost, and profit down the left column. Use the following formulas to find these values: demand = RANDBETWEEN(H9,H13), full price sells revenue =C17*C5, disposal sales revenue =(C12-
MIN(C17,C12))*C6, initial order cost =C12*C3, reorder cost =(C17-MIN(C17,C12))*C4, and profit =(C18+C19*C6)-(C20+C21*C4).
Step 3: Create table 2 by entering values 1-500 in the left column, enter 20/25/30/35/40 across the top of the rows to the right of the 1-500 values, enter profit calculated from the above table into a empty cell above the 1-500 values, highlight table, select data, then what if analysis, then data table, select demand of 33 from above table for the rows, select a cell outside of the table for the columns, and select ok to run simulation. Step 4: create a third table by entering order quantity, mean profit, and Std Dev in the column, use following formulas to find values: order quantity is just 20/25/30/35/40, mean profit =AVERAGE(C35:C534), and Std Dev =STDEV(C35:C534). Copy and drag first cells all the way to row labeled 40. Find Maximum profit using formula =MAX(C26:G26).
Step 5: Simulate a table to find 95% CI, standard error, etc. Select Data, Data Analysis, descriptive statistics, highlight table 2, chose 95% CI, and select ok. Use Excel formulas to find the following values for each of the 5 tables created: Sample Mean (x-bar) = Mean, Sample Std Dev = Standard Deviation, Standard error of x-bar = Standard error, n = count, t_alpha/2,n-1 =T.INV(1-0.05/2,C23-1), 95% confidence interval for mean of lower limit = =C19-C25*C22 and upper limit = =C19+C25*C22, B (margin of error) = =C25*C22, and Sample size determination of n = =ROUNDUP((C25*C21)^2/(C30/2)^2,0).
Step 6: Create table four by entering upper and lower limit averages for 95% CI using formulas: =AVERAGE('HW - 95% CI'!C27,'HW - 95% CI'!E27,'HW - 95% CI'!G27,'HW - 95% CI'!I27,'HW - 95% CI'!
K27,) for lower limit CI and =AVERAGE('HW - 95% CI'!C28,'HW - 95% CI'!E28,'HW - 95% CI'!G28,'HW - 95% CI'!I28,'HW - 95% CI'!K28,) for upper limit. Chap15 Prob33: A direct marketer of women’s clothing, must determine how many telephone operators to schedule during each part of the day. The company estimates that the number of phone calls received each hour of a typical eight hour shift can be described by the probability distribution in the file P15_33.xlsx. Each operator can handle 15 calls per hour and costs the company $20/hr. each phone call that is not handled is assumed to cost the company $6 in lost profit. Considering the options of employing 6, 8, 10, 12, 14, or 16 operators that minimizes the expected hourly cost (labor costs plus lost profits). Step 1: Enter all given values from problem into excel spreadsheet.
Step 2: Create table one with 1-1000 entered in a column, and add calls, max # of calls that can be handled, lost calls, lost call cost, operator cost, and total cost across the top rows. Step 3: Excel formulas used are as follows: calls (VLOOKUP(RAND(),$H$5:$I$9,2)), max # of calls that can be handled ($C$15*$C$11), lost calls (MAX(C17-D17,0)), lost call cost (E17*$C$12), operator cost ($C$15*$C$13), and total cost (F17+G17) for the first spreadsheet. Drag formula from first cell matching 1 all the way to cell matching 1000. Step 4: Obtain the average of the total cost from above table. Formula used AVERAGE(H17:H1016).
Step 5: Create a second table with # of operators in the columns using numbers 6, 8, 10, 12, 14, and 16 per above problem. In the second column write total cost at top and below in a blank space enter The average of the total cost above. Step 6: Copy table two above, click on data, then what if analysis and then data table. Input # of operators (10) into the columns portion and then select a blank cell outside the table and select ok. Step 7: Find the minimum of table twos Expected total cost by using MIN(K17:K1016) formula. 12 Operators as the lowest expected cost – this can change as the formulas are set using random numbers.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help