SCM360 SUNYSB Discussion
Try to use as many features as you can to make your files more flexible and readable.
Save your answers in one excel file with three separate sheets. Don’t forget to name your file and the sheets properly.
1.You are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it costs $0.03 per copy to operate the copier. Other fixed costs of running the store will amount to $400 per month. You plan to charge an average of $0.10 per copy, and the store will be open 365 days per year. Each copier can make up to 100,000 copies per year.
2.The excel file “Problem_two.xlsx” lists sales (in millions of dollars) of Dell computer during the period 1987-1997 (where year 1 corresponds to 1987).
3.Consider a project with the following cash flows: year 1, -$400; year 2, $200; year 3, $600; year 4, -$900; year 5, $1000; year 6, $250; year 7, $230. Assume a discount rate of 15% per year.
