Posts in category: Uncategorized

YO19_Excel_BU02_PS1_Advertise

Start Excel. Download and open   the file named Excel_BU02_PS1_Advertise.xlsx.   Grader will automatically add your last name to the start of the filename.   Save the file to the location where you are storing your files.

On the GuestData worksheet, in   cell H2, add a COUNTA function to determine the number of months listed in cell   range A6:A17.

In cell J2, add a DATEDIF function to calculate the survey duration   in years using the 2020 Fiscal Start date and 2021 Fiscal Start date.

Assign the named range Season to cell range L6:M17.

In cell range C6:C17, add a   VLOOKUP that will look up the value in column B and then return the exact   season match of Low, Mid, or High based on the value in column B. Use the   named range Season in the formula.

To count the number of seasons   in cell B22, enter a COUNTIF function that counts the Seasons in cell range   C6:C17 that meet the criteria in cell A22. Copy the formula through cell B24.   

To total the number of guests   surveyed by season in cell E22, enter a SUMIF function that sums the total   surveyed in J6:J17 if it meets the criteria in cell D22. Use appropriate   absolute referencing to copy the formula through cell E24. 

In cell range D19:J19, calculate   the averages for each column with a rounded (not formatted) value to zero   decimal places.

1. Software project decision point. 
   1. You need to determine an interest rate to use—select an interest rate and explain why you think this number should be used. Use it in your calculations in item 1.2.
   2. Given the information below on options 1 and 2, carry out three forms of analysis: breakeven, ROI, and NPV.
   3. Make a recommendation on which way to proceed, based on the TCO for each option.

• Option 1: Purchase the FunSoft package: Cost $200,000 for software and $85,000 for hardware in year one; with $50,000 to customize it and a $40,000 annual licensing fee for the life of the contract. There will be an annual saving of $61,000 due to the layoff of a clerk.
• Option 2: Purchase the SoftComm package, which will operate on the vendor’s hardware: Cost $250,000 for a five-year license, payable half up front and half during the first year of implementation. The maintenance contract, at $75,000 a year, includes all currently identified modifications to the software for the first three years. The clerk’s hours will be cut by half, for a saving of $25,000 a year.

In both cases, sales are expected to increase from the current $1 million a year, by 10% per year each year (over each year’s previous year’s sales) after full implementation.Assume a five-year life for the software.

Text-

Title: Project Management 

Subtitle: https://opentextbc.ca/projectmanagement/ 

ISBN: 978-1-77420-013-1 

Authors: Adrienne Watt 

Publisher: BCcampus 

Publication Date: August 14, 2014 

Edition: 2nd Edition

1. What were the traditional methods of data collection in the transit system?
2. Why are the traditional methods insufficient in satisfying the requirement of data collection?
3. Give a synopsis of the case study and your thoughts regarding the requirements of the optimization and performance measurement requirements and the impact to expensive and labor-intensive nature.

https://web.s.ebscohost.com/ehost/detail/detail?vid=0&sid=545f3f1b-c937-4e07-9211-61ad18684bc9%40redis&bdata=JkF1dGhUeXBlPXNoaWImc2l0ZT1laG9zdC1saXZl#AN=956104&db=e000xna

In this assignment, you will perform an exploratory analysis that will allow you to get a feel for the data and start exploring potential relationships. This may include:

• Descriptive statistics
• Histograms
• Bar charts
• Heat maps
• Line graphs
• Box plots
• Frequency tables

Once your analysis is complete, you will need to provide a Word document showing and describing the results of your exploratory analysis. This assignment is due by 11:59 PM CT on Sunday.

Assigned Readings:Chapter 14. Conflict and NegotiationInitial 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. Pauline has been asked to reorganize her department, eliminating at least two people within the office. Pauline has strong personal relationships with everyone in her office and being asked to complete this task is very hard on her. Thinking back to Stage Four of the conflict process, discuss one of the types of intentions with which Pauline might struggle in this situation.

Text

Title: Essentials of Organizational Behavior, Student Value Edition 

ISBN: ISBN-13: 9780135468890 

Authors: Stephen P. Robbins, Timothy A. Judge 

Publisher: Pearson 

Edition: 15TH

Networking question

The area of a trapezoid is A = ½h(B+b).Image of frmMain1. You are to write a Visual Basic program that accepts as input the height h, the big base B, and the small base b of a trapezoid and determines its area. Use a Sub/Function named CalcArea to calculate and display the result to the nearest tenth of a square inch. To display the commas and decimal places, you will need to read about the FormatNumber. You will call this Sub/Function four times. The default font Microsoft San Serif font displays commas that look like decimal points. Change the default font to Times New Roman.
2. As seen above, place your initials in the form’s title bar.
3. You are NOT to use any variables – only use object properties!
4. Do NOT use any TextBoxes – only labels.
5 When executed, the form appears in the center of the screen, and your form cannot be resized. (Note: All subsequent assignments will be centered and not resizable.This is the final message about this!)
6. Name your project Trap, attach your zipped VB project, including the executable file in an e-mail message with your name and section number (CRN) at the top of the message, and sent it to the e-mail address used for this course.This is the final message about this!)
Click the button below to see an example of a possible A version.
Notes: You will need to read about
Your project will work with VScrollBar controls, their Value, Minimum, Maximum, SmallChange, and LargeChange scroll-bar properties. Run my program to see these values.
Additionally, you MUST use the ValueChanged scroll-bar event for this project.
You will use the FormLoad event handler so that YOUR PROGRAM calculates initial number of square inches and NOT YOU.
The ControlBox form property so users can only exit the program using the Exit button.
Necessary casting functions/methods.
Other considerations:
The value of a vertical scroll-bar is based on the position of the top of the “thumb.”
Your form will NOT display the usual Minimize, Maximize, and Close buttons, so that users must use your Exit button.
You will include Option Strict for this assignment.

Java 

An online music store offers all songs for 3$ each. The store requires members to prepay any amount of money they wish, and then download as many songs accordingly. You are required to write a program that would ask the user for the amount that he/she will pay, then display a message indicating how many songs that user will be able to purchase as well as how much funds will remain in the account after that. For this assignment, assume that the user will always enter a valid integer value that is >= 0, and within the limit of the integer range.
Here is an example of how your program should behave (the value (shown in bolded italic for clarification purpose only) is entered by the user):
How much money do you wish to prepay?
80
With this amount, you will be able to purchase 26 songs.
You will then have 2$ left as a credit on your account.
Thanks for Shopping at Best Music Store!

The capability statement should contain the following sections:

• Technical Skills
• Non-Technical Skills
• Education
• Work Ethic/Motivation
• Role
• Social Media
• Schedule/Availability

 Draw t