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

  Describe how e-commerce begin and what made it successful

Describe how e-commerce begin and what made it successful and Briefly discuss the various organizational approaches to managing ethics within an IS

  Identify the significant developments

Identify the significant developments that are occurring related to global integration and What implications does this have for the technology that an organization might have in its supply network?

  Discuss about system development roles and responsibilities

Research and review at least three case studies using the University Library on BI.Use the software of your choice such as Sound Recorder.

  Write a term paper on the topic byod policies

You must write a 5 pages term paper on the topic BYOD Policies, In addition to the 5 pages of the paper itself.

  Leaving a taxable estate

Barry made taxable gifts as follows: $400,000 in 1973, $200,000 in 1974, $600,000 in 1985, and $700,000 in 2001. In 2009, Barry dies leaving a taxable estate of $4,000,000. Barry's tax base for applying the unified tax rate schedules (for estate t..

  Describe what hacking of memory or hacking of ram means

Describe what hacking of memory or hacking of RAM means. Examine the common tools that hackers use to hack into memory of computing devices. Detail two (2) real-life examples of such tools in action.

  Design a plan to integrate the different routing protocols

Design a plan to integrate the different routing protocols into a new network design for Genome4U's lab.

  Design and model a portion of csus network

Using the network design principles described in the textbook you are going to analysis, design and model a portion of CSU's network.

  Apple computers high technology personnel rapid response

apple computers high technology personnel rapid response support structureapple computers inc.1. what is apples special

  Think of a conflict that occurred in a team you were a part

Think of a conflict that occurred in a team you were a part of and analyze it. What were the main sources of the conflict?

  Analyze video game-type interfaces

Analyze video game-type interfaces and discuss three (3) reasons why video game-type interfaces would not be effective for real-world applications.

  Information security plans

As you are cleaning the store this morning you find a 3 gigabyte thumb drive. You know how valuable a thumb drive can be and that it probably contains one of your customer's data. What do you do? What security concerns are associated with the thum..

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