CourseHeroMBA620powerbi

For this final assignment I’d like you to call upon your knowledge of forecasting to help project your firm’s revenue stream for the upcoming year. In the Microsoft Excel that is attached to this assignment, you will find the past four years of quarterly revenue data for your nonprofit. Your revenue comes from two major sources: individual donations and donations from corporations. I’d like you to use the past four years’ worth of data to forecast the individual donations and donations for corporations for the next fiscal year (year 5 quarters 1-4).   Once you have forecasted both individual revenue streams you can simply add them together to get your overall revenue forecast for the next fiscal year. Please discuss what forecasting method you chose and how you made your decision. You can do this in your excel document or write up a separate paragraph or two in a Microsoft Word document.

Sales for the past 12 months at computer success are given here: January 3,000      July 6,300 february 3,400      August 7,200 March 3,700         Sept 6,400 April 4,100            Oct 4,600 May 4,700            Nov 4,200 June 5,700           December 3,900 a. Use a 3-month moving average to forecast the sales for the months May through December b. Use a 4-month moving average to forecast the sales for the months May through December C. Compare the performance of the two methods by using the mean absolute deviation as the performance criterion. Which method would you recommend? d. Compare the performance of the two methods by using the mean absolute percent error as the performance criterion. Which method would you recommend? e. Compare the performance of the two methods by using the mean squared error as the performance criterion. Which method would you recommend?

Better if you use excel in the computations. Thank you.

Based on these tables, Can you calculate the Profit and Revenue and explain how you got these calculations. Also please explain how these tables are important when finding profit and revenue.

The table below summarizes September 20223 financial performance by two market segments. The dates highlighted in orange indicate occupancy higher than 90% Please find the correct statement about the data analysis based on the table. Market segment 1 shows pattern of peak on Weekdays. Market segment 2 shows a pattern of peak on Weekends. Based on the demand pattern, Market Segment 2 could be leisure travelers. Most guests in the market segment 2 are less price sensitive than those in the market segment 1.

Explain the relationships (if there's any) between Forecasting and Inventory Management to a new (non perishable) consumer retail business in your city that has about 2 million residents. The company will employ about 100 people to start out. What do they need to understand? They need your help because they found out you are about to complete your MBA. Complete your response in 4 paragraphs.

Hide Assignment Information Instructions   Exercise #5 For this week exercise, we need to try a few logit models (see this link for more information: LOGIT REGRESSION) If you have chosen to work with Excel, please run above three models and complete the following tables. Model 1: Run a regression model and use being a member of network and find out its impact on hospital cost? (Model 1) Model 2: For the 2nd model run a regression model and use being a member of network and find out its impact on hospital cost and hospital revenue? (Model 2) Model 3: For the 3rd model run a regression model and use being a member of network and find out its impact on ratio-Medicare-discharge and ratio-Medicaid-discharge. Based on your finding please recommend 3 policies and discuss the impact of being on a network on hospital cost, hospital revenue and out its impact on ratio-Medicare-discharge and ratio-Medicaid-discharge. Do you recommend keeping membership for a hospital? Why or why not?

If Mr. Ishaq is the Director of Lexus Company in Nizwa, what does he need to do to predict customer sales or product demand? a. Forecasting b. Marketing c. Production d. Coordination

The topic of technology forecasting adopts  a  broad  definition  that  incorporates  competitive  technical  intelligence, foresight,  impact  assessment,  risk  assessment,  and  technology  road  mapping. Which of these topics is the highest of importance in technology forecasting?

Although the unpredicted, yet disruptive, impact of the CoViD-19 pandemic is global and has negatively affected all organizations, identify a business organization that you think has been affected the most. In the new normal, which forecasting time horizon (short-range, medium-range, or long-range) would you suggest should be adopted by this organization in forecasting the demand for its main product? Justify your answer. Cite your assumptions. Cite 2 to 3 factors that this business organization should use as a basis for forecasting the demand for its main product. Justify your answer.

What are the advantages and disadvantages of aggregating demand from a forecasting view? Are there other things that should be considered when going from multiple DCs to a DC?

What should be our forecast accuracy target if there is a high degree of volatility in customer orders and long lead times?   We have a new chief sales officer who is proposing that we should forecast in dollars, not in units/cases. I have never heard of anyone forecasting in dollars. It is true that dollarized forecasts can help Sales in knowing precisely what sales target they should be hitting. But, is it the best practice?

Develop a simple data model for a student data- base that includes student contact data, student demographic data, student grades data, and student financial data. Determine the data attributes that should be present in each table, and identify the primary key for each table. Develop a complete Entity Relationship diagram that shows how these tables are related to one another.

Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table: Maroon 5 TV Appearances Demand for Guitars 4 Y = 3 4 5 D 5 6 7 7 7 4 10 6 This exercise contains only parts b, c, and d. b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): = 0+0x

Distinguish between Historical Analogy and the Delphi Method forecasting and discuss a business application suitable for each methodology. In each example, discuss why the chosen method (Historical Analogy or Delphi) is more appropriate than the other. Use -- Evans, J. (2020). Business analytics (3rd ed.). Pearson.

Corporate triple-A bond interest rates for 12 consecutive months are as follows. 9.5 9.4 9.5 9.7 9.8 9.8 9.9 10.6 10.0 9.8 9.7 9.7 (a) Construct a time series plot. What type of pattern exists in the data? The data appear to follow a trend pattern.The data appear to follow a horizontal pattern.    The data appear to follow a seasonal pattern.The data appear to follow a cyclical pattern. (b) Develop three-month and four-month moving averages for this time series. (Round your answers to two decimal places.) Month Time SeriesValue 3-Month MovingAverage Forecast 4-Month MovingAverage Forecast 1 9.5     2 9.4     3 9.5     4 9.7     5 9.8     6 9.8     7 9.9     8 10.6     9 10.0     10 9.8     11 9.7     12 9.7     Does the three-month or four-month moving average provide the better forecasts based on MSE? Explain. The four-month moving average provides more accurate forecasts, because its MSE is smaller than that of the three-month moving…

Below is a table that shows the Freshmen Enrollment of the New Texas Elementary School during the 1a Semesters of the past ten (10) Academic Years (AY), AY 2013-2014 2014-2015 2015-2016 2016-02017 2017-2018 Freshmen Enrollees AY 200 220 235 270 315 4. For the Weighted Moving Averages model, use: a weight of 0.40 for the most recent data; a weight of 0.35 for the second most recent data; and a weight of 0.25 for the third most recent data. You are the Principal of New Texas Elementary School. You are interested to know the forecast of freshmen enrolment for the next academic year (AY2023-2024), in order to plan ahead the necessary resources: faculty, classroom, library holdings, physical facilities, student services, furniture and fixtures, etc.). These are the requirements: AT 2013-2014 1. Calculate the forecast using 5 forecasting techniques/methodologies/models namely: Naïve Model, Unweighted and Weighted Moving Averages, Exponential Smoothing, and Time-Series Regression. Follow and…

Cost Estimation; High-Low and Regression Methods The Mac Davis Company specializesin the purchase, renovation, and resale of older homes. Mac employs several carpenters and paintersto do the work for him. It is essential for him to have accurate cost estimates so he can determinetotal renovation costs before he purchases a piece of property. If estimated renovation costs plus thepurchase price of a house are higher than the house’s estimated resale value, it is not a worthwhileinvestment.Mac has been using the home’s interior square feet for his exterior paint cost estimations. Recentlyhe decided to include the number of external openings—the total number of doors and windows ina house—as a cost driver. Their cost is significant because they require time-consuming preparatorywork and careful brushwork. The rest of the house usually is painted either by rollers or spray guns,which are relatively efficient ways to apply paint to a large area. Mac has kept careful records of theseexterior…

Quantitative Methods II - Question 3 Please assist with i, ii & iii

What is the strategic importance of forecasting for a business such as Pinkie Ice Cream ? What are the possible challenges faced by organizations that do not utilize forecasting in the planning of their operations?

Arnold Tofu owns and operates a chain of 12 vegetable protein “hamburger” restaurants in northern Chicago area. Sales figures and profits for the stores are in the table below. Sales are given in millions of dollars; profits are in hundreds of thousands of dollars. Calculate a regression line for the data. What is your forecast of profit for a store with sales of $24 million? 30 million?

9

Movieflix, an online movie streaming service that offers a wide variety of award-winning TV shows, movies, animes, and documentaries, would like to determine the mathematical trend of memberships in order to project future needs. Year                              2013 2014 2015 2016 2017 2018 2019 2020 2021Membership (000s)   17      16      16     21     20      20     23      25      24    1. Provide an example of qualitative forecasting and explain the shortcomings.