ERPSim Lab and Cash to Cash Exercise PDF

Preview

Summary

ERPSim Lab and Cash to Cash Exercise...

Description

ERPSim'Lab'and'Cash'to'Cash'Exercise' COMM'MGMT'3511' Due:'Friday'February'12,'2021'by'11:59pm'Halifax'Time' Submit'to'Brightspace' Total'of'35'marks' ! ! It!is!recommended!that!you!have!this!lab!open!when!you!attend!your!synchronous! sessions!this!week.!You!will!need!to!take!some!screenshots!of!reports!to!include! with!your!lab.!Also,!keeping!the!questions!in!mind!as!you!play!the!ERPSim!game!will! help!you!answer!some!of!the!questions.!! ! Apart!from!the!cash-to-cash!exercise,!the!lab!should!be!basically!complete!by!the! time!you!finish!your!synchronous!session!J!! ! 1. Provide!screenshots!of!your!team!creating!the!Planned!Independent! Requirements,!the!MRP!Run,!and!the!PO.!!(6!marks)! 2. Provide!a!screenshot!that!shows!when!your!newly!ordered!goods!(from! question!2)!are!to!arrive.!!When!will!they!arrive?!!(2!marks)! 3. Is!the!sales!report!different!from!the!summary!report?!If!so,!how?!Which!is! more!valuable!when!making!decisions!and!why?!(3!marks)! 4. Provide!a!screenshot!of!your!valuation!at!the!end!of!Round!3.!Explain!what! decisions!the!team!took!to!explain!the!valuation!that!the!team!ended!the! game!with.!What!would!you!have!done!differently!during!the!game!to! increase!your!valuation?!(2!marks)! 5. At!the!end!of!Round!2,!take!a!screenshot!of!the!appropriate!financial! statement!that!shows!that!the!team!did!or!did!not!have!to!take!on!a!bank! loan.!Explain!why!a!bank!loan!was!needed!or!was!not!needed.!(3!marks)! 6. Did!your!team!decide!to!spend!any!money!on!marketing?!If!so,!why?!What! did!you!spend!your!marketing!money!on,!and!do!you!believe!it!helped!boost! your!sales!(and!why)?!If!you!did!not!spend!any!money!on!marketing,!explain! why!the!team!made!this!decision,!and!how!that!decision!could!have!affected! your!valuation.!(3!marks)! 7. If!you!charged!$13.99!for!the!1L!spritz,!how!would!this!affect!your!valuation! and!why?!(3!marks)! 8. If!you!wanted!to!show!your!boss!an!aggregated!market!report!for!your!sales,! which!report!would!you!use!and!why?!Include!a!screenshot!of!this!report!to! support!your!answer.!!!(3!marks)! ! ! (see!next!page!for!the!cash-to-cash!question)! ! ! ! ! !

! Cash-to-Cash!question!(10!marks)! ! The!sales!information!for!you!company!is!provided!in!the!attached!spreadsheet.!! ! Your!company,!ERPWater,!ordered!3,000!units!of!each!item!on!Day!18!of!Round!1.! The!lead-time!was!2!days,!and!your!inventory!arrived!for!the!beginning!of!Round!2.! When!you!checked!the!inventory!report!at!the!start!of!Round!2,!you!saw!that!you! had!3,000!units!for!each!of!your!product!codes.!You!were!also!told!by!the!finance! manager!that!at!the!beginning!of!Round!2,!there!were!no!outstanding!Accounts! Receivable.!!! ! On!day!7,!you!re-ordered!more!inventory,!and!ordered!another!3,000!units!of!each! product.!! ! If!your!opening!bank!balance!for!Round!2!was!$16,500,!how!much!cash!will!you! have!on!hand!to!pay!your!suppliers!on!Day!17!and!will!you!have!to!take!on!a!bank! loan?!! ! You!can!assume!that!the!terms!of!the!agreements!that!ERPWater!gives!its!customers! includes!the!day!of!sale,!and!that!the!terms!of!the!agreements!that!ERPWater!gets! from!its!suppliers!also!include!the!date!of!purchase.!These!terms!are!laid!out!in!the! Job!Aid.!! ! To!get!full!marks,!you!need!to!provide!your!calculations!to!support!your!answer.!!...