Inventory Quiz 11

To find sales revenue collected for food items by store by day requires which tables?

Question options:

CustomerBill

CustomerBill, CustomerPayment

CustomerBill, CustomerBillItem, CustomerPayment

CustomerBill, CustomerBillItem, CustomerPayment, FoodItem

Sales revenue billed for food and beverage is in Subtotal from CustomerBill.

CustomerPayment is required to determine whether the revenue was collected.

Suppose two queries are available as follows:

1. soldByFoodByStore contains StoreID, FoodID, and SumOfQuantity from CustomerBillItem
2. wasteFoodByStore contains StoreID, FoodID, and SumOfQuantity from FoodWaste.

To sum food quantities sold and food quantities wasted, how should the queries be joined?

Question options:

join (inner) soldByFoodByStore and wasteFoodByStore on StoreID; join (inner) outer soldByFoodByStore and wasteFoodByStore on FoodID

join (inner) soldByFoodByStore and wasteFoodByStore on StoreID; join (left) outer soldByFoodByStore and wasteFoodByStore on FoodID

join (left outer) soldByFoodByStore and wasteFoodByStore on StoreID; join (inner) outer soldByFoodByStore and wasteFoodByStore on FoodID

join (left outer) soldByFoodByStore and wasteFoodByStore on StoreID;join (left) outer soldByFoodByStore and wasteFoodByStore on FoodID

Left outer joins are needed for both joins to ensure that all the food items are included.

Because all food items have been sold but not every food item has been wasted,

all rows from soldByFoodByStore should be included.

The best expression for at attribute representing the week that food is received so it can be matched with food already in inventory is:

Question options:

recWeek: Format(DateAdd("d",-2,[ReceivedTimestamp]),"yymmdd")

recWeek: Format(DateAdd("ww",-2,[ReceivedTimestamp]),"yymmdd")

recWeek: DateAdd("d",-2,(Format([ReceivedTimestamp],"yymmdd")))

recWeek2: DateAdd("ww",-2,(Format([ReceivedTimestamp],"yymmdd")))

The Format function must be executed on the result of having used DateAdd to subtract two days from

[ReceivedTimestamp]. Executing the Format function first returns a result like “4/23/2257”

instead of “130506”. The choices with “ww” would add or subtract weeks rather than days.

To determine shrinkage by week by store, (1) the Monday inventory counts were added to the Wednesday purchases received and converted to dollar costs, (2) counts of food items served were summed and converted to dollar costs, and (3) the sum of costs of food items served and in ending inventory (inventory on the next Monday) were subtracted from the costs of food available. The result of executing this query strategy gives:

Question options:

an accurate value for shrinkage from unknown causes

an overstated value for shrinkage from unknown causes

an understated value for shrinkage from unknown causes

an understated value for shrinkage from unknown causes depending on the circumstances

Because it does not include the costs from known causes of wasted food (recook, dropped, server, spoilage)

in the uses of food, the result will overstate the value for shrinkage from unknown causes.

Question 5

The functions needed to get the day of the week from timestamp values for food served and convert it to values for determining weekly usage are:

Question options:

Day and DateAdd

DateAdd and Weekday

DatePart and Weekday

DateAdd and DateSerial

Hide Feedback

The Weekday function returns the day of the week (Sunday = 1, Monday = 2, etc.), and the DateAdd function

returns a date to which days have been added or subtracted.

For example to reset a Friday date to the preceding Monday, use DateAdd("d",-4,[WasteTimestamp]).

Your assistant showed you a query result intended to calculate shrinkage by week by store by food item that had thousands of rows. You tell your assistant to:

Question options:

set criteria

fix attribute name errors

create an expression

reconfigure the joins

Hide Feedback

The number of rows should be the number of weeks times the number of stores times the

number of food items inventoried, which is much less than thousands.

Suppose each restaurant had a dashboard showing useful operating results. The most informative value for weekly shrinkage would be calculated at:

Question options:

6 am Mondays

10 am Mondays

noon Wednesdays

6 am Sundays

Hide Feedback

Because the data for a week are complete (beginning inventory, purchases, food items served,

wasted food items, and ending inventory) when the next inventory is taken on Monday morning,

the most informative value for weekly shrinkage would be calculated at 10 am Mondays,

after inventory has been counted.

Your assistant said that a query that subtracted the sum of food items served and food items wasted from the sum of an inventory plus items received was giving results only when an item had been wasted. You tell the assistant to use:

Question options:

a Group By function

an Nz function

a criterion

cell formatting

Hide Feedback

The query needs an Nz function for the wasted items to make null values for items not wasted to

be treated as zeroes in the computations.

Suppose the following queries are available to determine costs for food items:

1. In inventory on Mondays
2. Received from vendors on Wednesdays
3. Served to customers by day
4. Wasted by day

Before creating a query to subtract the sum of food items served to customers and food items wasted from the sum of food items in inventory and food items received from vendors, which of the following changes would not need to be made?

Question options:

apply the Nz function on the PhysicalCount attribute

format timestamps to a uniform year, month, day format

create an expression to set food items received to Mondays

group food items served to customers and wasted by week

Hide Feedback

The Nz function needs to be applied to the quantity of wasted food items, not to the PhysicalCount attribute.

Question 10

Formatting timestamps to a “yymmdd” format:

Question options:

allows values of long form date fields to be changed

prevents date fields from being used for grouping

allows date fields to be used for grouping by day

prevents date fields from being used in calculations

Hide Feedback

Because timestamps contain hours, minutes, and seconds, they cannot be used for grouping by day,

week, month, or year. Formatting timestamps to a “yymmdd” format allows grouping by day.

Bottom of Form