{"id":52943,"date":"2021-09-23T20:12:12","date_gmt":"2021-09-23T20:12:12","guid":{"rendered":"https:\/\/papersspot.com\/blog\/2021\/09\/23\/scm-360-spreadsheetmodeling\/"},"modified":"2021-09-23T20:12:12","modified_gmt":"2021-09-23T20:12:12","slug":"scm-360-spreadsheetmodeling","status":"publish","type":"post","link":"https:\/\/papersspot.com\/blog\/2021\/09\/23\/scm-360-spreadsheetmodeling\/","title":{"rendered":"SCM 360 SpreadsheetModeling"},"content":{"rendered":"<p>Some questions are quite broad intheir nature, but others are very specific to the experiments\/data in the paper. <br \/>All problems are from Chapter 2. <br \/>Try to use as many features as you can to make your files more flexible and readable. <br \/>Save your answers in one excel file with three separate sheets. Don\u2019t forget to name your file and the sheets properly. <\/p>\n<p>1. (35 points) 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. a. For one to five copiers rented and daily demands of 500, 1000, 1500, and 2000 copies per day, find annual profit. That is, find annual profit for each of these combinations of copiers rented and daily demand. <br \/>b. If you rent three copiers, what daily demand for copies will allow you to break even? <br \/>c. Graph profit as a function of the number of copiers for a daily demand of 500 copies; for a daily demand of 2000 copies. Interpret your graphs. <\/p>\n<p>2. (35 points) The excel file \u201cProblem_two.xlsx\u201d lists sales (in millions of dollars) of Dell computer during the period 1987-1997 (where year 1 corresponds to 1987). <\/p>\n<p>a. Fit a power and an exponential trend curve to these data. Which fits the data better? <br \/>b. Use part a answer to predict 1999 sales for Dell. <br \/>c. Use your part a answer to describe how the sales of Dell have grown from year to year. <\/p>\n<p>3. (30 points)Consider<br \/> a project with the following cash flows: year 1, -$400; year 2, $200; year 3,<br \/> $600; year 4, -$900; year 5, $1000; year 6, $250; year 7, $230. Assume a<br \/> discount rate of 15% per year. <\/p>\n<p> a. Find the project\u2019s NPV if cash flows occur at the<br \/> ends of the respective years. <\/p>\n<p> b. Find the project\u2019s NPV if cash flows occur at the<br \/> beginnings of the respective years. <\/p>\n<p> c. Find the project\u2019s NPV if each cash flows occur at<br \/> the middles of the respective years. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Some questions are quite broad intheir nature, but others are very specific to the experiments\/data in the paper. All problems are from Chapter 2. 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\u2019t forget to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[10],"class_list":["post-52943","post","type-post","status-publish","format-standard","hentry","category-research-paper-writing","tag-writing"],"_links":{"self":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/52943","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/comments?post=52943"}],"version-history":[{"count":0,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/52943\/revisions"}],"wp:attachment":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/media?parent=52943"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/categories?post=52943"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/tags?post=52943"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}