Computer Science homework help

Computer Science homework help

POST I HAVE TO WRITE ABOUT

SaaS, PaaS, IaaS, and IDaaS are crucial components in any Cloud solution. It is important to understand how they work individually and how they complement each other. Describe how SaaS, PaaS, IaaS, and IDaaS can work together as a parts of a Cloud solution. Is there any way that they might detract from each other?

 

 

POST 1 I HAVE TO REPLY TO

Software as a service (SaaS), Platform as a service (PaaS), Infrastructure as a service (IaaS), and Identity as a service (IDaaS) are all part of the cloud and can work together or separately depending on the what need or needs the end user is fulfilling. The end user can be an individual, small business or corporation. Cloud computing is essentially the internet, we all use it and it grows more and more every day. ”For it to be considered ‘cloud computing,’ you need to access your data or your programs over the Internet.” (2016) as stated in an article in PC magazine. Cloud computing has become a multibillion dollar a year business for companies like Amazon. Who stated that revenue jumped 25 percent in the 4th quarter alone in 2018. With Amazon Web Services (AWS), individuals to governments use from one to all four as a service (aaS) functions on a metered pay-as-you-go basis. So, in no way do any of the services “detract” from on another. Each service is designed to work individually or together depending on the needs of the end user.

References

Griffith (May 3, 2016) What is Cloud Computing retrieved from https://www.pcmag.com/article/256563/what-is-cloud-computing

No Author (2019) Webpage retrieved from https://aws.amazon.com/

 

 

POST 2 I HAVE TO REPLY TO

 

SaaS, PaaS,IaaS, and IDaaS could function together as part of a Cloud solution because each component bring a different task to the table. By utilizing all solutions, the user is given more protected access to the cloud, a framework in which the cloud can employ and liaise,effectively transform the environment in which they are active, and have admittance to programs that might be required for individual operators without the burden costs of buying licenses in bulk.

Unfortunately, i was unable to find any pertinent information concerning any of these solution functioning independently but here are my sources:

A simple guide to Cloud Computing, IaaS,PaaS,BaaS,DBaaS,IPaaS,APIMaaS, (2015, April 01) Retrieved April 02,2019 from https://cloudramblings/me/2014/02/11/a-simple-guide-to-cloud-computing-iaas-paas-baas-dbaas-ipaas-idaas-apimaas/ (Links to an external site.)Links to an external site.

Understanding the Cloud Computing Stack: SaaS,PaaS,IaaS. (n.d.) Retrieved April 02,2019 from

https://support.rackspace.com/white-paper/understanding-the-cloud-computing-stack-saas-paas-iaas/ (Links to an external site.)Links to an external site.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Exp19_Excel_Ch06_HOEAssessment_Scholarship_Dinner

Grader – Instructions Excel 2019 Project

Exp19_Excel_Ch06_HOEAssessment_Scholarship_Dinner

 

Project Description:

You have recently been elected social coordinator for your University’s student government association. As part of your duties, you are required to plan an annual scholarship dinner. The dinner is a fundraiser in which the proceeds are used to fund scholarships. You will perform What-If Analysis to calculate the budget information required for the event to be successful.

 

Steps to Perform:

Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp19_Excel_Ch06_HOEAssessment_ScholarshipDinner.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 Create range names based on the left columns in the ranges A4:B9, A20:B20, and A30:B30. 4
3 Edit the named range of_Guests_Using_Valet to Guests_Using_Valet. 4
4 Enter a formula in cell B27 using Named Ranges to calculate projected cost of catering. The cost of catering is the cost per meal * the total number of tickets sold. 8
5 Enter a formula in cell B28 using Named Ranges to calculate total cost for room setup. 8
6 Enter a formula in cell B29 using Named Ranges to calculate the total valet expenses. The total valet expenses can be calculated by multiplying tickets sold * total guests using valet * valet cost per car. 8
7 Use a function to total all expenses in cell B30. 8
8 Enter a formula in cell C32 to calculate the remaining balance (Total_Income – Total_Expenses). 4
9 Enter a series of substitution values in the range E5:E20. The values should start at 50 and increase in increments of 5 stopping at 125. 3
10 Enter references to Total_income, Total_Expenses, and Balance in the correct locations (F4, G4, and H4) for a one-variable data table. Use range names where indicated. 3
11 Complete the one-variable data table in the range E4:H20 using cell B5 as the column input cell, and then format the results with Comma Style. 6
12 Type Price in cell E4 and apply custom number formats to make the formula references appear as descriptive column headings. In F4, Total Income; in G4, Total Expenses, in H4, Balance. 4
13 Copy the range E5:E20 and paste it in the range J5:J20. 4
14 Type 400 in cell K4. Complete the series of substitution values from 400 to 525 in increments of 25. 4
15 Enter the reference to the Balance formula in the correct location for a two-variable data table. 3
16 Complete the two-variable data table in the range J4:P20. Use cell B4 as the Row input cell and B5 as the Column input cell. Format the results with Comma Style formatting. 8
17 Apply a custom number format to make the formula reference appear as a descriptive column heading Price. 4
18 Load the Solver add-in if it is not already loaded. Set the objective to calculate the highest Balance possible (C32). 4
19 Use Tickets Sold (cell B4) and Ticket Price (cell B5) as changing variable cells. Do not use range names. 3
20 Use the Constraints section of the spreadsheet model to set constraints for minimum ticket price, maximum ticket price, and ticket sales. The ticket price must be less than or equal to the maximum ticket price (cell B14). The ticket price must also be greater than or equal to the minimum ticket price (cell B13). The total tickets sold must be less than or equal to the ballroom capacity and the number of tickets sold must be an integer. 4
21 Solve the problem. Generate the Answer Report and Keep Solver Solution. 6
22 Save and close Exp19_Excel_Ch06_HOEAssessment_ScholarshipDinner.xlsx. Exit Excel. Submit the file as directed. 0
Total Points 100

 

