Information Technology Project Management
8th Edition
ISBN: 9781285452340
Author: Kathy Schwalbe
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 7, Problem 5E
Explanation of Solution
Given data:
Charges per person: $600
Rent: $500
Registration cost: $400
Postcard designing cost: $300
Registration cost = $5 per person
Credit card processing fees = 4%
Postcard Printing=$40 per post card
Mailing and postage = $35 per postcard
Beverage and lunch cost = $25 per person
Handout cost = $30 per person
Required:
Calculate profit for 10, 20, 30, 40, 50, and 60 attendees.
Include data in Excel:
The data in Excel would look as follows.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving a seminar on cost estimating. Make the following assumptions:
• You will charge $600 per person for a two-day class (i.e., the class fee).
• Your fixed costs include $500 total to rent a room for both days, setup fees of $400 for registration, and $300 for designing a postcard for advertising.
• You will not include your labor costs for this estimate, but you estimate that you will spend at least 150 hours developing materials, managing the project, and giving the actual class. You would like to know what your time is worth given different scenarios.
• You will order 5,000 postcards, mail 4,000, and distribute the rest to friends and colleagues.
• Your variable costs include the following:
a. $5 per person for registration plus 4 percent of the class fee per person to handle credit card processing; assume that everyone pays by credit card
b. $.40 per postcard for printing if you…
Answer the given question with a proper explanation and step-by-step solution.
Practice is the best way to learn Excel. In this assignment, you will have the opportunity to apply what you learned from the video tutorial. The following are some expenses you have listed in your notes, this time you want to use excel to get the totals from the details automatically:
Electricity & Water Bill, 350.75 Phone Bill, 250 Internet, 190 Gas, 120 Meals with Client, 250 Courier, 25 Donation, 100 Car change oil, 179.25 Paid to your accountant, 1,500 Car repairs, 730 Instruction: 1. Open a blank Excel workbook, then create two columns- the 1st column is for the description (e.g. donation), and the 2nd column is for the amount. Write column headings e.g. Expenses for column 1 and Amount for column 2. 2. Write a table heading. The heading should be "Your Family Name's Expenses for the month of September 2022", for example, if your Family Name is Cruz, your table heading will be "Cruz Family…
Q1: Develop a table that compares the four installation strategies, showing the pros and cons of each.
Chapter 7 Solutions
Information Technology Project Management
Knowledge Booster
Similar questions
- You have decided to undertake a project and have defined the main research question as ‘What are theopinions of consumers on a 10 percent reduction in weight, with the price remaining the same, of “Snackers”chocolate bars?’Write both a null and alternative hypothesis that you could test in your project. In your response, also definethe purpose of the study, define the research problem statement, list the research objectives, and researchquestions.arrow_forwardDevelop a realistic retirement-planning simulation model for your personal situation. If you are currently employed, use as much information as you can gather for your model, including potential salary increases, promotions, contributions, and rates of return based on the actual funds in which you invest. If you are not employed, try to find information about salaries in the industry in which you plan to work in and the retirement benefits that companies in that industry offer for your model. Estimate rates of return based on popular mutual funds used for retirement or average performance of stock market indexes. Clearly state your assumptions and how you arrived at them and fully analyze and explain your model results.arrow_forwardDevelop a realistic retirement-planning simulation model for your personal situation. If you are currently employed, use as much information as you can gather for your model, including potential salary increases, promotions, contributions, and rates of return based on the actual funds in which you invest. If you are not employed, try to find information about salaries in the industry in which you plan to work in and the retirement benefits that companies in that industry offer for your model. Estimate rates of return based on popular mutual funds used for retirement or average performance of stock market indexes. Clearly state your assumptions and how you arrived at them and fully analyze and explain your model results. I NEED A DIFFRENT ANSWERarrow_forward
- Explanation In the first example, your initial amount of money is $200, which enable you to invest in the first, second, fourth and fifth project that needs only $200 each. By establishing these four projects apart, the investor will have $200*4 (profit) +$200 (initial basic) = $1000. This amount of money will enable the establishment the 3rd project that needs $500 of investment to gain $200 of profit. Finally, to calculate the overall profit, you have collected $1200, where $200 of them are the initial basic and hence the profit is $1200 - $200 = $1000. In the second example, your initial amount of money is $150, which enable you to invest in the 3rd project only. By doing so, your budget will increases to $200 and hence be able to invest in the 1st project to again increase your budget to $290. However, this is not enough to invest in the 3rd project. Finally, you collected $290, where $150 of them are the initial basic and hence the profit is $290 - $150 = $140. """ I want…arrow_forwardDraw the UML diagram using a strategy pattern for calculating different types of salaries. - Employees that work by the hour have a different tax rate and salary is calculated based on hours reported- Employees under a contract have a set monthly salary but could still have a different withholding rate- Overhours (for contract and hourly employees) are calculated using a 1.5 multiplier for their salary scale and are paid by the hour- Employees might also receive compensation from a delivery regardless of hours workedarrow_forwardYour mission is to visit a "Mam and Pap" convenient store and observe how they do business. Then using your skills and abilities along with all of the spreadsheet functions and formulas you would have learned in this class, decide how best you can help them perform their daily regiments better. Some ideas to consider are: 1. Better ways of controlling their inventory 1. Marketing strategies 3. Salary payment 4. Labelling and pricing of items/goods. 5. Store layout Project 2 instructions are as follows:- Your mission is to visit a "Mam and Pap" convenient store and observe how they do business. Then using your skills and abilities along with all of the spreadsheet functions and formulas you would have learned in this class, decide how best you can help them perform their daily regiments better. Some ideas to consider are: 1. Better ways of controlling their inventory 1. Marketing strategies 3. Salary payment 4. Labelling and pricing of items/goods. 5. Store layoutarrow_forward
- Perform the following activities as part of the assignment • Read the case study at the end of Chapter 5, (which I will include below). You should use the 4 questions for the case study as a guide to the following: • Add new resort use case • Add book reservation use case • Activity diagrams • Sequence diagrams CRUD analysis. • Remember tables and diagrams always need a narrative to elaborate on them. This is what makes your document a narrative business document and not just a list of facts and ideas. Here is the case study. The Spring Breaks 'R' Us Travel Service The SBRU information system includes four subsys- they only plan to provide some design specifications and tems: Resort relations, Student booking, Accounting guidelines to each resort. The resort will be responsible and finance, and Social networking. The first three for connecting to the Internet and for providing a secur are purely Web applications, so access to those occurs wireless environment for the students.…arrow_forwardWhat precisely does it imply when people talk about "algorithmic cost models," and how does one go about applying these models? Which disadvantages does it have in comparison to the many other methods that may be used in order to arrive at an estimate of costs?arrow_forwardComputer Science THIS MUST BE ANSWERED USING A UML STRATEGY DIAGRAM. This is a computer science based question. Please follow directions. Question: Draw the UML diagram using a strategy pattern for calculating different types of salaries. For example: - Employees that work by the hour have a different tax rate and salary is calculated based on hours reported - Employees under a contract have a set monthly salary but could still have a different withholding rate - Overhours (for contract and hourly employees) are calculated using a 1.5 multiplier for their salary scale and are paid by the hour - Employees might also receive compensation from a delivery regardless of hours workedarrow_forward
- For an in-house project, what is an ethical response to the marketing manager who says the project should be canceled if it will not be ready for the trade show? In your answer, suppose that you disagree with this opinion because you know the system has value regardless of whether it is done by the trade show.arrow_forwardCreate a decision table with three conditions. You can make one up or use a scenario from everyday life. Either way, be sure to show all possible outcomes from the tables put enough detail.arrow_forwardPlease explain plain as possible [For this question, you can use a program such as Excel or Word (paste into the quiz, then format at needed), or use the table formatting tools in the Canvas Toolbar in the quiz question to create your matrix.] Using the scenario information, illustrate a factorial matrix with identifiers for each side of the matrix, and the variable identifications in each box of the table. The goal is that your reader should be able to visually see what you are researching based on the matrix table. Do not copy and paste the matrix from SPSS or other automatically generated format. You are to create the table manually. However, it does not need to be complicated. Simply identify a letter or code that illustrates your variables in the scenario, and be sure your reader knows what they mean. An example is provided below. The goal here is not that you produce a beautifully formatted table for this quiz, but that your information is clearly understandable to your…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Information Technology Project ManagementComputer ScienceISBN:9781337101356Author:Kathy SchwalbePublisher:Cengage Learning
Information Technology Project ManagementComputer ScienceISBN:9781285452340Author:Kathy SchwalbePublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning
Information Technology Project Management
Computer Science
ISBN:9781285452340
Author:Kathy Schwalbe
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L