Question: Please help with the formula. On the InventoryAudit worksheet in cell C3, create a formula to retrieve the projected sales for each item within the

Please help with the formula.

On the InventoryAudit worksheet in cell C3, create a formula to retrieve the projected sales for each item within the category in cell B1. Enter an INDIRECT function to return the item numbers by category. The function will reference cell $B$1 (absolute) and index the value of the intersection of row 3 (A3) and column 2. Nest the function in an IFERROR function to return a blank cell if no items exist within the category. Please help with the formula. On the

Please help with the formula. On the

D E F G H K M . N O P Projection Actual B 1 Category Massage 2 Category Item 3 1 4 2 5 3 6 4 7 5 8 6 9 7 10 8 11 9 10 11 12 13 14 15 12 13 14 15 16 17 18 19 20 21 22 23 24 Mon Tues Wed Thur Fri Sat Sun Categories Massage Golf Food Novelty Reading Clothing 25 26 27 28 29 30 Item Total in Ending Actual Turnover Description 31 32 Beginning Total out inventory 35 33 33 Max Stock Inventory Discrepancy 25 On Target 20 On Target 15 On Target 10 On Target 30 On Target 30 On Target A1 A2 A3 |A4 A5 34 48 0.00% Healthy Trail Mix 0.00% Resort Polo 0.00% Healthy Energy Bar 0.00% Spirits Lifted Through Yoga 0.00% Golf Tees 0.00% 35 10 36 52 37 A6 10 > Inventory Inventory Audit DailyTransactions A B D E F G H M P R S U Golf Projection N O Reading Item Projection A5 Projection Food Item A1 Projection 2 3 Projection Projection K Novelty Item A13 A14 A15 Clothing Item A2 Massage Item A9 A10 A11 A12 5 Item A16 A17 A18 A19 A3 A6 4 5 A4 5 5 6 A20 A7 A8 6 8 9 10 11 12 13 14 Max_On_Hand Wholesell Price Sale Price Category Delivery Time Current Inventory ReOrder_Point RushReOrderPoint Discontinue ReorderStatus Vendor 45 $ 15.99 $ 21.99 Food 10 23 20 10 N Ok Vendor 1 35 $ 29.48 $ 45.34 Clothing 14 15 17 10 N Reorder Vendor 2 25 $ 3.90 $9.95 Food 4 5 15 10 N Rush Vendor 1 15 $ 6.90 $14.95 Reading 7 5 15 10 Y OK Vendor 4 50 $ 1.30 $ 2.59 Golf 11 27 20 10 N Ok Vendor 5 15 16 17 18 Item Description 19 A1 Healthy Trail Mix 20 A2 Resort Polo 21 A3 Healthy Energy Bar 22 A4 Spirits Lifted Through Yoga 23 A5 Golf Tees 24 A6 25 A7 26 A8 27 A9 28 A10 29 A11 30 A12 31 A13 32 A14 33 A15 34 A16 35 A17 36 A18 37 A19 38 A20 Inventory Inventory InventoryAudit Daily Transactions

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!