Question: It is for prof forma financail statment, s o I was required to make the cost report out of this info, and the next person
It is for prof forma financail statment, so I was required to make the cost report out of this info, and the next person in our group will prepare will make the budgeting
This is the note from my part Technical requirements. Most of the time, a product or service will have technical requirements to ensure proper performance. Examples from IS projects include speed and capacity of database systems and connectivity with alternative systems.
This one is made by our group, they aske me to make the cost report, i dont know how to please help me
Technical requirements. Most of the time, a product or service will have technical requirements to ensure proper performance. Examples from IS projects include speed and capacity of database systems and connectivity with alternative systems.
| Omega Protein Corporation | |||
| EXHIBIT 1 Sources and Uses | |||
| Sources of funds | |||
| Reinvestment into the company | |||
| Omega Shipyard, Inc (shared 50/50) | 2,757,672 | ||
| Omega Protein, Inc (shared 50/50) | 2,757,672 | ||
| Total | 5,515,344 | ||
| Financing | |||
| Commercial Fleet Retail Loan | 1,200,000 | ||
| Total | 1,200,000 | ||
| Total Sources | 6,715,344 | ||
| Uses of funds | |||
| Identification of Personnel Needed | |||
| Salaries | |||
| Truck Drivers - $27/hr - 20/day @ 30 day/mo | 129,600 | ||
| Logisitics/Scheduling Coordinator $14/8hr shift - 7/day @ 30 day/mo | 23,520 | ||
| Dispatcher $12/8hr shift - 7/day @ 30 day/mo | 20,160 | ||
| Data Management Supervisor $18/8hr shift - 7/day @ 30 day/mo | 30,240 | ||
| Manager $32/8hr shift - 7/day @ 22day/mo | 39,424 | ||
| Total | 242,944 | ||
| Technical Requirements | |||
| Wi-Fi equipment | 2,000 | ||
| Mobile iPads for ERP entry | 3,500 | ||
| Computers | 75,000 | ||
| Server/Cloud Backup | 325,000 | ||
| ERP Software | 1,300,000 | https://www.epromis.net/products/epromis-enterprise/ | |
| Telephones | 450 | ||
| CB Radios | 10,000 | ||
| Total | 1,715,950 | ||
| Materials and Equipment Needed | |||
| Repairs and Maintenance (1) | 71,000 | http://www.automotive-fleet.com/channel/operations/article/story/2002/09/how-to-justify-a-fleet-budget-in-tight-times.aspx | |
| Oil Changes $180/truck @20/mo | 43,200 | ||
| Gasoline (2) | 1,690,000 | http://www.automotive-fleet.com/channel/fuel-management/article/story/2014/11/forecast-of-operating-costs-in-the-2015-calendar-year.aspx | |
| Tires $450/tire @18 tires/truck; as needed semi-annually | 324,000 | ||
| Accident and Collision Expenses (3) | 50,000 | http://www.fleetfinancials.com/article/story/2015/09/steps-to-developing-and-controlling-a-fleet-budget.aspx | |
| Total | 2,178,200 | ||
| Start-up expenses | 2,578,250 | ||
| Working capital (cash) (4) | |||
| Total uses | 6,715,344 | ||
| (1) It is estimated that 7.1% of purchase cost to cover repairs and maintenance of fleet | 0 | ||
| (2) It is estimated that diesel is $3.38 per gallon and each truck has a capacity of 250 gallons. Based on industry average, trucks can travel 1500 before the next fill up, therefore 100 fill ups/yr/truck. | https://answers.yahoo.com/question/index?qid=20121225082948AAg6yIA | ||
| (3) It is estimated that 5% of purchase cost to cover accident and collision expenses | |||
| (4) To cover negative cash flow over 2 year of operation as well as contingency fund. See pro forma cash flow statements. | |||
| EXHIBIT 2 Start-Up Expenses | |||
| Operation/distribution consulting (1) | 5,000 | ||
| Miscellaneous consulting (legal, permitting, etc.) | |||
| Licenses/Permits $500/truck | 10,000 | ||
| Accounting | 1,000 | ||
| Legal | 1,500 | ||
| Other | 750 | ||
| Total | 13,250 | ||
| Annual Insurance Cost (2) | |||
| Commercial Property and Casualty Insurance 5,000,000 | 35,000 | ||
| General Liability 5,000,000 | 35,000 | ||
| Lost Income Coverage 3,000,000 | 21,000 | ||
| Product Liability 500,000 | 3,500 | ||
| Umbrella Rider for 1,000,000 | 7,000 | ||
| Disability Insurance 1,000,000 | 7,000 | ||
| Total | 108,500 | ||
| Fleet Purchases | |||
| Trucks $50,000/truck @20 trucks | 1,000,000 | http://www.commercialtrucktrader.com/Peterbilt-587-For-Sale/search-results?make=PETERBILT|2313546&model=587|764868192 | |
| Refrigerated trailers $72,500 @ 20 trailers | 1,450,000 | http://www.commercialtrucktrader.com/Trailer-Trailer-For-Sale/search-results?type=trailer&page=2 | |
| Total | 2,450,000 | ||
| Pre-start-up utilities and miscellaneous supplies | |||
| Office supplies | 500 | ||
| Other permitting fees | 1,000 | ||
| Total | 1,500 | ||
| 2,578,250 | |||
| (1) Distribution Management Consultant @ 1 month for training on ERP Software and logistics | |||
| (2) $1mm bond rider cost at $7000/bond | |||
| EXHIBIT 3 Capital Equipment List | |||
| Technical Requirements | |||
| Wi-Fi equipment | 2,000 | ||
| Mobile iPads for ERP entry | 3,500 | ||
| Computers | 75,000 | ||
| Server/Cloud Backup | 325,000 | ||
| ERP Software | 1,300,000 | ||
| Telephones | 450 | ||
| CB Radios | 10,000 | ||
| Total | 1,715,950 | ||
| Fleet Purchases | |||
| Trucks $50,000/truck @20 trucks | 1,000,000 | ||
| Refrigerated trailers $72,500 @ 20 trailers | 1,450,000 | ||
| Total | 2,450,000 | ||
| 4,165,950 | |||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
