Supply Chain Emergency Assignment
Background
Your team is the operations planning group for supply chain operations for CPG North America (CPGNA). Your company is owned by a very large multinational firm that recently acquired another company with a well-known set of brands and has placed those brands under CPGNA planning and control. Along with those brands came two manufacturing facilities, one located in Los Angeles, CA and the other in Wilmington, NC, and two large distribution centers located on the premises of the two plants.
The rest of the CPGNA supply chain network consists of three other plants with their own DCs, which act as regional DCs for the Big Girl Hair® product line. One is in Stamford, CT, another is in Kansas City, MO, and the third is in San Francisco, CA (that plant does not have a manufacturing facility associated with it). The Wilmington NC distribution center is the central DC. It does not ship directly to customers. It only ships to the regional DCs.
One of the product lines inherited by your company is a very popular hair spray line called Big Girl Hair ® that has 6 SKUs: 7oz. Big Hair pump spray, 12 oz. Big Hair pump spray, 7 oz. Scary Big Hair pump spray, 12 oz. Scary Big Hair pump spray, 7 oz. Ludicrously Big Hair pump spray, and 12 oz. Ludicrously Big Hair pump spray. These six SKUs are being produced in the LA and Wilmington plants and distributed from their DCs.
Although these are all good sellers, they have been losing market share to your main competitor, BIGHAIRCO, which has recently launched a product line of pump hair sprays under the brand Lollypophead ®. Your marketing department has gotten nervous (they do that) and decided to relaunch the Big Girl Hair ® line of products. Normally that would not be a big deal. You would just plan ahead, produce product to a forecast while you are selling out all the old product, and ship the new product on the ship-to-trade date. Sure there will be some problems because the forecasts will be wrong, but it should not be that big a transition- your company does it all the time.
But this time the geniuses at the company that owns CPGNA have decided to save some money. The way they plan to do that is two-fold. First, they are shutting down the LA plant and DC since the plant in Wilmington produces the same products as LA does and there is already a DC in California. Secondly, to take advantage of a tax break U.S. companies get for making products in Puerto Rico and shipping them into the U.S., the parent company has directed CPGNA to just mold and label the bottles in Wilmington, send them to San Juan, have the San Juan plant fill and package the bottles and send them to Wilmington, which will serve as a central DC for these products and send inventory to the other DCs as determined by the DRP system.
No problem. Your excellent operations planners have laid out a schedule for blow molding and labeling the bottles, sending them to San Juan for filling, and shipping them to Wilmington, as well as shipment schedules from Wilmington to the other DCs, leaving plenty of time to meet the ship-to-trade date.
Problem Statement:
Today’s date is October 31, 2022. The ship-to-trade date is January 1, 2023. Your Wilmington plant has been producing bottles for two months, but in order to save shipping costs they have been sending carloads of bottles by rail to Miami, where they have been stored in a warehouse that is not air-conditioned, until there are enough bottles to fill twenty containers. This gives the company a good shipping discount from the container ship company. The bottles were finally shipped to Puerto Rico. Upon receipt of the containers it was quickly discovered that not any of the bottles could be used. The bottles are very hot when they come off the blow molder, and are reheated when the labels are applied. To save money the bottles were not hand-packed, but instead were allowed to fall off the end of the line, while still very hot, into a box that was then sealed and palletized. The labels have a wax base, and if not allowed to cool, or at least hand packed using cardboard between the bottles, the bottles will rub against each other. That was not a problem when they stayed in the same location for filling, but a combination of the rail trip, a hot warehouse, and the ocean voyage all conspired to ruin every single bottle that was shipped.
You now must figure out how to make the ship-to-trade date and keep both your customers and your senior management happy. Somehow YOU will be blamed if the ship-to-trade date is not met.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme