Crusty Dough Pizza Company Crusty Dough Pizza creates a friendly and pleasant atmosphere for customers in a well-designed, and productive environment in which people can work happily. We are sensitive to the look and taste of good pizza as well as to high-quality ingredients. We look to provide the best possible value to our customers who desire great tasting pizza and to provide customers with the satisfaction of receiving a great value, both tangibly and intangibly. Additionally, we are the first home-deliverer of pizzas in our area. Our customers are our neighbors as we are residents of our market area. We will also create and nurture a healthy, creative, respectful, and fun working environment, in which our employees are fairly compensated and encouraged to respect the customer and the quality of the product we produce. We seek fair and responsible profit, enough to keep the company financially healthy for the long term and to fairly compensate owners and investors for their investment and risk. Using the historical sales data, Management wants you to develop a forecasting tool to help make the best financial and operational decisions.

1. Write a one page Executive Summary based on the following case study.

2. Develop a forecasting tool using the raw data provided from actual sales for the past 15 years.

3. Pick one of the three types to base your forecast on. Short-Term used to support decisions that are made for short term period ranging from daily level to monthly level. Mid-Term – are forecast to support decisions that are made from monthly to yearly level Long-Term are forecast that support decision are made over multiple years.

4. Management would like to know if seasonality exist in the data.

5. Create a seasonality index. Develop a forecast using one of the methods 6. What is your forecast? What method did you use and why? Raw data: Unit: Pizza Crusty Dough Pizza Company Pizza sold by month

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

2002 561 640 656 727 697 640 599 568 577 553 582 582

2003 600 566 653 673 742 716 660 617 583 587 565 598

2004 628 618 688 705 770 736 678 639 604 611 594 634

2005 622 709 722 782 756 702 653 615 621 602 635 635

2006 677 635 736 755 811 798 735 697 661 667 645 688

2007 713 667 762 784 837 817 767 722 681 687 660 698

2008 717 696 775 796 858 826 783 740 701 706 677 711

2009 734 690 785 805 871 845 801 764 725 723 690 734

2010 750 707 807 824 886 859 819 783 740 747 711 751

2011 804 756 860 878 942 913 869 834 790 800 763 800

2012 826 799 890 900 961 935 894 855 809 810 766 805

2013 821 773 883 898 957 924 881 837 784 791 760 802

2014 828 778 889 902 969 947 908 867 815 812 773 813

2015 834 782 892 903 966 937 896 858 817 827 797 843

Answer rating: 100% (QA)

The detailed answer for the above question is provided below Answer 1 Executive Summary Crusty Dough Pizza Company is an established pizza restaurant that seeks to provide its customers with the best ... View the full answer