Part AIn the spreadsheet under NPV calculation I an investment cell B8. It a negative because the cash flow will be an outflow. assume a capital value. Enter this cell B6. Enter this a anything .What I want you enter cash flows (make up numbers your choosing) cells B9 B18 ( ) so that the net (NPV) +$, +$, I up the spreadsheet calculate the cash flow the net the all the cash flows. Make sure you see how I did this.All cash flows must be greater $ (but the cash flows need be same amount ). Yes, this will be trial– you the numbers you assume you it work.I want you calculate the profitability the cash flows that you used calculate the NPV. cell C22 enter a formula that will calculate the profitability index. You must one formula that will this cell. I will look the cell be sure you did just enter the correct , but you figured how Excel make the calculation. we can this information calculate the payback (undiscounted), the discounted payback period. the undiscounted cash flows ( B), the cumulative the undiscounted cash flows D.* Similarly, the discounted (meaning ) cash flows ( C) the cumulative the discounted cash flows E. the bold font the two that bracket the investment paid back. this D (undiscounted) E (discounted). cells C24 C25 write the payback ” ” ” ” (whatever the correct two ). you cannot figure D E reason, figure the answer bold font the appropriate two B C. Optional bonus: This likely a challenge I have tried this so I know how easy difficult this ! See you can write one formula that gives the exact payback (see the details what the exact payback ) the undiscounted discounted cash flows. The formula must have cell , numbers. Enter the formula cells E24 E25. One added point you this correct (so you can up / this assignment). Part B the spreadsheet the IRR calculation I cash flows The investment shown. You need find an investment enter it cell B27 so that the IRR greater , but percent. Remember that the cash flow will be a negative value. The IRR will be calculated automatically (see cell B35 formula) be because the cell formatted percent.  ‘lnmcm r = »- m. M 5m. . 7/. -… m mm ’ .5. Ex. {y éxfw Zm. mm…“ . 3 . 9‘, , t4; ,4: m”: m“ wmmmwv I…“ 1mm 1..“ m 5.1… ram ,5…“ 53;?03 vl A a c D 5 F G H I J K L M N 0 P Q R s1 unmemsz3 u4 ‘ Presem Value calculation5 l5 instofcapualldeclmal) 0.157 Cash Flows Present Value5 l u s (900,000.00) 5 (500,000)Curnulative Sum 133m 51! Cumulative sum 09m C189 1 $ 230,000.00 5 200,000.00 xxx xxx10; 2 s 253,000.00 5 203,402.55 xxx xxx11‘ 3 5 234,000.00 5 153,353.50 xxx xxx12‘ 4 $ 100,000.00 $ 57,175.32 xxx xxx131 s s 130,000.00 5 54,532.93 xxx xxx14 5 s 172,000.00 5 74,350.35 xxx xxx15. 7 s 300,000.00 5 300,749.53 xxx xxx16‘ s s 400,000.00 5 130,750.71 xxx xxx17 5 s 53,400.00 5 23,707.49 xxx xxx13 10 $ 94,504.00 $ 23,334.55 xxx xxx19 ‘20 1 Net Present value: 5 332,032.55 ‘een +5200,000 and +5400,00021 ‘22 Profihbllitylndex: xxx23 l24 pack period (undlseounml): xxx Exact Payback Perlad: xxx25 back period (discos-med): xxx Exact Payback Period: xxx25 l27 Hi28 Emal rate of remm calculation29 . Cash Flows30 0 xxx31 , 1 s 345,000.0032 , 2 s 423,000.0033 1 3 s 300,000.0034 3 4 s 500,000.0035 5 s 400,000.0035 5 s 550,000.0037 138 IRR: ‘ #NUMI Between 12% and 15%39 ‘40 +1.1341 142 14344 l x. 35…. +M, -m _ _.__ 4 130’s

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

 make sure you read all instructions please 

Instructions

For the following research paper assignment, you have been asked to perform an evaluation of employee exposures at a small automobile parts manufacturing facility. The manufacturing processes include two metal presses, two machining stations, three welding stations, a small paint booth, and a shipping/receiving area. There are two employees working at each press, one person working at each machining station, one person working at each welding station, two people working in the paint booth, and four employees working in the shipping/receiving area.

One of the presses is a 2,000-ton press, and the other press is a 200-ton press. The 2,000-ton press is the greatest noise source for the facility. The machining area uses a metal working fluid. The safety data sheet (SDS) for the metal working fluid is attached here. All welding is performed on stainless steel. The painting booth uses a powder coating operation, but the employees use xylene and methyl ethyl ketone (MEK) to clean the parts prior to the powder coating operation. At the end of the shift, one of the employees uses 1,3 butadiene to clean the nozzles for the paint booth. The facility uses two electric forklifts to move materials between the production area and the storage warehouse and between the warehouse and the shipping area. All employees work an 8-hour shift.

Part 1:

