Excel VBA Programming
User Generated
wnfzvarnyznfuzbbz
Business Finance
Description
Hello
I have an assignment it should be done using excel
I will upload the files below take a deep look at it and solve the answer accurately, correctly, and with full steps.
Unformatted Attachment Preview
ECH 3002 – Intro to Chemical and Biomedical Engineering
HW #12
In this assignment, you will create two Excel-based spreadsheet tools. You should turn in two Excel
macro-enabled files as your answers to this assignment (i.e. they will be saved in “.xlsm” format so
that the macros you create can be seen and tested). The code you write should be commented so
that the TA can understand what your code does and it should use variable names that are somewhat
obvious as to their function. When saving your Excel files, keep the same name that they are
downloaded as and simply add your last name to the end of the file name.
1. As we have seen before, solution methods for linear systems of equations can be very useful
in chemical engineering. We have already seen how to set up systems of linear equations
into the
Ax=b
format and then solve them both by hand and by using MATLAB. It is also the case that Excel
can be programmed to solve Ax=b problems using methods like Guassian Elimination with
Back Substitution or Gauss-Jordan Elimination. Excel also has built-in worksheet functions to
operate on matrices like MMULT(rangeofcells1, rangeofcells2) which will multiply two
ranges of cells together by treating them like matrices (of course the number of columns in the
first range of cells must equal the number of rows in the second range of cells and the ranges
must contain only numbers).
In this problem you are provided with an Excel worksheet that has already been started which
will build a tool to solve Ax=b problems in Excel. The sheet already has 3 command buttons
defined in it. The first button has code that clears the working area of the sheet so that it can
be used over and over again to solve different Ax=b problems. The second button has code
in it that asks the user for the number of variables in the Ax=b system and uses that information
to draw areas for the user to input A and b into the spreadsheet.
Your assignment is to complete the code for the third button labeled “Solve Ax=b Problem.
The code you use must accomplish the following tasks:
1. It must find the solution for Ax=b problem.
2. It must display the solution to the user in the area of the worksheet labelled by the
“Define Number of Unknown Variables” button as the x vector solution.
You can use built in functions like Application.MInverse(Range of Cells To Be Inverted) to
find the inverse of the A matrix and then do matrix math for x=A -1b (this probably requires the
least code to be written but you will probably need to do a little research on how to use that
built-in function and then do the matrix multiplication) or you can write code to perform
Gaussian Elimination with Back Substitution or Gauss-Jordan (these just require reading in
the A and b from the sheet into arrays in Excel and then a couple of loops to do the row
elimination, but will require more lines of code and some careful thinking about the loops).
You should test your code to make sure it works by solving the following system of
equations:
3𝑥 + 2𝑥 + 1𝑥 = 11
1𝑥 + 1𝑥 + 2𝑥 = 9
1𝑥 +
1𝑥 = 5
2.
We will discuss building a worksheet in class that will find a root for a polynomial equation
supplied by the user. That Excel spreadsheet is provided with this homework assignment as
a starting point. Your task in this problem is to complete that VBA code in the “PolyFind”
subroutine linked to the “Define Polynomial and Find Root” button so that when pressed the
routine will find one root of the equation supplied by the user. We will assume for this problem
that the equation supplied by the user will in fact have a root (note this is not always guaranteed
with polynomial equations that have an even degree or order) so that you do not have to test
to make sure it in fact has a root.
The code is already built such that it expects you to evaluate the value of each term of the
polynomial at the estimated root in the cells next to each term in Column 3. It also expects
you to sum up the values of all of the polynomial terms at the estimated root in a cell at the
bottom of all of the term values in Column 3. Make sure that your root estimate appears in
Cell(2,2) when the code is finished running.
Test your code by finding a root of the polynomial:
2𝑥 + 𝑥 − 15𝑥 − 18 = 0
First Name:
Last Name:
USF U#:
This sheet will solve an Ax=b linear system of equations problem.
Instructions:
1. Press the "Clear Work Area" button to clear the working area portion of the spreadhseet.
2. You must then press the "Define Number of Unknown Variables" button and supply the number of variables in the equatio
3. When you define the number of variables, the sheet will display areas in which to enter the A matrix and b vector, and you
4. You must press the "Solve System of Equations" button and the program will display the solution to the system.
matrix and b vector, and you must enter the coefficients for A and b into the indicated cells. It will also define the area where the answer
efine the area where the answer vector for x will be shown, but do not type any numbers into that area.
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
This question has not been answered.
Create a free account to get help with this and any other question!
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
Part of group assignment; I only need 5 pages for my portion; serious tutors; no plagiarism
ToolsCorp Corporation is a fictitious company that does not exist anywhere. For the purpose of this course, it is located ...
Part of group assignment; I only need 5 pages for my portion; serious tutors; no plagiarism
ToolsCorp Corporation is a fictitious company that does not exist anywhere. For the purpose of this course, it is located in Tennessee. As members of the senior management team of ToolsCorp Corporation, your group has been asked to prepare a neat and organized report for the Strategic Officers Steering Committee (SOS-C) of ToolsCorp Corporation. The purpose of this paper is to obtain permission from them to go forward with the next step (developing a full-blown business plan) for ToolsCorp's strategic initiative to break into the global marketplace.Your group's paper should discuss the following (at a minimum):A complete strengths, weaknesses, opportunities, and threats (SWOT) analysis (including at least 5 factors from each category and full explanations of why each factor is important and why it was placed in the category) of the environment that exists within ToolsCorp and the environment that ToolsCorp is proposingAn outline of the business plan to be developed for ToolsCorp's strategic initiativeA full mission statement containing the nine components and presented in a well written paragraphKey operating principles as you will apply themA preliminary market analysis of the market(s) into which ToolsCorp expandsThe one-year, five-year, and ten-year strategic objectives of the strategic initiatives presented as one strategic proposal for each time frame (3 strategic proposals in all), complete with implementation plans, potential ramifications, and feedback mechanismsThe additional material that your group considers necessary to support the case for going forward with ToolsCorp's global strategic initiative (This is not optional, you must input additional material.)Background InformationToolsCorp Corporation is a fictitious company that does not exist anywhere. For the purpose of this course, it is located it in Tennessee. It builds power tools, lawn mowers, lawn furniture, microwaves, and ranges. All products are manufactured locally and sold through large retailers that place sales papers inserted in every Wednesday and Sunday paper. Although they have a thriving business in the United States and Canada, ToolsCorp is trying to break into the global marketplace.Deliverable LengthThe deliverable length is at least 15 pages (cover page and reference page not included). As graduate business students, you are required to provide a well-researched and analyzed comprehensive response to every assignment question. Brief, vague, generic, or nondefinitive responses will not earn good grades.This group project requires a minimum of 15 scholarly sources, a minimum of 1 per page. You are welcome and encouraged to use the David textbook and the course materials for this course, but other viable research sources are required.For references, use the APA guide that is available as shown in the Virtual Campus under "Interactive Learning."Remember that any paper longer than 10 pages requires the submission of an Executive Summary.Submit your group's Word document to your instructor via the Small Group Submitted Assignment area in APA format.ObjectiveThe Objective of the Unit 5 Group Project Assignment will involve the following the course outcomes and grading criteria with their respective percentages for the grading rubric:Identify examples of good and bad business practices in the use of strategy design components (30%).Research and discuss some of the changes occurring in the way that organizations structure themselves and their work (30%).Develop plans to improve business operations (20%).Use effective communication techniques (20%).
Final Project Milestone One: First Part of Workbook
Ultimately there is a final presentation that is due at the end of this class. There are three milestones that leads up to ...
Final Project Milestone One: First Part of Workbook
Ultimately there is a final presentation that is due at the end of this class. There are three milestones that leads up to it. If you take on the milestone, I will invite you for the other milestones and the final project. The combination of the milestones and the final project will be what i am offering for the whole assignment. The final project price will be lower than what it should be because it will be compiled in the prices for each milestonewe can discuss a specific number for everything if you wishi will attach the FINAL presentation rubric alsoIn this first milestone of your final project, you will submit your cost classification tabs in your workbook. Correctly classifying your costs is essential for successfully completing the next steps in your project, so be sure to carefully and thoroughly follow the instructions.To complete this assignment, review the prompt and grading rubric in the Milestone One Guidelines and Rubric document. When you have finished your work, submit the assignment here for grading and instructor feedback.Attachments are below( workbook is an excel file, milestone one shows the rubric and the details of the assignment)
BUSI 750 Liberty University Online Netflix Strategic HR Audit Presentation
Write a 2,000-word (minimum word count excluding your references section) paper and develop a related 15 slide presentatio ...
BUSI 750 Liberty University Online Netflix Strategic HR Audit Presentation
Write a 2,000-word (minimum word count excluding your references section) paper and develop a related 15 slide presentation (you will not actually deliver your presentation live but prepare your slides as though you were going to). Choose any company with 100 or more employees and apply the following Model of Strategic HR Management as a means of investigating and assessing the strategic HR practices of the firm.
We are Company E or E-Wear Company, Organization Performance help
Assignment: Organization Performance (We are Company E or E-Wear Company). Directions: Consider your BSG operations and i ...
We are Company E or E-Wear Company, Organization Performance help
Assignment: Organization Performance (We are Company E or E-Wear Company). Directions: Consider your BSG operations and in a 1200-1500 word paper discuss the following: 1.What was your company approach to workforce compensation? 2.What evidence indicates your company's workforce compensation strategy worked, for example, has your company's compensation approach actually boosted productivity? 3.What evidence indicates productivity gains resulted in adjusted labor costs? 4.Was your workforce compensation approach successful, explain? 5.What is your plan for improvement? 6.Format your paper according to NAU standards and APA 6th ed. Include two or more references.Read Plant 02. Operations Report - 03. Company Analysis - 01. Footwear Industry Report (Page 5, 6, 7)
Contracts and procurments
Overview:Project contract and procurement management involves making a decision to outsource work, developing a statement ...
Contracts and procurments
Overview:Project contract and procurement management involves making a decision to outsource work, developing a statement of work, submitting a request for proposal, awarding the contract, and then managing the procurements until contract completion. Having a detailed procurement plan lowers the risk for nonfulfillment of contracted work. In this class, you are asked to develop a Contract and Procurement Plan that identifies planning and execution components from developing the statement of work through the final contract delivery. You will select a project that you may have developed in a previous class or a known project in your organization to create this plan for.Throughout this course, you will be working on developing several components of the final Key Assignment. Additional information and the deliverables for each Individual Project will be provided in the assignment description for this project.In this first Individual Project, you are asked to develop the outline of the sections that will be included in the Contract and Procurement Plan document, as well as a draft of a proposal to submit to your instructor. The other information you will include is a high-level description of the project you will be conducting the project procurements for.You will also be setting up the final Key Assignment outline that you will add to each week. The combined Individual Project (IP) assignments will be your final Key Assignment deliverable.Project Selection:The first step will be to select a project for which you wish to develop a contract and procurement plan. This project will be used as the basis for each of the assignments throughout the course and should conform to the following guidelines:Nontrivial: The selected project candidate should reflect a real life project. Domain knowledge: You will be applying knowledge of this project to address assignments related to purchasing products or services outside the project team work, which requires the fulfillment of terms laid out in a contract. Select a project that fit these requirements, and submit your proposal to your instructor before proceeding further with the assignments in the course. Approval should be sought within the first few days of the course. Your instructor will tell you how to submit this proposal and what notification will be given for project approval.Assignment:Your first task in this process will be to select a project to use as the basis of your Key Assignment. You will also create the shell document for the final project Key Assignment document deliverable that you will be working on throughout the course. As you proceed through each phase of the project, you will add content to each section of the final document to gradually complete the final project delivery, which is the Contract & Procurement Management Plan. The project deliverables are as follows:1.Submit your project proposal to instructor for approval. 2.Contract & Procurement Management Plan Document Shell ◦Use Microsoft Word ◦Title Page i.Course number and name ii.Project name iii.Your name iv.Date ◦Table of Contents i.Use auto-generated TOC ii.Separate page iii.Maximum of 3 levels deep iv.Update the fields of the TOC so it is up-to-date before submitting your project ◦Section Headings (Create each heading on a new page with TBD as content except for sections listed under New Content below.) i.Project outline ii.Make or buy analysis iii.Contract type selection iv.Request for proposal (RFP) v.Statement of work (SOW) vi.Source selection criteria vii.Procurement contract award viii.Procurement risks ix.Procurement management process x.Contract administration process xi.Change control process xii.Quality control plan xiii.Performance reporting plan xiv.Project procurement legal rights & responsibilities xv.Project procurement closeout 3.New Content to be Inserted in Above Shell ◦Project Outline i.Brief description of the project ii.Material taken from approved proposal submitted to instructor will serve as the draft for the proposal iii.Project must be approved by the instructor ◦Make or Buy Analysis i.Discuss why the procurement portion of the selected project is going to be sourced out (or buy). ii.Discuss pros and cons of making (or keeping within the project team to do) versus sourcing out. iii.Include a financial and schedule deadline justification.◦Contract Type Selection i.Discuss the pros and cons of at least 3 contract types for this project. ii.Identify the final contract type selected with a justification. For this assignment, you will select the best RFP, SOW template, and procurement contract award template that you researched in the Discussion Board. You should have at least 6 sections in each of the templates. Your next task is to fill in all of your relevant project information in each of the templates.For the compilation of your source selection criteria, you may use similar to the following table or matrix:DeliverablesThe overall project deliverables are as follows:Update the Key Assignment document title page with the new date and project name. Update previously completed sections based on instructor feedback. Complete new content below, and copy it under the sections in Key Assignment document called Request for Proposal, Statement of Work, and Source Selection Criteria. New content to be inserted is as follows:1.Request For Proposal (RFP) i.Fill in all of the sections in the selected RFP with sufficient detail. ii.Prepare a brief letter to be sent with the RFP explaining why you are sending it to the specific vendors. iii.Build a list of at least 3 real or fictitious vendors. 2.Statement of Work (SOW) i.Fill in all of the sections in the selected SOW with sufficient detail. 3.Source Selection Criteria i.Construct a selection criteria matrix similar to the example with at least 6 or more criteria in the first column to effectively rate your 3 vendors or suppliers. ii.Fill in the names of each of the vendors across the top. iii.Determine how you will rank them (e.g., 3 = high probability, 2 = good probability, and 1 = low probability) to allow you to tally these up for an overall ranking. For this assignment, you will expand upon what you started in the Discussion Board. You will expand on the risks identified in the Discussion Board, and describe how you will prevent or mitigate them. For the procurement management process, you will update your project schedule to include the extra tasks related to this work and develop a contingency budget component. For the contract administration process, you will supply the details for how you will manage the overall contract process, and define your relationship with the vendor doing the work including checkpoints and payments. 1.New Content to be Inserted in Above Shell ◦Procurement Contract Awardi.Complete award letter ◦Procurement Risks i.Provide the list of risks related to the procured or contracted work. ii.Rate the risks according to likelihood and impact. iii.Include the mitigation strategy for each. iv.Include potential cost of each if it occurs. ◦Procurement Management Process i.Update the existing schedule or plan to include the additional tasks related to the deliverable that is now outsourced. ii.Update the contingency budget to include additional costs that may be related to resolving risks. iii.Design the overall communications process related specifically to the procured work. ◦Contract Administration Process i.Determine the communications process through status meetings, how often they occur, and what information will be supplied. ii.Describe each of the checkpoints and what reviews and sign offs will take place. iii.Identify the roles and responsibilities of both the vendor (seller) and the project manager (buyer). iv.When problems arise, describe in detail what the process will be to solve them. For this assignment, you will further enhance your overall Contract and Procurement Management Plan or Key Assignment by adding in a section for change control, quality control, and overall performance reporting. Addressing these up-front adds to the chances for a successful execution of this project.1.New Content to be Inserted in Above Shell ◦Change Control Process i.Describe how a change is submitted and a sample change request form. ii.Identify who has control over the review and approval process for the change. iii.Discuss how this change is submitted to the vendor for sizing and estimate of the cost. ◦Quality Control Plan i.Identify how the outsourced or procured work will be inspected/verified, and by whom. ii.Discuss the process if the work is rejected due to noncompliance with requirements. ◦Performance Reporting Plan i.Identify specific reports that will be utilized to track performance of this deliverable and in relation to whole schedule. ii.Provide mock-ups of the reports (these can be reports that are generated by Microsoft Project). iii.Determine how often and who will receive the reports. In the previous weeks, you selected a project to develop your Contract and Procurement Management Plan Key Assignment around. In Week 1, you provided compelling documentation on make versus buy, which led to determining a contract type that you would outsource the work with. In Week 2, you developed a detailed statement of work, included it in a formal RFP, and developed the section criteria to select the source the contract would be awarded to. In Week 3, you evaluated all of the risks involved with procuring out this work, and determined what the overall management and contract administration processes would be. In Week 4, you implemented processes for change control and quality control to reduce some of the risks identified in Week 3. At this point, you are planning for procurement closure, which includes attention being given to the legal aspects, rights, and responsibilities as well as all of the closure activities. In the final week, you are also revising the Key Assignment draft document based on feedback from your instructor and peer. Deliverables:The overall project deliverables are as follows:1.Update previously completed sections based on instructor feedback. 2.Complete new content below, and copy it under the appropriate sections in Key Assignment Document called Project Procurement Legal Rights & Responsibilities and Project Procurement Closeout. ◦New Content ◾Project Procurement Legal Rights, & Responsibilities i.Discuss legal aspects involved with contract management and closure. ii.Discuss the process to be used to handle any outstanding issues, claims, and disputes such as through an alternative dispute resolution (ADR). iii.Document what might be terms for contract termination by either the seller or buyer. iv.Outline rights and responsibilities of both the seller and buyer as they relate to procurement closure. ◾Project Procurement Closeout i.Determine the acceptance criteria for determining that the project procurement is complete. ii.Identify process for obtaining final sign-offs and final payments to close out the contract. iii.Determine final documentation to be included in the project procurement closure package. iv.Identify the techniques that will be utilized to elicit lessons learned. 3.Update the Key Assignment title page with new date and project name. 4.Update previously completed sections based on instructor feedback. 5.Be sure to update your table of contents before submission.Deliverable Length: 3,000–6,000 words (10–20 pages) total
Abbott Academy New York Times Co. V. Sullivan and Precedent Law Cases
2 or 3 pages about this case.Q: which prior cases were used as guidance (precedents)The final slide should be a bibliograp ...
Abbott Academy New York Times Co. V. Sullivan and Precedent Law Cases
2 or 3 pages about this case.Q: which prior cases were used as guidance (precedents)The final slide should be a bibliography of your references. Wikipedia will not count as a reference.You can use the format from this document. Any pages from this one.
Similar Content
MGT 402 Saudi Electronic University Diamond Rock Business Plan
المملكة العربية السعودية
وزارة التعليم
الجامعة السعودية ا...
news summaries about law
Use your own words write a news summaries about some law. Please do not plagiarism, the similar should under 10 perc...
Working in Groups paper
Write a 900-1,050-word paper in which you address the following:
Do you agree with your results?
Based on your self-asse...
Miami University Business Analytics and Data Analytics Discussion
What do you imagine will be the most challenging aspect of your individual project proposal? What is the weakest link that...
MGT 201 Saudi Electronic University Branding and Packaging Decisions Questions
NO plagiarism no match using APA style reference using time new roman size 12 double spaced font word only...
CSU Business Relationship Ethics and Leadership Questions
This assignment provides you with an opportunity to think critically about business ethics, business relationships, leader...
Cyber Crime
It may therefore, choose to expand locally so as ground and it doesn’t have to look for new assessments as well as risks...
Employees Health And Safety In The Organization
Roles of Human Resource in Offering Healthy and Safe Environment to Worker First, human resources are responsible for the ...
Sosop Mattresses
use of various raw materials. these raw materials include; The company uses line production with each level of productio...
Related Tags
Book Guides
Good Kids Bad City
by Kyle Swenson
American Gods
by Neil Gaiman
The Scarlet Letter
by Nathaniel Hawthorne
The Sun Is Also a Star
by Nicola Yoon
Milkweed
by Jerry Spinelli
Othello
by Wiliam Shakespeare
Hidden Figures
by Margot Lee Shetterly
1984
by George Orwell
Notes from Underground
by Fyodor Dostoyevsky
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
Part of group assignment; I only need 5 pages for my portion; serious tutors; no plagiarism
ToolsCorp Corporation is a fictitious company that does not exist anywhere. For the purpose of this course, it is located ...
Part of group assignment; I only need 5 pages for my portion; serious tutors; no plagiarism
ToolsCorp Corporation is a fictitious company that does not exist anywhere. For the purpose of this course, it is located in Tennessee. As members of the senior management team of ToolsCorp Corporation, your group has been asked to prepare a neat and organized report for the Strategic Officers Steering Committee (SOS-C) of ToolsCorp Corporation. The purpose of this paper is to obtain permission from them to go forward with the next step (developing a full-blown business plan) for ToolsCorp's strategic initiative to break into the global marketplace.Your group's paper should discuss the following (at a minimum):A complete strengths, weaknesses, opportunities, and threats (SWOT) analysis (including at least 5 factors from each category and full explanations of why each factor is important and why it was placed in the category) of the environment that exists within ToolsCorp and the environment that ToolsCorp is proposingAn outline of the business plan to be developed for ToolsCorp's strategic initiativeA full mission statement containing the nine components and presented in a well written paragraphKey operating principles as you will apply themA preliminary market analysis of the market(s) into which ToolsCorp expandsThe one-year, five-year, and ten-year strategic objectives of the strategic initiatives presented as one strategic proposal for each time frame (3 strategic proposals in all), complete with implementation plans, potential ramifications, and feedback mechanismsThe additional material that your group considers necessary to support the case for going forward with ToolsCorp's global strategic initiative (This is not optional, you must input additional material.)Background InformationToolsCorp Corporation is a fictitious company that does not exist anywhere. For the purpose of this course, it is located it in Tennessee. It builds power tools, lawn mowers, lawn furniture, microwaves, and ranges. All products are manufactured locally and sold through large retailers that place sales papers inserted in every Wednesday and Sunday paper. Although they have a thriving business in the United States and Canada, ToolsCorp is trying to break into the global marketplace.Deliverable LengthThe deliverable length is at least 15 pages (cover page and reference page not included). As graduate business students, you are required to provide a well-researched and analyzed comprehensive response to every assignment question. Brief, vague, generic, or nondefinitive responses will not earn good grades.This group project requires a minimum of 15 scholarly sources, a minimum of 1 per page. You are welcome and encouraged to use the David textbook and the course materials for this course, but other viable research sources are required.For references, use the APA guide that is available as shown in the Virtual Campus under "Interactive Learning."Remember that any paper longer than 10 pages requires the submission of an Executive Summary.Submit your group's Word document to your instructor via the Small Group Submitted Assignment area in APA format.ObjectiveThe Objective of the Unit 5 Group Project Assignment will involve the following the course outcomes and grading criteria with their respective percentages for the grading rubric:Identify examples of good and bad business practices in the use of strategy design components (30%).Research and discuss some of the changes occurring in the way that organizations structure themselves and their work (30%).Develop plans to improve business operations (20%).Use effective communication techniques (20%).
Final Project Milestone One: First Part of Workbook
Ultimately there is a final presentation that is due at the end of this class. There are three milestones that leads up to ...
Final Project Milestone One: First Part of Workbook
Ultimately there is a final presentation that is due at the end of this class. There are three milestones that leads up to it. If you take on the milestone, I will invite you for the other milestones and the final project. The combination of the milestones and the final project will be what i am offering for the whole assignment. The final project price will be lower than what it should be because it will be compiled in the prices for each milestonewe can discuss a specific number for everything if you wishi will attach the FINAL presentation rubric alsoIn this first milestone of your final project, you will submit your cost classification tabs in your workbook. Correctly classifying your costs is essential for successfully completing the next steps in your project, so be sure to carefully and thoroughly follow the instructions.To complete this assignment, review the prompt and grading rubric in the Milestone One Guidelines and Rubric document. When you have finished your work, submit the assignment here for grading and instructor feedback.Attachments are below( workbook is an excel file, milestone one shows the rubric and the details of the assignment)
BUSI 750 Liberty University Online Netflix Strategic HR Audit Presentation
Write a 2,000-word (minimum word count excluding your references section) paper and develop a related 15 slide presentatio ...
BUSI 750 Liberty University Online Netflix Strategic HR Audit Presentation
Write a 2,000-word (minimum word count excluding your references section) paper and develop a related 15 slide presentation (you will not actually deliver your presentation live but prepare your slides as though you were going to). Choose any company with 100 or more employees and apply the following Model of Strategic HR Management as a means of investigating and assessing the strategic HR practices of the firm.
We are Company E or E-Wear Company, Organization Performance help
Assignment: Organization Performance (We are Company E or E-Wear Company). Directions: Consider your BSG operations and i ...
We are Company E or E-Wear Company, Organization Performance help
Assignment: Organization Performance (We are Company E or E-Wear Company). Directions: Consider your BSG operations and in a 1200-1500 word paper discuss the following: 1.What was your company approach to workforce compensation? 2.What evidence indicates your company's workforce compensation strategy worked, for example, has your company's compensation approach actually boosted productivity? 3.What evidence indicates productivity gains resulted in adjusted labor costs? 4.Was your workforce compensation approach successful, explain? 5.What is your plan for improvement? 6.Format your paper according to NAU standards and APA 6th ed. Include two or more references.Read Plant 02. Operations Report - 03. Company Analysis - 01. Footwear Industry Report (Page 5, 6, 7)
Contracts and procurments
Overview:Project contract and procurement management involves making a decision to outsource work, developing a statement ...
Contracts and procurments
Overview:Project contract and procurement management involves making a decision to outsource work, developing a statement of work, submitting a request for proposal, awarding the contract, and then managing the procurements until contract completion. Having a detailed procurement plan lowers the risk for nonfulfillment of contracted work. In this class, you are asked to develop a Contract and Procurement Plan that identifies planning and execution components from developing the statement of work through the final contract delivery. You will select a project that you may have developed in a previous class or a known project in your organization to create this plan for.Throughout this course, you will be working on developing several components of the final Key Assignment. Additional information and the deliverables for each Individual Project will be provided in the assignment description for this project.In this first Individual Project, you are asked to develop the outline of the sections that will be included in the Contract and Procurement Plan document, as well as a draft of a proposal to submit to your instructor. The other information you will include is a high-level description of the project you will be conducting the project procurements for.You will also be setting up the final Key Assignment outline that you will add to each week. The combined Individual Project (IP) assignments will be your final Key Assignment deliverable.Project Selection:The first step will be to select a project for which you wish to develop a contract and procurement plan. This project will be used as the basis for each of the assignments throughout the course and should conform to the following guidelines:Nontrivial: The selected project candidate should reflect a real life project. Domain knowledge: You will be applying knowledge of this project to address assignments related to purchasing products or services outside the project team work, which requires the fulfillment of terms laid out in a contract. Select a project that fit these requirements, and submit your proposal to your instructor before proceeding further with the assignments in the course. Approval should be sought within the first few days of the course. Your instructor will tell you how to submit this proposal and what notification will be given for project approval.Assignment:Your first task in this process will be to select a project to use as the basis of your Key Assignment. You will also create the shell document for the final project Key Assignment document deliverable that you will be working on throughout the course. As you proceed through each phase of the project, you will add content to each section of the final document to gradually complete the final project delivery, which is the Contract & Procurement Management Plan. The project deliverables are as follows:1.Submit your project proposal to instructor for approval. 2.Contract & Procurement Management Plan Document Shell ◦Use Microsoft Word ◦Title Page i.Course number and name ii.Project name iii.Your name iv.Date ◦Table of Contents i.Use auto-generated TOC ii.Separate page iii.Maximum of 3 levels deep iv.Update the fields of the TOC so it is up-to-date before submitting your project ◦Section Headings (Create each heading on a new page with TBD as content except for sections listed under New Content below.) i.Project outline ii.Make or buy analysis iii.Contract type selection iv.Request for proposal (RFP) v.Statement of work (SOW) vi.Source selection criteria vii.Procurement contract award viii.Procurement risks ix.Procurement management process x.Contract administration process xi.Change control process xii.Quality control plan xiii.Performance reporting plan xiv.Project procurement legal rights & responsibilities xv.Project procurement closeout 3.New Content to be Inserted in Above Shell ◦Project Outline i.Brief description of the project ii.Material taken from approved proposal submitted to instructor will serve as the draft for the proposal iii.Project must be approved by the instructor ◦Make or Buy Analysis i.Discuss why the procurement portion of the selected project is going to be sourced out (or buy). ii.Discuss pros and cons of making (or keeping within the project team to do) versus sourcing out. iii.Include a financial and schedule deadline justification.◦Contract Type Selection i.Discuss the pros and cons of at least 3 contract types for this project. ii.Identify the final contract type selected with a justification. For this assignment, you will select the best RFP, SOW template, and procurement contract award template that you researched in the Discussion Board. You should have at least 6 sections in each of the templates. Your next task is to fill in all of your relevant project information in each of the templates.For the compilation of your source selection criteria, you may use similar to the following table or matrix:DeliverablesThe overall project deliverables are as follows:Update the Key Assignment document title page with the new date and project name. Update previously completed sections based on instructor feedback. Complete new content below, and copy it under the sections in Key Assignment document called Request for Proposal, Statement of Work, and Source Selection Criteria. New content to be inserted is as follows:1.Request For Proposal (RFP) i.Fill in all of the sections in the selected RFP with sufficient detail. ii.Prepare a brief letter to be sent with the RFP explaining why you are sending it to the specific vendors. iii.Build a list of at least 3 real or fictitious vendors. 2.Statement of Work (SOW) i.Fill in all of the sections in the selected SOW with sufficient detail. 3.Source Selection Criteria i.Construct a selection criteria matrix similar to the example with at least 6 or more criteria in the first column to effectively rate your 3 vendors or suppliers. ii.Fill in the names of each of the vendors across the top. iii.Determine how you will rank them (e.g., 3 = high probability, 2 = good probability, and 1 = low probability) to allow you to tally these up for an overall ranking. For this assignment, you will expand upon what you started in the Discussion Board. You will expand on the risks identified in the Discussion Board, and describe how you will prevent or mitigate them. For the procurement management process, you will update your project schedule to include the extra tasks related to this work and develop a contingency budget component. For the contract administration process, you will supply the details for how you will manage the overall contract process, and define your relationship with the vendor doing the work including checkpoints and payments. 1.New Content to be Inserted in Above Shell ◦Procurement Contract Awardi.Complete award letter ◦Procurement Risks i.Provide the list of risks related to the procured or contracted work. ii.Rate the risks according to likelihood and impact. iii.Include the mitigation strategy for each. iv.Include potential cost of each if it occurs. ◦Procurement Management Process i.Update the existing schedule or plan to include the additional tasks related to the deliverable that is now outsourced. ii.Update the contingency budget to include additional costs that may be related to resolving risks. iii.Design the overall communications process related specifically to the procured work. ◦Contract Administration Process i.Determine the communications process through status meetings, how often they occur, and what information will be supplied. ii.Describe each of the checkpoints and what reviews and sign offs will take place. iii.Identify the roles and responsibilities of both the vendor (seller) and the project manager (buyer). iv.When problems arise, describe in detail what the process will be to solve them. For this assignment, you will further enhance your overall Contract and Procurement Management Plan or Key Assignment by adding in a section for change control, quality control, and overall performance reporting. Addressing these up-front adds to the chances for a successful execution of this project.1.New Content to be Inserted in Above Shell ◦Change Control Process i.Describe how a change is submitted and a sample change request form. ii.Identify who has control over the review and approval process for the change. iii.Discuss how this change is submitted to the vendor for sizing and estimate of the cost. ◦Quality Control Plan i.Identify how the outsourced or procured work will be inspected/verified, and by whom. ii.Discuss the process if the work is rejected due to noncompliance with requirements. ◦Performance Reporting Plan i.Identify specific reports that will be utilized to track performance of this deliverable and in relation to whole schedule. ii.Provide mock-ups of the reports (these can be reports that are generated by Microsoft Project). iii.Determine how often and who will receive the reports. In the previous weeks, you selected a project to develop your Contract and Procurement Management Plan Key Assignment around. In Week 1, you provided compelling documentation on make versus buy, which led to determining a contract type that you would outsource the work with. In Week 2, you developed a detailed statement of work, included it in a formal RFP, and developed the section criteria to select the source the contract would be awarded to. In Week 3, you evaluated all of the risks involved with procuring out this work, and determined what the overall management and contract administration processes would be. In Week 4, you implemented processes for change control and quality control to reduce some of the risks identified in Week 3. At this point, you are planning for procurement closure, which includes attention being given to the legal aspects, rights, and responsibilities as well as all of the closure activities. In the final week, you are also revising the Key Assignment draft document based on feedback from your instructor and peer. Deliverables:The overall project deliverables are as follows:1.Update previously completed sections based on instructor feedback. 2.Complete new content below, and copy it under the appropriate sections in Key Assignment Document called Project Procurement Legal Rights & Responsibilities and Project Procurement Closeout. ◦New Content ◾Project Procurement Legal Rights, & Responsibilities i.Discuss legal aspects involved with contract management and closure. ii.Discuss the process to be used to handle any outstanding issues, claims, and disputes such as through an alternative dispute resolution (ADR). iii.Document what might be terms for contract termination by either the seller or buyer. iv.Outline rights and responsibilities of both the seller and buyer as they relate to procurement closure. ◾Project Procurement Closeout i.Determine the acceptance criteria for determining that the project procurement is complete. ii.Identify process for obtaining final sign-offs and final payments to close out the contract. iii.Determine final documentation to be included in the project procurement closure package. iv.Identify the techniques that will be utilized to elicit lessons learned. 3.Update the Key Assignment title page with new date and project name. 4.Update previously completed sections based on instructor feedback. 5.Be sure to update your table of contents before submission.Deliverable Length: 3,000–6,000 words (10–20 pages) total
Abbott Academy New York Times Co. V. Sullivan and Precedent Law Cases
2 or 3 pages about this case.Q: which prior cases were used as guidance (precedents)The final slide should be a bibliograp ...
Abbott Academy New York Times Co. V. Sullivan and Precedent Law Cases
2 or 3 pages about this case.Q: which prior cases were used as guidance (precedents)The final slide should be a bibliography of your references. Wikipedia will not count as a reference.You can use the format from this document. Any pages from this one.
Earn money selling
your Study Documents