Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Economy

05/09/2020 Client: happyw Deadline: 24 Hours

  Exercise #1: Big or Small?


A manufacturer is considering two investment programs to supply a new laptop. Market research anticipates rapid market growth: sales are expected to be 300, 000 the first year, 600,000 the second, and 900,000 the third. However, the company recognizes that actual sales may differ by plus or minus 50%.


The company has two plans to produce 900,000 units:


· Plan A: Build a single plant that could produce 900,000 units. Construction would cost $900 million and be finished in a year. The company would net $2,000 per computer sold, and the incremental manufacturing costs beyond the capital cost of the plant is expected to be $1,280 per computer.


· Plan B: Build three 300,000-unit plants, one each year, to match expected annual demand. The capital expenditure for each small plant is $300 million. The smaller plant has a unit manufacturing cost of $1,500. This plan gives the company the flexibility not to build successive plants if the demand falls short in the first or second year.


Note that both plans have drawbacks:


· Plan A involves a large amount of excess capacity in the first two years until market demand grows; and there is always a chance that demand falls short of expectations. Thus, the demand in year 3 might be as high as 1.35 million or as low as 450 thousand units.


· Plan B is less efficient. Also, if the demand grows faster than expected, it cannot take advantage of it.


The CFO asks you to prepare spreadsheets to analyze this decision. As the company will want to carry out extensive sensitivity analyses on the spreadsheet, all the input variables must be set in an input sheet, so that the rest of the spreadsheet will be an automated black-box that generates the required results.


  


Part 1: Based on the forecast demand expectation without variability, set up a spreadsheet to calculate the net present values (NPVs) for Plan A, and Plan B with an inflexible expansion plan (build one plant each year regardless of market demand). Based on this first analysis, which plan is better? See end of exercise for assumptions you should use for the NPV analysis.


Part 2: Now consider the effect of uncertainty in discount rate for small and big plant. Use “Data Table” in What-if Analysis to estimate profitability of plan A over plan B in a one-way (only change discount rate of one plant at a time) and two-way (change discount rate of both plants simultaneously). Draw a chart to illustrate the changes. Also use “Conditional Formatting” to color code when the sign of the difference of profitability of plans changes.


Part 3: Now consider the effect of uncertainty for variable costs of both plants and run another two-way sensitivity analysis using “Data Table” function. Draw a chart to illustrate the changes. Also use “Conditional Formatting” to color code when the sign of the difference of profitability of plans changes.


Part 4: Now consider the effect of uncertain market demand. Assuming that the market forecast is evenly distributed over the range, simulate the performance of Plan A, and Plan B without the flexibility. Use a two-way sensitivity analysis for 1st year demand vs 2nd years demand and another two-way sensitivity analysis for 2nd year demand vs 3rd year demand using “Data Table” function.


Note: In future assignments, I will ask you to conduct more sophisticated analysis on this same problem.


Assumptions for NPV analysis:


· Use a discount rate of 9% for Plan A, and 8% for Plan B.


· No salvage value for Plan A at year 3. Salvage value for Plan B is $300 million at year 3.


· No corporate overhead or selling costs allocated to the projects.


· For simplicity, assume that a new laptop line will replace the product in the 4th year so that there will be no sales in year 4 and beyond.


    

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Homework Tutor
Writer Writer Name Offer Chat
Homework Tutor

ONLINE

Homework Tutor

Hello client, I have gone through the project specifications you have provided and I can easily manage the task. I am an experienced writer with diverse Knowledge in Article writing and Rewriting, Dissertations & Thesis writing, reports, case studies, and Literature Review.

$35 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Sales account consultant topgolf salary - Factorytalk linx opc ua connector - Paper writing - A solid non metal - Physiotherapy multiple choice questions - Ict a level syllabus 2017 - Hoselink manual hose reel - Daphnia magna heart rate lab report - 2-3pg. Critical response paper on The Odyssey, Translated by Robert Fitzgerald. ----Due 4pm 8/24/2020 - How does picasso's guitar depart from traditional sculptures - Independent variable for bacterial growth - Secondary sector definition geography - Alka seltzer surface area experiment - Agritone 750 safety data sheet - Compute stefani's total standard cost per unit - Pathophysiology - Ch3cooh h2o balanced equation - Expository writing rutgers - Starwood hotels and resorts worldwide inc 2007 case study - Glencoe accounting 10 9 answers - A sales invoice included the following information merchandise price - Which of the following best defines what a provider referral is? - Discussion - Grasslin time clock wiring diagram - The practice of BYOD by organizations creates many risks since users are accessing organizational networks with personal devices. - Dr hiromi shinya kangen water - Excel chapter 4 grader project mountain view realty - Relation to cloud computing - PHd Isaac Newton - Stanley tookie williams documentary - Inductive arguments aim for this type of connection between their premises and conclusions. - Ted talks the hidden power of smiling - Newtown an american tragedy pdf - North hinksey parish council - Popular magazines rank colleges and universities on their academic quality - Nppa tt pt fn - Super saiyan workout plan - C.s. lewis company had the following transactions involving notes payable. - Playstation 4 error ws 37269 7 - Peer Review - 300 Word Discussion - When did kfc change its name - How to find the radius of two concentric circles - Social studies - Az 900 pdf download - What is the method of joints - Powder by tobias wolff literary devices - EMERGING WEEK 1 DQ - Revalorism - Prince sports inc case study - 14 page essay on Efficiency Wage Theory - Moonee valley council bin collection - Types of sickle scalers - Tesla strategic business units - CRIMINAL JUSTICE - Completing Business Messages and Crafting Messages for Digital Channels - Neeraj kanwar net worth - Describe the city of omelas - Discussion Post ALS3153 - Band booster class java - What is haemoglobin (and what is its function) - Is collateral beauty on redbox - I need help in writing a paper on REFLECTION IN PRACTICE: MENTAL MODELS? FULL DETAILS, Sample, & RUBRIC is ATTAched - A business evaluates a proposed venture as follows - The glass cage nicholas carr chapter summary - Beauty and the beast archetypes - Four seasons hotel financial statements - Sapir whorf hypothesis examples ppt - Midland energy resources - Graphic design final exam - Blue cloud gets agile case study - What is the relationship between population increases and climate change? - India pattern brown bess - Chart - Pepsico change management case study - Essays guru only - The janabi family - Employee training and development raymond noe 6th edition - Surfers paradise outrigger canoe club - Generation me twenge chapter summary - Four seasons hotel financial statements - Amoeba sisters video recap asexual and sexual reproduction - Edmonton japanese community association - Business Law - Climate change - Orange crush steven cannon lyrics - What did jonathon delonge invent in 1938 - The great atomic power - Mirco78 - Statistics for Business - Wk 3 - Lunch and Learn - Pronoun antecedent agreement exercises - Weekly English Work - Journal article Sensation and Perception - Hyperphysics phy astr gsu - Benchmark - Organizational Design, Structure, and Change Presentation - What Advice Would You Give to Executives About AI? - Sticks and stones and other student essays 8th edition - Grass singular or plural - Wheel and axle ima