Reference no: EM13852074
Introduction
You are a senior marketing executive in a leading toy manufacturing firm. Your product development team has presented you with three new products for consideration. Your job is to evaluate the three projects and determine which product the company should make. You will use EXCEL to evaluate each product on a number of criteria.
Directions
1) Save your file as lastname + first initial + EX1.xlsx (e.g., doejEX1.xlsx)
2) Your task is to enter the formulas in the cells that are shaded yellow. You MUST use formulas to receive credit.
3) The metrics table (in orange) tells you what logic you need to apply for the various calculations in the scenario.
4) Only the cells that are shaded in yellow may be modified.
5) The spreadsheet will provide you automatic feedback as to your score. HOWEVER, if the correct formulas are not used, the instructor may reverse points awarded in the grader. While the auto-grade feature is a helpful guide, your instructor will still verify all answers. Your score is not final until entered into Angel.
Tips
1) A weighted score is a raw score that is multiplied by some multiplier (typically a percentage). For this scenario, the weighted score = raw score * category weight.
2) You can use the AVERAGE() function to help you calculate the average weighted score, but it is not required.
3) Use the MIN() and MAX() functions in your formulas to get the lowest and highest values in a range respectively. The Startup Cost, Expected Sales, and Expected Profit cells must use the Min or Max functions in their formula.
4) Ratios are generally derived via division.
5) Time to Delivery and Product Tie In cells should use an IF statement in their formula.
6) The Startup Cost, Expected Sales, Expected Profit, and Average Weighted Score must utilize static cell references in their formulas.
7) Designated cells not using the correct formula will be marked incorrect if they are wrong despite the results indicated in the built-in exam grader.
Attachment:- MIS_204_Exam_1_Midterm_V4.xlsx
|
Evaluate statement using labor-leisure model
: In 1981 Andrew Carnegie asserted that "parents who leave their children enormous wealth generally deaden their children's talents and energies and tempt them to lead less productive lives." Evaluate this statement using the labor-leisure model and e..
|
|
Write research paper on russian empire
: Research topic Russien Empire, Please read that i wrote so i will have idea write 1 page please Russien empire between 18th ,19th ,20th centuries so please be clear so it a beging of the research topic it will be easy for you to do next part 5 p..
|
|
Characteristics of the most effective company development
: Discuss the characteristics of the most effective company development strategies
|
|
How does the production possibilities curve
: Farmer brown produces eggs and milk on his farm. He initially produces at point A. HE WOULD LIKE to produce the same amount of eggs per day and increase his milk production by one gallon per day. Is this possible? Why or why not. What is the opportun..
|
|
Ratios are generally derived via division
: Ratios are generally derived via division
|
|
Present and future values for different interest rates
: Present and future values for different interest rates. Find the following values. Compounding/discounting occurs annually. Round your answers to the nearest cent. An initial $700 compounded for 10 years at 9%. Define present value. How are present v..
|
|
Write down the budget constraint equation for him
: Suppose a person has $20 to spend on music and likes both rap music (R) and country music (C) with a set of preferences so that U=C^1/2R^1/2. Suppose that the iTunes price of a rap music song is PR=2 and the price of a country music song is PC=1. Wri..
|
|
What stereotypes might you already have when you consider
: What stereotypes might you already have when you consider this audience? It's okay to be honest here. Once you acknowledge what you believe or have heard/read/been taught, you can better focus on the reality.
|
|
Identical marbles of mass
: Two identical marbles of mass m and radius R sit in a glass beaker as shown below. Thediameter of the beaker is 3R. Express your answers in terms of m, g and numericalconstants. Hint: Draw FBDs of each marble starting with the upper marble.
|