Help me with this assignment for the discipline Algorithm Design.Write me in the chat if you can do it.

Post your Assingment files at this site and send me message that you have posted. I Will deliver your 100% Solution in 24 hours. 

Site Has Changed the Policy so you cant Purchase these solutions.

Thank you 

#Exp19_Excel_AppCapstone_CompAssessment_Manufacturing

#Excel Comprehensive Capstone Assessment – Manufacturing

#Exp19 Excel AppCapstone CompAssessment Manufacturing

Project Description 

You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your new position, you have decided to compile a report that details all aspects of the business, including: employee tax withholding, facility management, sales data, and product inventory. To complete the task, you will duplicate existing formatting, utilize various conditional logic functions, complete an amortization table with financial functions, visualize data with PivotTables, and lastly import data from another source.

Start Excel. Download and open   the file named Exp19_Excel_AppCapstone_ComprehensiveAssessment- Manufacturing.xlsx. Grader has   automatically added your last name to the beginning of the filename. 

Group all the worksheets in the   workbook and fill the range A1:F1 from the Insurance worksheet across all   worksheets including the formatting. Ungroup the worksheets after the fill is   complete and ensure the Insurance worksheet is active.

Click cell I5, and enter a   function that determines the number of full-time employees, (FT).

Enter a database function in   cell I6 that determines the average salary of all full-time employees with at   least one dependent. Format the results in Accounting Number Format.

Enter a lookup function in cell   E5 that returns the tax deduction amount for the number of dependents listed   in the cell C5. Use   the table in range H13:I17 to complete the function. The maximum deduction is   $500.00; therefore, employees with more than four dependents will receive no   additional deductions.

Use Auto Fill to copy the   function down, completing column E. Be sure to use the appropriate cell   referencing. Format the data in column E with the Accounting Number Format.

Enter a logical function in cell   F5 that calculates employee FICA withholding. If the employee is full-time   and has at least one dependent, then he or she pays 7% of the annual salary   minus any deductions. All other employees pay 5% of the annual salary minus   any deductions. Copy the function down through column F. Format the data in   column F with Accounting Number Format.

Apply conditional formatting to   the range C5:C34   that highlights any dependents that are greater than 3 with Light Red Fill and Dark Red Text.

Click cell H10, and enter an   AVERAGEIFS function to determine the average salary of full-time employees   with at least one dependent. Format the results in Accounting Number Format.

Use Advanced Filtering to   restrict the data to only display full-time employees with at least one   dependent. Place the results in cell A37. Use the criteria in the range   H24:M25 to complete the function.

Ensure that the Facilities   worksheet is active. Use Goal Seek to reduce the monthly payment in cell B6   to the optimal value of $6000. Complete this task by changing the Loan amount in cell E6.

Create the following three   scenarios using Scenario Manager. The scenarios should change the cells B7, B8,   and E6.
 

Good   
  B7 = .0325
  B8 = 5
  E6 = 275000
 

Most   Likely
  B7 = .057
  B8 = 5
  E6 = 312227.32
 

Bad
  B7 = .0700
  B8 = 3
  E6 = 350000
 

  Create a Scenario Summary Report based on the value in cell B6. Format the   new report appropriately.

Ensure that the Facilities   worksheet is active. Enter a reference to the beginning loan balance in cell   B12 and enter a   reference to the payment amount in cell C12. 

Enter a function in cell D12,   based on the payment and loan details, that calculates the amount of interest   paid on the first payment. Be sure to use the appropriate absolute, relative,   or mixed cell references.

Enter a function in cell E12,   based on the payment and loan details, that calculates the amount of   principal paid on the first payment. Be sure to use the appropriate absolute,   relative, or mixed cell references.

Enter a formula in cell F12 to   calculate the remaining balance after the current payment. The remaining   balance is calculated by subtracting the principal payment from the balance   in column B.

Enter a function in cell G12, based on the payment   and loan details, that calculates the amount of cumulative interest paid on   the first payment. Be sure to use the appropriate absolute, relative, or   mixed cell references.

Enter a function in cell H12,   based on the payment and loan details, that calculates the amount of   cumulative principal paid on the first payment. Be sure to use the   appropriate absolute, relative, or mixed cell references.

Enter a reference to the   remaining balance of payment 1 in cell B13. Use the fill handle to copy the functions created in   the prior steps down to complete the amortization table. 

