c3 need urgent in 15 minutes Month# Forecast# Starting inv.# Net requirement# Prod. rate# Ending inv.# StockoutJan120011282270200011280645100011280517240112837101500112801FebMarAprMay299227O0371xx177316457571129The table above provides the aggregate plan of Onyx Note Air tablet produced by a Chinese firm. It is known that the firm uses a level planwith backorders. Given this information, what is the number in the cell with xx? (If needed, round your final answer to nearest wholenumber (c)Orsdemir. Copyrighted material.)

level plan means similar production every period

Answered: Month# Forecast# Starting inv.# Net…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

1. Katherine is a forecast manager. She used exponential smoothing to forecast her sales with alpha equals 0.25. Her forecast for this week was 161 but the actual number is 232. What is her forecast for next week?2. Blue Pad Companyâ€™s lead time L is1week and demand rate is119units per week.Holding cost is $29 per unit and ordering cost is $281. Assume 52 weeks in a year.What is the EOQ? Keep two decimal points!3.Blue Pad Companyâ€™s lead time L is3week and demand rate is123units per week.Holding cost is $70 per unit and ordering cost is $726. Assume 52 weeks in a year.What is the ROP?4. Lugini Watchâ€™s annual demand is 107. It can produce at a rate of 19 watches per month with a $249 setup cost for the production run. Find the order quantity (EPQ) assuming carrying cost is $57 per unit a year. Keep two decimal points!5. Lugini Watchâ€™s annual demand is 108. It can produce at a rate of 24 watches per month. Using the…
please answer in 30 mins.
Source Available at: http://panmore.com/walmart-inventory-management [Accessed 18 July 2022] Reading the above, it becomes clear that good inventory management and forecasting can deliver supply chain success for and could ultimately lead to profitability and growth. In a report you are required to evaluate the importance of forecasting for Walmart Your report, must include but is limited to the following: • The importance of forecasting to Walmart. • Examine if a combination of both qualitative and quantitative forecasting may be best suited. • Argue the relevance of cloud-based forecasting for Walmart. NB: • The marks allocated next to each concept in the rubric below should serve only as a guide to the depth your discussion should cover. Your answer should be a minimum of 1 200 to a maximum of 1 500 words. Markers are to stop marking after the threshold of 1 500 words (two-and-a-half to three pages) has been reached. Please indicate the word count at the end of your answer. • You…
P.nilesh
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $40 $600 Aug. 13 Purchase 5 units at $41 205 Nov. 30 Purchase 11 units at $42 462 Available for sale 31 units $1,267 There are 9 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a. First-in, first-out (FIFO) $fill in the blank 1 b. Last-in, first-out (LIFO) $fill in the blank 2 c. Weighted average cost $fill in the blank 3
Please do not give solution in image format thanku
Plot these forecasts AND the original demand data on graph paper or spreadsheet. Use a key to distinguish among your three lines. Please use the graph in the attached picture for the answer.
Q29 please help me!!
A company director wants to employ you to forecast the monthly inventory levels for the firm, which manufactures a single product. However, he is unclear what facilities to provide you with, this being the first formal forecasting project undertaken by the firm. Discuss the kinds of decisions that need to be made, including those about what information to utilize and how much money to spend, and the implications of these decisions.
Navajo Company's year-end financial statements show the following. The company recently discovered that in making physical counts of inventory, it had made the following errors: Year 1 ending inventory is understated by $69,000 and Year 2 ending inventory is overstated by $39,000. For Year Ended December 31 (a) Cost of goods sold (b) Net income (c) Total current assets (d) Total equity Year 1 $ 744,000 Year 2 $ 974,000 287,000 1,266,000 1,406,000 294,000 1,379,000 1,599,000 Year 3 $ 809,000 269,000 1,249,000 1,264,000 Required: 1. For each key financial statement figure-(a), (b), (c), and (d) above-prepare a table to show the adjustments necessary to correct the reported amounts. 2. What is the total error in combined net income for the three-year period resulting from the inventory errors? Complete this question by entering your answers in the tabs below. Required 1 Required 2 For each key financial statement figure-(a), (b), (c), and (d) above-prepare a table to show the adjustments…
Weekly demand for an item averaged 100 units over the past year. Actual demand forthe next eight weeks is shown in what follows:a. Plot the data on graph paper.b. Letting a = 0.25, calculate the smoothed forecast for each week.c. Comment on how well the forecast is tracking actual demand. Is it lagging or leading actual demand?
How do you do this step by step?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS