QuestionQuestion

Transcribed TextTranscribed Text

4. If we moved to the highest paying contract on Day 51, if feasible from a response time perspective, how much more profit (assuming average demand per day) can we generate from Day 51-486, in comparison to the default contract. 5. Based on the mean demand per day you calculated in Part (3) above, and assuming holding cost of 10% per dollar per annum, spent on inventory (cost of capital), calculate the Economic Order Quantity in the Littlefield factory. 6. Based on the standard deviation of demand per day you calculated in Part (3) above, and assuming 99% service level, calculate the Reorder Point for the Littlefield factory. 7. Based on the mean and standard deviation of demand per day you calculated in Part (3) above, and based on whichever contract you are offering towards the end of the simulation, if the decision maker were to place one large order for Days 386-486 (and then shut down the ordering after that one large order), what would be the optimal one-time order quantity? 8. Please report your cash balance at the end of Day 486 of the simulation 9. Please report your average throughput time (Lead Time as reported within the simulation) from Day 51-486. 10. Please report the day within the simulation that you reached $1M in cash balance (not including debt). In other words on which day did your cash balance hit $1M. If you did not reach $1M, just say Day 486. Day Alpha = Constant we choose to (x) (Demand, y) Naive Forecasi 2-Moving Avg. 3-Moving Avg 4-MA Exponential Smoothinuse Trend Line (ax+b Seasonal (Periodic) Indici Seasonal Avg. Inde Trendline X Seasonal Foreca Basic Error (Actual-Forecas Abs. Error % Error (Abs. Error/Actua 1 13 13 0.5 13.1 99.3% 87.2% 11.4 1.6 1.6 12.22% 2 15 13 13 Slope(a) 13.1 114.9% 101.2% 13.2 1.8 1.8 11.93% 3 8 15 14 14 -0.035582233 13.0 61.4% 82.2% 10.7 -2.7 2.7 33.74% 4 19 8 11.5 14 10.5 Intercept(b) 13.0 146.3% 119.2% 15.5 3.5 3.5 18.57% 5 14 19 13.5 12 13.8 16 13.12734694 12.9 108.1% 87.2% 11.3 2.7 2.7 19.38% 6 15 14 16.5 14 14 13.5 12.9 116.2% 101.2% 13.1 1.9 1.9 12.89% 7 10 15 14.5 14 14 14 12.9 77.7% 82.2% 10.6 -0.6 0.6 5.82% 8 16 10 12.5 16 14.5 11.5 12.8 124.6% 119.2% 15.3 0.7 0.7 4.36% 9 10 16 13 13 13.8 14.5 12.8 78.1% 87.2% 11.2 -1.2 1.2 11.63% 10 6 10 13 14 12.8 11.5 12.8 47.0% 101.2% 12.9 -6.9 6.9 115.37% 11 11 6 8 12 10.5 9.5 12.7 86.4% 82.2% 10.5 0.5 0.5 4.86% 12 15 11 8.5 11 10.8 12 12.7 118.1% 119.2% 15.1 -0.1 0.1 0.88% 13 8 15 13 9 10.5 14 12.7 63.2% 87.2% 11.0 -3.0 3.0 37.99% 14 16 8 11.5 11 10 10.5 12.6 126.7% 101.2% 12.8 3.2 3.2 20.14% 15 13 16 12 11 12.5 14.5 12.6 103.2% 82.2% 10.3 2.7 2.7 20.40% 16 11 13 14.5 13 13 13 12.6 87.6% 119.2% 15.0 -4.0 4.0 36.03% 17 13 11 12 12 12 12 12.5 103.8% 88.3% 11.1 1.9 1.9 14.95% 18 17 13 12 13 13.3 13 12.5 136.1% 106.5% 13.3 3.7 3.7 21.78% 19 12 17 15 12 13.5 15 12.5 96.4% 90.9% 11.3 0.7 0.7 5.68% 20 19 12 14.5 14 13.3 12.5 12.4 153.0% 120.8% 15.0 4.0 4.0 21.04% 21 10 19 15.5 14 15.3 16 12.4 80.8% 81.5% 10.1 -0.1 0.1 0.85% 22 15 10 14.5 16 14.5 11.5 12.3 121.5% 107.8% 13.3 1.7 1.7 11.26% 23 15 15 12.5 14 14 14 12.3 121.9% 102.0% 12.6 2.4 2.4 16.33% 24 15 15 15 15 14.8 14 12.3 122.2% 120.2% 14.8 0.2 0.2 1.62% 25 5 15 15 13 13.8 14 12.2 40.9% 72.2% 8.8 3.8 3.8 76.60% 26 9 5 10 15 12.5 9 12.2 73.8% 114.5% 14.0 -5.0 5.0 55.27% 27 6 9 7 12 11 11 12.2 49.3% 92.7% 11.3 -5.3 5.3 87.96% 28 9 6 7.5 10 8.75 9.5 12.1 74.2% 109.3% 13.3 -4.3 4.3 47.27% 29 9 9 7.5 7 7.25 11 12.1 74.4% 75.0% 9.1 -0.1 0.1 0.75% 30 9 9 9 8 8.25 11 12.1 74.6% 101.5% 12.2 -3.2 3.2 36.02% 31 14 9 9 8 8.25 11 12.0 116.4% 96.0% 11.5 2.5 2.5 17.55% 32 14 14 11.5 9 10.3 13.5 12.0 116.8% 116.6% 14.0 0,0 0,0 0.19% 33 19 14 14 11 11.5 13.5 12.0 159.0% 88.7% 10.6 8.4 8.4 44.17% 34 15 19 16.5 12 14 16 11.9 125.9% 98.9% 11.8 3.2 3.2 21.39% 35 15 15 17 16 15.5 14 11.9 126.2% 103.5% 12.3 2.7 2.7 18.04% 36 13 15 15 16 15.8 14 11.8 109.7% 105.7% 12.5 0.5 0.5 3.65% 37 9 13 14 16 15.5 13 11.8 76.2% 87.6% 10.3 -1.3 1.3 14.97% 38 15 9 11 14 13 11 11.8 127.4% 100.4% 11.8 3.2 3.2 21.18% 39 10 15 12 12 13 14 11.7 85.2% 94.3% 11.1 -1.1 1.1 10.70% 40 11 10 12.5 12 11.8 11.5 11.7 94.0% 98.7% 11.5 -0.5 0.5 4.99% 41 15 11 10.5 11 11.3 12 11.7 128.6% 109.5% 12.8 2.2 2.2 14.80% 42 9 15 13 12 12.8 14 11.6 77.4% 101.3% 11.8 2.8 2.8 30.95% 43 13 9 12 12 11.3 11 11.6 112.1% 110.0% 12.8 0.2 0.2 1.88% 44 12 13 11 12 12 13 11.6 103.8% 106.1% 12.3 -0.3 0.3 2.20% 45 9 12 12.5 12 12.3 12.5 11.5 78.1% 110.4% 12.7 -3.7 3.7 41.45% 46 11 9 10.5 11 10.8 11 11.5 95.7% 106.6% 12.2 -1.2 1.2 11.34% 47 10 11 10 11 11.3 12 11.5 87.3% 102.7% 11.8 -1.8 1.8 17.65% 48 9 10 10.5 11 10.5 11.5 11.4 78.8% 96.6% 11.0 -2.0 2.0 22.54% 49 13 9 9.5 10 9.75 11 11.4 114.2% 99.3% 11.3 1.7 1.7 13.08% 50 12 13 11 10 10.8 13 11.3 105.7% 101.6% 11.5 0.5 0.5 3.96% Standard Deviation 3.376328159 ME MAD MAPE Average Jobs per Da 12.22 per day 0.1 2.3 21.61%

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.xlsx.

    50% discount

    Hours
    Minutes
    Seconds
    $45.00 $22.50
    for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Operations Management Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats