Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Spotlight Video is a company which uses automated retail kiosks to rent the latest selec- tions of DVDs, and Blu-ray. After they have been viewed

Spotlight Video is a company which uses automated retail kiosks to rent the latest selec- tions of DVDs, and Blu-ray. After they have been viewed a certain number of times, their quality deteriorates to the point that Spotlight Video considers them to be defective. Further- more, some customers own media players that are defective and can ruin Spotlight Videos merchandise.

Spotlight Video wants to maintain an inventory of DVDs and Blu-ray media that are at least 85 percent acceptable, although 95 percent is preferable. However, since it cant 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 rental, 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. xlsx. 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.

Please show how to do/set up on excel and any equations necessary image text in transcribed

Edit Alignment 10AA | | Fill : Arial CleaB I U Paste- Clear, B 1 U , S . A A1 SPOTLIGHT VIDEO DEFECT REPORT OF #OF STATUS MOVIE TITLE RENTALS DEFECTS Yours, Mine and Ours (2005 3 The Weather Man (2005 4 North Country (2005 5 Domino (2005 100 6Saw Il (2005 2 8 Just Like Heaven (2005 3 9 Elizabethtown (2005 4 10 Zathura: A Space Adventure (2005 5 11 Flightplan (2005 7 13 In Her Shoes (2005 9 15 The Legend of Zorro (2005 16 Proof (2005 1 17 Lord of War (2005 2 18 The lce Harvest (2005 3 19 Pride & 5 21 Red Eye (2005 9 Vitilkar x,4 inntit in .no, Caara, 41e aix: Wenn t.nit (2t1 7 23 Doom (2005 8 24 Wedding Crashers (2005 9 25 The Man (2005 0 26 The Constant Gardener (2005 1 27 The Fog (2005 2 28 Hustle & Flow (2005 3 29 The Prince and Me 2 (2006 4 30 The Aristocrats (2005 100 6 32 MirrorMask (2005 7 33 Where the Truth Lies (2005 8 34 Into the Blue (2005 9 35 Two for the Money (2005 74 1 3 Four Brothers (2005 2 38 Must Love Dogs (2005 5 41 The Cave (2005 8 44 Cinderella Man (2005 9 44 Mr. & Mrs. Smith(2005 0 44 Underclassman (2005 1 47 The 40 Year O Virgin 2005 2 47 The Brothers Grimm (2005 3 49 Nine Lives (2005 45Thumbsucker (2005 102 100 100

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions