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

Noneffective Communication - Not till then how much i owe - Nets - Are there as many stars as grains of sand - Why are pennate muscles stronger than fusiform - 4.16 1 classes and object oriented programming quiz - Toyota prius distribution channels - Bubble sort comparison calculator - Financial ratio analysis worksheet - What is personal beliefs - Module 9 workbook answers - Heart trust nta food preparation course - 3267 kj to calories - The voodoo of hell's half acre - Mid hospital silver plus hcf - 9th circle of hell punishment - Disadvantages of positive accounting theory - Ida jean orlando journal articles - 2x 75 WORD POSITIVE FEEDBACK RESPONSE DUE 10/4 - Assignment - Liverpool university open days - Night chapter 9 summary - Ford ethical issues - DQ - The magnitude of the electric current is directly proportional to the _____ of the electric field. - Yellow maize kernels surrounded by husks - Ggggo - 4.6 kw to hp - 17 caroline street redfern - Asi - Boral timber noble park - Slab for a jab - Features of a newspaper article - Law unsw course outline - The beatles eleanor rigby lyrics meaning - 5 Generic Strategies - Family Assessment Part II - Data table 1 chemical equations answers - Smart phones in school essay - Music - Explain the difference between psychological egoism and ethical egoism - Food and nutrition mark wahlqvist pdf - Safety what safety case study solution - Whats ethos pathos logos - Cain killed abel with a rock billboard - Nursing interventions for a pulmonary embolism - Entrapment defense case briefs - Pwc management override of controls - Developmental analysis paper coun 502 - 3D Bike Simulations - Clinical psychiatrist job description - How to read vernier caliper - 2002 general maths hsc answers - Havadurumu24 - Baloney - Equilibrium equation for the ionization of acetic acid - Calais 75 white double sink vanity by studio bathe - Capstone business simulation cheats - I need a discussion - Week 10 - Georgia o'keeffe watercolor flowers - English-Discussion: What's Nora's next move? - Please see question in attachment - Eyesight report form nsw - Discussion 3 - Risk Management Case Study - ANMC - FOUNDATION OF PUBLIC HEALTH NURSING - Shenton college year 10 subjects - 100 mental maths starters - Why do flowering plants need to have internal fertilisation - The open window story - Queensland kindergarten learning outcomes - How to beat ring toss - Discussion B: Children Bring Their Own Cultural Selves Into the Classroom - 30 page paper - Networking - Why gender matters chapter summaries - Becton labs inc produces various chemical compound for industrial use - Nelson university of northampton - Lightforce genesis 210 halogen - 109.9 kg in stone - Real world psychology w wileyplus acc - Ready player one theme essay - Data science methodology for emails - Week 4 Project - Qlik sense scripting language - Discussion questions about technology use - Library gcu 2048 login - 3 5 9 17 33 - Ethnic affairs priority statement - A sickeningly sweet baby boy case study answers - Business ethics book by manuel velasquez pdf - Medical literature review - 2 chloro 2 methylbutane structure - A raisin in the sun pdf - Catia v5 part design - Application Secuirty-->Assume you are an entry-level security administrator working for Always Fresh. You have been asked to evaluate the option of adding Active Directory to the company’s network (please see attachment and and follow all requirements) - Historical case study of neurological disorder - Hist 131 - Quotes in death of a salesman