Purchase Solution

Simulation, Modeling, Trends and Forecasting

Not what you're looking for?

Ask Custom Question

Forecast of volumes of pizzas that will be sold in Johnston County

The number of pizzas sold will be extremely important to Lotto Pizza. Two factors will impact this number: population growth and percent of population who will purchase a Lotto Pizza. To establish the first number use the population history provided. Although population growth is exponential, to be conservative, assume a linear trend line for the points provided. Assume five persons comprise a family in Johnston County. Target date for opening Lotto Pizza will be January 1, 2007. Provide the estimated population per month for five years starting with January 1, 2007.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Johnston County North Carolina
Population in 2003 (July 1) 136, 802 8,407,248

Population percentage change: 12.2% 4.5%
April 1, 2000 to July 1, 2003

Population in 2000 (April 1) 121,965 8,049,313

Population percentage change: 50% 21.4%
1990 to 2000
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

The next problem will be to convert these populations into pizzas sold by Lotto Pizza. Your consulting firm has already been employed to survey the population and determine the expected number of pizzas that will be purchased in both formats of operation. Six hundred families were contacted and you determined that they will purchase 310 Dine-In pizzas and 347 Delivery pizzas per year.

Pizza sales are seasonal. The following table represents the seasonal demand. A "1.00" would be exactly 100% of the surveyed amounts..

Jan Feb Mar Apr May Jun Jul Aug
.90 .90 1.0 1.0 1.1 .90 .80 .80

Sep Oct Nov Dec
1.15 1.25 1.3 1.1

Start up time will also be a factor for Lotto Pizza. It will take a while for business to ramp up. Even after calculating the above number of pizzas sold each month, reduce the number sold in the beginning. Use 20% of the predicted amounts for January, 40% for February, 60% for March, 80% April, and finally assume 100% for May. From May on use your original numbers as modified by the seasonal adjustments...

With your numbers, predict the number of pizzas and the profit predicted per month for the next five years for the delivery and dine-in environments

Attachments
Purchase this Solution
Solution Summary

Simulation, Modeling, Trends and Forecasting are investigated. The solution is detailed and well presented. The response received a rating of "5/5" from the student who originally posted the question.

Purchase this Solution
Free BrainMass Quizzes
Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Probability Quiz

Some questions on probability

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

View More Free Quizzes
Related BrainMass Solutions

  • Advantages and Limitations of Conceptual Models

    If a simulation is created using the model, the results of the simulation mislead the user. There are several reasons why bias enters modes. Background risks factors, correlated causes, and wrong diagnosis are some of the causes of bias in modeling.

  • Compare and contrast forecasting methods

    Modeling and Simulation: Dynamic modeling and simulation is the collective ability to understand the system and implications of its changes over time including forecasting.

  • Appropriate Forecasting Technique for Aldi Foods

    Casual forecasting would also utilize the use of regression formulas, economic models, input-output models and simulation modeling so as to figure out the relating variables from within and also externally to the retail chain's success.

  • Modeling, Trends and Forecasting

    152955 Modeling, Trends and Forecasting Suppose that the function represents the percentage of inbound e-mail in the U.S. that is considered spam, where x is the number of years after 2000.

  • The answer to Forecasting Methods

    Simulation methods - Simulation methods involve using analogs to model complex systems. These analogs can take on several forms. A mechanical analog might be a wind tunnel for modeling aircraft performance.

  • Comparison of Extrapolation and Writing of Scenarios

    Combining the techniques is a good way to analyze the past and forecast future trends while possible scenarios are considered based on anticipated trends and future possibilities.

  • Appropriate quantitative forecasting methods

    Input-Output Models: describes the flows from one sector of the economy to another, and so predicts the inputs required to produce outputs in another sector. 4. Simulation Modelling.

  • Advantages of Statement Analysis Models Examined

    The limitations of mathematical modeling The advantages of using conceptual models The gap between the complexity of the real world and the simplicity of many abstract models used in forecasting The issues of bias in conceptual modeling. ====

  • Simulation Modeling Software Applications

    581622 Simulation Modeling Software Applications What is your take on popular simulation modeling software applications. Find two applications to compare by examining the costs, features, and training requirements. Please include the sources used.

View More Related Solutions