PepsiCo uses potatoes for most of its products. The CEO has requested that you outline the forecasted volumes in tonnes using trend projection for the first FIVE months of 2025 (January, February, March, April, May and June) using the data for 2024 provided. The following data for 2024 is provided for potatoes in tonnes.

PepsiCo uses potatoes for most of its products. The CEO has requested that you outline the forecasted volumes in tonnes using trend projection for the first FIVE months of 2025 (January, February, March, April, May and June) using the data for 2024 provided. The following data for 2024 is provided for potatoes in tonnes.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 11P: For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12...

See similar textbooks

Similar questions

You would like to know how much should your business purchase for the month of February 2020. The December 2019 sales is 50,000 units and this is expected to increase by 1% per month. The inventory balance as of Dec. 31, 2019 is 4,000 units and you aim to maintain 10% of the month’s sale already to be on hand at the beginning of each month. So far, it is likely that the forecast for January will be achieved. Assuming that cost per unit is maintained at P40, how much would the total purchases be for February? *Note round OFF forecasted units to be sold to whole numbers and round UP the required balance to whole numbers.
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. Construct a time series plot. What type of pattern exists in the data? Compare a three-month moving average forecast with an exponential smoothing forecast for α = 0.2. Which provides the better forecasts using MSE as the measure of model accuracy? What is the forecast for next month?
If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
Furniture, Inc., estimates the following number of mattress sales for the first four months of 2019: Month Sales January 32,000 February 36,800 March 29,600 April 43,200 Finished goods inventory at the end of December is 7,100 units. Target ending finished goods inventory is 20% of the next month's sales. Required: Calculate the How many mattresses should be produced in each month of the first quarter of 2019?
The following sales information was extracted from the books of APEX Ltd during 2020. The company produces two products, Natural life and physical life. Sales forecast January- April 2020 Details January February March April Total Natural life 1,800 2,200 3,200 2,500 9,700 Physical life 2,200 1,700 1,500 2,700 8,100 Notes: The ending stock of finished goods each month is to be held equal to 20% of the forecasted sales for the next month. Raw material stocks at the end of each month are to be held at a level equal to twenty-five (25%) percent of the sales for that month. Sales for December 31, 2019 were Natural life 3,000 units; and Physical life 2,600 units. To make one unit of Natural life, five (5) units of raw material X12 are used, while four (4) units of raw material Z100 are used to make one unit of Physical life During 2020 the company sold one unit of Natural life for $650 and one unit of Physical life for $775. Budgeted sales for…
The following sales information was extracted from the books of APEX Ltd during 2020. The company produces two products, Natural life and physical life. Sales forecast January- April 2020 Details January February March April Total Natural life 1,800 2,200 3,200 2,500 9,700 Physical life 2,200 1,700 1,500 2,700 8,100 Notes: The ending stock of finished goods each month is to be held equal to 20% of the forecasted sales for the next month. Raw material stocks at the end of each month are to be held at a level equal to twenty-five (25%) percent of the sales for that month. Sales for December 31, 2019 were Natural life 3,000 units; and Physical life 2,600 units. To make one unit of Natural life, five (5) units of raw material X12 are used, while four (4) units of raw material Z100 are used to make one unit of Physical life During 2020 the company sold one unit of Natural life for $650 and one unit of Physical life for $775. Budgeted sales for…
The following sales information was extracted from the books of APEX Ltd during 2020. The company produces two products, Natural life and physical life. Sales forecast January- April 2020 Details January February March April Total Natural life 1,800 2,200 3,200 2,500 9,700 Physical life 2,200 1,700 1,500 2,700 8,100 Notes: The ending stock of finished goods each month is to be held equal to 20% of the forecasted sales for the next month. Raw material stocks at the end of each month are to be held at a level equal to twenty-five (25%) percent of the sales for that month. Sales for December 31, 2019 were Natural life 3,000 units; and Physical life 2,600 units. To make one unit of Natural life, five (5) units of raw material X12 are used, while four (4) units of raw material Z100 are used to make one unit of Physical life During 2020 the company sold one unit of Natural life for $650 and one unit of Physical life for $775. Budgeted sales for…
The following sales information was extracted from the books of APEX Ltd during 2020. The company produces two products, Natural life and physical life. Sales forecast January- April 2020 Details January February March April Total Natural life 1,800 2,200 3,200 2,500 9,700 Physical life 2,200 1,700 1,500 2,700 8,100 Notes: The ending stock of finished goods each month is to be held equal to 20% of the forecasted sales for the next month. Raw material stocks at the end of each month are to be held at a level equal to twenty-five (25%) percent of the sales for that month. Sales for December 31, 2019 were Natural life 3,000 units; and Physical life 2,600 units. To make one unit of Natural life, five (5) units of raw material X12 are used, while four (4) units of raw material Z100 are used to make one unit of Physical life During 2020 the company sold one unit of Natural life for $650 and one unit of Physical life for $775. Budgeted sales for…
Complete the table below. Given the following information, estimatethe quarterly production in 2019.a. Inventories as of December 31, 2018, 450,000 unitsb. Projected sales and target level of ending inventories are given on the following table
Patiomaster Products manufactures patio furniture. The estimated numbers of sets to be sold for the last three months of 2022 is: Month Sales October 10,000 November 7,000 December 5,000 January 6,000 Finished goods inventory at the end of September is expected to be 3,000 units. Finished goods inventory is set at 30 percent of next month's sales. How many tables will need to be produced in October?
Grey Manufacturing Company expects sales to total 18,600 units in the first quarter, 16,000 units in the second quarter, and 23,000 units in the third quarter of the current fiscal year. Company policy is to have on hand at the end of each quarter an amount of inventory equal to 10% of the following quarter’s sales. Given this information, how many units should be scheduled for production in the second quarter?
Joel Brown & Associates Limited produces and sells two products, vita 120 and vita 220. The following table provides information on the sales forecast for 2018: Sales Forecast Product Qrt1 Qrt2 Qrt3 Qrt4 Total Vita 120 5,000 6,000 4,800 5,500 21,300 Vita220 6,500 4,600 5,400 6,200 22,700 Notes: It is the company policy to have stock on hand at the end of each quarter equalling to 10% of sales for the next quarter. Budgeted sales for the first quarter of 2019 were: 7,000 units for Vita 120 and 5, 800 units for Vita 220 During 2016, the company sold one unit of Vita 120 for $600 and one unit of Vita 220 for $700 Opening inventory for the first quarter of 2018 was 320 units of Vita 120 and 420 units for Vita 220 To make one unit of Vita 120 four (4) units of raw material B20 is required while five (5) units of raw material B12 is required to make one unit of Vita 220. Prepare the sales budget Prepare the…