get answer 8950

Prompt: Kiana has been looking into buying into a franchise. This will increase her revenue but will also increase her expenses.

To conduct an appropriate analysis, the first thing Kiana needs is a forecast of demand for next year. She will base her forecast off historical MONTHLY sales data she has gathered data for the last three years. This data will be the basis for her 2021 forecast.

Next, she will need to determine the profitability of the two different options, by creating a yearly profit model for each option (continuing to operate her donut
shop or buy into the franchise).
Finally, she will use decision support tools to analyze her two different options. This will help her decide if she should buy into the franchise or continue with her current donut shop.

Assignment: Using the worksheet template attached create a forecast for average demand , using historic sales data (attached file) create a monthly forecast using classical decomposition that is based on regression and seasonality.

We are creating a monthly forecast not quarterly. The data is your historical salesls , this part of the project is completed on the Excel Worksheet: SI and Regression

Kiana is creating a monthly forecast based on monthly data. You will create a seasonal Index for each month. Therefore you will have seasonal indexes for Jan, Feb, March, etc. Remember the total of the month’s seasonal indexes for a year should add up to 12. You will still use a three-year average for your final seasonal index.


15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.

WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?