$6-9!!!!!!!!!!!$

The purpose of the excess inventory report is to call management's attention to:

a$.$ obsolete inventory.

b$.$ all inventory items for which the on hand plus on order less committed stock is greater than the maximum stocking level.

c$.$ all inventory items for which the on hand plus on order less committed stock is greater than the safety stock plus the EOQ by a material dollar value.

d$.$ poor control over purchase orders.

The purpose of the inventory turnover report is to:

a$.$ reveal obsolete inventory.

b$.$ measure sales efficiency.

c$.$ show overstocked items.

d$.$ measure the effectiveness of the purchasing function.

Peachtree Distribution of Atlanta has just taken a physical inventory of frozen food on hand. Included in the inventory listing are the following counts:

$\backslash$table$[[$Item$,$Unit of Measure,Count$],[$Cut green beans,carton of $1$ dozen,$125],[$Spinach$,$carton of $1$ dozen,$55],[$NY strip steaks,package of $5,77]]$

A listing from the inventory records in the AIS shows the following:

$\backslash$table$[[$Item$,$Free stock ${?}^{**},$Committed,On Order,EOQ,Safety Stock$],[$Cut green beans,$73,60,85,85,30],[$Spinach$,10,45,17,25,15],[$NY strip steaks,$55,20,-0-,30,15]]$

On hand less committed

Required:

Calculate the number of units by which the inventory records should be adjusted for each of the products.

$7.$ Refer to the data in problem $6.$ If the lead$-$time stock is $30,12,$ and $40$ for beans, spinach, and steaks, respectively, what quantities need to be ordered?

$8.$ Alaskan Outfitters has $3$ warehouses and stocks $1,285$ products.

Required:

a$.$ How many inventory records will Alaskan have if it uses warehouse method one?

b$.$ How many will it have using method two?

c$.$ If its warehouses are widely distributed $($Juneau$,$ Anchorage, and Fairbanks$),$ what impact will this have on its choice of warehouse method chosen?

$9.$ Pensacola Grocery Wholesalers, which is open $5$ days a week, purchases groceries and other items in bulk and sells in small quantities to bait shops, marinas, and small food stores. Several stock items are listed below along with the unit of purchase, stocking unit, and unit of sale.

$\backslash$table$[[$Inventory ltem,Purchase Unit,Stocking Unit,Sales Unit$],[$Pasta Roni, $144g$ box,Case of $30$ boxes,Box,Box$],[$Heinz Dill Relish, $296ml$ jar,Case of $24$ jars,Case,Jar$],[$Van Camp's Pork & Beans, $425g$ can,Case of $24$ cans,Can,Can$]]$

Other information related to the items is:

$\backslash$table$[[$Inventory Item,$\backslash$table$[[$Weekly$],[$Sale Rate$]],\backslash$table$[[$On$],[$Order$]],\backslash$table$[[$On$],[$Hand$]],$Committed,$\backslash$table$[[$Reorder$],[$Pt$.]],$EOQ$],[$Pasta Roni,$400,110,0,5,300,12],[$Heinz Dill Relish,$300,10,15,0,10,15],[$VC$\text{'}$s Pork & Beans,$500,200,0,0,120,20]]$