Question

In: Operations Management

Forecasting Exercise Every year the U of I hosts the Lionel Hampton Jazz Festival. Below you...

Forecasting Exercise Every year the U of I hosts the Lionel Hampton Jazz Festival. Below you will find some issues that need to be forecast in order to provide the best experience possible to customers, develop effective plans, and deliver "profits" to businesses. How many schools (and students) will be attending? How many will attend Saturday night’s concert? (Lionel Hampton Jazz Festival Big Band) What will be room availability in Lewiston because of the festival? What should I charge for my hotel rooms during the busy weekend? Is there a threshold? How much more should Casa Lopez be ordering for Thursday, Friday, and Saturday? What will the economic impact be to the city of Moscow? Select two or three and write a double-spaced paper telling what you forecasted and how you came up with the forecast you made – discuss the mechanics of how you would develop your forecasts. The specific numbers are not as important as demonstrating a well thought out approach to your forecast.

Solutions

Expert Solution

Answer:

In order to forecast for how many schools (and students) will be attending, what will be room availability in Lewiston because of the festival, what will the economic impact be to the city of Moscow; one can use the moving average method of forecasting. Since the event is held every year, the organiser needs to have the past data. On this past data, one can perform the 4 year moving average by taking into consideration the various situations and constraints of that particular year. A moving average is a technique that calculates the overall trend in a data set. For the question, how many schools and students will be attending, the moving average will provide the actual number that could possible attend the event. Previous year’s data will show the class and type of attendees who had booked the rooms in Lewiston and the availability of room in that year during the festival. Depending upon the number of attendees and the enthusiasm for the event among the public for the current period, it will be easier to forecast the availability of the rooms in Lewiston. Economic impact of the event to the city will be calculated from the past data and the current economic situation of the country.


Related Solutions

Assigned HW2: Income Statement Presented below is information related to Festival Co. for the calendar year...
Assigned HW2: Income Statement Presented below is information related to Festival Co. for the calendar year of 2017. Cost of goods sold- $1,575,000 Loss on disposal of discontinued electronic division (pre-tax) - $330,000 Dividends-Preferred stock- $275,000 Loss resulting from changes in accounting principles: FIFO to AC inventory assumption (pre-tax) - $32,000 Interest revenue- $690,000 Selling expenses 495,000 Net Sales- $3,850,000 Income from operations of discontinued electronic division (pre-tax) - $280,000 Administrative expenses- $375,000 Retained earnings, 1/1 (Jan 1) - $630,000...
Hi I have an exercise and I want to you to solve it step by step,...
Hi I have an exercise and I want to you to solve it step by step, please.. I found the solution here but it did not have steps .. *Answer the following questions using the information below: Tiger Pride produces two product lines: T-shirts and Sweatshirts. Product profitability is analyzed as follows: T-SHIRTS SWEATSHIRTS Production and sales volume 60,000 units 35,000 units Selling price $16.00 $29.00 Direct material $ 2.00 $ 5.00 Direct labor $ 4.50 $ 7.20 Manufacturing overhead...
Someone promises to pay you $1,000,000 every year (at the end of the year) for the...
Someone promises to pay you $1,000,000 every year (at the end of the year) for the next 15 years. The first payment will be one year from today. The relevant effective annual interest rate is 7.0%. What does the time line look like for this problem? What would you pay, today, for this promise? For this we have to calculate the present value of the total cash inflow at interest rate of 7% for 15 years formula for this =...
Someone promises to pay you $1,000,000 every year (at the end of the year) for the...
Someone promises to pay you $1,000,000 every year (at the end of the year) for the next 15 years. The first payment will be one year from today. The relevant effective annual interest rate is 7.0%. What does the time line look like for this problem? What would you pay, today, for this promise?
I can buy a business that promises a $15,500 cash flow every year for the next...
I can buy a business that promises a $15,500 cash flow every year for the next 6 years. How much should I pay to acquire this business if I require a 14% rate of return? A $50,274.35 B $60.000.87 C $60,274.35 D $60,766.87 E None of the above 8 If you purchased the above business for $55,000, then your NPV is... and you ...value A $5,274.35; destroyed B -$9,533.13; created C $666.87.13; created D $766.87.23; created E None of the...
Hello , I want you to give me an exercise with the solution and the equations...
Hello , I want you to give me an exercise with the solution and the equations for every principle mention below , thank you ! - Proximity sensors. - Optical flowmeter. - Turbine flowmeter. - Ultrasonic flowmeter. - Ultrasonic level gauge.
10. You are offered an annuity that will pay you $200,000 once every year, at the...
10. You are offered an annuity that will pay you $200,000 once every year, at the end of each year, for 25 years (i.e. the first payment will arrive one year from now, the last payment will arrive 25 years from now). Suppose your annual discount rate is i= 5.25%, how much are you willing to pay for this annuity? Hint: this is the same as the present value of an annuity.
You are promised a cash flow every year forever! Next year you will receive $100. After...
You are promised a cash flow every year forever! Next year you will receive $100. After that, the payment will grow by 1% compounded annually. There is no risk associated with the payments. You can invest and earn a risk-free rate of return of 5%. What is the present value of the perpetuity?
Before you start this exercise, I want you to write down the answers to these questions.  ...
Before you start this exercise, I want you to write down the answers to these questions.   Really, write them down BEFORE you read the discussion question. 1)  Are you for or against any forms of discrimination?  (Seems like a fairly ridiculous question, doesn't it?) 2) How do you define discrimination? If you had to describe discrimination what would it be?  How would you know if you were being discriminated against? STOP!  Before you read anything else, did you write down the answer to...
The compounding frequency on a loan is once every year. If you borrow $35,974.44 at an...
The compounding frequency on a loan is once every year. If you borrow $35,974.44 at an annual interest rate of 3.75%, how much must you pay every year so that you pay back the loan in 17 years? How do I do the steps in Excel? using PEMDAS Please show steps IF YOU GOT 2900. HOW DID YOU GET THAT ?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT