70.2K

Verified Solution

Link Copied!

11 In cell H13, type Stock Level. In cell H14, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 50 the Value. true is Order. Otherwise the ValueIl false is OK. Fill the formula down through cell H42. 7 9 10 Cake Types 11 Cakes Quantity in Stock: 12 13 Quantity in Stock 14 15 16 17 18 19 20 21 22 23 24 122 26 27 28 29 30 31 52 33 39 35 36 Item# Item Name Retail Price 72 852 Tiramisu Mocha 38 802 Butter Fudge 803 Fudge Duo 49 402 Apricot Puff 105 356 Biscotti 150 266 Celebration Gift Pack 82 862 Four Fruits 62 223 Amandine 38 834 Biscotti Cheese 55 BA3 Dipped Apricots 72 832 Morello Cherries 30 811 Dark Orangettes 83 848 Dresden Stolen 61 892 Royal Preserve Duo 36 1267 Cassonade Waffles 151 439 Holiday Assortment 55 BS Coconut Macaroons 39 SB Holiday Set 61 877 Belgian Trutties 98 86 Strawberry 29 237 Wolfe Assortment 36 789 Praline 47 428 French Madeleine B3 381 Candy Trio 58 Orange Sponge 21 278 Pecan Parties 63 220 Petits Fours 364 Grand Party Assortment 37 Si Ma's Nougat Size 13.95 14 1 19.95 10 Oz 24 55 10 02 28.95 28 02. 26.95 1102 45 95 40 02 16,95 15 02 25.95 14 02 34 95 3603 24.95 10 02 28.95 60 37.95 1602 32.95 26 1695 150 28.95 42 0 34 95 35 02 1595 18 3 31.95 26 2 1695401 1595 150 269533 44.95.16 03 38.95 280 31.05 10 2 1395 142 24.95 16 2195 600 34.95 29.95 274) Packaging Category Stock Level Tin Cake FIF Tin Confection Box Confection BOX Danish Cellophane Cookies Cellophane Cookies Jar Confection Jar Cookies BOK Cake jar Chocolates Box Chocolates Box Confection Tin Cake Har Confection Cellophane Confection Tin Danish Cookies Tin Cake Tin Confection sar Confection Cake Cellophane Confection Bow Danish Tin Confection Tin Cake BON Confection Cellophane Cake Box Danih Tin Confection 39 40 1 42 Sheet View

Answer & Explanation Solved by verified expert

See Answer