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 blan

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 blan

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

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

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

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: 12 units at $47 Jan. 11 Aug. 13 20 units at $48 Nov. 30 $564 960 735 Avaliable for sale $2,259 There are 20 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-sout (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) b. Last-in, first-out (LIFO) c. Weighted average cost Inventory Purchase Purchase 15 units at $49 47 units 1,284 X
The Majestic Theater had 378 cans of Kettle Corn and 132 cans of regular Pop Corn on hand at month end. During the next month Majestic sold 142 cans of Kettle Corn and 67 cans of regular Pop Corn. Cans of each cost $28.40. What is the value of the inventory on hand at the end of the second month?
Specialty Toys, Inc., sells a variety of new and innovative children's toys. As with other products, Specialty faces the decision of how may Weather Teddy units to order for coming holiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, 28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning the market potential. The product management team ask you for analysis of the stock-out probabilities for various order quantities, an estimate of the product potential, and to help make an order quantity recommendation. Specialty expects to sell Weather Teddy for $24 based on cost of $16 per unit. If inventory remains after the holiday season, Specialty will sell all surplus inventory for $5 per unit. After reviewing the sales history of similar products, Specialty%u2019s sales forecaster predicted and expected demand of 20,000 units with a .95 probability that demand would be between 10,000 units and…
ABC Company purchased its inventory at a lump price of P20,000. Relative sales value for each type of inventory was: Inventory XX, P10,000 Inventory YY, P4,000 Inventory ZZ, P10,000 How much would be the cost assigned to inventory XX, YY an ZZ respectively? 10,000. 4,000 and 10,000 respectively 10,000, 4,000 and 8,333 respectively 8,333, 3,333 and 8333 respectively 6667, 6667 and 6667 respectively
Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
If Exxon uses FIFO for its inventory valuation, calculate the cost of ending inventory and cost of goods sold if ending inventory is 110 barrels of crude oil. Beginning inventory and purchases Barrels Barrel cost Total cost Beginning inventory: Jan 1 129 $ 96 $ 12,384 March 1 54 102 5,508 June 1 69 99 6,831 September 1 79 91 7,189 December 1 54 104 5,616 385 $ 37,528 Cost of ending inventory Cost of goods sold
19. SPRAY-PAINT INVENTORY The Graphic Hobby House made purchases of assorted colors of spray paint during the year as follows. Beginning inventory 200 cans at $2.20 March 400 cans at $2.40 May 700 cans at $2.00 August 500 cans at $2.30 November 300 cans at S2.60 At the end of the year, they had 450 cans of spray paint in stock. (a) Find the inventory value using the weighted-average method. (b) Find the inventory value using the FIFO method. (c) Find the inventory value using the LIFO method.
Activities of Inventory Control in Procter & Gamble.
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,120 February 4,220 March 3,920 April 4,320 May 4,920 June 4,620 July 5,220 August 4,820 September 5,320 October 5,620 November 6,220 December 5,920 a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round…
Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day’s paper for $0.50 a copy. You sell a copy of San Pedro Times for $1.25. Daily demand is distributed normally with mean = 335 and standard deviation = 67. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.)
1. With examples and necessary figures, define the Key Inventory Terms ? 2. Suppose, you are newly appointed as a Sales Manager in Unilever Company and after joining your first assignment is to do the sales forecast for the next quarter. Therefore, explain what would be your approach to do a good sales forecast for the next quarter.