Tutoring Center needs to allocate tutors this week for office appointments, so it needs to forecast the number of students who will seek appointments. The director has gathered the following time series data recently: Time Period Code Student Appointments Jan 6 - 10 1 95 Jan 13 - 17 2 80 Jan 20 - 24 3 65 Jan 27 - 31 4 50 a) What is the naïve forecast for the number of student appointments for Time Period 5 (Feb 3– 7)? b) What is the 2 week moving average for Time Period 5? c) What is the 3 week moving average for Time Period 5? d) What is the forecast for Time Period 5 using exponential smoothing with alpha = 0.2 and a forecast 90 for Time Period 3? e) Is demand for appointments increasing or decreasing?

Tutoring Center needs to allocate tutors this week for office appointments, so it needs to forecast the number of students who will seek appointments. The director has gathered the following time series data recently: Time Period Code Student Appointments Jan 6 - 10 1 95 Jan 13 - 17 2 80 Jan 20 - 24 3 65 Jan 27 - 31 4 50 a) What is the naïve forecast for the number of student appointments for Time Period 5 (Feb 3– 7)? b) What is the 2 week moving average for Time Period 5? c) What is the 3 week moving average for Time Period 5? d) What is the forecast for Time Period 5 using exponential smoothing with alpha = 0.2 and a forecast 90 for Time Period 3? e) Is demand for appointments increasing or decreasing?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

What are the ethical issues, as identified with the Markkula Center Framework for Ethical Decision related links, in the strategy of Dollar General Download Dollar Generalas depicted in this article? DG may have "hit a gold mine in rural America," but at what ethical cost? This is not merely your personal opinion but an opinion informed by the detailed and contradictory ethical analysis the Markkula app provides. Between Tuesday and Wednesday (11:59 pm) post your detailed analysis based on Markkula for all to see. Wednesday.-Friday, compare and contrast the work of others in the class, and seek to synthesize overall ethical ideas.
Please do not give solution in image format thanku please answer as they are straight to the point, i will rate but i need them asap
1. Answer the following. Provide the monthly sales plan of shopee (please use gantt chart or a suitable graphical representation for data visualization) Use this in creating the sales plan: January: New Year promotions, kick-off sales meetings. February: Valentine's Day promotions, lead nurturing activities. March: End of Q1 push, performance review, and strategy adjustment. April: Spring sales campaign, customer feedback collection. May: Mid-year training, product refresh. June: Mid-year performance review, prepare for summer promotions. July: Summer sales push, lead generation activities. August: Back-to-school promotions, focus on upselling. September: End of Q3 push, prepare for Q4 strategy. October: Fall sales campaign, early holiday promotions. November: Black Friday and Cyber Monday sales. December: Holiday sales, year-end clearance, customer appreciation events.
1. Review the provided CRM data to guide you in selecting the buying firm that will maximize revenue for DataLocker. Once you have analyzed the CRM data, select the appropriate industry that will maximize revenue for DataLocker: Small Size Manufacturing Small Size Hospitality Small Size Services Medium Size Manufacturing Medium Size Hospitality Medium Size Services Large Size Manufacturing Large Size Hospitality Large Size Services
1. Before the arrival of the internet, many small businesses were not able to advertise because it was expensive for them. But when the Internet arrived, now they are able to do so. Where are they placing their adverts? 2. What are Broadcast stations that specialize in one genre only, such as sports, movies, news, music etc called? 3. The arrival of digitization is affecting general broadcast stations. Mention one way in which digitization is affecting general broadcast stations. niathovbe
Incoterms determine ________. Group of answer choices When the shipper will send the cargo Which carrier will move the cargo Which party is responsible for insuring cargo None of these answers
Service efforts and accomplishments reporting is now required by the GASB for governme O True O False
9.In the context of the web, what is a cookie? Whatis the benefit of cookies for online shoppers?
A. Explain the following based on CRM – Customer Relationship Management:1. Customer Centric Approach2. Attract Customers3. Delight Customers4. Amplify Sales5. Go Mobile.
In the marketplace today, the demand for high-level salespeople
please answer in 4 sentences
Using Big Data and AI solutions to anticipate when and where customers will need deliveries is known as ________. Group of answer choices Creepy voyeurism Forward supply chaining Predictive logistics Retail surveillance