Question 1 (a) Consider the "newsboy problem". The newspaper vendor ordered 100 newspapers from the supplier in anticipation of demand for newspapers the next day. The newsvendor calculated the expected profit to be $150. Later, the newsvendor computed the critical ratio for the problem as 0.57. The probabilities of possible demand of the newspaper are shown in Table 1. Analyse whether the quantity the newsvendor ordered is the best quantity to maximise the expected profit. Demand Table 1: Newspaper demand distribution 25 50 75 100 125 150 Probability 0.10 0.15 0.20 0.30 0.15 0.10 (9 marks) (b) The average weekly demand for a piece of respiratory equipment was found to be 25 units with a lead time of 3 weeks. The standard deviation of lead time demand is known to be 10 units. The company plans to provide a service level that is 47.7% more than the mean lead time demand. Both demand and lead time follow a normal distribution. The company determined that an order of 250 units is the optimal order quantity for the item. (i) Identify the ordering policy for the item. (ii) If the company decides not to keep any safety stock, what service level can it achieve? Question 2 Demand for video projectors from a reputed company over the last two years is shown in Table 2. The company is trying to forecast the demand for the year of 2022. Table 2: Monthly Demand for Video Projectors Month Demand Month Demand Jan-20 120 Jan-21 118 Feb-20 105 Feb-21 110 Mar-20 97 Mar-21 95 Apr-20 85 Apr-21 90 May-20 98 May-21 100 Jun-20 110 Jun-21 115 Jul-20 125 Jul-21 122 Aug-20 102 Aug-21 98 Sep-20 92 Sep-21 88 Oct-20 90 Oct-21 79 Nov-20 100 Nov-21 95 Dec-20 115 Dec-21 110 (a) Plot the demand data and comment on the pattern. What should be the most appropriate method to forecast demand for 2022? (6 marks) (b) The supply chain manager believes there is a linear relationship between demand and time and decides to use a regression analysis method to forecast the demand. Determine the regression equation for the given data. Clearly identify the dependent variable, independent variable, slope and intercept. Discuss whether regression analysis is appropriate or not to forecast demand in this situation. Provide your reasons. (c) The actual demand for the months of Jan-22 to Apr-22 were found to be 120, 100, 80 and 75, respectively. Compute the mean absolute deviation (MAD) based on the demand forecasts for 2022 using the method in part (b).
Question 1 (a) Consider the "newsboy problem". The newspaper vendor ordered 100 newspapers from the supplier in anticipation of demand for newspapers the next day. The newsvendor calculated the expected profit to be $150. Later, the newsvendor computed the critical ratio for the problem as 0.57. The probabilities of possible demand of the newspaper are shown in Table 1. Analyse whether the quantity the newsvendor ordered is the best quantity to maximise the expected profit. Demand Table 1: Newspaper demand distribution 25 50 75 100 125 150 Probability 0.10 0.15 0.20 0.30 0.15 0.10 (9 marks) (b) The average weekly demand for a piece of respiratory equipment was found to be 25 units with a lead time of 3 weeks. The standard deviation of lead time demand is known to be 10 units. The company plans to provide a service level that is 47.7% more than the mean lead time demand. Both demand and lead time follow a normal distribution. The company determined that an order of 250 units is the optimal order quantity for the item. (i) Identify the ordering policy for the item. (ii) If the company decides not to keep any safety stock, what service level can it achieve? Question 2 Demand for video projectors from a reputed company over the last two years is shown in Table 2. The company is trying to forecast the demand for the year of 2022. Table 2: Monthly Demand for Video Projectors Month Demand Month Demand Jan-20 120 Jan-21 118 Feb-20 105 Feb-21 110 Mar-20 97 Mar-21 95 Apr-20 85 Apr-21 90 May-20 98 May-21 100 Jun-20 110 Jun-21 115 Jul-20 125 Jul-21 122 Aug-20 102 Aug-21 98 Sep-20 92 Sep-21 88 Oct-20 90 Oct-21 79 Nov-20 100 Nov-21 95 Dec-20 115 Dec-21 110 (a) Plot the demand data and comment on the pattern. What should be the most appropriate method to forecast demand for 2022? (6 marks) (b) The supply chain manager believes there is a linear relationship between demand and time and decides to use a regression analysis method to forecast the demand. Determine the regression equation for the given data. Clearly identify the dependent variable, independent variable, slope and intercept. Discuss whether regression analysis is appropriate or not to forecast demand in this situation. Provide your reasons. (c) The actual demand for the months of Jan-22 to Apr-22 were found to be 120, 100, 80 and 75, respectively. Compute the mean absolute deviation (MAD) based on the demand forecasts for 2022 using the method in part (b).
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter3: Cost Behavior And Cost Forecasting
Section: Chapter Questions
Problem 67P: Refer to the information for Farnsworth Company (p. 139) for the first 10 months of data on...
Related questions
Question
Please provide clear explanation with step by step guidiance. QN 1 & 2
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 14 images
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College