The actual demand of a product for six months are summarized in the table below: Month ( ) t Demand t D 1 2 3 4 5 6 80 90 70 100 70 90 i. Find three months weighted moving averages by assuming the weights, 1 0.1 W = , 2 0.4W = and 3 0.5 W =
Q: QUESTION SIX (a) Suppose that a decision is faced with three decision alternatives and four states…
A: Given data is
Q: Question 1 Rangaswamy owns 50 acres of land in the Hassan district of Karnataka on which he grows…
A: From the given data, the following excel model can be formulated. Excel model:
Q: QUESTION 9 ________ provide the resources needed by a company to produce its goods and services.…
A: suppliers provide the resources needed by a company to produce its goods and services. retailers are…
Q: Question 19 Based on this table information and what you know about housing and labor markets, which…
A: The question is related to the identification of the city having the highest quality of life or…
Q: QUESTION 9 The graph below represents the market demand curve for a product, where p is the price…
A: Consumer surplus refers to the additional benefit a consumer has by the consumption of one…
Q: Question Completion Status: Consider the following payoff Table Decision Alternative D1 The State of…
A: Given data: The state of nature Decision alternative 0.79 1-0.79 S1 S2 D1 5 8 D2 4 8…
Q: a) “The practice of investment refers to the buying of a financial product or any valued item with…
A: 1) "The practice of investment is the buying of a financial product with anticipation that positive…
Q: A property development company is planning to build a block of student apartments in Lusaka’s Mass…
A: This question is related to the topic-Decision Making and This topic falls under Operations…
Q: Question 3 Use a weighted score model to choose between three methods (A, B, C,D) of financing the…
A: Given- Relative weights for method A, B, C and D.
Q: A CFE of -140 suggests which of the following? Group of answer choices a. There is a bias towards…
A: The CFE stands for the cumulative sum of forecast errors. It helps to the measurement of the total…
Q: There are a number of key risks that the logistics function may face. Explain five typical immediate…
A: Logistics refers to the distribution system comprising the components in a channel assigned to…
Q: QUESTION 1 A). Describe at least six (6) costs involved in the Management of Materials B). If the…
A: I have solved the first two sub-parts of the question 1 for you. Kindly find them in Step 2 & 3…
Q: Compute the expected value for each decision and select the best one. B.Develop the opportunity…
A: Formula:
Q: Unit 4 Exercises Question 4.1 Use exponential smoothing with trend adjustment to forecast demand for…
A: Given Table - Initial Trend Value = 12 Initial Forcast = 200 Period Actual Demand 1 200 2…
Q: Compute the expected value for each decision and select the best one. Develop the opportunity loss…
A: Formula:
Q: Question 1 A firm uses simple exponential smoothing with "a = 0.6" to forecast demand. The forecast…
A: Given data is Alpha = 0.6 1st week forecast = 498 units 1st week demand = 445 units
Q: Question 4 The below data represent the advertising expenditure and sales of Little Liu Ltd from…
A: This question is related to the topic -Forecasting approach/Regression analysis, this topic falls…
Q: Question #10 Compute the expected value. 0.2 15,000 0.5 11,000 0.3 9,000 Piçk x 0.1 4,000 DI C2 -0.7…
A: Expected Value indicating the possible payoff based on the probability of getting a state of nature.…
Q: Use a weighted score model to choose between three methods (A, B, C,D) of financing the acquisition…
A: Find the Given details below: Given details: Category Weight Method A B C D Consulting…
Q: Question (4): Answer the following problem: Cover Me, Inc. sells umbrellas in two cities.…
A: Given data:
Q: QUESTION B2 A financial Analyst wants to evaluate the feasibility of his investment options. The…
A: Given- Economic Environment Investment Option Good Fair Poor X 25 8 -15 Y 20 15 -10 Z…
Q: The DEF Company is developing an operational plan to move his company into a new building. Mr. DEF…
A: Static Plan normally portrays the everyday running of the organization. Operational plans are…
Q: QUESTION • A producer of a particular product has the following production function: Q = 100K05 L0.5…
A: Q=100K^0.5L^0.5. K = 100, L = 25. a.) The marginal product of capital and marginal product of labor…
Q: STION THREE a) Zambia Breweries has a backlog of 250 crates of Fanta drinks at the end of December.…
A: Given: Backlog of 250 crates Fanta drinks in December Demand expected in January=400 crates Demand…
Q: Question.1. A bed mart company is in the business of manufacturing beds and pillows. The company has…
A: Decision variables: Let x be number of beds manufactured. Let y be number of pillows manufactured.…
Q: Question 3: Jerry has preferences over cats, c, and hats, h, that can be described by u(c, h) =…
A: Consumption Curve: On the graph, the consumption curve shows that how consumers' choice of…
Q: Question 1 B A company produces 2 (two) different grades of gasoline – regular and premium from…
A: Table 1: Table 2:
Q: Question Consider the following transactions occurring during a given fortnight. Remi's wage for his…
A: Remi's balance sheet: Assets: Cash: $600 + $150 + $70 + $350 - $920 = $850 Bonds: $70 Shares: $350…
Q: Question 16 'USC' STANDS FOR UNIT SHIPPING COST AREA X AREA Y AREA Z SUPPLIES 300 300 PLANT A 600…
A: The problem can be solved using the transportation problem solving technique. In the Excel, the…
Q: Month [Bulan] Sales Units [Unit Jualan] 1 1100 2 1200 3 1450 4 1800 5 2100 6 2700…
A: The sales unit data for 6 months is given as below
Q: Question 4: Prepare a flexible budget for Oman Electro-Mechanical Company for the yoar 2021. The…
A: Below is the solution:-
Q: Companies A, B, C were evaluated as prospective suppliers of timber to a furniture manufacturing…
A:
Q: Question 3 (Forecasting) - Consider the following time series data. Week 1 2 3 4 5 6. Value 18 13 16…
A: Given data: *As per guideline first 3 parts are answerable, repost the remaining part.
Q: . Do the 2 month SMA forecast 2. Do 2 month WMA forecast using the information below WMA – 2: last…
A: Solution Question 1 1. The two month simple moving average forecast is calculated in the below…
Q: Another solution for antibiotic resistanceis the development of new drugs that defeat resistant…
A: Monopoly means the existence of one seller. it's the important sort of imperfect completion. there's…
Q: Question 1: Kimji Company is engaged in the business of export of garments. In the past, the…
A: In the above case, the Kimji company is engaged in the business of manufacturing garments and then…
Q: Shawna is the marketing manager for Yummy Marinades and Dips. The company wants to should introduce…
A: Given information, Cost of testing done = $150,000 Probability of test market = 0.6 Annual Profit…
Q: Suppose you are given a set of data for output at a company which manufactures detergents over a…
A:
Q: Assuming Mike is saving the same amount per month in the next 3 years. How much does Mike get for…
A: Simple interest is computed over a given period at a fixed percentage of the principal amount.…
Q: The forecast of a product for the first week of January was 200 units, whereas the actual demand…
A: Below is the solution:-
Q: QUESTION 39 Coca-Cola Company's global marketing leadership position is based in part on its ability…
A: Coco Cola company's global marketing leadership position is based in part of its ability to put coke…
Q: Question 2 (Linear Programming) - . The government of Ghana has available GH¢1 billion earmarked for…
A: Given data is Available investment = 50,00,00,000 Total annual return = more than equal to…
Q: Examination questions Question 1 ■ On 1 September each year, Salemis Limited begins the task of…
A: Since you have submitted a question with multiple subparts, as per guidelines we have answered first…
Q: Shawna is the marketing manager for Yummy Marinades and Dips. The company wants to should introduce…
A: As per the guidelines, we can answer only one question at a time. Please resubmit others for…
Q: Question 1: Salalalh Methanol company management is considering three competing investment Projects…
A: Payback (period) method is that the exact amount of your time required for a firm to recover its…
Q: QUESTION ONE (a) Mr. Sak is interested in developing and marketing a new drug. The cost of extensive…
A: From the given data: i. Draw a decision tree for Mr. Sak indicating all choices and events
Q: Question 5 Year 2010 2011 2012 2013 2014 2015 Economic Growth (%) 2.7 1.7 1.3 2.7 2.5 1.9…
A: Unemployment is estimated by the unemployment rate, which is the quantity of individuals who are…
Q: a)The overall objective of the procurement evaluation process is to reduce purchase risk and…
A: The method of identifying, evaluating, or contracting with suppliers is known as supplier selection.…
QUESTION ONE
(a)
The actual demand of a product for six months are summarized in the table below:
Month ( ) t Demand t D
1 2 3 4 5 6
80 90 70 100 70 90
i.
Find three months weighted moving averages by assuming the weights, 1 0.1 W = , 2 0.4W = and 3 0.5 W =
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- QUESTION THREE (a) The actual demand of a product for 6 months are summarized in Table below: Actual Demand Values Month ( ) t Demand ( ) tD 1 300 2 450 3 700 4 900 5 1200 6 1400 i. Find three months weighted moving averages by assuming the weights 1 0.15 W = , 2 0.36W = and 3 0.49 W = . ii. Compute the mean forecast errors. iii. Compute the mean square error29 00:24 1 令.l 50 B/s Question no. 02: A Leading manufacturer of Action Figures is about to introduce four new Action Figures. The accompanying table summarizes price and cost data, combined fixed costs equal $650,000. A marketing research study predicts that for each unit sold of Noyan, 2 units of Dogan, 3 units of Bamsi and 4 units of Turgut will be sold. Action Figures Turgut Bamsi Dogan Novan Selling Price (in dollars) 35 26 24 16 Variable Cost/unit (in dollars) 17 12 12 11 Table 1 a) How many product mix units must be sold to break even? b) How does it translate into sales of individual games?Q 6. For the following data, calculate the number of workers required for level production and the resulting month-end inventories. Each worker can produce 15 units per day, and the desired ending inventory is 9000 units. Month 1 3 4 Total Working Days 20 24 12 19 Forecast Demand 28,000 27,500 28,500 28,500 Planned Production Planned Inventory 11,250 [3+2] 2.
- QUESTION THREE (a) The actual demand of a product for 6 months are summarized in Table below: Actual Demand Values Month ( ) t Demand ( ) tD 1 300 2 450 3 700 4 900 5 1200 6 1400 iv. Compute the mean absolute deviation. v. Mean absolute percent error (MAPE)Table 1. Demand of Hairdryer from January to July [Jadual 1. Permintaan Pengering Rambut dari Januari 2021 hingga Julai 2021] Month Demand January February 2800 2870 March 2968 April Мay 3000 3100 Jun 3150 July 3400 a) Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.[hitung ramalan permintaan masa depan untuk bulan Mei, Jun, Julai dan Ogos dengan menggunakan purata bergerak sederhana 3 bulan.] *Part B Three-period Four-period Units Units Demanded Period weighted moving weighted moving Demanded Three-period weighted moving average forecast average forecast average forecast Four-period weighted moving average forecast 24 2 25 60 28 50 49 S50 4 32 26.33 46 4.90 39,80 40 41 5 35 29.50 28.6 38 35 38 32.83 31.7 30 32 28 25 26,93 250 es 7 41 36.00 34.9 24 20 8 46 39.00 38 49 43.00 41.8 10 10 53 46.67 45.4 50.50 49.2 1 2 3 4 5 6 7 8 9 10 11 1. Make a comparative analysis out of your answers in the plotted data. (3-5 sentences)
- Question 2 Historical demand for gulab jamun from a sweet stall on Commercial Road is as displayed in the table. Month Demand (orders) January 66,753 February 67,686 March 68,641 April 68,979 May 69,278 June 69,577 July 69,602 August 70,348 September 70,806 October 71,011 November 71,819 December 72,752 What is the forecast for June using Holt's model with an alpha of 0.1 and a beta of 0.2? 69121 69612 70564 63545 Full explain this question text typingCalculate customer life time value for the data below. (Show Work) Purchase Occasion Transition Probability Average Basket Size 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ΝΑ 55% 75% 78% 83% 81% 81% 86% 82% 85% 90% 93% 85% 89% 85% 91% 97% 97% 96% 85% 83% 89% 82% 79% 82% 89% 88% 86% 67% 75% $46.71 $56.71 $57.93 $56.87 $58.26 $66.90 $63.62 $70.27 $63.03 $62.60 $71.81 $76.76 $78.14 $65.65 $74.84 $81.11 $72.08 $87.30 $71.94 $75.44 $70.35 $72.86 $66.68 $79.90 $93.91 $61.08 $94.16 $100.40 $77.89 $99.70Q 6. A production line is to run at 1200 units per month. Sales are forecast as shown in the following table. Calculate the expected period-end inventory. The opening inventory is 700 units. All periods have the same number of working days. Week Forecast Demand 3 |5 6 1 2 4 800 850 600 550 600 700 Planned Production 1200 1200|1200 1200 1200|1200 Planned Inventory 700
- Question 3: Jane is trying to forecast demand for her store, using moving average with n=2, Fill in the missing cells with correct values and find average error for first quarter and second quarter of year 2000 E Enroll- Year Quarter ment Forecast Error Abs Error 1997 313 3. 2 285 4 3 312 5. 4 339 6. 1998 1 359 7 320 356 385 6. 10 1999 396 367 11 397 12 423 13 14 2000 1 15 2000 3412M4QUESTION 4 Calculate four periods moving average forecast from the following last six periods Period Demand 1 38 40 42 4 40 44 38 O a. 40 Ob.41 Ос. 42 Od. 43c. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). MONTH PRODUCTION DAYS DEMAND FORECAST DEMAND PER DAY JAN 2022 16 150 ? FEB 2022 16 150 ? MAR 2022 23 250 ? APR 2022 21 250 ? MAY 2022 22 400 ? JUN 2022 22 500 ? JUL 2022 21 600 ? AUG 2022 20 750 ? SEP 2022 20 450 ? OCT 2022 20 250 ? NOV 2022 16 150 ? DEC 2022 16 150 ? TOTAL ? ? d. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number). e. Prepare a graph showing the monthly forecasts and average daily forecast (in units per day) for MPQ Limited.