BACK TO LISTING

Worksheet Name

Closed on 07/31/19 by Teresa L.

DISPLAY OPTIONS

Group By

Storage Areas GL Accounts

View Price

At Close Current

APPLY

APPLY & SAVE

Total at Close
$86,843.00

Page 1 of 5 Total: 246 Items

GL Account: 12345

Item Name	Amount	Stock Unit	SU Price at Close	Value at Close
Milk 2%	5	1 Gallon	$####.##	$####.##
Milk 2%	2.75	5 Gallon	$####.##	$####.##
Milk Chocolate	9	2L	$####.##	$####.##
Milk Lactose Free	125	4oz Bottle	$####.##	$####.##
Milk Lactose Free	3	5 Gallon	$####.##	$####.##
Milk Lactose Free	.5	1 Gallon	$####.##	$####.##

GL Account: 78495723

Item Name	Amount	Stock Unit	SU Price at Close	Value at Close
Milk 2%	5	1 Gallon	$####.##	$####.##
Milk 2%	2.75	5 Gallon	$####.##	$####.##
Milk Chocolate	9	2L	$####.##	$####.##
Milk Lactose Free	125	4oz Bottle	$####.##	$####.##
Milk Lactose Free	3	5 Gallon	$####.##	$####.##
Milk Lactose Free	.5	1 Gallon	$####.##	$####.##

GL Account: 61742

Item Name	Amount	Stock Unit	SU Price at Close	Value at Close
Milk 2%	5	1 Gallon	$####.##	$####.##
Milk 2%	2.75	5 Gallon	$####.##	$####.##
Milk Chocolate	9	2L	$####.##	$####.##
Milk Lactose Free	125	4oz Bottle	$####.##	$####.##
Milk Lactose Free	3	5 Gallon	$####.##	$####.##
Milk Lactose Free	.5	1 Gallon	$####.##	$####.##

GL Account: 13-34251

Item Name	Amount	Stock Unit	SU Price at Close	Value at Close
Milk 2%	5	1 Gallon	$####.##	$####.##
Milk 2%	2.75	5 Gallon	$####.##	$####.##
Milk Chocolate	9	2L	$####.##	$####.##
Milk Lactose Free	125	4oz Bottle	$####.##	$####.##
Milk Lactose Free	3	5 Gallon	$####.##	$####.##
Milk Lactose Free	.5	1 Gallon	$####.##	$####.##

Total Estimated Amount on Hand

9-1 Gallons (Storage Location 1)

2-5 Gallons (Storage Location 2)

Storage Location

Status

Action Type

Date

Details

Status

Date

Action

Storage Location

Total Estimated Amount on Hand

Upcoming

05/01/2020

Receiving

Storage Location 2 (2-5 Gallons)

2-5 Gallon : 9-1 Gallon

Completed

04/06/2020 (Breakfast)

Reduction

Storage Location 2 (2-5 Gallons)

1-5 Gallon : 9-1 Gallon

Where Used	Amount
Muffin Blueberry Hmd(W/S 2019 Menu)	2 Cups (500g)
HT Milk 2% f/Bulk (Fluid Substitute)	4 fl oz (125g)
Milk 2% f/bulk (W/S 2019 Menu)	3/4 Gallon (3kg)
Milk with Beneprotein (Personal Menu - Victoria Trash)	4 fl oz (125g)

Completed

04/06/2020

Adjustment

Storage Location 2 (1-5 Gallons)

1-5 Gallon : 15-1 Gallon

Completed

04/04/2020

Adjustment

Storage Location 2 (1-5 Gallons)

1-5 Gallon : 15-1 Gallon

Type	Adjusted By	Reason	Amount
New Baseline	Username	Milk was spoiled, had to buy more at Walmart	15-1 Gallon

Completed

04/04/2020

Requisition List

Storage Location 2 ()

18-1 Gallon

Completed

04/02/2020

Recieving

Storage Location 1 (18-1 Gallon)

1-5 Gallon : 18-1 Gallon

Completed

04/01/2020 (Dinner)

Reduction

Storage Location 1 (5-1 Gallon)

1-5 Gallon

Completed

03/18/2020 (Lunch)

Reduction

Storage Location 1 (5-1 Gallon)

1-5 Gallon : 5-1 Gallon

Completed

03/26/2020

Receiving

Storage Location 2 (1-5 Gallons)

1-5 Gallon : 8-1 Gallon

PO #	Vendor	Product ID	Received By	Amount	Description
124568	Sysco Central	12803	Username	1-5 Gallon	Milk 2% Carton

Completed

03/26/2020

Requisition List

Storage Location 1 ()

1-5 Gallon : 8-1 Gallon

Requisition List Name	Location	Fulfilled By	Amount
Name	Nurses Station West	Username	1-5 Gallon

Completed

02/26/2020

Physical Inventory

Storage Location 2 (1-5 Gallons)

1-5 Gallon : 8-1 Gallon

Completed

02/26/2020

Physical Inventory

Storage Location 1 (8-1 Gallons)

1-5 Gallon : 8-1 Gallon

Inventory Worsheet Name	Closed By	Amount
Name	Username	8-1 Gallon

Nutrition Facts
Serving Size		(100g)
Amount Per Serving
Calories		200
% Daily Value*
Total Fat14g		22%
	Saturated Fat 9g	22%
	Trans Fat 0g
Cholesterol 55mg		18%
Sodium 40mg		2%
Total Carbohydrate 17g		6%
	Dietary Fiber 1g	4%
	Sugars 14g
Protein 3g

Recipe Name22	Recipe Box	Category	Owner
Recipe Name	Poultry	Main	MealSuite
Recipe Name	Main	Main	Sysco
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Poultry	Main	MealSuite
Recipe Name	Main	Main	Sysco
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Poultry	Main	MealSuite
Recipe Name	Main	Main	Sysco
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Poultry	Main	MealSuite
Recipe Name	Main	Main	Sysco
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Poultry	Main	MealSuite
Recipe Name	Main	Main	Sysco
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Poultry	Main	MealSuite
Recipe Name	Main	Main	Sysco
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Poultry	Main	MealSuite
Recipe Name	Main	Main	Sysco
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Poultry	Main	MealSuite
Recipe Name	Main	Main	Sysco
Recipe Name	Dessert	Category	Facility/Name
Recipe Name	Dessert	Category	Facility/Name

Menu Name	Type	Week	Day	Meal	Owner
Menu Name	Standard	1	Sunday	Dinner	MealSuite
Menu Name	Snack	2	Friday	AM	Sysco
Menu Name	Holiday	-	-	Lunch	Facility Name
Menu Name	Liquid	1	Monday	Breakfast	Facility Name
Menu Name	Standard	1	Sunday	Dinner	MealSuite
Menu Name	Snack	2	Friday	AM	Sysco
Menu Name	Holiday	-	-	Lunch	Facility Name
Menu Name	Liquid	1	Monday	Breakfast	Facility Name
Menu Name	Standard	1	Sunday	Dinner	MealSuite
Menu Name	Snack	2	Friday	AM	Sysco
Menu Name	Holiday	-	-	Lunch	Facility Name
Menu Name	Liquid	1	Monday	Breakfast	Facility Name

Person Name	Type	Day	Meal	Facility
Patient Name	Extra	Sunday	Dinner	Name
Patient Name	Substitute	Friday	AM	Name
Patient Name	Substitute	All	Lunch	Name
Patient Name	Liquid	Monday	Breakfast	Name
Patient Name	Extra	Sunday	Dinner	Name
Patient Name	Substitute	Friday	AM	Name
Patient Name	Substitute	All	Lunch	Name
Patient Name	Liquid	Monday	Breakfast	Name
Patient Name	Extra	Sunday	Dinner	Name
Patient Name	Substitute	Friday	AM	Name
Patient Name	Substitute	All	Lunch	Name
Patient Name	Liquid	Monday	Breakfast	Name
Patient Name	Extra	Sunday	Dinner	Name
Patient Name	Substitute	Friday	AM	Name
Patient Name	Substitute	All	Lunch	Name
Patient Name	Liquid	Monday	Breakfast	Name

	Product Description (vendor) Pack size"	Link
Vendor Prouct Name		$1.14
Vendor Prouct Name		$1.61
Vendor Prouct Name		$1.10
Vendor Prouct Name		$1.76