Read the following description and solve the problems. You need to submit both WORD- FILE and Excel files 1. Build a quantitative model to analyze the development and sale of a bicycle light Assume that production ramp-up expenses would be $20,000, ongoing marketing and support costs would be $2,000 per month, and development would take 12 months. Assume that you could sell 20,000 units per year for five years after development at a sales price (wholesale) of $20 per unit and a manufacturing cost of $10 per unit. How much development spending could justify such a project if you use 6% annual interest rate? 2. Compute the trade-off rules for the above case. 3. Use the project schedule in the case study Read the following description and solve the problems. You need to submit both WORD- FILE and Excel files 1. Build a quantitative model to analyze the development and sale of a bicycle light Assume that production ramp-up expenses would be $20,000, ongoing marketing and support costs would be $2,000 per month, and development would take 12 months. Assume that you could sell 20,000 units per year for five years after development at a sales price (wholesale) of $20 per unit and a manufacturing cost of $10 per unit. How much development spending could justify such a project if you use 6% annual interest rate? 2. Compute the trade-off rules for the above case. 3. Use the project schedule in the case study