BUS225_Module_Six_Assignment (1)

Problem 16A: ROLLED DOWN unit forecast for part C is 22, F is 2, I is 254, and L is 3. Can you please shows the answers in excel with the formula in it, becuase I need to practices this kinda question for my upcoming exam.

need help with this question! Note:- • Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. • Answer completely. • You will get up vote for sure.

Weighted moving average using Excel:3.1 Calculate demand forecast for weeks 7-24 using 6 week weighted moving average with weights 0.55, 0.1, 0.1, 0.1, 0.1, 0.053.2 Calculate demand forecast for weeks 7-24 using 6 week weighted moving average with weights 0.2, 0.2, 0.2, 0.15, 0.15, 0.13.3 Plot the two weighted moving average forecasts together with the actual demand. Comment on the obtained graph.3.4 Using the forecasting error measures seen in class, evaluate the forecasting error of each method. Accordingly which method is better?

please answer within 30 minutes.

Answer part a only

1. A forecaster must decide on the value of this factor before he can use the simple moving average model. *   a. Actual demand for each period b. Averaging period c. Exponential smoothing constant d.Weights   2. A forecaster must decide on the value of this factor before he can use the exponential smoothing model. *   a. Actual demand for each period b. Averaging period c. Exponential smoothing constant d. Weights   3. A forecaster must calculate this value to assess the accuracy of a time series forecasting model. * a. Averaging period b. Correlation coefficient c. Exponential smoothing constant d. Mean absolute deviation

Problem 2

Company Name: Floward (flowers Market) Create a campaign for your company to launch, starting January 2021 till December, that will be active for 12 months. Marketing budget: SR 450,000 to spend on digital advertising media over the next 12 months. The budget also includes up to SR 340,500 for advertising creative and content development, and for the company to manage the program. Monitoring and Optimization: describe how you will measure and improve digital marketing performance during the campaign. What tools you will use to monitor the campaign’s activity. (Must include screenshots of the monitoring tools that will keep track of your costs and activity).

I need typing clear urjent no chatgpt used i will give 5 upvotes pls full explain

a) The demand forecast for Month 6 would be:    A. 565 haircuts    B. 574 haircuts    C. 578 haircuts    D. 584 haircuts   b) With Mean Absolute Deviation (MAD) as the criterion, the best forecasting model for this time series data is:    A. Naïve approach    B. 2-week Simple Moving Average (SMA)    C. Weighted Moving Average (WMA) with weights: 0.5, 0.3, 0.2    D. Exponential Smoothing (ES) with alpha = 0.8

Corporate triple-A bond interest rates for 12 consecutive months follow. Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 9.5 9.3 9.4 9.6 9.8 9.7 9.8 10.5 9.9 9.7 9.6 9.6 a. Construct a time series plot. What type of pattern exists in the data? b. Develop the three-month moving averages for this time series. Compute MSE. c. Compute MAE. d. Compute MAPE. e. What is the three-month moving average forecast for the next month (month 13)?

Operations Management

Explain basic concepts of forecasting and time series. Explain the concept of capacity. Describe how to compute and use capacity measures. Describe long-term capacity expansion strategies. Describe short-term capacity adjustment strategies.

Forecasting Forecasting is important relative to capacity requirements planning. What are some of the merits of using judgment methods (i.e., qualitative data) in contrast to quantitative forecasting methods. Which methods are considered to be superior or more accurate, and in what forecast situations would require judgment methods? In what situations would require a quantitative approach to forecasting?

When Mikayla decided to open a café, she had to decide how much seating she should have in her café so she could rent a large enough space. In order to figure this out, she had to estimate the demand she might have, that is, how many customers she would likely have based on her products and location. Mikayla was: Group of answer choices a) Forecasting b) Production planning c) Managing operations d) Marketing

2. Calculate the exponential smoothing forecast for week eight using a=0.2.   Week Sales Forecast 1 39   2 44   3 40   4 45   5 38   6 43   7 39   a. 41.63 b. 39.98 c. 40.54 d. 40.03 Instruction: This is consists of one (1) multiple choice question. The question requires deep analysis. Choose  the appropriate response for the question. A detailed working out should accompany the responses.

homework 2 #2

How can the Ansoff Matrix be used to analyse the airline industry?

Suppose a four-period weighted average is being used to forecast demand. Weights for the periods are as follows: wt-4 = 0.1, wt-3 = 0.2, wt-2 = 0.3 and wt-1 = 0.4. Demand observed in the previous four periods was as follows: At-4 = 380, At-3 = 410, At-2 = 390, and At-1 = 400. What will be the demand forecast for period t?

Neil is decision maker for Pepe's Atlantic sausage company. Because there are several suppliers of the ingredients and their prices fluctuate, he has come up with several different formulations for the various sausages that he makes, depending on the availability of particular ingredients from particular suppliers. He often orders ingredients accordingly twice a week. Even though he cannot predict when ingredients will become available at a particular price, his ordering of supplied can be considered routine. 1. On what level of management is Neil working? Explain in a paragraph. 2. What attributed of his job would have to change before you would categorize him as working on a different level of management? List them.

The schedular at ZamTech uses MPS time-phased records for planning and item production. The planner is currently working on a schedule for a strut assembly, one of ZamTechs top-selling spare parts.The planner uses a production lot size of 170 and a safety stock of 15 for the strut assembly. The planner has the following forecasts (Ft) and orders (Dt) for the next 8 weeks, as shown in Table 1. Table 1 Week 1 2 3 4 5 6 7 8 Ft 130 130 130 140 140 140 145 145 Dt 45 38 18           Required: a) Help the master production scheduler to fill in the MPS time-phased record shown in Table 2 for the strut assembly. There are 120 units on hand. Table 2   1 2 3 4 5 6 7 8 Ft                 Dt                 EIt-1                 Pt                 EIt                 ATPt                 b) Can the planner accept the following orders? Update the MPS time-phased record for accepted orders, in Table 3. Table 3 Order Quantity Desired week 1 120 4 2 144 6 3 100 2…