Looks like homework for a class! I don't find a web site for ProLobsters, but I DID find cross-postings of the same question on different Excel help sites!
P ________________________________ From: subs <subbu1...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Mon, December 7, 2009 10:17:05 PM Subject: $$Excel-Macros$$ forecasting in excel Can anybody help me solve the problem in excel any help will be greatly appreciated thanks 1. ) ProLobsters is a direct-from-the-ocean shipper of fresh Maine lobsters to consumers throughout the United States. All orders are shipped FedEx Overnight or 2ndDay on the date requested by the customer. ProLobsters acquires new customers with daily spots on the Food Channel, and also enjoys a brisk repeat business. Three times each month, ProLobsters sends an e-mail to its entire customer base containing special offers. July sales data is detailed in the companion workbook, and the e-mail drop dates are highlighted in blue. Using this information, create a forecast for August daily orders, shipments, new customers, and retention orders. Orders Shipments New Customers Repeat Orders 1-Jul 2,258 3,364 659 1,599 2-Jul 1,594 3,201 506 1,088 3-Jul 1,078 0 333 745 4-Jul 605 0 213 392 5-Jul 843 1,364 286 557 6-Jul 619 726 196 423 7-Jul 883 0 310 573 8-Jul 3,094 3,359 837 2,257 9-Jul 3,559 2,664 959 2,600 10-Jul 2,502 2,857 851 1,651 11-Jul 2,041 3,156 686 1,355 12-Jul 1,306 989 403 903 13-Jul 719 719 265 454 14-Jul 981 0 338 643 15-Jul 3,531 3,463 915 2,616 16-Jul 4,003 3,018 794 3,209 17-Jul 2,627 2,981 851 1,776 18-Jul 2,114 3,496 722 1,392 19-Jul 1,556 1,068 518 1,038 20-Jul 739 762 240 499 21-Jul 916 0 290 626 22-Jul 2,276 3,060 741 1,535 23-Jul 2,248 2,306 783 1,465 24-Jul 2,130 2,285 776 1,354 25-Jul 1,876 2,894 627 1,249 26-Jul 1,301 960 415 886 27-Jul 661 538 227 434 28-Jul 830 0 278 552 29-Jul 3,370 3,147 790 2,580 30-Jul 3,898 2,882 790 3,108 31-Jul 2,803 3,229 858 1,945 1-Aug 2-Aug 3-Aug 4-Aug 5-Aug 6-Aug 7-Aug 8-Aug 9-Aug 10-Aug 11-Aug 12-Aug 13-Aug 14-Aug 15-Aug 16-Aug 17-Aug 18-Aug 19-Aug 20-Aug 21-Aug 22-Aug 23-Aug 24-Aug 25-Aug 26-Aug 27-Aug 28-Aug 29-Aug 30-Aug 31-Aug -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