Ensure the Sales worksheet is   active. Enter a function in cell B8 to create a custom transaction number.   The transaction number should be comprised of the item number listed in cell   C8 combined with the quantity in cell D8 and the first initial of the payment type in cell E8. Use   Auto Fill to copy the function down, completing the data in column B.

Enter a nested function in cell G8 that displays the word Flag if the Payment Type is Credit and the Amount is greater than   or equal to $4000. Otherwise, the function will display a blank cell. Use Auto   Fill to copy the function down, completing the data in column G. 

Create a data validation list in   cell D5 that displays Quantity, Payment Type, and Amount (in that order).

Type the Trans# 30038C in cell B5, and select Quantity from the validation list in   cell D5.

Enter a nested lookup function   in cell F5 that evaluates the Trans # in cell B5 as well as the Category in   cell D5, and returns the results based on the data in the range A8:F32.

Create a PivotTable based on the   range A7:G32. Place the PivotTable in cell I17 on the current worksheet.   Place Payment Type in the Rows box and Amount in the Values box. Format the   Amount with Accounting Number Format.

Insert a PivotChart using the   Pie chart type based on the data. Place the upper-left corner of the chart   inside cell I22. Format the Legend of the chart to appear at the bottom of   the chart area. Format the Data Labels to appear on the Outside end of the   chart.

Insert a Slicer based on Date.   Place the upper-left corner of the Slicer inside cell L8.

Use PowerQuery to connect to the   Access database Exp19_Excel_AppCapstone_Comprehensive_Inventory.accdb.   Load the Inventory table into a new worksheet named Inventory.
 

  Note, Mac users, download and import the delimited Inventory.txt file into a new worksheet named Inventory starting in cell A1.

Create a footer with your name   on the left, the sheet code in the center, and the file name on the right for   each worksheet.

Save the file Exp19_Excel_AppCapstone_ComprehensiveAssessment-   Manufacturing.xlsx. Exit Excel. Submit the file as directed.

Try to answer the following question, 

why are evolutionary models considered by many to be the best approach to software development in a modern context?

 Please refer to Section 2.5.3 from the textbook

This is discussion Post.

Wireshark Assignment Instructions

Assignment: Wireshark Exploration

I want you to install and run Wireshark, gather some data, and begin to decipher/understand the information it is giving you.  Use the Wireshark Exploration submission link to submit a document including screenshots of you running Wireshark and a detailed description of what the Wireshark output is telling you. Run Wireshark to look at both local network activity and remote network activity. 

I have created a separate Wireshark Getting Started tutorial to help you get started by successfully connecting, capturing, and interpreting to a site and file.

Do not submit the read out or interpretation of the tutorial for your assignment. If you do, you will not receive any points for the assignment. It is just a tutorial to get you acquainted with the most basic feature of Wireshark. After you have run through the tutorial and just looked at your network traffic, work through the activity below and you can filter and see the process of data transmission in layer 2 and 3. 

A good way to get started with this assignment is to ping your Raspberry Pi. So, I would suggest completing the Pie setup assignment prior to completing this Wireshark assignment.

1. Open Wireshark on the host (should be you laptop or desktop) 
2. Click the Wi-Fi adapter (assuming you’re not using a wired Ethernet connection). This will start a live capture. 
3. In the filter box (below the toolbar at the top), type arp or icmp and hit Enter. – this will filter the captured data.
4. In the command line on the host, ping the IP address of your Pi. 
5. In Wireshark, you should see an ARP Request, an ARP Reply, as well as four ICMP Echo Requests and Replies. Click the red square icon (second from the left) on the toolbar at the top to stop the capture. 
6. In the middle Wireshark pane (Packet Details), look for the first ARP, and expand the triangle next to Ethernet_II and the triangle next to Address Resolution Protocol (Request). 

Things to note 

• In the Ethernet frame, the source MAC address is the MAC address of the host machine, and the destination MAC address is the Layer 2 Broadcast Address (12 Fs). 
• In the ARP (which is encapsulated inside the Ethernet frame), the Sender MAC and Sender IP address belong to the host machine. Also notice that the Target MAC is all 0s (the sender left that field blank), but the Target IP address is that of the Pi. 
• In the top pane (Packet List), Wireshark turns this into a nice English question in the Info column. 
• The next frame, below the Packet List, is the response. Compare the fields in the Ethernet frame and the ARP in this response to the frame above, the request. ARP is a pure Layer 2 protocol. It is not routable. There is no IP header. Even though you did see IP addresses in the ARP fields, that does not make it a Layer 3 routable protocol. 

