Total Cost of Ownership (TCO) Using MS Excel

The production manager has asked you to purchase a replacement numerically controlled (NC) plasma-cutting machine for the metal fabrication shop. She has provided you with the manufacturer’s number and model number for two models and indicates that the performance of either machine is perfectly acceptable. The existing tooling and fixtures will also work with either machine. Footprint and utility requirements are nearly the same as the old machine and will not require changes to the facility. The equipment will be depreciated over a ten-year period, which is also the expected service life. An annual service contract is required after the expiration of the warranty and throughout the remaining service life. You will take advantage of a 2% discount offered by each supplier for paying cash. You decide to complete a total cost of ownership (TCO) analysis to help make the purchasing decision.

The two manufacturers have provided the following additional information:

Submit a MS Excel spreadsheet that calculates the total cost of ownership of each machine. Based on the TCO calculation, specify which model you recommend purchasing.

When the capacity of an organization to produce goods or services and the demands of its customers to purchase goods or services is not matched, then the result is inefficiency, either in under-utilized resources or dissatisfied customers.

Choose a local organization that produces either a good or service and describe its capacity and demand concerns. Develop an equation to calculate its capacity. Define lead strategy, lag strategy, and match strategy, and recommend which your local organization should pursue and why.

Embed course material concepts, principles, and theories, which require supporting citations along with at least one scholarly, peer-reviewed reference in supporting your answer.

You are required to reply to at least two peer discussion question post answers to this weekly discussion question and/or your instructor’s response to your posting. These post replies need to be substantial and constructive in nature. They should add to the content of the post and evaluate/analyze that post answer. Normal course dialogue doesn’t fulfill these two peer replies but is expected throughout the course. Answering all course questions is also required.

Hello Cristina,

How are you?

Yes please, As usual, Max 2 pages, Min 1 page, With 2 references.

I will be in touch later for 2 replies.

Thank you

Hello , Please submit below 2 answers in a separate WORD Doc

Course: Digital Forensics Tools & Tchq

Describe the plain view doctrine, and whyit has such a significant impact on digital forensics? What are three approaches to determining whether the doctrine applies to a specific case. Use your own words 200-300 and do not copythe work of another student.

It is important that you use your own words, that you cite your sources, Cite 2 of your sources in a clickable reference list at the end. Complete answers on a WORD Document please and ensure that you are following APA Format guidelines, using in-text citations and references.

Course: Cloud Computing 

Compare and evaluate in 500 words or more qualitative v quantitative risk assessment.

Use at least three sources. Use the Research Databases available from the Danforth Library (https://libguides.nec.edu/az.php)not Google.Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list.Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources using APA format. Use the quotes in your paragaphs.Stand alone quotes will not count toward the 3 required quotes.

Copying without attribution or the use of spinbot or other word substitution software will result in a grade of 0. 

Write in essay format not in bulleted, numbered or other list format.

Please note that, outside of running the Regression tool, all work should be completed inside of the yellow-filled cells. Including ANY work outside of the yellow-shaded cells will result in an automatic ZERO for that step. Similarly, you should NEVER hard-code the values into a cell and/or formula. In other words, you MUST use only cell references and formulas to complete all instructions and calculate your results; directly entering values into cells or formulas will result in ZERO credit for the step.

Step 1: Download the attached file “Module 5 CorporateBonds Template.xlsx” and open the file in Microsoft Excel.

Step 2: Use the Data Analysis package to run a Regression where you use Years to predict Yield.

Step 3: Use relative cell references to display the coefficients for Years and Yield from the Regression Report in cells D44:D45 on the Data worksheet.

Step 4: Use the Regression Coefficients you entered in Step 3 to predict the Yieldvalues for each company, based on the Years for that row. Enter the results in range D2:D41. Remember, hard-coding is NOT permitted and will result in zero credit.

Step 5: Calculate the Residuals (aka Regression Errors) for each predicted value from Step 4, and enter the results in range E2:E25.

Step 6: Use the Residuals calculated in Step 5 to compute the Sum of Squares due to Error (SSE) in Cell F42, using Cells F2:41 for the intermediate computation of the Squared Residuals.

Step 7: Follow a similar process from Steps 5 and 6 to compute the Sum of Squares due to Regression (SSR) in Cell H42. To do so, you will need to compute the y-bar in Cell C42, and you should use cells G2:H41 for your other intermediate computations.

Step 8: Now compute the Total Sum of Squares (SST) in Cell J42 by completing the computations in Cells I2:J41.

Step 9: Compare your results for SSE, SSR, and SST to the SS column of the ANOVA table in your Regression Output generated in Step 2. If your computed values do not match the corresponding values from the Regression Output report, review your calculations to identify and correct your mistake.

Step 10: Cell M2 contains a formula that tells Excel to pick a random number each time that formulas are recalculated across the sheet (which by default happens every time that a cell value is changed), so as you are working, you may notice that the value in this cell changes, but don’t pay it any mind. Rather, build a formula in cell M3 that predicts the Yield based on the Random Years in cell G2. Note: this step is similar to the process for computing Regression Coefficients in Step 3.

Once you have completed all the steps, save your work and submit the completed document to this Assignment folder.