Solve on Excel and anwser the question: Evaluate the effectiveness of the current ordering system. Can it be improved?

Home Online Chapter 12: Inventory Control Models Internet Case Studies > Laplace Power and Light Laplace Power and Light Internet Case Study: Laplace Power and Light The Southeastern Division of Laplace Power and Light Company is responsible for providing dependable electric service to customers in and around the areas of Metairie, Kenner, Destrehan, Laplace, Lutcher, Hammond, Pontchatoula, Amite, and Bogalusa, Louisiana. One material used extensively to provide this service is the 1/0 AWG aluminum triplex cable, which delivers the electricity from the distribution pole to the meter loop on the house. The Southeastern Division storeroom purchases the cable that this division will use. For the coming year, this division will need 499,500 feet of this service cable. Since this cable is only used on routine service work, practically all of it is installed during the five normal work days. The current cost of this cable is 41.4 cents per foot. Under the present arrangement with the supplier, the Southeastern must take one-twelfth of its annual need every month. This agreement was reached in order to reduce lead tim nt was reached in order to reduce lead time by assuring Laplace a regular spot in the supplier's production sche Without this agreement, the lead time would be about twelve weeks. No quantity discounts are offered on this cable; however, the supplier requires that a minimum of 15,000 feet be on an order. The Southeastern storeroom has the space to store a maximum of 300,000 feet of 1/0 AWG aluminum service cable. Associated with each cable shipment are ordering costs of $50, which include all the costs from making the purchase requisition to issuing a check for payment. In addition, inventory carrying costs (including taxes) on all items in stores are considered to be ten percent of the purchase price per unit per year. Being a government-regulated, investor-owned utility, both the Louisiana Public Service Commission and its stockholders watch closely how effectively the company, including inventory management, is managed. Download Internet Case questions, or submit your answers to your instructor by using the form below. This activity contains 1 question. 1. Evaluate the effectiveness of the current ordering system. Can it be improved? Home Online Chapter 12: Inventory Control Models Internet Case Studies > Laplace Power and Light Laplace Power and Light Internet Case Study: Laplace Power and Light The Southeastern Division of Laplace Power and Light Company is responsible for providing dependable electric service to customers in and around the areas of Metairie, Kenner, Destrehan, Laplace, Lutcher, Hammond, Pontchatoula, Amite, and Bogalusa, Louisiana. One material used extensively to provide this service is the 1/0 AWG aluminum triplex cable, which delivers the electricity from the distribution pole to the meter loop on the house. The Southeastern Division storeroom purchases the cable that this division will use. For the coming year, this division will need 499,500 feet of this service cable. Since this cable is only used on routine service work, practically all of it is installed during the five normal work days. The current cost of this cable is 41.4 cents per foot. Under the present arrangement with the supplier, the Southeastern must take one-twelfth of its annual need every month. This agreement was reached in order to reduce lead tim nt was reached in order to reduce lead time by assuring Laplace a regular spot in the supplier's production sche Without this agreement, the lead time would be about twelve weeks. No quantity discounts are offered on this cable; however, the supplier requires that a minimum of 15,000 feet be on an order. The Southeastern storeroom has the space to store a maximum of 300,000 feet of 1/0 AWG aluminum service cable. Associated with each cable shipment are ordering costs of $50, which include all the costs from making the purchase requisition to issuing a check for payment. In addition, inventory carrying costs (including taxes) on all items in stores are considered to be ten percent of the purchase price per unit per year. Being a government-regulated, investor-owned utility, both the Louisiana Public Service Commission and its stockholders watch closely how effectively the company, including inventory management, is managed. Download Internet Case questions, or submit your answers to your instructor by using the form below. This activity contains 1 question. 1. Evaluate the effectiveness of the current ordering system. Can it be improved