Now that the host machine got the ARP reply, with the MAC address of the Pi, it can send the ICMP Echo Replies. The next 8 rows should be 4 ICMP Echo Requests and 4 ICMP Echo Replies. ICMP is a Layer 3 protocol. 

1. Select the first ICMP Echo Request. 
2. Notice how ICMP is encapsulated inside of an IP packet, which is encapsulated inside an Ethernet frame. 
3. Expand the fields of all protocols, by clicking the triangles. 

Notice with the ICMP Echo Requests that the source MAC address and the source IP address are those of the host machine, while the destination MAC address and the destination IP address are those of the Pi. 

• For the ICMP Echo Replies, the pairs are reversed. This is local communication. The source determined that the destination was on the same subnet by first logically ANDing its IP address with its subnet mask, and then logically ANDing the destination IP address subnet mask with the source subnet mask. When both resultant network IDs came out the same, the source realized it had to ARP for the MAC address of the actual destination. 

Now try Viewing Remote Communication (not on your local network)

1. Start a new Wireshark capture by clicking the blue fin (first icon from the left), with the same filter as in Step 3 under Use Wireshark to view network activity (arp or icmp). 
2. Open up a new command line interface with Administrator privileges, by clicking the Start button, typing cmd, right clicking on the icon, selecting Run As Administrator, and clicking the Yes button. 
3. At the prompt, type arp -d, which will clear the host’s ARP cache. Then, immediately type ping www.google.com (Links to an external site.). You will have a new set of ARPs and ICMPs. 

In a Word document I want you to try looking at the general traffic on your network, what do you see? Interpret it and use screenshots. Do not just resubmit the tutorial. You can submit the Pi activity above for credit (10pts) but you will need provide additional information about the traffic on your network. So run Wireshark and then try to to explain what you are seeing on your network (10pts).

Next, Ping a remote location (not Google.com or TWU.edu) and use Wireshark to figure out its ip address, MAC address and other components. Again, include screenshots and explain in detail what you see and what you found (10pts).

In your document address the following (10 pts):

1. Explain what is the difference in ICMP Echo Requests sent from your machine, when pinging a local destination vs. a remote destination.
2. Explain what is the difference in ICMP Echo Replies sent to your machine, when pinging a local destination vs. a remote destination.

NOTE:  All screenshots should show your application (Wireshark, SSH client, etc.) running in a non-maximized window, and should show part of your desktop background as well as the time/date in the taskbar/menu bar/status bar. 

I have set up an optional discussion folder in Canvas called Wireshark Exploration for you to use to ask questions  and provide insight to each other in the completion of this assignment.  You are NOT required to participate in this discussion (unlike other discussions) as it is just for support in this assignment. Do not post direct answers or tutorials in this discussion.

Submit your document to the submission link titled Wireshark Exploration dropbox on Canvas.

NOTE:  All screenshots should show your application (Wireshark, SSH client, etc.) running in a non-maximized window, and should show part of your desktop background as well as the time/date in the taskbar/menu bar/status bar. 

You are a member of the Human Resource Department of a medium-sized organization that is implementing a new interorganizational system that will impact employees, customers, and suppliers.  Your manager has requested that you work with the system development team to create a communications plan for the project.  He would like to meet with you in two hours to review your thoughts on the KEY OBJECTIVES OF THE COMMUNICATIONS PLAN.  What should those objectives be?

INFRAGuard Assignment

Write business memo to your boss (Instructor) explaining what INFRAGuard is, when the local chapter is meeting next and what is the process to join.

Remember that memos are to the point and do not include tons of information just to include information. Make you memo brief yet contain all the required info.

Considering joining now that you are aware of the organization.

https://owl.english.purdue.edu/owl/resource/560/10/

Wiki’s are not acceptable as an academic reference.

Assigned Readings:Chapter 6. Administrative Law.Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

