Project Overview You have been retained by Widget Sales Company

 

Project Overview

You have been retained by Widget Sales Company (for more information, see Widget Sales Company Project Overview [DOCX]), an international company with offices in 25 countries, to develop a website that will allow its employees to enter travel expenses incurred on a business trip and store that data for reporting purposes. It is estimated that, initially, only 100 employees in the United States will use the system, but within two years, all 2,500 employees worldwide will be using it. The site should have functions that ask for input and calculate the following:

  • The total number of days spent on the trip.
  • The time of departure on the first day of the trip and the time of arrival back home on the last day of the trip.
  • The amount of any round-trip airfare.
  • The amount of any car rentals.
  • Miles driven, if a private vehicle was used. Vehicle allowance is $0.58 per mile.
  • Parking fees. (The company allows up to $12 per day. Anything in excess of this must be paid by the employee.)
  • Taxi fees. (The company allows up to $40 per day for each day a taxi was used. Anything in excess of this must be paid by the employee.)
  • Conference or seminar registration fees.
  • Hotel expenses. (The company allows up to $90 per night for lodging. Anything in excess of this amount must be paid by the employee.)
  • The cost of each meal eaten. On the first day of the trip, breakfast is allowed as an expense if the time of departure is before 7 a.m. Lunch is allowed if the time of departure is before noon. Dinner is allowed if the time of departure is before 6 p.m. On the last day of the trip, breakfast is allowed if the time of arrival is after 8 a.m. Lunch is allowed if the time of arrival is after 1 p.m. Dinner is allowed if the time of arrival is after 7 p.m. The program should ask only for the costs of allowable meals. (The company allows up to $18 for breakfast, $12 for lunch, and $20 for dinner. Anything in excess of this must be paid by the employee.)

The program should perform the necessary calculations to determine the total amount spent by the business traveler in each category (mileage charges, parking, hotel, meals, etc.) as well as the maximum amount allowed in each category. It should then create a nicely formatted expense report that includes the amount spent and the amount allowed in each category, as well as the total amount spent and the total amount allowed for the entire trip. This report should be written to a file.

Phase 2 Instructions

In this phase, you will provide the detail that each of the roles must perform in completing the website.

Project Manager

Provide a timeline for the various activities that need to be completed. You must include a start date and an end date. Each individual activity should have its own start and end date. Indicate which activities can be done in parallel and which activities must end before another activity can start. The following is an example of how to start this. Try to be realistic in the assignment of dates:

  • Project Duration
    • Start Date-1/1/2019
    • End Date – 12/31/2020
    • Dependencies –
  • Initial Meeting
    • Start Date – 1/2/2019
    • End Date – 1/31/2019
    • Dependencies – None
  • Web Design
    • Start Date – 4/1/2019
    • End Date – 10/31/2019
    • Dependencies – Database tables defined.
Database Analyst

Provide an overview of the data that will need to be captured. This can be in a table format, listing the variable name, the data type, and any restrictions on the data. The following is an example of the expectations for this part:

  • Employee
    • Variable – Emp Name
    • Data Type – String
    • Restriction – None
  • Employee
    • Variable – Expenses allowed
    • Data Type – Boolean
    • Restrictions – Only Yes or No values
  • Expenses
    • Variable – Hotel Arrive Date
    • Data Type – Date
    • Restrictions -Valid date
  • Expenses
    • Variable – Hotel Depart Date
    • Data Type – Date
    • Restrictions – Valid date, greater than arrival date
Developer

Provide the detail for the website. At a minimum, this should include the number of pages on the site and what data should be on each page. You must also include an overview of the Python functions needed to complete the functionality of the site. While no code will be required, you will need to provide the function signature, the parameters being passed in (if any), and a brief description of what the function will accomplish. Below is an example of this part:

def parking(days):

  • Calculates the maximum allowance for parking fees using MAX_DAILY_FEE * days
  • Gets the parking fees from the user.
  • Adds the parking fees to total expenses (a global variable used for keeping track of the total amount spent by the traveler).
  • Determines if the parking fees exceed the allowed amount.
  • Returns the allowable parking fees.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

ENVR 1401-82004 Students will create a 7-page PowerPoint presentation (excluding title and reference pages) detailing human impact on the environment. Please

ENVR 1401-82004 Students will create a 7-page PowerPoint presentation (excluding title and reference pages) detailing human impact on the environment. Please use the following questions when creating your presentation. Chapter 1: Introducing Environmental Science and Sustainability Assignment Introduction Is their human impact on the environment? Do humans affect the world?

M3A1: Citizens United

