Month Sales Jan Feb Mar Apr May Jun Jul Aug 51 55 54 57 50 68 66 59 「 51 」 Nov Dec Sep Oct 67 69 75 77 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. Make use of relevant calculations.

Month Sales Jan Feb Mar Apr May Jun Jul Aug 51 55 54 57 50 68 66 59 「 51 」 Nov Dec Sep Oct 67 69 75 77 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. Make use of relevant calculations.

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

Chapter3: Data Visualization

Section: Chapter Questions

Problem 2P: The following table shows an example of gross domestic product values for five countries over six...

See similar textbooks

Similar questions

Gan
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…
Use the information provided below to calculate the Cost of sales for 2023. INFORMATION Oyster Manufacturers had an inventory of 30 000 units of Product B (at a production cost of R11 per unit) on 01 January 2023. An additional 600 000 units are expected to be produced during 2023. The unit production cost of Product B is expected to be R12 per unit during 2023. An inventory of 45 000 units is expected on 31 December 2023. The first-in-first-out method of valuing inventories is used.
Refer to the gasoline sales time series data in Table 8.1. Compute four-week and five-week moving averages for the time series. Compute the MSE for the four-week and five-week moving average forecasts. What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Recall that the MSE for the three-week moving average is 10.22.
The required production of a product manufactured by Ditto Manufacturers for 2023 is 38 000 units. The opening inventory on 01 January 2023 was 6 000 units and a closing inventory of 4 000 units is desired on 31 December 2023. What are the expected sales of the product for 2023? A. 40 000 units B. 48 000 units C. 28 000 units D. 36 000 units
The forcasted demand using Exponential (a-0.72) in June given the follwoing: Month Sales Forcasted Demand Ⓒ2935 O6288 OOOO 5712 5311 April 5200 5000 May 5600 6000 June
Target Level of Endil с. 2. Given the following information, estimate the quarterly production in 2016. 450 000 units a. Inventories, December 31, 2015 b. Projected Quarterly Sales and Target Level of Ending Inventories in 2016: Target Level of Ending Inventories Quarter Projected Sales 500 000 Quarter 1 Quarter 2 Quarter 3 Quarter 4 3 500 000 4 500 000 500 000 5 000 000 1000 000 8 000 000 550 000 Requirements: Determine the production for each quarter in 2016. a. b. How many units are expected to be produced in 2016? С. How many units are expected to be sold in 2016?
I need help and i need the excel functions (answers by using excel)
10
At the EOQ, what is the firm’s total inventory costper year, assuming safety stock = 15 units?
Calculate the horizontal (trend) analysis, and horizontal % change for 2020, 2019, 2018 in excel. Please use excel and display the formula's used. Thank you! Toyota Motor Corporation Income Statement 2018-2020 2020 2019 2018 Sales 29929992 30225681 29379510 Cost of Goods Sold 24522364 24781785 23889153 Gross Profit 5407628 5443896 5490357 Selling, general and administrative 2964759 2976351 3090495 Operating Income 2442869 2467545 2399862 Other income (expense) Interest and dividend income 232870 225495 179541 Interest expense -32217 -28078 -27586 Foreign exchange gain, net -79020 12400 22664 Unrealized gains (losses) -24600 -341054 0 Other income (loss), net 14705 -50843 45948 Total other income (expense) 111738 -182080 220567 Income before income taxes and equity 2554607 2285465 2620429 Provision for…
E The following sales information was extracted from the books of Brandon Brothers Ltd during 2015. The company produces two products, Antox and Betox. Sakes forecast January- April 2015 Details January February March April Total Antox 2,000 1,800 2,200 2,500 8,500 Betox 1,500 1,700 1,900 2,200 7,300 Notes: The ending stock of finished goods each month is to be held equal to 25% 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 thirty (30%) percent of the sales for that month. Sales for December 31, 2014 were Antox 3,000 units; and Betox 2,600 units. To make one unit of Antox, four (4) units of raw material X12 are used, while five (5) units of raw material Z100 are used to make one unit of Betox. During 2015 the company sold one unit of Antox for $750 and one unit of Betox for $975. Budgeted sales for May 2015 were 2,400 units of Antox and 2,000 units of Betox.…