All posts by : chebby

Exp22_Excel_Ch02_ML1 – Katherine’s Coffee Shop Weekly Payroll

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

Use IF functions to calculate   the regular pay and overtime pay in columns E and F based on a regular   40-hour workweek. Be sure to use the appropriate absolute or mixed cell   references. Pay overtime only for overtime hours. Note employees receive 1.5   their hourly wage for overtime hours worked. Calculate the gross pay in cell   G5 based on the regular and overtime pay. Spencer’s regular pay is $440. With   five overtime hours, Spencer’s overtime pay is $82.50.

Create a formula in cell H5 to   calculate the taxable pay. Multiply the number of dependents by the deduction   per dependent and subtract that from the gross pay. With two dependents,   Spencer’s taxable pay is $422.50.

Insert a VLOOKUP function in   cell I5 to identify and calculate the federal withholding tax. With a taxable   pay of $422.50, Spencer’s tax rate is 25% and the withholding tax is $105.63.   The VLOOKUP function returns the applicable tax rate, which you must then   multiply by the taxable pay.

Calculate FICA in cell J5 based   on gross pay and the FICA rate, and calculate the net pay in cell K5. Copy   all formulas down their respective columns. Be sure to preserve the existing   formatting in the document. Based on the hours Spencer worked he paid $39.97   to FICA and had a weekly net pay of $376.90

Use Quick Analysis tools to   calculate the total regular pay, overtime pay, gross pay, taxable pay,   withholding tax, FICA, and net pay on row 17. (On a Mac, this step must be   completed using the AutoSum feature on the ribbon.)

Apply Accounting Number Format   to the range C5:C16. Apply Accounting Number Format to the first row of   monetary data and to the total row. Apply the Comma style to the monetary   values for the other employees. 

Insert appropriate functions to   calculate the average, highest, and lowest values in the Summary Statistics   area (the range I24:K26) of the worksheet. Format the # of hours calculations   as Number format with one decimal and the remaining calculations with   Accounting Number Format.

Use the XLOOKUP function to look   up the employee name in cell A20 (Wagner) in the payroll data and return the   specified information in row 20. Ensure the return array includes overtime   pay, gross pay, taxable pay, federal tax, FICA and net pay. 

Save and close the workbook.   Submit the file as directed. 

For your personal use, what would be the most ideal home network setup and why?  Describe it fully.  Number of devices, connection types, uses for devices, etcetera.

Your design will be a list of all the specifications that this network will have.  In addition, you will need to write up a document explaining why you have selected these specifications, features, and components.

At a minimum you must consider the following items in your design.

1. Cost
2. Functionality
3. Connecting devices
4. Internet connections

Devices to consider on your network can include but are not limited to:

• Printers
• DVRs
• Smart TVs
• Gaming Consoles
• Appliances
• Computers
• Mobile devices
• Digital media players
• Smart home devices

Document minimum requirements:

• A minimum of one full paragraph in addition to a neatly ordered equipment list. (DO NOT copy the list from the Internet)
• Your submission must have three to seven devices excluding the modem and router.
• Submit only one document via the link title above.
• Use paragraph structure. Use complete sentences and proper grammar and spelling.
• Include a header that contains your name, the assignment name, and the course code from page two of the syllabus.
• Your document must be one of the following formats (.doc, .docx, or .rtf).
• Cite any and all sources.

#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, Amount (in that order). Do not use cell references as the source of the   list. Be sure to enter a blank space after each comma when entering the   values.

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.

Doing a basic python programming exercise assignment. When I open it I must complete. Will pay good money.

Computer Applications and Concepts

The health information technology covers a wide array of information that is suitable to the advancement of the healthcare sector. Over the past few years, it is evident that computer technology transforms the mode of operations within the medical sector, which makes the systems essential. With an extensive range of data integrating private and valuable patient information, the health information technology has the responsibility of making certain that there  

 I want you to identify the paper that was the best one of the semester, and the paper that was the worst one of all these papers below. You should name each of them, and provide just a couple of sentences describing why you choose them. Then use the scholarly search tools we listed early in the semester to find current papers (2020 onward) on the same two general topics. For example, if one of your choices is the paper that focused on Multics virtual memory, you probably wouldn’t find much that is current and specifically references Multics, but you could certainly find papers on some aspect of virtual memory. So again, find a current paper on each of those two topics. Then write the usual summary and reaction for each of them with the headings.  

i uploaded the complete question document.

The purpose of the project proposal is to describe a project (i.e., to describe how to automate or improve the automation of a specific business process) and then to explain how completing the project will positively affect the business.

Once a project proposal is accepted, project work can begin; therefore, a successful project proposal must include all of the information necessary for stakeholders to make a go/no-go decision, including a statement of scope, a list of the benefits you expect the proposed project to provide, and a rough estimate of how long it will take and how much it will cost to complete the project.

For this assignment, you will create a 3- to 4-page project proposal for the business scenario you selected earlier this week and that was approved by your instructor. For your project proposal, be sure to:

• Complete the Project Proposal Template based on the business scenario you selected (and that was approved by your instructor) earlier this week. If you prefer, you may re-create the template using another software application of your choice, such as Microsoft Excel®.
• Develop a project definition and scope that defines the project and articulates the business context for the project.
• Identify problems that the proposed system is expected to solve (or opportunities the proposed project is expected to produce).
• Create project objectives.
• Create the project methodology or game plan.
• Compile a high-level schedule for completing the project scope.

The final portfolio project is a three- part activity. You will respond to three separate prompts but prepare your paper as one research paper. Be sure to include at least one UC library source per prompt, in addition to your textbook (which means you’ll have at least 4 scholarly sources cited). 

Start your paper with an introductory paragraph.

Prompt 1 “Data Warehouse Architecture” (2-3 pages): Explain the major components of a data warehouse architecture, including the various forms of data transformations needed to prepare data for a data warehouse. Also, describe in your own words current key trends in data warehousing. 

Prompt 2 “Big Data” (1-2 pages): Describe your understanding of big data and give an example of how you’ve seen big data used either personally or professionally. In your view, what demands is big data placing on organizations and data management technology? 

Prompt 3 “Green Computing” (1-2 pages):  One of our topics in Chapter 13 surrounds IT Green Computing. The need for green computing is becoming more obvious considering the amount of power needed to drive our computers, servers, routers, switches, and data centers. Discuss ways in which organizations can make their data centers “green”. In your discussion, find an example of an organization that has already implemented IT green computing strategies successfully. Discuss that organization and share your link. You can find examples in the UC Library.

Conclude your paper with a detailed conclusion section. 

The paper needs to be approximately 5-8 pages long, including both a title page and a references page (for a total of 7-10 pages). Be sure to use proper APA formatting and citations to avoid plagiarism.

Your paper should meet the following requirements:

• Be approximately 5-8 pages in length, not including the required cover page and reference page.
• Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
• Support your answers with the readings from the course, the course textbook, and at least three scholarly journal articles from the UC library to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
• Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

Organizations are struggling to reduce and right-size their information foot-print, using data governance techniques like data cleansing and de-duplication. Why is this effort necessary?  Briefly explain and support from your readings, using APA style citations. Remember to appropriately respond to two other learners for full credit.

Please make your initial post and two response posts substantive. A substantive post will do at least two of the following:

• Ask an interesting, thoughtful question pertaining to the topic
• Answer a question (in detail) posted by another student or the instructor
• Provide extensive additional information on the topic
• Explain, define, or analyze the topic in detail
• Share an applicable personal experience
• Provide an outside source (for example, an article from the UC Library) that applies to the topic, along with additional information about the topic or the source (please cite properly in APA)
• Make an argument concerning the topic.