Answer this

X AutoSave Off H . Homework chapter 04 ( General* 9 Search File Home Insert Page Layout Formulas Data Review View Automate Help Arial 12 ~ A " A ab General Conditional Formatting Paste BIUVF ~ ~ A - $ ~ % 9 Format as Table .00 Cell Styles ~ Clipboard Font Alignment Number Styles G11 v : XV fxv A B C D E F G H 3 Lesley is the purchasing manager for an organic food restaurant with a banquet room. She needs to create the food purchase orders for tomorrow. Her par-value, on-hand, and special-order requirements are as follows. Help Lesley determine the amount of each item she needs to order. (Spreadsheet hint: Use the ROUNDUP function with zero decimals in the Order Amount column. 9 Daily Inventory Sheet 10 Item Description Unit Par Value On Hand Special Order Order Amount 11 Avocados 48 ct case 6 2 3 12 Cauliflower 12 ct. case 5 13 Cucumbers Medium case 0 14 Grapes Red seedless lug 4 15 Lettuce Green leaf, 24 ct. case 5 2 4 16 Lettuce Romaine, 24 ct. case 3 0.5 17 Pears D'Anjou case 3 18 Peppers Green bell, med. case 7 2 5 19 Pineapples 7 ct. case 4 0 20 Potatoes B reds 50-lb bag 3 0.5 21 Potatoes Peeled, large 25-lb bag 4 1 22 Squash Yellow #2 30-lb case 5 2 23 Strawberries Driscoll flat 3 15 - . Q2 Q 3 Q4 26 Q8 Q9 Ready Accessibility: Investigate Q Search