Spotlight Video is a premier video rental company in Denver, Colorado, offering

Question

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: Number of times each title has been rented. Number of defects that 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.

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

Explanation / Answer

READ "Number of rental", X

READ "Number of defects", D

Calculate "Percentage", P = (D/X)*100

IF P>85 THEN "Status", S="REPLACE"

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.