Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN: 9781337508841
Author: Carey
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
A startup Internet company has generated the following cash balance for the first six years of its IS projects: -$250,000, -$180,000, $225,000, $340,000, $410,000, and $425,000. Using the NPV function in Excel, calculate the net present value of this project at an 8.5 percent interest rate. What is the IRR of this project? If a bank is willing to give the company a loan at 15 percent to implement these projects, should the company accept the loan (assuming there are no other conditions)? Why or why not?
The CTO of the company mentioned in Project 1 has decided to acquire a CASE tool to help expedite and better document the Web site that is being designed for his company’s e-commerce operations. The CTO has narrowed these choices to CA ERwin Process Modeler and Oracle Designer. Based on the information provided in this module and other sources, which tool would you recommend? What are the three major factors behind your recommendation?
The CTO of the company mentioned in Project 1 also…
The Touche Young accounting firm must complete three jobs during the next month. Job 1 will require 500 hours of work, job 2 will require 300 hours of work, and job 3 will require 100 hours of work. Currently, the firm consists of 5 partners, 5 senior employees, and 5 junior employees, each of whom can work up to 40 hours per month. The dollar amount (per hour) that the company can bill depends on the type of accountant who is assigned to each job, as shown in the table below. (The X indicates that a junior employee does not have enough experience to work on job 1.) All jobs must be completed. Touche Young has also set the following goals, listed in order of priority:
Goal 1: Monthly billings should exceed $68,000.
Goal 2: At most, 1 partner should be hired.
Goal 3: At most, 3 senior employees should be hired.
Goal 4: At most, 5 junior employees should be hired.
Formulate a preemptive goal programming model for thissituation
Show how including a stay option (L,R,S) can be accomplished with a standard TM
Knowledge Booster
Similar questions
- A known distribution company intends to reward it deserving employees with a bonus only for sales agents who reached the quota of Php50,000. Considering its mainstream operations, the firm wants to limit it to Manila and San Juan. Details of its roster is shown below: Name Area Position Sales Denni Cruz Caloocan Manager 76,400 Carmen Romulo Manila Sales Agent 53,085 Lea Ramirez Quezon City Rep 98,320 Exequiel Cabanda Las Pinas Supervisor 67,082 Marissa Caparaz Manila Sales Agent 59,999 Michael Guba Pasay Manager 43,999 Leslie Romero Caloocan Rep 93,000 Patrick Cua Quezon City Store Manager 100,032 Paul Rodrigues San Juan Sales Agent 32,028 Eryck Pangin San Juan Rep 100,320 Ezra Reyes Manila Sales Agent 50,021 Henry Dominquez Makati Supervisor 65,000 Sarah Folloja Paranaque Gen. Manager 82,092 Using logical functions, determine the qualified.arrow_forwardDraw decision table for Bookstores that get trade discount of a. 15% for orders from libraries and individuals b. 5%% extra allowed on orders of 6-19 copies per book titles c. 10% extra on orders of 20 -49 copies per book title d. 15% extra on orders of 50 or more copies per book title.arrow_forwardClyde Clerk is reviewing his firm’s expense reimbursement policies with the new salesperson, Trav Farr. “Our reimbursement policies depend on the situation. You see, first we determine if it is a local trip. If it is, we only pay mileage of 45 cents a mile. If the trip was a one-day trip, we pay mileage and then check the times of departure and return. To be reimbursed for breakfast, you must leave by 7:00 A.M., lunch by 11:00 A.M., and have dinner by 5:00 P.M. To receive reimbursement for breakfast, you must return later than 10:00 A.M., lunch later than 2:00 P.M., and have dinner by 7:00 P.M. On a trip lasting more than one day, we allow hotel, taxi, and airfare, as well as meal allowances. The same times apply for meal expenses.” Draw a decision tree depicting the reimbursement policy in this Problem using LucidChart or Word documentarrow_forward
- IKEO is a furniture manufacturer which produces two sizes of wood blocks (type A and B) thatare used to make either a table or a chair. A table is made of a type A and a type B wood blocks,while a chair is made of a type A and two type B wood blocks (See Figure 1) A table makes RM 3 profit, and a chair makes RM 5 profit. If M number of type A and Nnumber of type B wood blocks are produced, how many tables and chairs should themanufacturer make to obtain the greatest profit?For example, let M = 12 and N = 12.By making 4 tables (4 type A and 4 type B) and 4 chairs (4 type A and 8 type B), themanufacturer gain profit as follows,Profit = (RM 3) × 4 + (RM 5) × 4 = RM 32.If the manufacturer makes 2 more tables and 1 less chair, the profit will be increased as follows,Profit = (RM 3) × 6 + (RM 5) × 3 = RM 33.Is this the greatest profit? Write a complete C++ program to help the manufacturer determine the greatest profit obtainfrom making tables and chairs with a given number of M type A and N…arrow_forwardEvery campus has full time students who attend classes between 8h00 and 17h00 during theweek. Every campus also has part time students who attend classes between 18h00 and 21h00 onweekdays. In the scenario provided at the beginning of Q.1.1, it is stated that no student shouldbe allowed to access the campus after 12h00. The campus has decided to change this rule to state“no full-time student will be allowed to access the campus after 12h00. Part time students canaccess the campus as from 17h00 By making use of a class diagram, demonstrate how the concept of inheritancecan be used to represent the scenario provided at the beginning of thisquestion. Marks will be awarded as follow: Class diagram showing inheritance; Attributes; Instance methods; Access specifiersarrow_forwardJoe Forrester, an operations analyst for a manufacturing company, developed the following LP formulation and wants to create an initial simplex tableau. ? Max 40xl + 30x2 + 50x3s.t. 2xl + 3x2 + 4x3 < 200 x1 + 2x2 + 2x3 < 300 3xl + x2 + 5x3 < 500arrow_forward
- A company owns the same asset in a ASIAN plant and in a UK plant . It has B $2,000,000 and a salvage value of 20% of B . For tax depreciation purposes, ASIA allows a straight line write-off over 5 years, while the UK allows SL write-off over 8 years. The general managers of the two plants want to know the difference in the depreciation amount for year 5.arrow_forwardAn engineer working in the quality control laboratory of a construction company is 4800, 5810 and 5690 dm3 respectively.It needs sand, fine gravel and coarse gravel. There are 3 quarries where these can be bought. Of these stovesTheir composition is given in the table. How many dm3 from the quarries so that the engineer can make the necessary analysis?sampleUse the Cramer method to solve the need to be taken.arrow_forwardA call center has 60 employees on‐line, each of whom make one phone call every 3 min on average, and talk on average for 2 min. Each call costs 15¢. What is the total traffic in erlangs? How many circuits are required for a GoS of 1%? How much should the yearly (250 working days, 8 working hours a day) lease price be for the company to make a 50% saving in its telephone bills over the first 3 years? Assume the lease set‐up fee of $30,000 should be paid over a period of 3 years.arrow_forward
- (b) Using VLOOKUP, write a formula in cell G24 to find the rate per hour from Table 8 for the given server size. Copy the formula to G25 to G41. (c) Using IF and VLOOKUP functions, write a formula in cell H24 to find the spot server's discount rate. For on-demand servers, the discount rate is 0%. Copy the formula to H25 to H41. SCREENSHOTS ARE ATTACHED BELOW Write down the formula needed to solve for the cells neededarrow_forwardEvery campus has full time students who attend classes between 8h00 and 17h00 during the week. Every campus also has part time students who attend classes between 18h00 and 21h00 on weekdays. In the scenario provided at the beginning of Q.1.1, it is stated that no student should be allowed to access the campus after 12h00. The campus has decided to change this rule to state “no full-time student will be allowed to access the campus after 12h00. Part time students can access the campus as from 17h00”.20; 21 2021© The Independent Institute of Education (Pty) Ltd 2021Page 4 of 4Q.2.1 By making use of a class diagram, demonstrate how the concept of inheritance can be used to represent the scenario provided at the beginning of this question. Marks will be awarded as follow:Q.2.1.1 Class diagram showing inheritance; (8)Q.2.1.2 Attributes; (4)Q.2.1.3 Instance methods; (12)Q.2.1.4 Access specifiers. (2)Q.2.2 By means of pseudocode, demonstrate how overloaded methods can be used in the COVID-19…arrow_forwardEvery campus has full time students who attend classes between 8h00 and 17h00 during the week. Every campus also has part time students who attend classes between 18h00 and 21h00 on weekdays. In the scenario provided at the beginning of Q.1.1, it is stated that no student should be allowed to access the campus after 12h00. The campus has decided to change this rule to state “no full-time student will be allowed to access the campus after 12h00. Part time students can access the campus as from 17h00”.Q.2.1 By making use of a class diagram, demonstrate how the concept of inheritance can be used to represent the scenario provided at the beginning of this question. Marks will be awarded as follow:Q.2.1.1 Class diagram showing inheritance; Q.2.1.2 Attributes; Q.2.1.3 Instance methods; Q.2.1.4 Access specifiers.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageOperations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole