Integrated Learning Project Assignment Instructions: Business & Finance Answers 2021

Integrated Learning Project Assignment Instructions: Business & Finance Answers 2021

Integrated Learning Project Assignment Instructions: Business & Finance Answers 2021

Question Title:

Integrated Learning Project Assignment Instructions

Full Question:

Unformatted Attachment Preview

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

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:
a. 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)
b. 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)
c. What could be the future sources of inaccuracy in the data contained the ERP
system (min 300 words)
d. How the corruption of the data could be prevented (min 300 words)
e. An analysis and composition of the net benefit (benefits minus costs linked to
income statement and balance sheet) of the implemented ERP system

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.
a. 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 1 of 5
BUSI 615
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:
o
Details on how this module could be implemented (assignment management
process, who should be involved, and why, etc.) within the chosen firm (300
words)
o
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)
o
What could be the future sources of inaccuracy in the data contained in the
module (300 words)
o
A comparison of any 2 MPS schedule formats and logic taken from
https://www.softwareadvice.com/erp/?more=true#more 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:
o
Description of the how the software selection criteria (and which ones) were
chosen for your company (300)
Page 2 of 5
BUSI 615
o
An analysis and tabulation of the strengths and weaknesses of the main
modules of each software solution when compared of your selection criteria
(300)
o
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)
o
Consideration of which functional areas would be responsible for the
operation of each of the major ERP modules (300)
o
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:
o
Details on how this module could be implemented (assignment management
process, who should be involved, and why, etc.) within the chosen firm (300
words)
o
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)
o
What could be the future sources of inaccuracy in the data contained in the
module (300 words)
o
A comparison of any 2 MRP schedule formats and logic taken from
https://www.softwareadvice.com/erp/?more=true#more 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:
o
Details on how this module could be implemented (assignment management
process, who should be involved, and why, etc.) within the chosen firm (300
words)
o
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)
o
What could be the future sources of inaccuracy in the data contained in the
module (300 words)
Page 3 of 5
BUSI 615
o
A comparison of any 2 DRP schedule formats and logic taken from
https://www.softwareadvice.com/erp/?more=true#more 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:
o
Details on how this module could be implemented (assignment management
process, who should be involved, and why, etc.) within the chosen firm (300
words)
o
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)
o
What could be the future sources of inaccuracy in the data contained in the
module (300 words)
o
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:
o
Overall structure of the ERP implementation plan detailing responsibilities
and timing (300 words)
o
Details on the Education and Training activities of the plan, their sequencing
and timing (300 words)
o
Details on the key activities in the Bills of Materials sub-assignment to
achieve a company document with 98% accuracy (300 words)
o
Details on the key activities in the Warehouse sub-assignment to achieve a
minimum of 95% accuracy (300 words)
o
Details on the key activities in the Master Production Schedule subassignment 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.
o 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
Page 4 of 5
BUSI 615
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
Master Production Sche
Opening
stock Week 1
Forecast Demand
Production Plan
Projected Stock on Hand
Customers orders
Available to Promise
MPS Orders
35
Week 2
5
10
40
10
35
20
Week 3
15
10
35
5
10
10
35
5
Iron 883 MPS
Proportion = 0.3
Opening
stock Week 1
Gross Requirements
Schedule Receipts (WIP)
Projected Stock on Hand
Customer Orders
Available to Promise
MPS Order
10
Week 2
6
15
19
3
4
Week 3
0
0
19
2
19
1
Superlow MPS
Proportion = 0.7
Opening
stock Week 1
Gross Requirements
Schedules Receipts (WIP)
Projected Stock on Hand
Customer Orders
25
Week 2
14
50
61
7
Week 3
0
0
61
3
61
4
Available to Promise
MPS Order
11
Piston Assembly MR
Proportion = 2
Opening
stock Week 1
Gross Requirements
Schedules Receipts (WIP)
Projected Stock on Hand
Planned Order
50
Week 2
0
100
150
Week 3
0
0
150
150
Dstribution Requirements Plann
Piston Rings DRP
Dimensions
Opening
stock Week 1
London Warehouse Forecast
In transit
Projected Stock on Hand
Planned Order
50
Week 2
200
1000
850
Week 3
200
200
650
450
Dstribution Requirements Planning – Houston Gl
Piston Rings DRP
Dimensions
Opening
stock Week 1
Houston Warehouse Forecast
London Warehouse Planned Orders
Tacoma Warehouse Planned Orders
New York Warehouse Planned Orders
Osaka Warehouse Planned Orders
Schedules Receipts
Projected Stock on Hand
Planned Order
Week 2
100
Week 3
100
100
500
1000
1000
2400
2000
1300
3000
?
1200
Capacity Requirements
Planned
Order
Quantity
Week 1
Week 2
Week 3
Manfactured Part X Set Up
Set up Time per Batch
Run Time Per Batch
Manfactured Part Y Set Up
Set up Time per Batch
Run Time Per Batch
Manfactured Part Z Set Up
Set up Time per Batch
Run Time Per Batch
Required Capacity
Demonstrated Capacity
Under Over Capacity
Input / Output Co
Week 1
Planned Input
Week 2
15
Week 3
15
0
Actual Input
Cummulative deviation
14
-1
13
-3
5
2
Planned Output
Actual Output
Cummulative deviation
Actual Backlog
11
8
-3
26
11
10
-4
29
11
9
-6
25
20
Master Production Schedule Sport Family
Week 4
Month 2
Month 3
Month 4
Month 5
Month 6
10
10
35
35
50
50
45
50
55
50
50
55
55
50
50
60
50
40
20
20
50
50
50
50
50
50
55
55
60
60
Iron 883 MPS
Lead time = 1 month
Week 4
EPQ = 50
Month 2
Month 3
Month 4
Month 5
Month 6
6
15
15
15
17
18
13
48
33
18
2
34
50
50
50
50
Superlow MPS
Lead time = 1 month
Week 4
EPQ = 50
Month 2
Month 3
Month 4
Month 5
Month 6
14
35
35
35
39
42
47
12
27
42
4
12
50
50
50
50
50
50
Piston Assembly MRP
Lead time = 1 month
Week 4
EPQ 100
Month 2
Month 3
Month 4
Month 5
Month 6
0
100
100
100
0
200
150
50
100
50
100
50
50
200
50
n Requirements Planning – London Warehouse
Piston Rings DRP
Lead time = 3 month
Week 4
EOQ 1000
Month 2
Month 3
Month 4
Month 5
Month 6
200
200
200
200
200
200
250
1000
50
850
650
450
250
Planning – Houston Global Warehouse and Global Procurement
Piston Rings DRP
Lead time = 3 month
Week 4
EOQ 3000
Month 2
100
1000
Month 3
100
Safety Stock 200
Month 4
Month 5
Month 6
100
100
100
100
2700
2600
2500
2400
200
100
2800
Capacity Requirements Planning Work Center A
Week 4
Month 2
Month 3
Month 4
Month 5
Month 6
Week 8
Week 9
Input / Output Control Work Center A
Week 4
Week 5
10
Week 6
10
Week 7
0
10
10
10
9
1
17
8
8
16
6
12
3
5
12
7
11
11
-6
23
11
9
-8
31
11
10
-9
29
11
9
-11
26
11
11
-11
18
11
9
-13
21

