10- An Investor has decided to build an IV solution factory. The assumptions for this project are as follow: Acquire 10.

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

10- An Investor has decided to build an IV solution factory. The assumptions for this project are as follow: Acquire 10.

Post by answerhappygod »

10 An Investor Has Decided To Build An Iv Solution Factory The Assumptions For This Project Are As Follow Acquire 10 1
10 An Investor Has Decided To Build An Iv Solution Factory The Assumptions For This Project Are As Follow Acquire 10 1 (55.25 KiB) Viewed 16 times
Using excel please
Thank you in advance
10- An Investor has decided to build an IV solution factory. The assumptions for this project are as follow: Acquire 10.000 m² of land for $30/m² The registration of the land costs 6% of the land price Build 2000 m² for $800/m² Build a warehouse of 2000 m² for $300/m² Build offices for 250 m² at the cost of $500/m² Engineering fees are for 12% of the total built area Furniture is estimated to be 20 units for $2000 each, Equipment for production line estimated at $4.000.000 4 vehicles are needed for $30.000 each IT system for $30.000 A generator for $80.000 is needed Human resources needed are as follows: Number Monthly Salary 3,000 1,000 Managers Stock Keeper Purchasing Pharmacist 1,000 1,500 800 Technicians (sterilzation + production) Warehouseman 500 Drivers 4 500 The social insurance for employees is 21.5% Yearly production of 6.000.000 units. The selling price is $1 per unit Yearly inflation rate is 10%, affecting only expenses Depreciation rates are: 2.5% for building, 20% for furniture, vehicles, generator & IT, and 15% for the equipment line Using Excel, Make the Income Statement for the 7 coming years. Make the related graph. 4 1 1 1 6 3
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply