calculate the payback period considering the initial investment in hardware and software using excel

Jack Bracket, the CEO of Bracket International (BI), has grown his business to sales last year of $78 million, with a cost of goods sold of $61 million. Average inventory levels are about $14 million. As a small manufacturer of steel shelving and brackets, the firm operates three small factories in Ohio, Kentucky, and South Carolina. Bl's number one competitive priority is "service first," while high product quality and low cost are the number two and three priorities. Service at Bl includes preproduction services such as customized engineering design, production services such as meeting customer promise dates and being flexible to customer-driven changes, and postproduction services such as shipping, distribution, and field service, The Ohio and Kentucky factories are automated flow shops, whereas the South Carolina factory specializes in small custom orders and is more of a batch-processing job shop. All three factories use bar coding labels and scanning equipment to monitor and control the flow of materials. Bl manually scans about 9,850 items per day at all three factories. An item may be an individual part, a roll of sheet steel, a box of 1,000 rivets, a pallet load of brackets, a box of quart oil cans, a finished shelf or bracket set ready for shipment, and so on. That is, whatever a bar code label can be stuck on is bar coded. A factory year consists of 260 days. One full-time Bl employee works 2,000 hours per year with an average salary including benefits of $69,000