ERPSim Final Manufacturing Game

User Generated

qlukwbuaal

Writing

Description

Analytics & Business Intelligence

a. Explain how your company performed relative to the rest of the market using analytics tools available to you including the ZMarket report and Lumira.

b. How did Business Analytics in Lumira aid in decision making during the game and between rounds?

according the two file ,which is game result, our term is group H, total have 5 round.

Unformatted Attachment Preview

Manufacturing Extended Game © Copyright 2004-2017, Léger et al., HEC Montréal. All rights reserved. Last Update: December 19th 2017 $1 to $9 User: Password: ERPSIM FORECAST SALES CALCULATE REQUIREMENTS PURCHASING RELEASE PRODUCTION MARKETING EXPENSE CHANGE PRICE Create Planned Indep. Req. (MD61) MRP Run (MD01) Automatic Gen. of POs (ME59N) Coll. Conversion of Pld Orders (CO41) Marketing Expense Planning (ZADS) Condition Maintenance: Change (VK32) Product group, 1 Select then enter : $$-F 2 forecasted quantities 3 Enter in the 2nd date column 4 quantity corresponds to ? The the replenishment level 1 1 2 Click once again on Enter 2 Purchase orders are created 3 ? In the pop-up window, click If no open requisitions : No suitable requisitions found. 1 order: Planned ? Iforderno planned could not be selected 2 Select orders on Convert. Message 3 Click confirms the conversion. fails, ? Ifclickconversion on to see log 1 2 Enter the daily amount of marketing for each product and each area. To apply your marketing expense plan prices folder and 1 Open double click on Price list In Distribution channel, enter 2 10, 12 or 14 3 4 Enter your prices 5 FINANCIAL STATEMENT STOCK LEVELS PO TRACKING PRODUCTION SCHEDULE PRODUCTION COST SALES AND MARKET DATA Financial Statements (F.01) Inventory Report (ZMB52) Purchase Order Tracking (ZME2N) Production Schedule (ZCOOIS) Product Cost Analysis (ZCK11) Sales Order Report (ZVA05) For each product, it shows variable and fixed costs. Shows sales transactions: time, sales revenues, boxes sold and price per box. company code, enter your 1 Incompany code ($$) ALV Tree control 2 Select (optional) 3 Shows for each purchase order, the issue , arrival and payment dates. Shows all stock levels Shows released production orders, past and future. For each order the time released, started and finished (or to start and finish if incomplete). Target Qty > Conf. Qty means still pending. Vendor Pricing (ZME13) Shows material prices for each vendor. Liquidity Planning (ZFF7B) Displays an estimate of your cashflow for the coming weeks. Summary Sales Report (ZVC2) Aggregates the daily sales orders by product. Price Market Report (ZMARKET) Shows market sales for lagging 5 days - revenues, units, and average price. CHANGE PRODUCT DESIGN LOAN REPAYMENT SETUP TIME REDUCTION INCREASE CAPACITY Modify BOM (ZCS02) Enter G/L Account (FB50) Enter G/L Account (FB50) Enter G/L Account (FB50) enter the product 1 Into Material, redesign : $$-F## 2 3 Change quantities 4 current date (F4) in 1 Enter Document Date 1 Line 2 2 Account 113300 113101 D/C Credit ??? prompted the “incorrect recipe“ ? Ifmessage, click on to modify it 3 4 st Amount nd Line current date (F4) in 1 Enter Document Date 1 Line 2 2 st nd Line st nd Line Account 113300 11000 Debit D/C Credit Debit ??? Amount ??? ??? Account 113300 478000 Debit D/C Credit ??? Amount ??? 3 4 current date (F4) in 1 Enter Document Date 1 Line 2 2 3 4 Product Design Blueberry Nut $$-F01 $$-F11 © Copyright 2004-2017, Léger et al., HEC Montréal. All rights reserved. Last Update: December 19th 2017 500g 1kg $$-F02 $$-F12 Strawberry 500g 1kg 20% wheat* 30% oat* 20% blueberry* 1 box / 1 bag* 20% wheat* 30% oat* 20% nut* 1 box / 1 bag* 500g 1kg 20% wheat* 30% oat* 20% raisins* 1 box / 1 bag* *minimum CUSTOMER S Original $$-F04 $$-F14 500g 1kg 20% wheat* 30% oat* 20% strawberry* 1 box / 1 bag* *minimum *minimum $$-F03 $$-F13 Raisin *minimum STOR AGE CAPACIT Y AND COSTS DC10 DC 10: Hypermarkets Payment Time : 20 Approximate Market Size €90 000 per team per week DC12 DC 12: Grocery Chains Payment Time : 10-20 Approximate Market Size €220 000 per team per week DC14 DC 14: Independant Grocers Payment Time : 1-20 Approximate Market Size €130 000 per team per week $$-F05 $$-F15 500g 1kg 20% wheat* 30% oat* 1 box / 1 bag* $$-F06 $$-F16 500g 1kg 20% wheat* 30% oat* 30% fruits & nuts** 1 box / 1 bag* *minimum *minimum **At least some of all fruits/nut PRODUCTION CAPACIT Y Product type Current space Cost per additional 50,000 units* Finished product 250,000 boxes €500/day Raw materials 250,000 kg €1 000/day **Investing in additional capacity will increase equipment depreciation costs Packaging (bags and boxes) 750,000 units €100/day SETUP TIME *Billed automatically SUPPLIER S Mixed FIXED COSTS (€ paid each 5 days)* Capacity (units/day) 24,000 Additional Capacity (€ per 1,000 units) 1 000 000** Setup time (hours) Investment (€) 8 - Direct labor 20 000 7 50 000 Factory overhead 15 000 6 125 000 S, G & A 40 000 5 250 000 1 250 4 500 000 50 000** 3 1 250 000 Lead time (days) 1-5 Depreciation (Building) Payment time (days) 20 Depreciation (Equipment) *Billed automatically Financial Statements - R1 Team Credit ratings Interest Rate Rank (%) F A 8 K A 8 L A8.25 J A 8 G A8.25 E A 8 I BBB+ 8.75 H BBB+ 8.75 1 2 3 4 5 6 7 8 Company valuation Cumulative Net Income Total sales 67,629,180.33 561,708.47 1,591,804.81 63,181,206.33 173,478.73 1,667,093.49 34,991,501.71 -101,128.42 1,316,216.35 30,684,459.00 306,844.59 1,166,688.38 20,872,289.96 -245,262.04 1,307,873.44 17,042,910.00 170,429.10 1,049,601.33 -22,094,021.33 -387,832.31 640,930.18 -149,839,380.71 -1,592,043.42 0 Gross Margin Net(%) MarginROE (%) (%) ROA (%) D/E (%) Mktg/S (%)Round Net Income Round Productivity 75.767 35.288 2.732 2.015 35.55 0 561,708.47 70 70.719 10.406 0.86 0.623 38.114 0.375 173,478.73 75.833 70.315 -7.683 -0.508 -0.357 42.347 2.735 -101,128.42 64.167 70.963 26.3 1.511 1.134 33.285 0 306,844.59 54.411 70.721 -18.753 -1.242 -0.85 46.02 0.078 -245,262.04 70.833 69.286 16.238 0.845 0.601 40.615 0 170,429.10 53.333 72.778 -60.511 -1.978 -1.396 41.683 14.643 -387,832.31 44.169 0 0 -8.649 -5.969 44.9 0 -1,592,043.42 0 Round Sales per Team 1,591,804.81 1,667,093.49 1,316,216.35 1,166,688.38 1,307,873.44 1,049,601.33 640,930.18 0 Financial Statements - R2 Team Credit ratings Interest Rate Rank (%) F A+ 7.75 K A 8 L A8.25 J A 8 G A 8 E A 8 I BBB+ 8.75 H BBB+ 8.75 1 2 3 4 5 6 7 8 Company valuation Cumulative Net Income Total sales 98,480,446.81 1,824,408.75 3,893,608.63 73,912,990.83 1,061,593.15 3,469,846.01 47,956,082.78 562,436.69 2,969,561.30 39,857,949.50 797,158.99 2,615,707.93 34,540,614.83 274,145.63 2,943,319.35 22,355,553.50 447,111.07 2,155,507.08 15,688,203.61 194,207.66 2,662,004.13 -109,882,469.18 -2,335,002.47 955,292.16 Gross Margin Net(%) MarginROE (%) (%) ROA (%) D/E (%) Mktg/S (%)Round Net Income Round Productivity 76.045 46.857 8.359 6.499 28.629 0 1,262,700.28 77.5 75.37 30.595 5.04 3.838 31.331 0.604 888,114.42 65.417 71.434 18.94 2.735 1.981 38.085 1.455 663,565.11 74.2 71.182 30.476 3.833 2.908 31.79 0 490,314.40 62.898 69.338 9.314 1.352 0.969 39.601 1.028 519,407.67 66.875 72.297 20.743 2.187 1.575 38.877 0.172 276,681.97 48.333 67.805 7.296 0.962 0.665 44.67 8.935 582,039.97 89.504 70.263 -244.428 -13.218 -8.935 47.93 198.159 -742,959.05 46.667 Round Sales per Team 2,301,803.82 1,802,752.52 1,653,344.95 1,449,019.55 1,635,445.91 1,105,905.75 2,021,073.95 955,292.16 Financial Statements - R3 Team Credit ratings Interest Rate Rank (%) F AA 7 K AA7.25 L A 8 J A 8 E A+ 7.75 G A 8 I A8.25 H BBB 9 1 2 3 4 5 6 7 8 Company valuation Cumulative Net Income Total sales 121,951,160.73 3,259,906.92 6,350,196.27 84,079,931.38 1,989,748.07 5,372,788.06 67,627,572.33 1,653,827.17 5,213,916.05 39,693,276.67 1,190,798.30 3,930,348.90 35,245,614.30 1,035,339.92 3,606,378.38 32,524,750.33 38,242.51 4,432,575.25 30,910,196.90 821,374.78 4,532,550.39 -95,143,676.00 -3,092,169.47 2,009,817.99 Gross Margin Net(%) MarginROE (%) (%) ROA (%) D/E (%) Mktg/S (%)Round Net Income Round Productivity 76.157 51.336 14.015 11.434 22.576 0 1,435,498.17 78.75 75.469 37.034 9.049 7.258 24.667 0.51 928,154.92 73.958 71.926 31.719 7.638 5.715 33.647 0.829 1,091,390.48 86 71.18 30.298 5.619 4.301 30.659 0.003 393,639.31 65.453 74.399 28.709 4.922 3.577 37.609 0.158 588,228.85 49.167 69.788 0.863 0.191 0.134 42.587 1.292 -235,903.12 80 68.684 18.122 3.945 2.812 40.267 5.855 627,167.12 88.338 71.468 -153.853 -18.288 -11.819 54.74 142.252 -757,167.00 46.667 Round Sales per Team 2,456,587.64 1,902,942.05 2,244,354.75 1,314,640.97 1,450,871.30 1,489,255.90 1,870,546.26 1,054,525.83 Financial Statements - R4 Team Credit ratings Interest Rate Rank (%) F AA+ 6.5 L AA7.25 K AA 7 E AA7.25 G A+ 7.75 J A8.25 I A 8 H BBB 9 1 2 3 4 5 6 7 8 Company valuation Cumulative Net Income Total sales 121,464,781.49 4,269,154.67 8,263,716.14 96,710,046.22 3,293,293.40 7,923,602.05 89,406,777.36 2,944,915.17 7,304,136.15 49,361,922.40 1,851,072.09 5,387,314.03 39,994,434.98 733,115.37 6,304,693.91 38,735,628.73 1,581,704.84 5,354,930.41 37,900,834.58 1,404,700.05 6,449,187.64 -75,762,911.31 -3,283,059.49 2,704,130.25 Gross Margin Net(%) MarginROE (%) (%) ROA (%) D/E (%) Mktg/S (%)Round Net Income Round Productivity 76.618 51.661 17.591 15.743 11.735 0 1,009,247.75 75 74.378 41.563 14.138 10.915 29.535 0.545 1,639,466.23 79.6 75.826 40.318 12.835 10.801 18.828 0.411 955,167.10 84.167 74.983 34.36 8.471 6.366 33.064 0.135 815,732.17 68.333 69.747 11.628 3.536 2.603 35.833 1.657 694,872.86 85.625 70.9 29.537 7.329 5.538 32.327 0.837 390,906.54 58.896 67.522 21.781 6.563 4.692 39.872 4.542 583,325.27 88.338 70.561 -121.409 -19.639 -12.565 56.306 109.136 -190,890.02 33.333 Round Sales per Team 1,913,519.87 2,709,686.00 1,931,348.09 1,780,935.65 1,872,118.66 1,424,581.51 1,916,637.25 694,312.26 Financial Statements - R5 Team Credit ratings Interest Rate Rank (%) F AAA+ 6 L AA+ 6.5 K AA+ 6.5 E AA 7 I A+ 7.75 G A+ 7.75 J A8.25 H BBB 9 1 2 3 4 5 6 7 8 Company valuation Cumulative Net Income Total sales 141,653,847.28 5,829,326.97 11,000,859.28 109,455,453.69 4,611,025.53 10,363,013.05 86,471,182.14 3,581,521.70 8,777,348.82 63,115,596.00 2,892,798.15 7,472,144.18 43,687,479.76 2,041,449.53 8,333,059.70 43,261,150.91 1,388,827.18 8,093,537.97 37,967,532.54 1,937,926.14 6,667,390.29 -58,627,442.77 -3,175,653.15 3,709,427.32 Gross Margin Net(%) MarginROE (%) (%) ROA (%) D/E (%) Mktg/S (%)Round Net Income Round Productivity 76.364 52.99 22.569 21.052 7.202 0 1,560,172.30 69.792 75.347 44.495 18.736 14.566 28.626 0.417 1,317,732.13 74.6 76.006 40.804 15.188 13.488 12.599 0.398 636,606.53 45.833 75.839 38.714 12.636 9.874 27.98 0.119 1,041,726.06 62.083 68.241 24.498 9.262 6.753 37.159 3.55 636,749.48 89.504 69.742 17.16 6.493 5.112 27.02 1.767 655,711.81 88.125 71.1 29.066 8.834 6.69 32.04 0.732 356,221.30 51.833 70.583 -85.61 -18.875 -12.135 55.546 79.699 107,406.34 40 Round Sales per Team 2,737,143.14 2,439,411.00 1,473,212.67 2,084,830.15 1,883,872.06 1,788,844.06 1,312,459.88 1,005,297.07
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

...


Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags