can you do it in excel

Read PSM Case 5-1 Garland Chocolates and prepare three 10-year cashflow spreadsheets for three scenarios---maintaining the current lines, upgrading the lines, and outsourcing-using the attached template and submit the completed spreadsheets. Please only use explicit information provided in the case. For example, when the case states annual maintenance cost...expected to increase by at least 25 percent in the next 12 months", you can assume that the cost will increase exactly 25% for the next year and remain at this level for future years. Exhibit 1 lists the standard costs, rather than actual costs, of current operations. Exhibit 2 shows that the actual scrap rates deviate from the standard scrap rates. The standard material costs are based on the standard scrap rate rather than the deteriorated actual scrap rate. Therefore you need to adjust the standard material costs based on the standard and actual scrap rates to calculate the actual costs. The labor costs do not need to be adjusted. For the outsourcing option, the case states "it would need six months to ramp up production", therefore you should assume the outsourcing options takes effect in year 1 rather than 0. You may also make the assumption that the outsourcing option uses new packaging lines and thus enjoys the 20% increase in sales. garland_template.xlsx Read PSM Case 5-1 Garland Chocolates and prepare three 10-year cashflow spreadsheets for three scenarios---maintaining the current lines, upgrading the lines, and outsourcing---using the attached template and submit the completed spreadsheets. Please only use explicit information provided in the case. For example, when the case states "annual maintenance cost...expected to increase by at least 25 percent in the next 12 months", you can assume that the cost will increase exactly 25% for the next year and remain at this level for future years. Exhibit 1 lists the standard costs, rather than actual costs, of current operations, Exhibit 2 shows that the actual scrap rates deviate from the standard scrap rates. The standard material costs are based on the standard scrap rate rather than the deteriorated actual scrap rate. Therefore you need to adjust the standard material costs based on the standard and actual scrap rates to calculate the actual costs. The labor costs do not need to be adjusted. For the outsourcing option, the case states "it would need six months to ramp up production", therefore you should assume the outsourcing options takes effect in year 1 rather than 0. You may also make the assumption that the outsourcing option uses new packaging lines and thus enjoys the 20% increase in sales. garland_template.xlsx Read PSM Case 5-1 Garland Chocolates and prepare three 10-year cashflow spreadsheets for three scenarios---maintaining the current lines, upgrading the lines, and outsourcing-using the attached template and submit the completed spreadsheets. Please only use explicit information provided in the case. For example, when the case states annual maintenance cost...expected to increase by at least 25 percent in the next 12 months", you can assume that the cost will increase exactly 25% for the next year and remain at this level for future years. Exhibit 1 lists the standard costs, rather than actual costs, of current operations. Exhibit 2 shows that the actual scrap rates deviate from the standard scrap rates. The standard material costs are based on the standard scrap rate rather than the deteriorated actual scrap rate. Therefore you need to adjust the standard material costs based on the standard and actual scrap rates to calculate the actual costs. The labor costs do not need to be adjusted. For the outsourcing option, the case states "it would need six months to ramp up production", therefore you should assume the outsourcing options takes effect in year 1 rather than 0. You may also make the assumption that the outsourcing option uses new packaging lines and thus enjoys the 20% increase in sales. garland_template.xlsx Read PSM Case 5-1 Garland Chocolates and prepare three 10-year cashflow spreadsheets for three scenarios---maintaining the current lines, upgrading the lines, and outsourcing---using the attached template and submit the completed spreadsheets. Please only use explicit information provided in the case. For example, when the case states "annual maintenance cost...expected to increase by at least 25 percent in the next 12 months", you can assume that the cost will increase exactly 25% for the next year and remain at this level for future years. Exhibit 1 lists the standard costs, rather than actual costs, of current operations, Exhibit 2 shows that the actual scrap rates deviate from the standard scrap rates. The standard material costs are based on the standard scrap rate rather than the deteriorated actual scrap rate. Therefore you need to adjust the standard material costs based on the standard and actual scrap rates to calculate the actual costs. The labor costs do not need to be adjusted. For the outsourcing option, the case states "it would need six months to ramp up production", therefore you should assume the outsourcing options takes effect in year 1 rather than 0. You may also make the assumption that the outsourcing option uses new packaging lines and thus enjoys the 20% increase in sales. garland_template.xlsx