Calculate the weighted average cost

Assignment Help Management Information Sys
Reference no: EM132248389

Application Integration Assignment - Hospital Procurement Process Model

1. You are given an actual hospital procurement process (see attached Table 1 and related Figure 1). This is to be modeled as the 'As Is' Process using IBM Blue Works Lives. Sign up for the 1 month free trial of the full version of this SaaS application.

Export your process, or use screen shots to depict your process diagram in your report.

2. Provide a report on your BlueWorksLive As Is Model analysis. This is to include:

  • Comments
  • Problems
  • Costs
  • Times

As an extension exercise to earn full marks for this assignment, calculate the Weighted Average Cost (WAC) for this process. Use an Excel spreadsheet. Identify each case (path through the process), and add the total cost for each case. Then, consider the probability for each path, with the total probability adding to 100%. Apply the probability percentages to the total costs, and sum to obtain the WAC.

3. Based on the objectives of e-procurement, an automated, improved 'To Be' process is to be proposed. Use your imagination! The 'To Be' process is to be presented as a new BlueWorksLive Process.

Hint: Do not copy the As Is Process and make a few incremental changes. Start afresh and submit a simplified redesigned process.

Provide your analysis. In particular, how have addressed the following problems:

a) Backorder problem. The supplier has no stock and the hospital does not find out for a week until the start of the next ordering cycle.

b) Three-way match problem. The Purchase Order, GRN (Goods Received Note) and Invoice from Supplier need to be matched by Accounts Payable to pay the supplier.

These 3 documents often do not match resulting in a short or delayed payment to the supplier.

Again, as an extension exercise, you can consider the WAC of the To Be Process. You can make the following assumptions:

  • IT capital investment of $50,000 for the ROI calculation
  • 'As Is' and 'To Be' processes are each daily processes, 365 days p.a.
  • Costs in the 'To Be' process are only a preliminary feasibility and do not have to be highly accurate.

Attachment:- Assignment File.rar

Verified Expert

This was a very difficult assignment. It involved both software and financial analysis.A manual supply chain management process was automated. Detailed process diagrams were created in IBM Blueworks.Costs of the old and new systems were calculated.

Reference no: EM132248389

Questions Cloud

Analyze the cost projections completed by franklin : Analyze the cost projections completed by Franklin Electronics. Reconstruct the cost projections toward the compilation of a realistic project budget.
Perform the hypothesis testing with data : Perform the hypothesis testing with this data. Show all of your calculation and work at each of the four steps of statistical hypothesis testing.
What facts and misconceptions need to be revisited : What will it take for Americans (as individuals) and for the United States (as a nation) to get their health and nutrition back on track? What facts.
Smartphone-dependent-younger adults : Smartphone adoption among younger adults has increased substantially and mobile access to the Internet is pervasive. Sixteen percent of young adults
Calculate the weighted average cost : ITEC832: Application Integration Assignment - Hospital Procurement Process Model, Macquarie University, Australia. Calculate the Weighted Average Cost
What is your opinion of the role of project management : What is your opinion of the role of project management within an organization, and ultimately, of the project manager.
What is the probability that based on a sample : What is the probability that based on a sample of 36 nails, the inspector will conclude that the machine needs an adjustment?
Normally distributed within the population : Assume that the fuel efficiency for this vehicle is normally distributed within the population, and let X denote the fuel efficiency of a randomly selected
Analyze events that have taken place in real-life businesses : Evaluate which of the sources/risks above with which Cooper Manufacturing is involved. Explain the amount of risk associated with each.

Reviews

inf2248389

8/21/2019 2:14:49 AM

It was a great experience having your service. An assignment delivered on time and it is as per the requirements. Assignment was plagiarism free and no errors were present in the report file.

inf2248389

8/21/2019 2:13:24 AM

Provide a report on your BlueWorksLive As Is Model analysis. This is to include: - Comments - Problems - Costs - Times The information in the assignment also gave an hint here, Based on the objectives of e-procurement, an automated, improved ‘To Be’ process is to be proposed. Use your imagination! The ‘To Be’ process is to be presented as a new BlueWorksLive Process. Provide your analysis. In particular, show you have addressed the following problems: a) Backorder problem. b) Three-way match problem. Invoice from Supplier need to be matched by Accounts Payable to pay the supplier. These 3 documents often do not match resulting in a short or delayed payment to the supplier.

len2248389

3/5/2019 2:15:27 AM

No Of Pages/Words: 2000. Kindly follow the instructions given in the attached document in details. Hint: Do not copy the As Is Process and make a few incremental changes. Start afresh and submit a simplified redesigned process. HINT: Calculate the WAC for As Is and To Be. Determine the annual cost savings (As Is – To Be)*365. If the To Be cost is not cheaper than the As Is then redesign it! Next, deduct depreciation of capital = $50,000/5, assuming a 5 year system life. ROI = average annual net cost saving/capital cost. This assignment report as pdf and is expected to be 5 to 10 pages long (minimum of 10 point). Any detailed calculations or supporting data should be relegated to appendices, which can be additional to the 5 to 10 pages.

len2248389

3/5/2019 2:15:22 AM

Submission: Submit your report electronically through iLearn. This is a Turnitin assignment. Turnitin sometimes takes up to 24 hours to return a Similarity Index to you. You will not be penalized for copied cover sheets, questions and references. However, your analysis and discussion should be your own and not copied from any other sources. Marking Criteria - Students must satisfactorily complete each of the 3 sections of the report to pass this assignment. You will be marked according to the following criteria, with a final mark out of 100 and count towards 15% of your final score.

len2248389

3/5/2019 2:15:17 AM

Model of the As Is Process - Demonstrates high level of understanding of key concepts. Skillfully develops and presents the AS IS PROCESS diagram. As Is Model Analysis - Demonstrates high level of understanding of key concepts, Presents analysis in a clear and concise manner, All the key issues are identified as Comments and Problems. Metrics are correctly calculated and analysed as an extension exercise. To Be Process - Demonstrates high level of understanding of key concepts, Skillfully develops and presents the TO BE PROCESS diagram, All the key issues are identified as Comments and Problems, Metrics are correctly calculated and analysed as an extension exercise.

Write a Review

Management Information Sys Questions & Answers

  Information technology and the changing fabric

Illustrations of concepts from organizational structure, organizational power and politics and organizational culture.

  Case study: software-as-a-service goes mainstream

Explain the questions based on case study. case study - salesforce.com: software-as-a-service goes mainstream

  Research proposal on cloud computing

The usage and influence of outsourcing and cloud computing on Management Information Systems is the proposed topic of the research project.

  Host an e-commerce site for a small start-up company

This paper will help develop internet skills in commercial services for hosting an e-commerce site for a small start-up company.

  How are internet technologies affecting the structure

How are Internet technologies affecting the structure and work roles of modern organizations?

  Segregation of duties in the personal computing environment

Why is inadequate segregation of duties a problem in the personal computing environment?

  Social media strategy implementation and evaluation

Social media strategy implementation and evaluation

  Problems in the personal computing environment

What is the basic purpose behind segregation of duties a problem in the personal computing environment?

  Role of it/is in an organisation

Prepare a presentation on Information Systems and Organizational changes

  Perky pies

Information systems to adequately manage supply both up and down stream.

  Mark the equilibrium price and quantity

The demand schedule for computer chips.

  Visit and analyze the company-specific web-site

Visit and analyze the Company-specific web-site with respect to E-Commerce issues

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd