Question

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

Daily Inventory Sheet
Item	Description	Unit	Par Value	On Hand	Special Order	Order Amount
Avocados	48 ct.	case	6	2	3
Cauliflower	12 ct.	case	5	1
Cucumbers	Medium	case	3	0
Grapes	Red seedless	lug	4	1
Lettuce	Green leaf, 24 ct.	case	5	2	4
Lettuce	Romaine, 24 ct.	case	3	0.5
Pears	D'Anjou	case	3	1
Peppers	Green bell, med.	case	7	2	5
Pineapples	7 ct.	case	4	0
Potatoes	B reds	50-lb bag	3	0.5
Potatoes	Peeled, large	25-lb bag	4	1	4
Squash	Yellow #2	30-lb case	5	2	2
Strawberries	Driscoll	flat	3	1.5

Answer 1

****Please please please LIKE THIS ANSWER, so that I can get a small benefit, Please****

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.)
Daily Inventory Sheet
Item	Description	Unit	Par Value	On Hand	Special Order	Order Amount
Avocados	48 ct.	case	6	2	3	7
Cauliflower	12 ct.	case	5	1		4
Cucumbers	Medium	case	3	0		3
Grapes	Red seedless	lug	4	1		3
Lettuce	Green leaf, 24 ct.	case	5	2	4	7
Lettuce	Romaine, 24 ct.	case	3	0.5		3
Pears	D'Anjou	case	3	1		2
Peppers	Green bell, med.	case	7	2	5	10
Pineapples	7 ct.	case	4	0		4
Potatoes	B reds	50-lb bag	3	0.5		3
Potatoes	Peeled, large	25-lb bag	4	1	4	7
Squash	Yellow #2	30-lb case	5	2	2	5
Strawberries	Driscoll	flat	3	1.5		2

****Please please please LIKE THIS ANSWER, so that I can get a small benefit, Please****