Skip to main content

Benedictine BALT6102 W3 Hw3 quiz

 

Your work has been saved and submitted

An Excel __________ quantifies the impact of changing the value of a specific input on an output of interest.
Question options:
The impact of two inputs on the output of interest is summarized by a
Question options:
Excel’s __________ tool allows the user to determine the value of an input cell that will cause the value of a related output cell to equal some specified value.
Question options:
The ___________ button, located in the Formula Auditing group, creates arrows pointing to the selected cell from cells that are part of the formula in that cell.
Question options:
The following table is used to lookup information on a specific product. The Product ID is entered into cell B2 and the information is returned in the shaded box. There are several formulas in the table. How could I look at the cells that use the value in cell B2?

​

Question options:
The calculations of a cell can be investigated in great detail by using the __________ button.
Question options:
Which of the following tools provides an excellent means of identifying the exact location of an error in a formula?
Question options:
The __________ button provides an automatic means of checking for mathematical errors within formulas of a worksheet.
Question options:

Q9-13 are based upon Problems 3 and 6 in Chapter 10 in the textbook.

Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, text- book design, and web site construction is estimated to be $160,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for $46.

Build a spreadsheet model to calculate the profit/loss for a given demand.

What profit can be anticipated with a demand of 3,500 copies?

Question options:

See Q9.

Use a one-way data table to vary demand from 1,000 to 6,000 in increments of 200 to assess the sensitivity of profit to demand.

What profit can be anticipated with a demand of 5000 copies?

Question options:

See Q9.

Use Goal Seek to determine the access price per copy that the publisher must charge to break even with a demand of 3,500 copies. What is the break-even price?

Question options:

See Q9.

Construct a two-way data table to vary price from $46 to $296 in increments of $10 and vary variable cost from $1 to $9 in increments of $1 to assess the sensitivity of profit to price and variable cost.

What profit can be anticipated with a price of $106 and variable cost of $5?

Question options:

See Q12.

Through a series of web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4,000 -20*p, where p is the price of the e-book.

Update your spreadsheet model to take into account this demand function.

Reconstruct a two-way data table to vary price from $46 to $296 in increments of $10 and vary variable cost from $1 to $9 in increments of $1 to assess the sensitivity of profit to price and variable cost.

What profit can be anticipated with a price of $106 and variable cost of $5?

Question options:

Labels:

Comments

Post a Comment

Popular posts from this blog

GE5103-2 Project Management [Aug 23 Syllabus]

    Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A)        True 2.    Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A)        Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A)        Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in t...
Post a Comment
Read more

GE5093 Design Thinking All Quizzes

  GE---5093-1D2-FA-2021 - Design Thinking Home My courses 2021-FA GE---5093-1D2-FA-2021 Week 1 Reading Quiz 1 Started on Sunday, October 31, 2021, 2:04 PM State Finished Completed on Sunday, October 31, 2021, 2:30 PM Time taken 25 mins 58 secs Grade 8.00  out of 10.00 ( 80 %) Top of Form Question  1 Correct 1.00 points out of 1.00 Flag question Question text A critical finding of Edward Lorenz related to Design Thinking was: Select one: a. An application of the caterpillar effect b. The idea of deterministic chaos or the "Butterfly Effect" c. Business leaders enjoy chaos d. Statistical modeling of weather was fairly accurate in the long term Feedback Your answer is correct. The correct answer is: The idea of deterministic chaos or the "Butterfly Effect" Question  2 Incorrect 0.00 point...
Post a Comment
Read more

IS5213 Data Science and Big Data Solutions

WEEK- 2 code  install.packages("dplyr") library(dplyr) Rajeshdf = read.csv('c:\\Insurance.csv') str(Rajeshdf)                        str(Rajeshdf) summary(Rajeshdf) agg_tbl <- Rajeshdf %>% group_by(Rajeshdf$JOB) %>%    summarise(total_count=n(),             .groups = 'drop') agg_tbl a = aggregate( x=Rajeshdf$HOME_VAL, by=list( Rajeshdf$CAR_TYPE), FUN=median, na.rm=TRUE ) a QUIZ 2. What famous literary detective solved a crime because a dog did not bark at the criminal? A). Sherlock Holmes 1.  In the Insurance data set, how many Lawyers are there? A).  1031 3. What two prefixes does the instructor use for variables when fixing the missing values? Select all that apply. A). IMP_ M_ 4. What is the median Home Value of a person who drives a Van? A).  204139 5. In the insurance data set, how many missing (NA) values does the variable AGE have? A) 7   1. What...
Post a Comment
Read more