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...
-
Calculate the minimum excitation energies of (a) The 33 kHz quartz crystal of a watch, (b) The bond between two atoms in 02' for which k=ll77 Nm-1.
-
Summarize the main features of third generation mobile phone systems. How do they achieve higher capacities and higher data rates? How does UMTS implement asymmetrical communication and different...
-
Turbines are to be designed to develop 30,000 horsepower while operating under a head of \(70 \mathrm{ft}\) and an angular velocity of \(60 \mathrm{rpm}\). What type of turbine is best suited for...
-
From the following list, identify the accounts that should be closed to Income Summary at the end of the fiscal year: a. Accounts Receivable b. Accumulated DepreciationEquipment c. Depreciation...
-
Branding is very important to marketing, that is while most businesses focus on brands that attract customer's interest. Store brand is unique to a particular store compared to national brand . A...
-
Required information [The following information applies to the questions displayed below.] The following transactions apply to Jova Company for Year 1, the first year of operation: 1. Issued $27,000...
-
Organizing one's financial life starts with making a budget. Use the link https://consumer.gov/sites/default/files/pdf-1020-make-budget-worksheet_form.pdf to make a budget for Vanessa given the...
-
You have 25 years to save up for a 10,000,000. Youre willing to deposit savings each year at year-end, in an account that yields 12%, and you are willing to increase your yearly payments at a rate of...
-
Topic: Implementing database row-level encryption -benefits and challenges Requirement: investigate it, report the result of investigation and develop a practical experiment demonstrating some aspect...
-
You want to buy a house in 7 years and expect to need $30000 for a down payment. If you have $10000 to invest, how much interest do you have to earn (compounded annually) to reach your goal? (Enter...
-
Provide a description of each program, including the target population the program seeks to serve. . 1.Social Security Act 2.social insurance program 3.public assistance programs 4.food shelter...
-
The kitchen textiles buyer placed an order for 12,000 holiday motif towels at a billed cost of $1.70 each. The shipping charges on the order amounted to $300. The buyer negotiated a cost discount of...
-
Waterline corrosion is a type of different aeration cell. Severe corrosion occurs just below the waterline on a steel pipe as indicated in the figure. Which position is the most effective cathode...
-
For the following arrangements, discuss whether they are 'in substance' lease transactions, and thus fall under the ambit of IAS 17.
-
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...
-
Summer and winter constellations are different because (a) of the spin of Earth about its polar axis. (b) the night sky faces in opposite directions in summer and winter. (c) of the tilt of Earths...
-
The property of a star that relates to the amount of energy per unit time it is producing is its (a) luminosity. (b) apparent brightness. (c) color. (d) volume. (e) mass.
-
The longest-lived stars are those of (a) low mass. (b) high mass. (c) intermediate mass. (d) infinite mass.
Study smarter with the SolutionInn App