Created On: 06/09/2021 1 Exp19_Excel_Ch06_HOEAssessment – Scholarship Dinner 1.1

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Bank Simulation Assignment Help 

Bank Simulation Assignment Help

Assignment ½ page

Present a brief overview of your theory or conceptual framework. This is not a detailed review of your theory or framework. The detailed review is required in the Review of the Literature section. Here, a model for presenting the theory or framework section is offered. You will want to state the name of the theory or identify the conceptual framework, identify the theorist if applicable, list key concepts of the theory or framework, identify any propositions or hypotheses, and identify how the theory or framework applies to your study. A theoretical framework is similar to a blueprint, it serves as a guide to help build and support your study by providing structure. Examples of theories across disciplines: Transformational/relational , transactional/management, servant leadership, trait, behavioral, systems, developmental theories, Cognitive theories, feminist theories, critical race theories, self-efficacy theories, gender theories, change theories, identify theories, and community of inquiry theory, among others. Your chosen theory will provide a structure to your research.

 

Background

Theoretical or Conceptual Framework

Problem: Virtual teams are less successful then in person teams.

Purpose: Purpose Statement

The purpose of this postmodern phenomenological study is to understand the necessary changes in leadership style to ensure organizational effectiveness when teams transition from in office to virtual environment. At this stage in the research, leadership style changes will be generally defined as the process of adopting leadership style to be effective in virtual environment.

The research is based on a postmodernism framework to change the way people think. When we go from one environment to the next, we need to be aware of the employee needs, and organizational culture changes. How leaders need to adapt when people are working in a virtual environment.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Introduction To BIG DATA Midterm Exam Solution

Introduction To BIG DATA Midterm Exam Solution

QUESTION 1

What are the three characteristics of Big Data, and what are the main considerations in processing Big Data?

 

QUESTION 2

Explain the differences between BI and Data Science.

 

QUESTION 3

Briefly describe each of the four classifications of Big Data structure types. (i.e. Structured to Unstructured)

 

QUESTION 4

List and briefly describe each of the phases in the Data Analytics Lifecycle.

 

QUESTION 5

In which phase would the team expect to invest most of the project time? Why? Where would the team expect to spend the least time?

 

QUESTION 6

Which R command would create a scatterplot for the dataframe “df”, assuming df contains values for x and y?

 

QUESTION 7

What is a rug plot used for in a density plot?

 

QUESTION 8

What is a type I error? What is a type II error? Is one always more serious than the other? Why?

 

QUESTION 9

Why do we consider K-means clustering as a unsupervised machine learning algorithm?

 

QUESTION 10

Detail the four steps in the K-means clustering algorithm.

 

QUESTION 11

List three popular use cases of the Association Rules mining algorithms.

 

QUESTION 12

Define Support and Confidence

 

QUESTION 13

How do you use a “hold-out” dataset to evaluate the effectiveness of the rules generated?

 

QUESTION 14

List two use cases of linear regression models.

 

QUESTION 15

Compare and contrast linear and logistic regression methods.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Computer Science homework help

Computer Science homework help

COM520 Written Assignment 4

Assignment: Security Audit Procedure Guide

Assignment Requirements

This assignment requires you to prepare a procedure guide for a security audit in Ken 7 Windows Limited. Ken 7 Windows Limited has acquired several new servers and workstations to support the new enterprise resource planning (ERP) software. You want to ensure the new computers comply with Microsoft’s initial secure baseline. You choose to use the Microsoft baseline security analyzer (MBSA) tool to assess the basic security for all of your Windows computers. MBSA will identify many of the basic vulnerabilities found in Windows environments. MBSA’s vulnerability report provides a good starting point for securing new and existing Windows computers. You need to develop procedures to ensure that each computer in your environment has no reported vulnerabilities. Using the format below, describe the steps to follow to scan multiple computers for security vulnerabilities using MBSA. Include steps to research and address any reported vulnerabilities. Assume you plan to run MBSA on a new server that does not have MBSA installed. Fill in the details for each procedural step to audit each computer and address discovered vulnerabilities.

1) Acquire and install MBSA.

2) Scan computers.

3) Review scan results.

4) Identify vulnerabilities you need to address.

5) Document the steps to address each vulnerability.

 

Submission Requirements

 Format: Microsoft Word

 Font: Arial, Size 12, Double-Space

 Citation Style: APA Style

 Length: 1–2 pages

 

Self-Assessment Checklist

 I have properly organized the steps necessary for malware-free environment.

 I have given a proper justification of the following steps in the security audit procedure guide:

o Download and install MBSA.

o Use MBSA to scan multiple computers.

o Review the scan results.

o Identify vulnerabilities to mitigate.

o Document the steps necessary to mitigate selected vulnerabilities.

 

 

 

COM520 Written Assignment 4

Case Scenario:

Ken 7 Windows Limited is a manufacturer of Windows for residential and commercial builders. Ken 7 Windows Limited carries a variety of Windows and related products. It supplies builders with all of the tools and supplies to install finished Windows in any type of building. Ken 7 Windows Limited has just purchased a new enterprise resource planning (ERP) software package to help control costs and increase both quality and customer responsiveness. The ERP software collects and stores information including:

• Raw material costs

• Labor costs

• Materials and labor requirements for products

• Purchasing requirements

Ken 7 Windows Limited has identified six basic roles for users in the new ERP software:

• Administrators—maintain ERP data and system operation.

• Planners—run planning software and generate requirements reports.

• Shop Floor users —enter operational data (receiving, shipping, and product progress during manufacturing).

• Managers—manage department personnel.

• Purchasing users—generate purchasing documents based on planning requirements.

• Accounting users—maintain cost and accounting data.

Access controls limit what users or roles can do with different types of data. For example, consider the following types of data:

• Cost information—raw materials and labor costs, including the cost of finished goods.

• Manufacturing details—cost, amount of labor, and time required to produce finished goods.

• Purchasing requirements—rules for determining when raw materials, components, or supplies should be purchased.

Through access control:

• Cost information can be viewed only by Accounting users.

• Manufacturing details can be viewed only by Shop Floor users.

• Purchasing requirement can be viewed only by Purchasing users.

During the analysis phase of the ERP implementation, Ken 7 Windows Limited raised concerns about users being able to access restricted data.

• Accounting users are able to login to shop floor computers.

• Purchasing users are able to access human resource (HR) applications and data.

The ERP implementation team suggested the following access control measures to protect restricted data.

• Create an organizational unit (OU) in Active Directory for shop floor computers.

• Deploy Group Policy Objects (GPOs) to restrict shop floor users to the shop floor OU.

• Define data access controls in the ERP software to deny access for all non-HR users to restricted data.

 

 

COM520 Written Assignment 4

Implementation of several access control measures helped Ken 7 Windows Limited to restrict the data access. Hence access control and authentication is important, as it helped Ken 7 Windows Limited in reducing costs and increasing profits.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Computer Science homework help

Computer Science homework help

CSci 430 Spring 2019

Objectives:

ˆ Explore the Process state models from an implementation point of

view.

ˆ Practice using basic queue data types and implementing in C.

ˆ Use C/C++ data structures to implement a process control block and

round robin scheduling queues.

ˆ Learn about Process switching and multiprogramming concepts.

Description:

In this assignment you will simulate a Three-State process model (ready,

running and blocked) and a simple process control block structure as dis-

cussed in Chapter 3. Your program will read input and directives from a

le. The input describes a time sequence of events that occur. These are the

full set of events you will simulate:

1

Event Description

cpu The processor executes for 1 time step the currently running process

new A new process is created and put at tail of the ready queue

done The currently running process has nished

wait X The currently running process has done an I/O operation and

is waiting on event X

event X Event X has occurred, the process waiting on that event should

be made ready.

The input le will simply be a list of events that occur in the system, in

the order they are to occur. For example:

—– simulation-01.sim ——–

new

cpu

cpu

cpu

new

cpu

cpu

cpu

cpu

wait 1

cpu

cpu

event 1

cpu

cpu

done

cpu

cpu

cpu

cpu

exit

———————————-

Your task is to read in the events, and simulate the creation and execution

of processes in the system as they move through the various three-states of

their process life cycle. You need to:

2

ˆ Dene a simple process control block (PCB) to hold information about

all processes currently running in your system. The PCB can be a

simple C struct or a C++ class. At a minimum you need to have a

eld for the process identier and the process state (Ready, Running or

Blocked). You need to also keep track of the time step that the process

entered the system, and the number of steps the process has been

running. Minimal credit will be given to programs that at least handle

new events and create a process in a simulated PCB. You probably

need a list or an array to hold the current processes that have been

created and are being managed by your simulated system.

ˆ You will need a ready queue of some kind. You should use a C++

Standard Template Library (STL) container to manage your ready

queue.

ˆ You will need to implement a simple dispatcher function. Whenever

a cpu event occurs, and no process is currently running, you should

select the next Ready process from the head of your ready queue and

start it running on the processor.

ˆ You need to also implement a simple time slicing mechanism. The

time slice value to use will be passed into your program when it is

started. At the end of a cpu cycle, you should check if the currently

running process has executed for its full time quantum. In that case,

the currently running process should timeout, and be returned to the

end of the Ready queue.

ˆ new events should cause a new process to be created (including creating

its PCB and lling it in). New processes should be placed on the tail

of the ready queue after being created. You should assign each new

process a process identier. The process identier should be a simple

integer value, and you should start numbering processes from 1.

ˆ For a done event, if a process is currently running it should then be

released. It should be removed from the CPU, and not placed back on

the ready or blocked queue. If a done occurs when the CPU is idle,

then nothing will happen as a result of this event.

ˆ A wait event simulates the currently running process performing some

I/O operation. If a wait occurs, the currently running process should

become blocked and put on the blocked queue. You also need an entry

in the PCB so you know what event the process is waiting for. The

3

wait event is followed by an integer number, which is an indication of

the type of event the process has requested.

ˆ Likewise the event directive simulates the nishing of some I/O oper-

ation. When an event occurs, you should scan your blocked processes

and make any process ready that was waiting on that event. The in-

teger value following an event indicates the type of event that just

occurred.

You have been given some example event sequences (simulation-01.sim,

simulation-02.sim, etc.) along with the expected output for those sequence

of events (simulation-01.res, simulation-02.res, etc.). The output of your

program should be sent to standard output. The correct output for the

simulation-01.sim simulation is:

Time: 1

CPU (currently running):

pid=1, state=RUNNING, start=1, slice=1,

Ready Queue:

EMPTY

Blocked Queue:

EMPTY

Time: 2

CPU (currently running):

pid=1, state=RUNNING, start=1, slice=2,

Ready Queue:

EMPTY

Blocked Queue:

EMPTY

Time: 3

CPU (currently running):

pid=1, state=RUNNING, start=1, slice=3,

Ready Queue:

EMPTY

Blocked Queue:

EMPTY

Time: 4

CPU (currently running):

4

pid=1, state=RUNNING, start=1, slice=4,

Ready Queue:

pid=2, state=READY, start=4, slice=0,

Blocked Queue:

EMPTY

Time: 5

CPU (currently running):

pid=1, state=RUNNING, start=1, slice=5,

Ready Queue:

pid=2, state=READY, start=4, slice=0,

Blocked Queue:

EMPTY

Time: 6

CPU (currently running):

pid=2, state=RUNNING, start=4, slice=1,

Ready Queue:

pid=1, state=READY, start=1, slice=5,

Blocked Queue:

EMPTY

Time: 7

CPU (currently running):

pid=2, state=RUNNING, start=4, slice=2,

Ready Queue:

pid=1, state=READY, start=1, slice=5,

Blocked Queue:

EMPTY

Time: 8

CPU (currently running):

pid=1, state=RUNNING, start=1, slice=1,

Ready Queue:

EMPTY

Blocked Queue:

pid=2, state=BLOCKED, start=4, slice=2, event=1

Time: 9

CPU (currently running):

5

pid=1, state=RUNNING, start=1, slice=2,

Ready Queue:

EMPTY

Blocked Queue:

pid=2, state=BLOCKED, start=4, slice=2, event=1

Time: 10

CPU (currently running):

pid=1, state=RUNNING, start=1, slice=3,

Ready Queue:

pid=2, state=READY, start=4, slice=2,

Blocked Queue:

EMPTY

Time: 11

CPU (currently running):

pid=1, state=RUNNING, start=1, slice=4,

Ready Queue:

pid=2, state=READY, start=4, slice=2,

Blocked Queue:

EMPTY

Time: 12

CPU (currently running):

pid=2, state=RUNNING, start=4, slice=1,

Ready Queue:

EMPTY

Blocked Queue:

EMPTY

Time: 13

CPU (currently running):

pid=2, state=RUNNING, start=4, slice=2,

Ready Queue:

EMPTY

Blocked Queue:

EMPTY

Time: 14

CPU (currently running):

6

pid=2, state=RUNNING, start=4, slice=3,

Ready Queue:

EMPTY

Blocked Queue:

EMPTY

Time: 15

CPU (currently running):

pid=2, state=RUNNING, start=4, slice=4,

Ready Queue:

EMPTY

Blocked Queue:

EMPTY

Your output to standard out should look exactly the same as this output

(i.e. if I do a di and your program is generating the correct output, then

there will be no dierence between the output your program generates and

the above output format). The output is generated by displaying the system

state after each cpu cycle executes. Basically we print out the system time.

Then we show which process (if any) is currently running on the CPU (or

say it is IDLE if no process is running). Then we display the queue of

processes currently on the Ready and Blocked queues. Note that the queues

are displayed in order. The top of the output corresponds to the head of the

queue. Thus when a new process is dispatched, the next one selected should

be the rst process listed from the ready queue in the previous system cycle.

I have given you some template code (p2-start.cpp) to get you started

The code is meant to be run from the command line, thus from a shell or

dos prompt you would do something like:

$ p2-start simulation-01.sim 5

i.e. the program expects two parameters on the command line, which

should be the name of a le that holds the events to be simulated, and the

value to be used for the time slice quantum. If you need to test your program

and can’t gure out how to invoke running it from the command line, you

can change the line in ‘p2-start.cpp’ to explicitly run a particular simulation

le, like this:

runSimulation(“simulation-01.sim”, time_slice_quantum)

7

However, you need to make sure that your program correctly works using

the command line invocation, as shown in `p2-start.cpp`.

I have given some template code to get you started in the le called

p2-start.cpp. I have already provided you with the code needed in order to

correctly parse the command line parameters for the program, and to open

and read in the simulation le events. Your job is to implement the necessary

actions and data structures to handle the simulated events described. The

runSimulation() in ‘p2-start.cpp holds example code and indicates locations

where you need to write your own functions to implement the simulation.

You can use this as a starting point to implement your solution.

Assignment Submission and Requirements

All source les you create for you solution (.c or .cpp/.c++ and .h header

les) should be uploaded to the MyLeo Online submission folder created for

this assignment by the deadline. You should not attach any les besides the

source les containing your C/C++ code. But you should make sure you

attach all needed les you create to your submission, so that I can compile

and run your solution.

You are required to write the program in standard C/C++ programming

language. You should use a relatively recent version of the C/C++ compiler

(C90 C++98 is ne, or the more recent C99 C++11 will also be acceptable),

and/or recent IDE that has an up to date compiler. You should only use

standard C/C++ libraries, do not use Microsoft specic or other third-party

developed external libraries. This page http://en.cppreference.com/w/

provides a good up to date reference of the libraries in the standard C++ and

C languages. You may use the C++ standard template library containers

(like the list and queue items) to implement the ready queue you need. We

will go over a simple implementation of a queue using pointers and/or arrays

in class, if you would like an example implementation in plain C that might

be simpler to use than learning the STL.

8

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Solved Exp19_Excel_Ch07_HOEAssessment_Employees Assignment Help

Solved Exp19_Excel_Ch07_HOEAssessment_Employees Assignment Help

Exp19_Excel_Ch07_HOEAssessment_Employees

Project Description:

You work for a clothing distributor that has locations in Iowa, Minnesota, and Wisconsin. You will use date and logical functions to complete the main employee data set, use database functions to calculate key summary statistics and create a map, and use financial functions to complete a loan amortization table.

 

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

 

The 1-Data worksheet contains   employee data. You will insert several functions to complete this worksheet.   Column C contains the actual hire dates for the employees. You want to   extract only the year in column G.
In cell G9, insert the appropriate date function to extract the year from the   date in cell C9. Copy the function from cell G9 to the range G10:G33.

 

Next, you want to determine how   many years each employee has worked for the company.
In cell H9, insert the YEARFRAC function to calculate the years between the   hire date and the last day of the year contained in cell G2. Use a mixed   reference to cell G2. Copy the function from cell H9 to the range H10:H33.

 

You want to determine what day   of the week each employee was hired.
In cell I9, insert the WEEKDAY function to display the day of the week the   first employee was hired. Use 2 as the return_type. Copy the function from   cell I9 to the range I10:I33.

 

The value returned in cell I9 is   a whole number. You want to display the weekday equivalent.
In cell J9, insert a VLOOKUP function to look up the value stored in cell I9,   compare it to the array in the range H2:I6, and return the day of the week.   Use mixed references to the table array. Copy the function from cell J9 to   the range J10:J33.

 

Column D contains the city each   employee works in. You want to display the state.
In cell F9, insert the SWITCH function to switch the city stored in cell D9   with the respective state contained in the range C2:C4. Switch Des Moines for Iowa, St. Paul for Minnesota, and Milwaukee for Wisconsin. Use mixed   references to cells C2, C3, and C4. Copy the function from cell F9 to the   range F10:F33.

 

Your next task is to calculate   the bonus for the first employee. If the employee was hired before 1/1/2010,   the employee’s salary is multiplied by 3%. If the employee was hired before   1/1/2015, the employee’s salary is multiplied by 2%. If the employee was   hired before 1/1/2020, the employee’s salary is multiplied by 1%.
In cell K9, insert the IFS function to create the three logical tests to   calculate the appropriate bonus. Use mixed references to cells within the   range K2:L4. Copy the function from cell K9 to the range K10:K33.

 

Top management decided to ensure   all representatives’ salaries are at least $62,000 (cell G2).
In cell L9, nest an AND function within an IF function. If the job title is Representative   and the salary   is less than the minimum representative salary, calculate the difference   between the minimum representative salary and the actual salary. If not,   return zero. Use a mixed reference to cell G3. Copy the function from cell L9   to the range L10:L33.

 

The 2-Summary worksheet contains   data to insert conditional math and statistical functions to provide summary   data. First, you want to count the number of employees in each state.
Click the 2-Summary worksheet. In cell J3, insert the COUNTIF function to   count the number of employees in Iowa, using the state abbreviation column   and the state abbreviation in cell I3. Use mixed references for the range and   cell to keep the row numbers the same. Copy the function from cell J3 to the   range J4:J5.

 

Next, you want to calculate the   total payroll for each state.
In cell K3, insert the SUMIF function to total the salaries for employees who   work in Iowa, using the state abbreviation column and the state abbreviation   in cell I3. Use mixed references for the ranges and cell to keep the row   numbers the same. Copy the function from cell K3 to the range K4:K5.

 

Next, you want to calculate the   average salary for executives and the average salary for representatives.
In cell J8, insert the AVERAGEIF function to calculate the average salary for   executives. Use mixed references to the range and for the cell containing   Executives. Copy the function to cell J9.

 

You want to identify the number   of representatives hired before 1/1/2015.
In cell J12, insert the COUNTIFS function to count the number of   representatives who were hired before 1/1/2015. Use ranges for the criteria   ranges and the reference to cell H9 that contains Representatives. Enter the   date condition directly in the criteria box.

 

In cell J13, insert the SUMIFS   function to calculate the total salaries for representatives hired before   1/1/2015. Use ranges for the criteria ranges and the reference to cell H9   that contains Representatives. Enter the date condition directly in the   criteria box. Use mixed references to the ranges and cell reference so that   you can copy the function in the next step.

 

Copy the function from cell J13   to the range J14:J16. Edit the function in cell J14 to calculate averages.

 

Edit the function in cell J15 to   calculate the lowest salary.

 

Edit the function in cell J16 to   calculate the highest salary.

 

Insert a map to display total   salaries by states.
Select the ranges I2:I5 and K2:K5 and insert a filled map. Change the chart   title to Payroll by State. Cut the chart and paste it in cell M1.

 

The 3-Finance worksheet contains   inputs for a loan.
In cell F2, insert the PV function to calculate the loan. Use cell references   in the Input Area and Basic Output Area.

 

You are ready to insert formulas   and functions in the loan amortization table.
In cell C7, enter a reference to the Payment that is stored in cell D2. Use   mixed reference so that the row number does not change. Copy the formula from   cell C7 to the range C8:C42.

 

The next column is designed to   display the interest portion of each payment.
In cell D7, insert the IPMT function to calculate the interest for the first   payment. Use mixed references for cells in the Basic Output Area and make   sure the result is a positive value. Copy the function from cell D7 to the   range D8:D42.

 

Next, you are ready to calculate   the portion of the monthly payment that goes toward the principal.
In cell E7, insert the PPMT function to calculate the principal portion of   the first payment. Use mixed references for cells in the Basic Output Area   and make sure the result is a positive value. Copy the function from cell E7   to the range E8:E42.

 

Now you are ready to calculate   the balance of the loan after each payment.
In cell F7, enter a formula to calculate the ending balance after subtracting   the Principal Repayment from the Beginning Balance. Copy the formula from   cell F7 to the range F8:F42.
In cell B8, enter a formula that refers to the ending balance for the   previous month in cell F7. Copy the relative formula to the range B9:B42.

 

Now you want to calculate the   cumulative interest after each payment.
In cell H7, insert the CUMIPMT function. Use mixed references for cells in   the Basic Output Area and the Start_period argument. Make sure the result is   a positive value. Copy the function from cell H7 to the range H8:H42.

 

Finally, you want to calculate   the cumulative principal after each payment.
In cell I7, insert the CUMPRINC function. Use mixed references for cells in   the Basic Output Area and the Start_period argument. Make sure the result is   a positive value. Copy the function from cell I7 to the range I8:I42.

 

Insert a footer on all three   sheets with your name on the left side, the sheet name code in the middle,   and the file name code on the right side.

 

Save and close Exp19_Excel_Ch07_HOEAssessment_Employoees.xlsx.   Exit Excel. Submit the file as directed.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Exp19_Excel_Ch06_Cap_High_West_Fashions

Exp19_Excel_Ch06_Cap_High_West_Fashions

Grader – Instructions Excel 2019 Project

Exp19_Excel_Ch06_Cap_High_West_Fashions

 

Project Description:

You are the digital marketing director for High West Fashions, a regional clothing company that specializes in custom t-shirts. Your company has decided to launch an online advertising campaign that gives customers the ability to purchase heavily discounted products. You have the task of determining the optimal amount of advertising to purchase in order to maximize profit and most effectively utilize resources.

 

Steps to Perform:

Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp19_Excel_Ch06_Cap_DirectMarketing.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 On the Direct Marketing worksheet, create appropriate range names for Design_Fee (cell B8), Cost_Per_Ad (cell B9), Total_Clicks (cell B10), Profit_Per_Click (B11), and Gross_Profit (cell B12). 5
3 Edit the existing name range Design_Fee to Design_Fee2021 to reflect the current year. 4
4 Use the newly created range names to create a formula to calculate Gross Profit (cell B12) and Net Profit (cell B13). 6
5 Create a new worksheet named Range Names, paste the newly created range name information in cell A1, and resize the columns as needed for proper display. Mac users, use the Insert menu to insert a new worksheet and paste the range names. 5
6 On the Direct Marketing worksheet, use Goal Seek to determine the optimal click rate in order to earn a $5,000 net profit. 6
7 Starting in cell E4. Complete the series of substitution values ranging from 2% to 6.5% at increments of .50% vertically down column E. 5
8 Enter references to the Gross Profit and Net Profit in the correct location for a one-variable data table. 3
9 Complete the one-variable data table, and then format the results with Accounting Number Format with two decimal places. 6
10 Apply custom number formats to display Gross Profit in cell F3 and Net Profit in cell G3. 4
11 Copy the response rate substitution values from the one-variable data table, and then paste the values starting in cell I4. 4
12 Type 10000 in cell J3. Complete the series of substitution values from 10000 to 40000 at 5000 increments. 3
13 Enter the reference to net profit formula in the correct location for a two-variable data table. 4
14 Complete the two-variable data table and format the results with Accounting Number Format with two decimal places. 7
15 Apply a custom number format to make the formula reference appear as Net Profit. 3
16 Make the Direct Marketing 2 worksheet active. Create a scenario named Best Case, using Number of Ads and Click Rate. Enter these values for the scenario: 40000, and 6.5%. 4
17 Create a second scenario named Worst Case, using the same changing cells. Enter these values for the scenario: 10000, and 1%. 4
18 Create a third scenario named Most Likely, using the same changing cells. Enter these values for the scenario: 10000, and 6.83%. 4
19 Generate a scenario summary report using Gross Profit and Net Income. 4
20 Return to the Direct Marketing 2 worksheet. Load the Solver add-in if it is not already loaded. Launch Solver and set the objective to calculate a net profit of $20,000. 4
21 Use Number of Ads and Click Rate (B4:B5) as changing variable cells. 4
22 Set a constraint to ensure Number of Ads purchased is less than or equal to 40,000. 2
23 Set a constraint to ensure Click Rate is less than or equal to 7%. (Mac users should enter the value in decimal form. Example .07) 2
24 Solve the problem. Generate the Answer Report. 3
25 Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side. 4
26 Save and close Exp19_Excel_Ch06_CAP_DirectMarketing.xlsx. Exit Excel. Submit the file as directed. 0
Total Points 100

 

Created On: 04/09/2021 1 Exp19_Excel_Ch06_Cap – High West Fashions 1.6

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Exp19_Excel_Ch06_ML1_Housing_Cost

Exp19_Excel_Ch06_ML1_Housing_Cost

Exp19_Excel_Ch06_ML1_Housing_Cost

 

Exp19_Excel_Ch06_ML1_Housing_Cost

Project Description:

Your friends, Elijah and Valerie Foglesong, want to build their dream house. They identified tentative costs, but they cannot afford the $414,717 estimated cost. You will use Goal Seek to determine an estimate of the total finished square footage they can afford. To help provide more flexibility in their decision-making, you will create a data table listing various finished square footages and their effects on the base house cost and total cost. Finally, you will create another data table showing combinations of square footages and lot prices to identify total costs.

 

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

 

Assign the range names B9 (Base), B15 (Interior), B21 (Exterior), B23 (Lot).

 

Enter a formula in cell B25 to   calculate the total estimated cost. The total estimated cost is the sum of   the base house price (B9), total interior upgrades (B15), total exterior   upgrades (B21), and lot fee (B23). Be sure to use range names in the formula.

 

Use Goal Seek to determine the   total finished square footage(B7) to meet the total cost goal of $350,000.

 

Enter a series of total square   footage ranging from 1,800 to 3,600 in increments of 200 in the range D6:D15. Apply Blue font and Comma Style with   zero decimal places to the series.

 

Enter a reference to the base   house price in cell E5 and a reference to the total estimated cost in cell   F5.

 

Complete the single variable   data table in the range D5:F15. Be sure to use total square footage as the   column input. Apply Custom number formats to give appropriate descriptions to   the second and third columns. Apply these formats to the headings: bold,   center, and Blue font color.

 

Identify the square footage,   base price, and total cost in the data table that comes closest to their   goal. Apply Yellow fill color to those cells.

 

Copy the square footage   substitution values, range D6:D15 to the range H6:H15 and remove the fill   color. Enter these lot price substitution values in the range I5:K5: 9000096000, and 102675. Format these values with Accounting Number Format with zero   decimal places and Blue font color.

 

Enter the reference to the total   estimated cost in the appropriate location for the second data table. Apply a   custom number format to display Total Sq Ft in that cell. Apply Blue font and bold to that   cell.

 

Complete the two-variable data   table using total square footage as the Column Input and lot price as the Row   Input. Apply a Custom number format to the reference to the formula cell.   Apply Yellow fill color to the total price in each column that comes closest   to their goal.

 

Format results in both tables   with Accounting Number Format with zero decimal places.

 

Create a scenario named Ideal Costs, using Base price per square   foot and Lot fee (use cell references). Enter these values for the scenario: 80102,675.

 

Create a scenario named Increased   Costs, using   Base price per square foot and Lot fee (use cell references). Enter these   values for the scenario: 100110,000.

 

Create a scenario named Low Costs, using Base price per square   foot and Lot fee (use cell references). Enter these values for the scenario: 6080,000.

 

Generate a scenario summary   report using the cell references for Price per square foot and Lot Fee. Add   the appropriate formatting to the newly created report

 

Save and close Exp19_Excel_Ch06_ML1_HW-Housing Cost.xlsx.   Exit Excel. Submit the file as directed.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Microsoft Excel Assignment – “Revenue”

Microsoft Excel Assignment – “Revenue”

Do Project 3E Revenue that begins on page 527 of your textbook. Submit the document by clicking the Attachments button to attach the file. Do not paste the document in the Message area.

You will need to download and use the following data file to complete your assignment:

Revenue Report

In addition to the assignment file, answer the following question with your submission.  This can be answered directly in your Submission comment area, or as a separate Word attachment file:

In this Week’s reading and prep work, In this week’s chapter, you utilized the “What-If Analysis” feature. Explain what this is and how you feel you might be able to use it in a personal finance worksheet of your own?  Please look to answer this in at least 3 complete sentences in order to address it adequately.

The picture on the right is what it should look like afterwards!!!!  

 

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!