Practice project 1.1 Use the attached Excel Spreadsheet to complete.
Industrial Automation of Corellia is interested in developing a new line of droids. However, with the Imperial Senate in disarray, IAC has to make decisions as to which droid best suits its needs. They have asked you, as a newly minted project manager, to make the decision for them. You only have $100 billion to invest in these projects, so choose wisely.
Below are the selection criteria for each project along with the scores for each criterion and the costs of each project.
R2-Series Astromech—This droid is an all-purpose unit that can be programmed to fill a variety of roles. They are approximately 3 feet high and weigh just under 1,500 pounds.
Cost of development: $80 billion
Potential ROI: 185%
Customer Relations: 7
New Products: 5
Supplier Relations: 3
Positive ROI: 4
2-1B Surgical Droid—Humanoid in appearance, all 2-1B series droids were equipped with encyclopedic memory banks. Their memory banks and modular limbs helped ensure that the droids gave the best course of medical treatment in any given medical situation.
Cost of development: $95 billion
Potential ROI: 85%
Customer Relations: 6
New Products: 10
Supplier Relations: 5
Positive ROI: 3DTS-Series Dismantler Droid—Just as the name suggests, these droids can take apart just about anything. They are cheap and easy to assemble, so they can be built in great quantities. Additionally, they can be programmed to attack incoming vessels, so are useful in battle.
Cost of development: $30 billion
Potential ROI: 25%
Customer Relations: 2
New Products: 5
Supplier Relations: 3
Positive ROI: 2
GNK-Series Power Droid—Also known as Gonks, these droids are essentially walking batteries. Programmed in simple Binary, they are cheap and easy to repair, making them popular with everyone from moisture farmers on Tatooine to Tie Mechanics on space stations.
Cost of development: $15 billion
Potential ROI: 205%
Customer Relations: 6
New Products: 1
Supplier Relations: 10
Positive ROI: 1
Practice project 1.2
Create an Excel spreadsheet to complete the assignment.
Your team at Corellian Engineering has $1 billion to invest in new product development. This time, management has decided to invest in freighters with FTL Hyperdrives, so they have narrowed the selection down to two projects as described below. Your task is to calculate the Payback period and Rate of Return. Management will only accept a project if it has a payback period of fewer than 5 years AND the rate of return is at least 15%.
YT-1300
This freighter is capable of making the Kessel Run in less than 12 parsecs, in the right hands. It has multiple sensor-proof cargo holds, dual phase cannons, and inertial dampeners to cushion the 3,000 Gs suffered from ludicrously fast speeds. The financials are as follows:
Initial Investment: $700,000,000
Estimated Annual Sales: $225,000,000
____________________________________________________________________________________
VCX-100 light freighter
This has sleeping quarters and perhaps even a kitchen. It is also outfitted with a magnetic cargo clamp on its ventral plating, capable of holding several bulk containers. The cargo bay and main entrance ramp of the VCX-100 is located in the front of the freighter, making loading and unloading easier.
The financials are as follows:
Initial Investment: $400,000,000
Estimated Annual Sales: $110,000,00
project Deliverables:
Page 1. Cover page with your name, the class name, and Lynn University
Page 2. One-page executive summary where you tell me which projects to back and why.
Page 3. Appendix where you copy and past your tables.
Table 1. Selection Matrix
Table 2. Payback Period
Table 3. NPV Model
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER
Why Choose Us?
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee

How It Works
- Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the “PAPER DETAILS” section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
About AcademicWritersBay.com
AcademicWritersBay.com is an easy-to-use and reliable service that is ready to assist you with your papers 24/7/ 365days a year. 99% of our customers are happy with their papers. Our team is efficient and will always tackle your essay needs comprehensively assuring you of excellent results. Feel free to ask them anything concerning your essay demands or Order.
AcademicWritersBay.com is a private company that offers academic support and assistance to students at all levels. Our mission is to provide proficient and high quality academic services to our highly esteemed clients. AcademicWritersBay.com is equipped with competent and proficient writers to tackle all types of your academic needs, and provide you with excellent results. Most of our writers are holders of master’s degrees or PhDs, which is an surety of excellent results to our clients. We provide assistance to students all over the world.
We provide high quality term papers, research papers, essays, proposals, theses and many others. At AcademicWritersBay.com, you can be sure of excellent grades in your assignments and final exams.