- Joined
- Jan 25, 2010
- Messages
- 30,736
- Reaction score
- 15,052
- Gender
- Undisclosed
- Political Leaning
- Undisclosed
To a certain degree and size yes
My previous company (which produced the equivalent 650 000 2 x 2.5 USG cases of a variety of different products in a year) ran a lot of the business off Excel
Supply Chain was the most significant, but production records, analytical records, work sheets for the production dept were all done using excel
Inventory, was done in both excel and Adage (an older smaller ERP system) Accounting was done in the ERP
Eventually the company moved to Oracle for an ERP system, which the implementation was done very poorly) It was supposed to handle Supply chain, production demand, store of all production and analytical records, accounting and inventory. For the Canadian side of the business, we used Oracle for inventory and accounting only. The US side spent hundreds of thousands if not millions of dollars trying to get the supply chain and production demand parts of it working. After I believe 5 years they got it to at least potentially work
Now the company I was at is a multinational company with sales of approx $1.6 billion. The Can operations were around $100 million, the US approx $600 million.
Overall trying to get Oracle ERP up and running probably cost the company $10 million dollars and a significant amount of wasted labor hours
So for a small business with limited IT skills yes i would run a business off excel and ensure I had the right and required data being fed into it. It might take longer, and require double inputs but it can work for a business at a single location. It should not be shared or used for multiple locations so a "One Company One system" will not work with excell
My previous company (which produced the equivalent 650 000 2 x 2.5 USG cases of a variety of different products in a year) ran a lot of the business off Excel
Supply Chain was the most significant, but production records, analytical records, work sheets for the production dept were all done using excel
Inventory, was done in both excel and Adage (an older smaller ERP system) Accounting was done in the ERP
Eventually the company moved to Oracle for an ERP system, which the implementation was done very poorly) It was supposed to handle Supply chain, production demand, store of all production and analytical records, accounting and inventory. For the Canadian side of the business, we used Oracle for inventory and accounting only. The US side spent hundreds of thousands if not millions of dollars trying to get the supply chain and production demand parts of it working. After I believe 5 years they got it to at least potentially work
Now the company I was at is a multinational company with sales of approx $1.6 billion. The Can operations were around $100 million, the US approx $600 million.
Overall trying to get Oracle ERP up and running probably cost the company $10 million dollars and a significant amount of wasted labor hours
So for a small business with limited IT skills yes i would run a business off excel and ensure I had the right and required data being fed into it. It might take longer, and require double inputs but it can work for a business at a single location. It should not be shared or used for multiple locations so a "One Company One system" will not work with excell