{"id":35463,"date":"2024-03-11T21:31:29","date_gmt":"2024-03-11T21:31:29","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/business-finance-operations-management-operations-management-excel-assignment\/"},"modified":"2024-03-11T21:31:29","modified_gmt":"2024-03-11T21:31:29","slug":"business-finance-operations-management-operations-management-excel-assignment","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/business-finance-operations-management-operations-management-excel-assignment\/","title":{"rendered":"Business  Finance &#8211; Operations Management Operations Management (Excel) Assignment"},"content":{"rendered":"<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Criteria &nbsp;&nbsp;<\/p>\n<p>&nbsp;Analysis &nbsp;&nbsp;completed for the historical performance data provided. &nbsp;&nbsp;<\/p>\n<p>4 points &nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n<p>Summary of descriptive statistics completed for &nbsp;&nbsp;the historical performance data provided. Either a separate worksheet &nbsp;&nbsp;summary, separate file, or neatly displayed within, (above, or around) the &nbsp;&nbsp;raw data provided in the group&#8217;s data file. Analysis must be easy to locate &nbsp;&nbsp;within the sharepoint file provided or separate file uploaded to the &nbsp;&nbsp;sharepoint). &nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n<p>Precedence &nbsp;&nbsp;Diagram &nbsp;&nbsp;4 points &nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n<p>Construction of the precedence diagram &nbsp;&nbsp;completed based on the data provided in group\u2019s data file. \u201cRough\u201d, \u201cdraft\u201d, &nbsp;&nbsp;&#8220;sketch&#8221; or \u201cfinished\u201d version is acceptable. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Precedence diagram is uploaded to reside &nbsp;&nbsp;within the group&#8217;s folder in the class sharepoint. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Precedence diagram is in the form of a &nbsp;&nbsp;separate file (Word, PDF, .DRWG (CAD), Visio, Excel, PPT, etc. or hand-sketch &nbsp;&nbsp;is OK at this point. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Precedence diagram is Labelled as &nbsp;&nbsp;\u201cPrecedence Diagram_Group(###)\u201d &nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n<p>TAKT &nbsp;&nbsp;Time Calculation &nbsp;&nbsp;3 points &nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n<p>TAKT time calculator tool (formula) established &nbsp;&nbsp;within one of the spare worksheets provided within the group\u2019s data file &nbsp;&nbsp;(provided in the sharepoint). &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TAKT time calculator tool is able to &nbsp;&nbsp;calculate TAKT time based on the various inputs\/variables such as &nbsp;&nbsp;&#8220;available time&#8221;, and &#8220;customer demand&#8221; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Evidence of knowledge and understanding &nbsp;&nbsp;for how to plan, determine, and assign the various inputs\/variables such as &nbsp;&nbsp;&#8220;available time&#8221;, and &#8220;customer demand&#8221; by leveraging the &nbsp;&nbsp;data provided and the suggestions mentioned about in class. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The TAKT time calculator tool must be &nbsp;&nbsp;able to re-calculate TAKT time by changing any one or a multiple of input &nbsp;&nbsp;variables. &nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n<p>&nbsp;Evidence &nbsp;&nbsp;that a workstation assignment table has been started &nbsp;&nbsp;3 points &nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n<p>Evidence that a workstation assignment table &nbsp;&nbsp;has been created within the group&#8217;s data file (spare worksheet), OR added to &nbsp;&nbsp;the sharepoint as a separate file. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Work sheet does not have to be complete &nbsp;&nbsp;yet! &nbsp;But the evidence must be shown that this table is setup, ready to &nbsp;&nbsp;be worked on, and some progression has begun for establishing workstations. &nbsp;&nbsp;&nbsp;&nbsp;Provide &nbsp;&nbsp;a small project plan that lists the remaining steps that your group will be &nbsp;&nbsp;working on and completing over the next 2 to 3 weeks so that there is a clear &nbsp;&nbsp;path to successful completion of this project prior to the due date. &nbsp;&nbsp;<\/p>\n<p>4 points &nbsp;&nbsp;&nbsp;&nbsp;Uploaded to the Group&#8217;s sharepoint is an Excel &nbsp;&nbsp;or MS Project (or Word.doc if you choose) which lists (itemizes) the &nbsp;&nbsp;remaining activities planned to be completed for this project (see &amp; &nbsp;&nbsp;review the original project instructions for detail) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Identify \u201cwho\u201d will be responsible for &nbsp;&nbsp;completing each listed activity &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Identify \u201cby when\u201d that person will be &nbsp;&nbsp;aiming to complete the listed activity &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ensure the plan shows clearly that all &nbsp;&nbsp;remaining activities have an assigned\/delegated person(s) (group member) and &nbsp;&nbsp;that the pertinent activities are targeted to be completed prior to the due &nbsp;&nbsp;date for the project\/report; &nbsp;&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Criteria &nbsp;&nbsp; &nbsp;Analysis &nbsp;&nbsp;completed for the historical performance data provided. &nbsp;&nbsp; 4 points &nbsp;&nbsp;&nbsp;&nbsp; Summary of descriptive statistics completed for &nbsp;&nbsp;the historical performance data provided. Either a separate worksheet &nbsp;&nbsp;summary, separate file, or neatly displayed within, (above, or around) the &nbsp;&nbsp;raw data provided in the group&#8217;s data file. Analysis must be easy to locate &nbsp;&nbsp;within [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[210],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/35463"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=35463"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/35463\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=35463"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=35463"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=35463"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=35463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}