University | Singapore University of Social Science (SUSS) |
Subject | (ANL203) Analytics for Decision Making |
ANL203: Analytics for Decision-Making Assignment, SUSS, Singapore You are to analyze a spreadsheet model in Capacity.xlsx which is used by Company A to plan the proper capacity level for a new product
Question 1
You are to analyze a spreadsheet model in Capacity.xlsx which is used by Company A to plan the proper capacity level for a new product. The company aims to maximize the expected net present value generated from the new product over the next 15 years. The discount rate is assumed as 10% per year. The unit cost of building capacity (400,000 units) to produce the new product is $10 per year. The unit maintenance cost is $1 per year.
Assuming all construction costs are paid at year 0, the first profits come in at the end of the first year. In year 1, we know demand will be for 160,000 units of the product. The annual percentage growth of demand for the product is 15%. During year 1, each unit of the product sells for $8. The price of the product will grow by 5% per year. Unit variable cost is known to be 40% of the sales price. The depredation rate is 10% and the tax rate is 30%.
(a) Your task in this question is to analyze the spreadsheet model built for you and identify all the bugs You may assume that the accounting in the model is conceptually correct. Present your findings in tabular format.
Buy Custom Answer of This Assessment & Raise Your Grades
- ELG101: Discovering Language Assignment, SUSS, Singapore: Speakers are creative users of the languages they speak. In our everyday interaction
- ELG101: Discovering Language Assignment, SUSS, Singapore: Demonstrate the articulation of the words in the above data set using the International Phonetic
- Principles of Project Management Individual Assignment, SUSS, Singapore: You are appointed a Project Manager in charge of organising and planning a project
- COR2223: Frontiers of Modern Computing Final Written Assignment, SMU, Singapore: Write a short story imagining a future scenario and how one or more of the modern computing technologies
- AC2101: Accounting Recognition and Measurement Assignment, NTU, Singapore: If NTU-C were to record the abovementioned transactions on 31 January, 28 February and 15 March 20×2
- BSE217: Motor Development, Control and Learning Assignment, SUSS, Singapore: Create a rating scale or categories of differentiation to rate the movement proficiencies of the individual
- BSE217: Motor Development, Control and Learning Assignment, SUSS, Singapore: Discuss the main theoretical foundations of Ecological Dynamics Theory
- NCO201: Learn To Learn, Learn For Life Tutor-Marked Assignment 2, SUSS, Singapore: Create a learning plan. Use this template to create your learning plan
- NCO201: Learn To Learn, Learn For Life Tutor-Marked Assignment 2, SUSS, Singapore: Self-reflection is a critical part of learning. By looking back at your process and analysing
- BPM301: LCC and Sustainable Design and Construction Assignment, SUSS, Singapore: A developer is building a new 3-storey sports complex on a 10-year leasehold land
UP TO 15 % DISCOUNT