http://digital.films.com.vlib.excelsior.edu/p_ViewVideo.aspx?xtid=6976 (copy and paste the link) Review Campaign Finance: Abuses and Reforms. [Video File] [48 min 25 sec] before you participate in this activity. Parts of the video will discuss aspects of campaign finance and reform. Before engaging in this activity, please return to the first discussion topic on political

The decision in Williams v Roffey Bros signals that the courts in

The decision in Williams v Roffey Bros signals that the courts in deciding whether or not to enforce a promise, may be guided less by technical questions of consideration than by questions of fairness, reasonableness and commercial utility.   The assignment will be in accordance with the following criteria: •

Management and Organizational Behavior.

Description Exercise 17: Read Annual Pay Raises (W-68-69). This is located in the color-coded workbook section in the back of your book. ( Uhl-Bien, M., Osborn, R. N., & Schermerhorn, J. R. (2014).) Organizational Behavior. Hoboken, NJ: Wiley. ISBN:9781118517376 Review the exercise and complete steps 1 and 2. For this

JP Morganchase Bank

Clearly present brief history, purpose, advertisement, competition, audience and location for that one institution. The information provided is supported with ample applicable data/evidence. analyze historical and current policy of the institution in reference to the Great Recession. use fact finder U.S. Census : Zip code Population Income Education Race PowerPoint:

HEPATITIS C USING APRI SCORE

Determination of Human Subjects Research Form and my project proposal. please, research about IRB. write the Description. Referencing the Determination Checklist on Page 2, briefly describe project objectives, the subject population and types of data/specimens to be collected and analyzed, how the data/specimens will be obtained, and why you determined

critical thinking :Public Service

Description Identify a public health concern that contributes to health risks or disease. As a governmental official, prepare a public service announcement (PSA) in the form of a two-page brochure to educate the public on this concern. Remember to address the following: A brief explanation of the concern, including a

Oral Language chart of phone conversation

Instructions In an APA formatted paper, paste the template found in doc. sharing. Define each of the terms and then watch the video of two children talking on the phone. Rate the language development of one of the two children in the video found at https://www.youtube.com/watch?v=sL3vqlHabck Use the SOLOM. Using

Motivations of Private-Sector Organizations

 Presidential Policy Directive 8 (PPD-8) is part of the national preparedness goal and provides a description for preparing for the threats in an all-hazards approach that pose the greatest risk to the United States. Community preparedness is a shared responsibility of the whole community. In addition to the public sector

Ethics Case Study

A student’s analysis of the ethic case must use the following written structural framework, which can be written as a memorandum to the file. Without the bullet points – these indicate required headings for each of the four sections. The following the description heading below to form a memorandum to

What is the overall impact in Muslim communities who have been exposed

 Research in the field of addiction studies has important implications for individuals, groups, organizations, the government, and society at large.Develop and hone your empirical question/issue, search the literature, read and analyze the literature, and form conclusions regarding your research question/issue based on the scientific articles. Number of references: Your paper

Poverty in the classroom

A four-unit research paper in APA formatting centered around the effects of poverty in education. The first unit needs to be about the effects poverty has on students in the classroom and needs to be 8-10 pages. Second unit is on the effects of substance abuse on students in the

Causes of America’s War in Vietnam

Description Formatting 12 font or smaller, standard script (e.g. Calibri, New Times Roman), 1.00-1.25 margins maximum, double spaced, clean appearance, etc. Basic organization is simple— don’t make it difficult Title— choose one that reflects your views on the topic to inform and engage your reader from the start, do not

International Finance

1. Discuss different ways that dominant investors use to establish and maintain the control of the company with relatively small investments. 2. Following corporate scandals and failures in the U.S. and abroad, there is a growing demand for corporate governance reform. What should be the key objectives of corporate governance

Workflows in telemetry

Workflow analysis aims to determine workflow patterns that maximize the effective use of resources and minimize activities that do not add value. There are a variety of tools that can be used to analyze the workflow of processes and clarify potential avenues for eliminating waste. Flowcharts are a basic and

Critical Decision Making for Providers

View the scenario called “Critical Decision Making for Providers”. In a 750-1,200 word paper, describe the scenario involving Mike, the lab technician, and answer the following questions: What were the consequences of a failure to report? What impact did his decision have on patient safety, on the risk for litigation,

sexual harassment

 (Sexual harassment is the “idea” in every sentence mentioned) Description: reflect on how and why sexual harassment “idea” is useful to the study of deviance and/or crime. Relevance: Here, you will discuss how this idea challenges common sense/common knowledge assumptions about people or activities that are deemed deviant or illegal.

Attack and Penetration Test

 Description Scenario: You are the owner and operator of a small information security consulting firm. You have received a request from one of your clients, Infusion Web Marketing, that you provide a written proposal for performing a penetration test on the company’s production Web servers and corporate network. Environment: Scope