Carmen is the manager of an office furniture company, Instead of producing all the office furniture items itself, her company imports prepackaged office furniture. For individual customers, the company assembles the items ordered and ships them to the client with a markup.

The company also sells its prepackaged units to retailers like Office Depot in flat packages. For these retail sales, the company has to ensure that the correct pieces are in the prepackaged units. It also needs to provide assembly instructions and the assembly kit $($e$.$g$.,$ nails, screws, washers, bolts, and nuts$).$ One of Carmen's jobs is to monitor the costs of these prepackaged units. She also manages the inventory levels of both the furniture items and the installation kits. She collected the following data sets for the top five most popular items.

Furniture Company Kit data set. Product$\_$ID is the product identifier. Each product has an assembly kit based on the ID number. To ensure that the company always has the correct assembly kit available, it generally keeps about $400$ backup kits for each product in its warehouse. That is$,$ the supplier is supposed to include an assembly kit in the prepackaged unit. In case the supplier forgets to include the kit, the company can always put the correct one in the package. This safety stock amount $(400$ units$)$ is determined based on information the company collected about three years ago.

Furniture Company Sales data set. Sales$\_$ID is the number that identifies each sales transaction on a specific date $($invoice$\_$date$).$ The sale is handled by a specific employee $($employee$\_$ID$)$ for a specific customer $($customer$\_$ID$).$ Customer number $999$ is assigned to all individual consumers $($the company only assigns a specific customer number to each business client$).$ The data also shows the product sold $($product$\_$ID$)$ and the quantity sold on that date $($Q$\_$sold$).$

Furniture Company PO data set. This file shows all the purchase orders $($PO$\_$num$)$ on a specific date $($PO$\_$date$).$ The purchase is for a specific product $($product$\_$ID$)$ from a vendor $($vendor$\_$ID$).$ It also shows total quantity ordered $($Q$\_$ordered$).$

Furniture Company Product Search data set. Carmen asked the webmaster of the company's shopping website to tell her the number of searches for a product during the month when the sales occur. She wants to get a sense of the popularity of each

Carmen wants to evaluate whether the current safety stock inventory level of $400$ assembly $($installation$)$ kits is still an appropriate level. She used the Furniture Company Sales data set to create the following visualization.

Product ID

Invoice Data, January

Use the Furniture Company Sales and Product Search data sets available in Wiley Course Resources to answer the following

Use the Furniture Company Sales and Product Search data sets available in Wiley Course Resources to answer the following questions.

Use Furniture Company Kit data set available in Wiley Course Resources and the above visualization to answerthe following questions.

Click here to view Furniture Company Sales data

Click here to view Furniture Company Product Search data

$($a$)$

According to the visualization, does the company regularly sell more than $400$ units of any product?