Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
forecasting
Can anyone help me with solving the question in Excel- - all i need is a final solution. Thanks a lot for any help 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
forecasting
Our best advice would be for you do attend classes rather than getting
others to do your homework. You could also look up the Forecast function in Help. Regards, Fred. "subs" wrote in message ... Can anyone help me with solving the question in Excel- - all i need is a final solution. Thanks a lot for any help 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
forecasting | Excel Discussion (Misc queries) | |||
Forecasting | Charts and Charting in Excel | |||
Forecasting | Charts and Charting in Excel | |||
Forecasting | Excel Worksheet Functions | |||
Forecasting | Excel Discussion (Misc queries) |