Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please include formulas A B D E F G . 1 J K. L 1 How many different items in our current invento 2 How

image text in transcribedPlease include formulas

A B D E F G . 1 J K. L 1 How many different items in our current invento 2 How many items are on reorder? 3 How many items are not in stock? What is the maximum reorder time? What is the minimum reorder time? 4 5 6 Inventory ID Item Unit Price Reorder Level Quantity in Reorder 7 8 22.00 5 9 12.00 8 8 10 19.00 11 18.00 8 5 12 20.00 Reorder Quantit Time in y in Days Stock 14 18 5 18 5 16 2 22 5 12 21 2 28 28 4 21 21 1 21 12 21 8 13 19.00 1094 TIAB sampler $ 1095 SPF 15 gel $ 1096 SPF 30 gel $ 1097SPF 45 gel $ 1098 SPF 60 gel $ 1099 Yan Can Shampoo $ 1100 Yan Can Conditioner $ 1101 Yan Can Hair Mask $ 1102 Yan Can Mousse $ 1103 Yan Can Gel $ 1104 Yan Can Moulding Gell $ 1105 Yan Can Masque $ 20 14 7.00 NNN 5 5 5 5 15 18.00 20 16 18.00 17 15.00 5 22 18 25.00 5 19 20.00 5 20 21 22 In cell D1, enter a formula using a counting function to count the number of items in the inventory (CELLS B8:319) 23 In cell D2, enter a formula using a counting function to count the number of values in the "Quantity in Reorder" column 24 In cell D3, enter a formula using a counting function to count the number of blank cells in the "Quantity in Stock" column 25 In cell D4, enter a formula to find the MAXIMUM reorder time (D8:D19) 26 In cell D5, enter a formula to find the MINIMUM reorder time (D8:D19) 27 28

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_2

Step: 3

blur-text-image_step3

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 Accounting questions