Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Carmen is the manager of an office furniture company. Instead of producing all the office furniture items itself, her company imports prepackaged office furniture.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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 product. 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. 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. Invoice Data, January Product ID 648 600 494 515 551 581 547 557 572 588 474 480 500 530 482 459 452 596 1 Q Sold 400-494 527 474 425 459 482 480 418 413 381 423 441 356 372 200 0 Product ID 2 600- Q Sold 400- 617 545 627 504 515 537 593 604 584 600 540 550 554 547 494 441 436 461 445 507 486 511 499 523 488 438 464 459 439 441 343 200- 0- Product ID 679 618 600- 547 562 608 516 540 592 581 493 513 525 522 529 477 608 3 Q Sold 400-473 509 514 527 523 554 463 497 450 455 401 428 415 432 351 200 Product ID 654 602 618 600- 570 557 564 559 557 528 504 524 608 485 456 544 549 560 4 Q Sold 400- 491 513 535 494 463 466 436 457 469 428 449 455 468 432 200- 0 613 Product ID 651 658 564 561 557 531 600-660 538 512 515 497 518 508 507 466 551 5 QSold 400- 522 485 504 496 468 489 472 420 433 409 418 410 358 364 200- 0 12345678 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 According to the visualization, does the company regularly sell more than 400 units of any product? Should Carmen increase, decrease, or not change the number of backup assembly (installation) kits in the warehouse?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Floyd A. Beams, Joseph H. Anthony, Bruce Bettinghaus, Kenneth Smith

11th Edition

978-0132568968, 9780132568968

More Books

Students also viewed these Accounting questions