Homework Help is Here – Start Your Trial Now!
Business
Operations Management
If the percentage reported is below 85 percent, then Spotlight Video wants to flag this video as “REPLACE.”     Spotlight Video has provided you with the data in a file called  T4_SpotlightVideo_Data. xls.  You will want to create an IF function to write a conditional expression that examines the criteria mentioned above.  Figure T4.18  displays a sample of the output that Spotlight Video ne

If the percentage reported is below 85 percent, then Spotlight Video wants to flag this video as “REPLACE.”     Spotlight Video has provided you with the data in a file called  T4_SpotlightVideo_Data. xls.  You will want to create an IF function to write a conditional expression that examines the criteria mentioned above.  Figure T4.18  displays a sample of the output that Spotlight Video ne

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question

  1. Spotlight Video is a premier video rental company in Denver, Colorado, offering the latest selections on DVD, game, and VHS releases. After DVDs and VHS tapes have been viewed a certain number of times, their quality deteriorates to the point that Spotlight Video considers them to be defective. Furthermore, some customers own DVD and VHS players that are defective and can ruin Spotlight Video’s merchandise. Spotlight Video wants to maintain an inventory of DVDs and VHS tapes that are at least 85 percent acceptable, although 95 percent is preferable. However, since it can’t keep customers’ machines from damaging the rentals, Spotlight Video has had to relax its criterion a little. You have been hired to create a spreadsheet that will evaluate each DVD and VHS based on the following criteria:   

    ■ A number of times each title has been rented. 

    ■ A number of defects have been reported. 

    ■ The percent acceptable must be above 85 percent based on usage.

    If the percentage reported is below 85 percent, then Spotlight Video wants to flag this video as “REPLACE.”     Spotlight Video has provided you with the data in a file called  T4_SpotlightVideo_Data. xls.  You will want to create an IF function to write a conditional expression that examines the criteria mentioned above.  Figure T4.18  displays a sample of the output that Spotlight Video needs

     

     

     

     

    T4_SpotlightVideo_Data.xlsx
9 35 Two for the Money (2005) 0 36 Broken Flowers (2005) 1 36 Four Brothers (2005) 2 38 Must Love Dogs (2005) 3 39 The River King (2005) 4 39 Stuart Little 3: Call of the Wild (2005) (V) 5 41 The Cave (2005) 6 42 The Thing About My Folks (2005) 7 43 Separate Lies (2005) 8 44 Cinderella Man (2005) 9 44 Mr. & Mrs. Smith (2005) 0 44 Underclassman (2005) 1 47 The 40 Year Old Virgin (2005) 2 47 The Brothers Grimm (2005) 3 49 Nine Lives (2005) 4 50 Thumbsucker (2005) 55 86 47 61 87 75 75 83 3 34 40 12 90 61 19 19 12 42 99 102 89 96 77 47 100 100 22 82 75 19 40 42
Transcribed Image Text:9 35 Two for the Money (2005) 0 36 Broken Flowers (2005) 1 36 Four Brothers (2005) 2 38 Must Love Dogs (2005) 3 39 The River King (2005) 4 39 Stuart Little 3: Call of the Wild (2005) (V) 5 41 The Cave (2005) 6 42 The Thing About My Folks (2005) 7 43 Separate Lies (2005) 8 44 Cinderella Man (2005) 9 44 Mr. & Mrs. Smith (2005) 0 44 Underclassman (2005) 1 47 The 40 Year Old Virgin (2005) 2 47 The Brothers Grimm (2005) 3 49 Nine Lives (2005) 4 50 Thumbsucker (2005) 55 86 47 61 87 75 75 83 3 34 40 12 90 61 19 19 12 42 99 102 89 96 77 47 100 100 22 82 75 19 40 42
# OF # OF ID MOVIE TITLE STATUS RENTALS DEFECTS 1 Walk the Line (2005) 2 Yours, Mine and Ours (2005) 3 The Weather Man (2005) 4 North Country (2005) 5 Domino (2005) 6 Saw II (2005) 7 Rent (2005) 8 Just Like Heaven (2005) 9 Elizabethtown (2005) ! 10 Zathura: A Space Adventure (2005) 11 |Flightplan (2005) 5 12 |Waiting.. (2005/1) - 13 In Her Shoes (2005) 3 14 Corpse Bride (2005) 15 The Legend of Zorro (2005) O 16 Proof (2005) 1 17 Lord of War (2005) 2 18 The Ice Harvest (2005) 3 19 Pride & Prejudice (2005) - 20 Transporter 2 (2006) 521 Red Eye (20051) 522 Wallace & Gromit in The Curse of the Were-Rabbit (20 - 23 Doom (2005) 3 24 Wedding Crashers (2005) 9 25 The Man (2005) O26 The Constant Gardener (2005) 1 27 The Fog (2005) 2 28 Hustle & Flow (2005) 3 29 The Prince and Me 2 (2006) (V) 130 The Aristocrats (2005) 5 31 Supercross (2005) 5 32 MirrorMask (2005) - 33 Where the Truth Lies (2005) 3 34 Into the Blue (2005) 114 5 53 112 5 54 23 12 100 44 12 19 53 12 42 26 92 26 20 19 44 40 88 26 34 33 99 33 62 33 24 19 50 47 34 74 54 55 54 29 26 78 26 66 61 51 47 100 54 50 40 56 54 98 12 46 40 72 33 78 19 50 74 69
Transcribed Image Text:# OF # OF ID MOVIE TITLE STATUS RENTALS DEFECTS 1 Walk the Line (2005) 2 Yours, Mine and Ours (2005) 3 The Weather Man (2005) 4 North Country (2005) 5 Domino (2005) 6 Saw II (2005) 7 Rent (2005) 8 Just Like Heaven (2005) 9 Elizabethtown (2005) ! 10 Zathura: A Space Adventure (2005) 11 |Flightplan (2005) 5 12 |Waiting.. (2005/1) - 13 In Her Shoes (2005) 3 14 Corpse Bride (2005) 15 The Legend of Zorro (2005) O 16 Proof (2005) 1 17 Lord of War (2005) 2 18 The Ice Harvest (2005) 3 19 Pride & Prejudice (2005) - 20 Transporter 2 (2006) 521 Red Eye (20051) 522 Wallace & Gromit in The Curse of the Were-Rabbit (20 - 23 Doom (2005) 3 24 Wedding Crashers (2005) 9 25 The Man (2005) O26 The Constant Gardener (2005) 1 27 The Fog (2005) 2 28 Hustle & Flow (2005) 3 29 The Prince and Me 2 (2006) (V) 130 The Aristocrats (2005) 5 31 Supercross (2005) 5 32 MirrorMask (2005) - 33 Where the Truth Lies (2005) 3 34 Into the Blue (2005) 114 5 53 112 5 54 23 12 100 44 12 19 53 12 42 26 92 26 20 19 44 40 88 26 34 33 99 33 62 33 24 19 50 47 34 74 54 55 54 29 26 78 26 66 61 51 47 100 54 50 40 56 54 98 12 46 40 72 33 78 19 50 74 69
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS