Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

Logistics 2

See attachments and link

BUSI 615

Integrated Learning Project Assignment Instructions

Overview

The integrated learning assignment is a series of 6 assignments and a final course consolidated submission. All assignments and the compilation of the final consolidated submission is managed as an individual assignment.

Purpose

The purpose of the ILP is for everyone to develop a working model of an ERP system applied to a firm of their choosing. This model will be built up in modular format through weekly assignments culminating in the submission of the completed model in the final week of the course together with a management proposal detailing the costs and benefits as they apply to the income statement and balance sheet of the selected firm.

Resources

The development of the assignments will be supported not only by written instructions but also with an explanatory Watch item.

Expectations

1. Each component, from Module 3: Week 3 will be the development of an ERP module in Excel relevant to the topic for that week. The Excel development will follow SAP and other ERP systems formats. The Excel file will be accompanied by a written assignment containing:

0. Details on how this ERP assignment could be implemented (assignment management process, who should be involved, and why, etc.) within the chosen firm (min 300 words)

0. Details on how ERP could be operated (management process, who should be responsible, numbers of different users of each module, data accuracy, etc.) within the chosen firm (min 300 words)

0. What could be the future sources of inaccuracy in the data contained the ERP system (min 300 words)

0. How the corruption of the data could be prevented (min 300 words)

0. An analysis and composition of the net benefit (benefits minus costs linked to income statement and balance sheet) of the implemented ERP system

1. The final integrated Excel ERP working model for your chosen firm, due at the end of week 8, will tie all the preceding modules together into a fully integrated working ERP model in Excel. The integrated modules will include, Master Production Schedule, Bill of Materials, Materials Requirements Planning, Capacity Planning, Distribution Requirements Planning and Shop Floor Control. The Excel file will be submitted simultaneous with the following written report. The final course report would be about 3,000 words (excluding references and appendices), much of which would have been accumulated over the preceding 6 weeks.

1. The final submission will also include a written management report detailing (1) a recommendation for implementation based on a cost / benefits analysis (2) implementation assignment plan with responsibilities, (3) a justified recommendation for an ERP system (e.g. SAP, or other) and its operation (local or cloud processing, scope of application (national, global, etc.)

Instructions

Part 1 –
Company selection – Characteristics – Manufacturing – Publicly available financial accounts – consumer or industrial product (either make to order or make to stock) – examples Tesla / Boeing (search YouTube “Mega factories” and choose one of these documentary examples to appreciate the level of manufacturing detail required). Structure your assignment as follows (word counts are minimums):

o Title page

o Company description (300 words)

o Financial trends: Overview of inventory types/trends/productivity (trends in day’s stock by type, Etc.) (300 words)

Income statements (last 3 years) (300 words)

Balance sheet (last 3 years) (300 words)

o Opportunities for logistics to improve income statement (consider revenues and operating costs) and balance sheet asset productivity. Provide quantitative calculations and probable range of costs / benefits. (300 words)

Part 2 –
Master Production Scheduling
(MPS) – Develop an Excel based Master Production Schedule for your chosen product. Use the format and logic as shown in the illustrative Excel spread sheet to be found under Course Content. Also review the Kaptur presentation for this week, as well as pages 281 through 303 in your Logistics textbook. Your MPS Excel file will be accompanied by a written assignment containing:

· Details on how this module could be implemented (assignment management process, who should be involved, and why, etc.) within the chosen firm (300 words)

· Details on how this module could be operated (management process, key factors in the MPS policy, who should be responsible and why, the users of this modules data, etc.) within the chosen firm (300 words)

· What could be the future sources of inaccuracy in the data contained in the module (300 words)

· A comparison of any 2 MPS schedule formats and logic taken from or other MPS types from your own research of available MPS software (300 words)

Part 3 –
Enterprise Resource Planning – Develop an Excel analysis of the modules and functionality of 3 ERP systems, one of which must be SAP and the other 2 are of your choice. Follow the “ERP Links” tab under the Readings section of Course content for a listing of over 100 ERP software systems, including SAP. Overlay the functionality of these ERP systems onto the main manufacturing processes of your selected firm and determine which software best fits your chosen company. Your Excel analysis will accompany your written assignment which will contain:

· Description of the how the software selection criteria (and which ones) were chosen for your company (300)

· An analysis and tabulation of the strengths and weaknesses of the main modules of each software solution when compared of your selection criteria (300)

· A discussion of any ancillary data capture equipment and other software that may be advantageous to the operation of the ERP system in your company (300)

· Consideration of which functional areas would be responsible for the operation of each of the major ERP modules (300)

· An analysis of the possible software costs of your recommended ERP software (300)

Part 4 –
Materials Requirements Planning – Develop an Excel based Materials Requirements Plan for your chosen product. Use the format and logic as shown in the illustrative Excel spread sheet to be found under Course Content. Show at least 4 MRP levels with sub-assemblies, purchased components, manufactured components, and raw materials. Review the Kaptur presentation for this week, as well as pages 233 through 305 in your Logistics textbook. Your MRP Excel file will be accompanied by a written assignment containing:

· Details on how this module could be implemented (assignment management process, who should be involved, and why, etc.) within the chosen firm (300 words)

· Details on how this module could be operated (management process, key factors in the MRP operating policy, who should be responsible and why, the users of this modules data, etc.) within the chosen firm (300 words)

· What could be the future sources of inaccuracy in the data contained in the module (300 words)

· A comparison of any 2 MRP schedule formats and logic taken from or other MRP types from your own research of available MRP software (300 words)

Part 5 –
Distribution Requirements Planning – Develop an Excel based Distribution Requirements Plan for your chosen product. Use the format and logic as shown in the illustrative Excel spread sheet to be found under Course Content. Show at least 4 distribution warehouses with 4 components planned for each with at least 1 common to all distribution warehouses. Review the Kaltura presentation for this week, as well as pages 319 through 406 in your Logistics textbook. Your DRP Excel file will be accompanied by a written assignment containing:

· Details on how this module could be implemented (assignment management process, who should be involved, and why, etc.) within the chosen firm (300 words)

· Details on how this module could be operated (management process, key factors in the DRP operating policy, who should be responsible and why, the users of this modules data, etc.) within the chosen firm (300 words)

· What could be the future sources of inaccuracy in the data contained in the module (300 words)

· A comparison of any 2 DRP schedule formats and logic taken from or other DRP types from your own research of available MRP software (300 words)

Part 6 –
Capacity Requirements Planning – Develop an Excel based Capacity Requirements Plan for your chosen product. Use the format and logic as shown in the
Integrated Learning Project Example found on
. Review the Kaptur presentation for this week, as well as pages 439 through 478 in your Logistics textbook. Your CRP Excel file will be accompanied by a written assignment containing:

· Details on how this module could be implemented (assignment management process, who should be involved, and why, etc.) within the chosen firm (300 words)

· Details on how this module could be operated (management process, key factors in the CRP operating policy, who should be responsible and why, the users of this modules data, etc.) within the chosen firm (300 words)

· What could be the future sources of inaccuracy in the data contained in the module (300 words)

· A comparison of any 2 CRP schedule formats and logic taken from
ERP Software or other CRP types from your own research of available CRP software (300 words)

Part 7 – Assignment Plan – Develop a time phased assignment plan for the implementation of an ERP system at your selected firm. Review the assigned Learn material, as well as pages 511 through 551 in your Logistics textbook. Your time phased assignment plan Excel file will be accompanied by a written assignment containing:

· Overall structure of the ERP implementation plan detailing responsibilities and timing (300 words)

· Details on the Education and Training activities of the plan, their sequencing and timing (300 words)

· Details on the key activities in the Bills of Materials sub-assignment to achieve a company document with 98% accuracy (300 words)

· Details on the key activities in the Warehouse sub-assignment to achieve a minimum of 95% accuracy (300 words)

· Details on the key activities in the Master Production Schedule sub-assignment to achieve a 98% customer service accuracy (300 words)

Part 8 – Final Submission – The final integrated Excel ERP working model for your chosen firm, due at the end of week 8, will tie all the preceding modules together into a fully integrated working ERP model in Excel. The integrated modules will include, Master Production Schedule, Bill of Materials, Materials Requirements Planning, Capacity Planning, Distribution Requirements Planning and Shop Floor Control. The Excel file will be submitted simultaneous with the following written report. The final course report would be about 3,000 words (excluding references and appendices), much of which would have been accumulated over the preceding 6 weeks.

· The final submission will also include a written management report detailing (1) a recommendation for implementation based on a cost / benefits analysis (2) implementation assignment plan with responsibilities, (3) a justified recommendation for an ERP system (e.g. SAP, or other) and its operation (local or cloud processing, scope of application (national, global, etc.)

Page 5 of 5

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Order Now

Related Questions

BUSINESS MANAGEMENT GREAT WORK, ON TIME, NO PLAGARISM,

Tutor respond in business 2 ***Respond JD ( no more than 200-250 ) I would expect the following to be written evidence: All email communications between Mavis, Carlee, and Bigly (plus any other email communication with “AC” employees in reference to Mavis’ pregnancy and potential repercussions/accommodations. It is important to

Total Quality Management week 2

see attached BUSI 616 Strategic Partners and Alliances Assignment Instructions You will review the assigned readings and identify who the strategic partners are within your selected organization. What alliances have been formed and what type of organizational culture does your selected company have? How does the organizational culture of the

BUSINESS MANAGEMENT GREAT WORK, ON TIME, NO PLAGARISM,

Tutor discussion 1 Week 4 Discussion ( No more than 300 words) Pregnancy Discrimination Part of the Title VII of the Civil Rights Act is the Pregnancy Discrimination Act (PDA). The focus of a PDA claim is whether an employer’s policy treats pregnant workers less favorably than it treats non-pregnant

Project Work Breakdown

 Developing practical project management skills by applying theoretical concepts to a real-world scenario enhances your ability to plan and execute complex projects effectively.   Select a professional or personal (e.g., vacation, wedding, home remodeling) project that requires planning. In Excel, provide a brief summary of the event, identify all stakeholders involved

Unit 4

Please use the attached documents to complete unit 4 spreadsheet. Please follow CHAPTER 8 step by STEP instructions to complete the spreadsheet. Please use the spreadsheet that’s attached to complete the assignment.

Walmart Failure case study 2.0

Please see instructions, rubric and case study questionnaires attached eTextbook: Organization Theory & Design Translate Place: Convenience 637 Promotion: Communication Sources Integrative Case 3.0. IKEA: Scandinavian Style 639 Beginnings Supplier Relationships 640 Mission and Culture Current Challenges 641 Globalization Behind the Curtain  Contents Bookmarks 1 Recents Search table of

BUSINESS MANAGEMENT GREAT WORK, ON TIME, NO PLAGARISM,

TUTOR DISCUSSION Ob (respond no more than 200 words) Good evening, One practical business application for a humanoid AI robot (AIR) is as a customer service or public facing robot. Robots can be deployed in stores, airports, hospitals, hotels, government agencies, and other businesses to greet customers, provide directions, answer

work planning

Work BUSI 642 Case Analysis: Strategic Workforce Planning Assignment Overview Strategic workforce planning is important for HR because it directly impacts the organization’s ability to achieve goals. Strong workforce planning can help ensure the right people are in place at the right time. It can also help reduce the costs

Discussion response

    Respond by Tuesday midnight ET to at least two of your colleague’s posts. In your responses, evaluate the conclusions made by your classmates regarding loan request of this company, the possible source of funding to expand the market in a foreign country, and whether you agree with these.

Unit 3 spreadsheet

  Purpose The goal of the Excel template assignments weeks 1-4 is to build a working Excel spreadsheet model with built-in formulas and circular references using provided Excel template for Walmart company for 2010-2017, following detailed instructions in the textbook. The chapters of the textbook present a comprehensive guide on

HRM 6304 Unit III PP

2 Labor Relations and Collective Bargaining HRM 6304 Unit III PowerPoint Presentation Create a PowerPoint presentation that outlines the advantages and disadvantages of union representation, mandatory benefits in a bargaining package, how market factors may drive the bargaining process, and how these factors increase or decrease employee motivation or morale.

ITC 5301 Unit IIDB

2 Management Information Systems ITC 5301 Unit II Discussion Board Your initial post should be at least 300 words in length. Your initial post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or quoted material. There has been

4-1 Journal: Criminal Responsibility

Need help Module Four Journal Guidelines and Rubric.html BUS 206 Module Four Journal Guidelines and Rubric Overview Approach this journal assignment as an opportunity to reflect upon and apply what you learned from the assigned readings, discussions, and activities. It is also an opportunity to share your knowledge and expertise

business

Part A paper You will write a paper no less than 300 words, double-spaced, academic style, in APA format (in-text citations, references, correct grammar and spacing, etc.).  In Chapter 5, Locker (2025) discusses power distance. You will write a paper no less than 300 words, double-spaced, academic style, in APA

BUSINESS( NO PLAGARISM A+ WORK, ON TIME)

Tutor Discussion  1 Week 4 Discussion ( No more than 300 words) Pregnancy Discrimination Part of the Title VII of the Civil Rights Act is the Pregnancy Discrimination Act (PDA). The focus of a PDA claim is whether an employer’s policy treats pregnant workers less favorably than it treats non-pregnant

YL A2

Please use template provided  Assignment 2 Description and Deliverable After our last assignment, we discussed modern payment flow in the US, new opportunities in payments, risks in payment systems, as well as blockchain and payments. In this assignment, you will be asked to review and revisit some of the concepts

Feedbet Login: A Smarter Way to Access Digital Platforms

Feedbet Login is a streamlined authentication approach designed to improve how users enter and  interact with digital platforms. It focuses on simplicity, security, and user experience, ensuring that  access feels smooth rather than complicated.