In the # Items Shipped column, write a formula to determine the number of bearings shipped. Write the formula so that it can be copied down the column to automatically determine the number of timing belts shipped, the number of air filters shipped, and so on. In the Total Dollar Value of Items Shipped column, write a formula to determine the value of all bearings shipped. Again, write the formula so that it can be copied down the column to automatically determine the value of timing belts, air filters, and so on. In the Average #Days Held in Inventory column, write a formula to determine the average number of days bearings shipped were held in inventory; again, write the formula so that it can be copied down the column.

1. Based on the recommended inventory level you previously calculated for bearings, would you have had enough bearings in the warehouse to cover these orders? Place your answer in a cell below your analysis on the Actual Demand worksheet. Clearly identify this answer and highlight it in yellow.

AutoSave CH He O Scarch (Alto) File Home Insert Page Layout Formulas Data Review View Help Power Pivot Comments Share 2 Arial - A A w 10 AutoSum- == * P 2 Wrap Text General DIX 27 O X Out [Copy Paste Format Painter Cupboard Insert Delete Format Sensitive B 1 - 4 - 4 Merge & Center $ % 68% Conditional Formatas Cell Formatting lable Styles Clear Sort & Find & Filter Select Font Alignment Number Stvies Colls Editing Sensitivity E8 D D E F G . 1 J K ! M N 0 P A B 1 Description - Value Days in Invento - 2 Timing Bells 34.95 33 Average # Days Held In Inventory Item # Items Total Dollar Value Description Shipped of items Shipped Bearings 324 Timing Bells 199 Fan Ber Electronic Board 12 Air Filters 230 924 3 Fan Belt 3.59 36 4 Fan Bolt 3.59 25 5 Tan Bell 3.59 21 6 Hearings 6 43 25 37 7 Bearings 43.25 13 8 Fan Belt 3.59 21 9 Bearings 4325 20 10 Hearings 135 23 11 Bearings 135 33 12 Bearings 43.25 14 13 Bearings 135 37 14 Timing Helts 34.95 13 15 Bearings 135 12 16 Air Filters 2.25 37 17 Hearings 135 35 18 Timing Belts 34.96 37 19 Bearings 43.25 27 20 Bearings 43 25 6 21 Air Filters 2.25 39 22 Timing Belts 34.95 20 23 Fan Belt 3.59 10 24 Bearings 135 20 25 Hearings 135 34 28 Air Filters 2.25 38 27 Fan Bell 3.59 13 28 Fan Belt 3.59 21 29 Hearings 43.25 10 30 Air Filters 2.25 32 31. EL BE 125 37 Bearing Data Simulation Simulation Data 1 ReacyAccessibility: Good to go 13 Type here to search Actual Demand + IM TOOS O 10 Rain coming A Ja 3:20 PM 3/28/2022