1. The Federal Aviation Administration (FAA) proposes a new rule.  During the comment period, an individual considered to one of the most experienced aviation experts in the country strongly disagrees with the rule and provides a wide variety of support for her position.  Must the FAA not pass the proposes rule based on this comment?  Must the FAA consider the comment when deliberating passing the new rule?
2. State and explain each stage of the formal rule making process for administrative agencies. Provide examples as appropriate.

Text

Title: Business 

ISBN: 9780357447642 

Authors: Marianne M. Jennings 

Publication Date: 2021-01-01 

Edition: 12th Edition

see attachment 

Exp19_Access_Ch03_Cap – Brilton Madley Games 1.0

Brilton Madley, a board game  manufacturer, hired a new CEO. She asked for your assistance in  providing summaries of data that took place before she started with the  company. To help her with her strategic planning, you will create  queries to perform data analysis. Based on your meeting, you plan on  creating four queries. One query will find orders with minor delays.  Another query will summarize company revenue and cost by country. A  third query will be used to help evaluate payments made by customers on  their orders. The final query will calculate the total sales by sales  representative title.

Create a query using Query Design.   From the Customers table,  include the fields FirstName, LastName, and Phone   (in that order).  From the Orders table, include the fields OrderID,   OrderDate, and  ShippedDate (in that order). Run the query and then examine the records.  Save the query as Shipping   Efficiency.

Add   a calculated field named DaysToShip   to  calculate the number of days taken to fill each order. (Hint: the    expression will include the OrderDate and ShippedDate fields; the  results   will not contain negative numbers.) Run the query and then  examine the   results. Save the query.

Add   criteria to limit the query results to include any order that took more than 30 days to ship.

Add the Quantity field from the   Orders table and the ProductName  field from the Products table to the query   (in that order). Sort the  query by ascending LastName.

Add the caption Days to Ship to the DaysToShip field. Switch to   Datasheet view to view the final results. Save and close the query.

Create a query using Query Design and   add the Customers, Orders,  and Products tables. Add the Country field from   the Customers table.  Set the field’s Total row to Group By. Save the   query as Revenue and Cost by Country.

Add a calculated field in the second   column. Name the field TotalRevenue.    This field should multiply the quantity ordered (from the Orders  table) by   the unit price for that item (from the Products table).  Format the calculated   field as Currency and change the caption to Total Revenue.   Change the Total row for the TotalRevenue field to Sum.

Add a calculated field in the third   column. Name the field TotalCost.    The field should multiple the quantity ordered (from the Orders  table) by the   unit cost for that item (from the Products table).  Format the calculated   field as Currency   and add a caption of Total Cost.   Change the Total row to Sum. Run the query. Save the query. Return to Design   view.

Add the OrderDate field and criteria   to that field so that only orders made between 7/1/2018   and 12/31/2018  are displayed. Change the Total row   to Where. This expression will  display only orders that were completed during   the second half of  2018. Run the query and view the results. Save and close   the query.

Create   a copy of the Revenue and Cost by Country query named Customer Payments.  Switch to Design view of the new   query and remove the Country,  TotalCost, and OrderDate fields. Add the   FirstName and LastName  fields. Move the TotalRevenue field to the end. Rename   the  TotalRevenue field to OrderTotal.   Change the caption to Order Total.

Add   a new field using the Expression Builder named SamplePayment.   Insert the Pmt function with the following parameters:
 •   Use .05/12 for the rate argument (5% interest,   paid monthly)
 •   Use the number 12   for the num_periods argument (12 months)
 •   Use the calculated field OrderTotal   for the present_value
 •   Use 0 for both future_value and type

Change   the Total row to Expression for the SamplePayment field.  Change the Format   for the SamplePayment field to Currency. Run the  query and verify the second   order(with LastName Sparks) has a sample  payment of $26.80. Note: it will   display as a negative number. Save  and close the query.

Create   a copy of the Revenue and Cost by Country query named Revenue by Sales Rep.  Switch to Design view of the new   query and remove the entire  Customers table, the TotalCost, and OrderDate   fields. Add the Sales  Reps table. Add the Title field from the Sales Reps   table and move it  to the front of the TotalRevenue field.
 

Run   the query and then examine the summary records; there should be  4 Titles   listed. Switch to Design view and change the sort order so  that the title   with the highest TotalRevenue is first and the title  with the lowest   TotalRevenue is last. Run the query and verify the  results. Save and close   the query.