Formative Exercise Exercise Description: Using concepts, issue, and skills you learnt form the readings, PowerPoints notes,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Formative Exercise Exercise Description: Using concepts, issue, and skills you learnt form the readings, PowerPoints notes, the Business Case provided in the next few slides, to address the questions below. That is developed a comprehensive Economic Feasibility Workbook. Even though the focus of this exercise is mostly related to developing an Economic Feasibility Workbook for the summative assignment, you will be required to define terms, and address other major feasibility points, etc. That is, requires to meet the APA format and correctness and those that are required for this course. Moreover, correct and appropriate visual appearance, grammar, and quality of writing, as well as its contents, citing, and reference to justified context. Using PowerPoint format, make sure that the text of your report is well-structured, using paragraphs, full sentences, and other features of a well-written presentation. Use an appropriate number of slides, slide size (widescreen), soft background, and text font and size should appropriate for the reader. Assignment Details: From the Business Case text and Table A, use insightful justifications to complete a feasibility workbook. In the workbook. 1) Develop a separate worksheet for each, Tangible benefits. One-time Cost, and Recurring Cost. For each category (Tangible benefits, One-time Cost, and Recurring Cost) sheets must include as least two examples of tangible benefits, one-time costs and recurring costs, respectively. 2) Using a discount rate of 10%, develop a well labeled, legible flexible cost-benefit comprehensive analysis worksheet. Then, identify the overall NPV and ROI and when will break-even occurs. Also, include a well labelled and legible break-even chart. 3) Flexible - The sheets developed for (1) and (2) must include the use of cell-referencing, functions, etc., in, within, and across worksheets so when changing static values (ex: discount rate, one-time cost, etc.), all cells dependent on these changes are automatically updated 4) After complete the previous steps, make change to the workbook to reflect the data in Table B (slide5) Business Case: American Labs American Labs provides lab testing services for a variety of clients, mostly doctors' offices and other small medical businesses throughout the Midwest. Clients send test vials containing blood samples or other test requests to American Labs' testing center, where the requested tests are performed, after which the results are sent back to the client via fax. Jane Smith is the president of the company and the sponsor for the project is Rago Quell. Jan and Rago have approved the service request for the project. Jim Stevens, who is the project manager and who reports to Rago, is the head technician in the testing facility at American Labs, has approached you for help with the company's outdated inventory tracking system. The business has picked up recently, and the turnaround for clients' requested tests has been lengthening. To make matters worse, the lab technicians are seldom able to give customers an answer regarding where their requests fall in the testing queue or how long they can expect the turnaround to be. Much of this stems from an old, mostly paper-based inventory tracking system, which includes handwritten labels put on each of the incoming test vials and a logbook with entries made for each vial at each stage of the testing process. Business Case: American Labs - Cont. Jim would like to streamline the online inventory tracking process with an updated information system that uses barcodes and a modern database to keep track of customer test requests and the accompanying vials. He would like to enable technicians to provide accurate status updates and turnaround estimates, and generally shorten the turnaround time for test requests. He hopes to get this project completed within 4 months. After an initial analysis, the following estimations were summarized Table A (Values represent $) Year 0 0 Net economic benefit One-time cost Recurring Cost 75,000 0 Year 1 54,500 27,500 Year 2 54,500 27,500 Year 3 54,500 27,500 Year 4 54,500 27,500 Year 5 54,500 27,500 Business Case: American Labs - Cont. Table B (Values represent $) and discount rate = 12% Year 0 0 Net economic benefit One-time 70,000 cost Recurring 0 Cost Year 1 53,500 26,500 Year 2 53,500 26,500 Year 3 53,500 26,500 Year 4 53,500 26,500 Year 5 53,500 26,500 Formative Exercise Exercise Description: Using concepts, issue, and skills you learnt form the readings, PowerPoints notes, the Business Case provided in the next few slides, to address the questions below. That is developed a comprehensive Economic Feasibility Workbook. Even though the focus of this exercise is mostly related to developing an Economic Feasibility Workbook for the summative assignment, you will be required to define terms, and address other major feasibility points, etc. That is, requires to meet the APA format and correctness and those that are required for this course. Moreover, correct and appropriate visual appearance, grammar, and quality of writing, as well as its contents, citing, and reference to justified context. Using PowerPoint format, make sure that the text of your report is well-structured, using paragraphs, full sentences, and other features of a well-written presentation. Use an appropriate number of slides, slide size (widescreen), soft background, and text font and size should appropriate for the reader. Assignment Details: From the Business Case text and Table A, use insightful justifications to complete a feasibility workbook. In the workbook. 1) Develop a separate worksheet for each, Tangible benefits. One-time Cost, and Recurring Cost. For each category (Tangible benefits, One-time Cost, and Recurring Cost) sheets must include as least two examples of tangible benefits, one-time costs and recurring costs, respectively. 2) Using a discount rate of 10%, develop a well labeled, legible flexible cost-benefit comprehensive analysis worksheet. Then, identify the overall NPV and ROI and when will break-even occurs. Also, include a well labelled and legible break-even chart. 3) Flexible - The sheets developed for (1) and (2) must include the use of cell-referencing, functions, etc., in, within, and across worksheets so when changing static values (ex: discount rate, one-time cost, etc.), all cells dependent on these changes are automatically updated 4) After complete the previous steps, make change to the workbook to reflect the data in Table B (slide5) Business Case: American Labs American Labs provides lab testing services for a variety of clients, mostly doctors' offices and other small medical businesses throughout the Midwest. Clients send test vials containing blood samples or other test requests to American Labs' testing center, where the requested tests are performed, after which the results are sent back to the client via fax. Jane Smith is the president of the company and the sponsor for the project is Rago Quell. Jan and Rago have approved the service request for the project. Jim Stevens, who is the project manager and who reports to Rago, is the head technician in the testing facility at American Labs, has approached you for help with the company's outdated inventory tracking system. The business has picked up recently, and the turnaround for clients' requested tests has been lengthening. To make matters worse, the lab technicians are seldom able to give customers an answer regarding where their requests fall in the testing queue or how long they can expect the turnaround to be. Much of this stems from an old, mostly paper-based inventory tracking system, which includes handwritten labels put on each of the incoming test vials and a logbook with entries made for each vial at each stage of the testing process. Business Case: American Labs - Cont. Jim would like to streamline the online inventory tracking process with an updated information system that uses barcodes and a modern database to keep track of customer test requests and the accompanying vials. He would like to enable technicians to provide accurate status updates and turnaround estimates, and generally shorten the turnaround time for test requests. He hopes to get this project completed within 4 months. After an initial analysis, the following estimations were summarized Table A (Values represent $) Year 0 0 Net economic benefit One-time cost Recurring Cost 75,000 0 Year 1 54,500 27,500 Year 2 54,500 27,500 Year 3 54,500 27,500 Year 4 54,500 27,500 Year 5 54,500 27,500 Business Case: American Labs - Cont. Table B (Values represent $) and discount rate = 12% Year 0 0 Net economic benefit One-time 70,000 cost Recurring 0 Cost Year 1 53,500 26,500 Year 2 53,500 26,500 Year 3 53,500 26,500 Year 4 53,500 26,500 Year 5 53,500 26,500
Expert Answer:
Answer rating: 100% (QA)
Solutions Step 1 The provided scenario revolves around American Labs a company specializing in lab testing services Facing challenges with an outdated inventory system the head technician Jim Larsen s... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
What does internal rate of return (IRR) help you to determine? What is the primary goal of contract administration? Provide a repeatable methodology to ensure the development of a positive business...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
You would like to buy a house in in 16 years and estimate that you will need a deposit of $73,014. You plan to make bi-weekly deposits into an account that you hope will earn 7.05%. How much do you...
-
Eagle Inc., a U.S. corporation intends to create a limitada in Brazil in 2014 to manufacture pitching machines. The company expects the operation to generate losses of US$2,500,000 during its first...
-
Last year's freshman class at Big State University totaled 5,324 students. Of those, 1,254 received a merit scholarship to help offset tuition costs their freshman year (although the amount varied...
-
Which one of the following is not a cash equivalent? a. 30-day certificate of deposit b. 60-day corporate commercial paper c. 90-day treasury bill d. 180-day note issued by a local or provincial...
-
Gainesville Cigar stocks Cuban cigars that have variable lead times because of the difficulty in importing the product: Lead time is normally distributed with an average of 6 weeks and a standard...
-
Macrohard is a large software corporation that can obtain a8.50% pafixed rate of interest. Outtel is a government owned microchip manufacturing company. Outtel has a capital structure that is...
-
A beam of T cross section is formed by nailing together two boards having the dimensions shown in the figure. If the total shear force V acting on the cross section is 1500 N and each nail may carry...
-
How do organizational structures and hierarchies affect communication flow and decision-making processes within an organization ?
-
Highland Corporation acquired an asset in January of 2 0 X 1 the original cost was $ 8 0 , 0 0 0 . The property was 7 - year MARS property and was depreciated for book on a 1 0 - year straight line...
-
Consider the following data from the records of Monkey Co.: Units produced 20,000 Manufacturing cost incurred (per unit): Cost incurred to rework (per unit): Direct materials P5 Direct materials P2...
-
Over the years, smith's stockholders have provided $20 million when they purchased newly issued stocks. Currently, the stock is trading at $41 per share and 1 million shares outstanding. What is its...
-
Write- a paper, however, I need to plan outline of it first but I have no clue how to even start it. For some background information, the paper will be about a conspiracy theory that has evidence...
-
..A copper pipe carries hot water for domestic central heating. It is proposed to insulate the pipe to prevent heat loss to the surrounding air. (a) Calculate critical radius given that the thermal...
-
32. Solve the inequality set. Graph the solution on a numberline. |2x+12 13 Ox 0.5 -12.5x or x < 0.5 Ox-12.5 or x < 0.5 -12.5 0.5 O all real numbers no solution
-
Give the structural formulas of the alkenes that, on ozonolysis, give: a. (CH3)2C=O and CH2=O b. Only (CH3CH2)2C=O c. CH3CH=O and CH3CH2CH=O d. O=CHCH2CH2CH2CH=O
-
Sally hires a maid to work in her home for $250 per month. The maid is 25 years old and not related to Sally. During 2012, the maid worked 10 months for Sally. a. What is the amount of Social...
-
In 2012, Gale and Cathy Alexander hosted an exchange student, Axel Muller, for 9 months. Axel was part of International Student Exchange Programs (a qualified organization). Axel attended tenth grade...
-
Ray and Maria Gomez have been married 3 years. They live at 1610 Quince Ave., McAllen, TX 78701. Ray works for Palm Oil Corporation and Maria works for the City of McAllen. Maria's Social Security...
-
Below is a list of financial statement items. Required 1. Indicate whether each item is found on the income statement (IS), statement of retained earnings (RE), and/or balance sheet (BS). 2. User...
-
Below are three independent sets of financial statements with several amounts missing. Required 1. Complete each set of financial statements by determining the amounts that correspond to the letters....
-
Below are the financial accounts of Landscape Design, Inc. The company has just completed its third year of operations ended November 30, 20x8. Required 1. Prepare the income statement, statement of...
Study smarter with the SolutionInn App