Purchase answer to see full
attachment

This question was handled by a Studyhelp247 Business & Finance tutor and the student left a positive review. 19+ custom answers have been given to students for this question in November 2021 alone. To avoid plagiarism and maintain student privacy, we do not resell answers. Get your custom solution now. It is affordable.

Bram Eldoff, Founder, Studyhelp247.com

Consider this Business & Finance Assignment Done
Beat its deadline and stringent requirements.

[advanced_iframe securitykey=”your key” use_shortcode_attributes_only=”true” src=”https://core.studyhelp247.com/main-site-question-post/” id=”example4″ height=”350″ width=”450″ show_part_of_iframe=”true” show_part_of_iframe_x=”-100″ show_part_of_iframe_y=”75″ show_part_of_iframe_width=”450″ show_part_of_iframe_height=”350″ show_part_of_iframe_new_window=”_top” show_part_of_iframe_new_url=”https://core.studyhelp247.com/new-question-posting/”]

>Approximate cost: $8 per page.<br>>Choose your own tutor.<br>>Get free revision, plagiarism reports, and a list of sources.<br>>Release the money only after delivery

How it Works

hw

Why you should post this Business & Finance question now.

Flawless Deliveries
Our tutors deliver fault free assignments after careful and detailed research. All instructions are followed to the letter.

100% Originality Guarantee
Every task delivered to students on our platform has 100% originality guarantee. Find plagiarism, get 100% money back.

Timely Deliveries
When you post a question here, we assure on-time delivery, or 100% money back. You cannot miss deadlines with us.

24/7 Customer Support
Our support agents are always online, ready to help you when using our platform. It only gets better.

Student-Friendly Prices
Getting quality help should not break your pocket. Find instant quality help for whatever budget you have.

Free Revisions
You can request your tutor for as many revisions as needed to ensure you are 100% satisfied with our services.

100% Privacy
Every action you take on our platform is anonymous. Once you receive your help, it is almost as if you weren’t here.

100% Refunds
If a tutor breaks any of our guarantees, you get 100% money back to ask questions in the future. No questions.

Here are other questions on different subjects that our tutors have handled with excellent results.

The first ones are New York Institute of Technology Equal Employment Opportunity Commission Questions and CISS 302 CC Business Data Communications And Networking Analysis which required in-depth research and computations. The third and fourth ones are Integrated Learning Project Assignment Instructions and Strayer University Political Science Federal Gun Laws Presentation, which called for experts to help with online quizzes. All these were answered for students who were looking for study assistants for homework help 2021

Reviews from Students; Verified by Trustalyze

Studyhelp247 Exceeded my expectations.

Rated 5 out of 5
2 years ago

I believe in studyhelp247 now. Here, I found the best tutor to assist me with a complex math task. It was seamless using the site.

Avatar for SdfDsf
SdfDsf

Response from Studyhelp247

Thank you for using our platform to find academic help. We are happy that you found what you were looking for.

By far, the best source of affordable custom writing solutions.

Rated 5 out of 5
2 years ago

I came to studyhelp247 after seeing an ad and they have been great. It is quite affordable owing to the fact that there are no service fee charges.

Avatar for Student01
Student01

Response from Studyhelp247

Thank you for the great review. We are committed to providing the best platform to foster student excellennce. 🙂

Very responsive support

Rated 5 out of 5
2 years ago

I have enjoyed using studyhelp247. The support was very responsive and I received quality work

Avatar for Alsalem
Alsalem

Response from Studyhelp247

Thank you.
Our support agents are always available to assist you with any issue.

Great work done for me by Anastacia.

Rated 5 out of 5
2 years ago

Thank you for the great work that you delivered. I will be back for more. 🙂

Avatar for Elsie
Elsie

Response from Studyhelp247

Thank you for using our site.

Refund Reason

Assignment Help. All November

Nov 2021 Offer

Get 50% Discount 

Happy Student - Studyhelp247

Press ENTER or click get started below to submit. 

Via Email

A Minute,

THIS YEAR, YOU EXCEL

Post Any Question for           Instant Assistance from Qualified Tutors.

 

Pay 10% Less when Hiring.

 

Get a Professional Tutor / Writer for as Low as $1