Using the information on anticipation and control we studied in the textbook, identify the hazards that are present in the facility. In your discussion, explain why you chose the hazards, and describe whether you believe the hazards to be actual hazards or potential hazards (which require further evaluation). Describe the specific location(s) at the facility where the hazards are located, and determine how many employees are potentially at risk in those areas.

Your response for Part 1 should be at least one page in length.

Part 2:

Using the information on evaluation that we studied in the textbook, summarize how you would measure the personal exposures to the hazards that you identified in Part 1. Use the Occupational Safety and Health Administration (OSHA) website (https://www.osha.gov/dts/sltc/methods/toc.html) or the National Institute for Occupational Safety and Health (NIOSH) website (http://www.cdc.gov/niosh/docs/2003-154/default.html) to select the specific sampling and analytical method that would work best to evaluate any chemical hazards you identified. Provide a summary of the sampling media you would use, include the sampling flow rate, discuss how long you would sample, and explain how you would calibrate the sampling train. Include a discussion about why you selected the specific sampling and analytical method.

Your response to Part 2 should be at least one page in length.

Part 3:

Access the attached sampling results here. For each set of results, perform the following actions:

• Calculate the 8-hour time weighted average (TWA) exposure.
• Compare the results to the appropriate OSHA permissible exposure limit (PEL).
• Determine which results exceed an established OSHA PEL.

Write a one-page summary of the sampling results; document the exposures that exceeded an OSHA PEL, and identify those areas that you believe will require the application of controls to reduce risk. Include your calculations, include a list of the OSHA PELs you compared the results to, and explain how you decided that an exposure exceeded an OSHA PEL.

Part 4:

Using OSHA’s hierarchy of controls, recommend the control methods that you believe would be the most effective for reducing the risks associated with the exposures that exceeded the OSHA PEL above. Explain how you would implement the controls and how you would evaluate the effectiveness of the controls. Also, discuss any interim control methods you would recommend for the facility.

This section should be at least one page in length.

Include a reference page and in-text citations for all sources you used in this project, including your textbook, using proper APA format.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Marketing Plan: Part I

Throughout this course, you will compile a comprehensive marketing plan using one of the product/service scenarios listed below. (Note: You will use the same scenario throughout the course.) This scenario will be the basis of your start-up company and will be the catalyst for the three parts of the marketing plan that you will compose in Units II (Part I), IV (Part II), and VII (Part III). The company that you choose to submit a marketing plan for is a fictional start-up company (not an existing company).

Scenarios for your start-up company are explained below. (Note that these descriptions are basic, and you will need to be creative and develop the business idea/model for your selected scenario.)

Scenario #4

Women on the Go is a startup company targeted at women who need assistance with the selection and purchasing of their clothing/accessories. This service is aimed at the more affluent customer who simply does not have the time and/or knowledge to dress to the business or social setting that they are expected to fulfill. Initial research will provide insight into the types of services that this particular target market would be interested in.

Remember to choose one of the aforementioned scenarios to use for the entire course. Submissions will be completed in Units II, IV, and VII and, together, will comprise a full marketing plan. While this is a cumulative marketing plan, submit only the designated unit’s work.

This unit’s submission should consist of the items listed below.

§  Include an introduction/overview of the company.

o    This section of the marketing plan should introduce the company and business model along with a brief description of the products/services.

§  Discuss market research strategies.

o    This section of the marketing plan should discuss the research strategies that will be used by your company to understand the target market(s), industry, competition, and/or any other aspects of the company that will provide valuable insight into profitable operations.

§  Describe the macro environment through a political, economic, social, and technological (PEST) analysis.

o    In this section, you will compile a PEST analysis of your company. You will analyze how the changes in the macro environment as described in the PEST will impact the company and, specifically, the marketing decisions.

ensure you provide an introduction for this assignment that is engaging and provides a clear background to the purpose of the assignment. The format of the submission should be in essay format using subheadings. Use APA format. Additionally, you need to include a minimum of five sources, three of which must be peer-reviewed, academic sources that are no more than 5 years old. The submission should be a minimum of three pages in length (not counting the title and reference pages).

Textbook

Kotler, O., & Keller, K. L. (2016). Marketing Management (15th ed).

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

“Marketing Mix.” Please respond to the following:When thinking about the history of public relations, determine which development do you think was the most significant. Explain your reasoning.Of all the articles you found on the Web site for the World Advertising Research Centre (WARC) at http://www.warc.com/, determine which was the most applicable. Explain your rationale.Explain how can this information help you communicate effectively with these professionals.

History of public relations Course: NameHistory of public relationsStudent’s NameProfessor’s Name [optional]DOS: August 6, 2015University 1 History of public relationsIn the history of…

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

A3. (Market versus book value weights)Miami Distribution has 1,000 outstanding bonds that have a book value of $1,000 per bond and a market value of $1,200 per bond. Miami Distribution has 250,000 outstanding shares with a per-share book value of $40 and market value of $68. When estimating the WACC, what proportions of debt and equity capital should be used?

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"