Math  /  Data & Statistics

QuestionThe following excel screenshot presents calculating the average profit (from 20 replications) of a supplier. Thie monthly demand follows a normal distribution with mean 50 and standard deviation 5 . The order quantify of any month is equal to the demand quantity from the previous month. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline , & A & B & C & D & E & F & G & H & I \\ \hline 1 & \multicolumn{2}{|l|}{Simulation: Order Quatity} & & & & & & & \\ \hline 2 & & & & & & & & & \\ \hline 3 & Month & Demand & Order & Pruchase Cost & Cost of Unsatisfied Demand & Cost of Unsold Units & Item Sold & Revenue & Profit \\ \hline 4 & 1 & 53 & 41 & \123.00 & \$24.00 & \$12.00 & 41 & \$205.00 & \46.00 46.00 \\ \hline 5 & 2 & 58 & 53 & $159.00\$ 159.00 & \10.00 & \5.00 5.00 & 53 & \265.00 & \91.00 91.00 \\ \hline 6 & 3 & 52 & 58 & \174.00 & \0.00 0.00 & $0.00\$ 0.00 & 52 & $260.00\$ 260.00 & $86.00\$ 86.00 \\ \hline 7 & 4 & 48 & ? & \156.00 & \0.00 0.00 & $0.00\$ 0.00 & 48 & $240.00\$ 240.00 & $84.00\$ 84.00 \\ \hline 8 & 5 & 42 & 48 & $144.00\$ 144.00 & $0.00\$ 0.00 & $0.00\$ 0.00 & 42 & \210.00 & \66.00 66.00 \\ \hline 9 & 6 & 50 & 42 & \126.00 & \$16.00 & \$8.00 & 42 & \$210.00 & \$60.00 \\ \hline 10 & & & & & & & & Total & \$433.00 \\ \hline \end{tabular} \left|\right.\begin{tabular}{|l|c|} \hline Unit Revenue & \5.00 5.00 \\ \hline Unit Cost & $3.00\$ 3.00 \\ \hline Cost of Unsatifled Demand & $2.00\$ 2.00 \\ \hline Cost of Unsold Unit & $1.00\$ 1.00 \\ \hline \multicolumn{2}{|l|}{} \\ \hline \end{tabular}|\begin{tabular}{l|c|} \hline Demand Distribution \\ \hline Mean & 50 \\ \hline Standard Deviation & 5 \\ \hline Last Month's Demand & 41 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline Average Profit (one Replication) & 433 \\ \hline \multicolumn{2}{|c|}{} \\ \hline Average Profit (20 Replications) & 440.2 \\ \hline \end{tabular} \begin{tabular}{|c|r|} \hline \multicolumn{1}{|l|}{ Data Table } & \\ \hline Replication & Profit \\ \hline 1 & 433 \\ \hline 2 & 451 \\ \hline 3 & 460 \\ \hline 4 & 436 \\ \hline 5 & 474 \\ \hline 6 & 494 \\ \hline 7 & 338 \\ \hline 8 & 546 \\ \hline 9 & 452 \\ \hline 10 & 431 \\ \hline 11 & 505 \\ \hline 12 & 508 \\ \hline 13 & 413 \\ \hline 14 & 467 \\ \hline 15 & 430 \\ \hline 16 & 378 \\ \hline 17 & 409 \\ \hline 18 & 388 \\ \hline 19 & 341 \\ \hline 20 & 450 \\ \hline \end{tabular}
What is the number of 'Order' for Month 4 (i.e., the value in cell C7, indicated by the red box)? 42 52 53 48

Studdy Solution
Assign the demand from Month 3 as the order quantity for Month 4:
Order for Month 4=Demand for Month 3=52 \text{Order for Month 4} = \text{Demand for Month 3} = 52
The number of 'Order' for Month 4 is:
52 \boxed{52}

View Full Solution - Free
Was this helpful?

Studdy solves anything!

banner

Start learning now

Download Studdy AI Tutor now. Learn with ease and get all help you need to be successful at school.

ParentsInfluencer programContactPolicyTerms
TwitterInstagramFacebookTikTokDiscord