he following data below gives information for ABCO building supplies. Cost of goods sold last year was 36646558.0 and the average aggregate inventory on raw materials is 2,310,000, work in process (WIP) is 3,500,000 and the finished goods is 4,000,000. Round all of your answers to ONE decimal place. Inventory Turns Last Year is:

he following data below gives information for ABCO building supplies. Cost of goods sold last year was 36646558.0 and the average aggregate inventory on raw materials is 2,310,000, work in process (WIP) is 3,500,000 and the finished goods is 4,000,000. Round all of your answers to ONE decimal place. Inventory Turns Last Year is:

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?
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. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
The Eagle Machine Company averaged $2 million in inventory last year, and the cost of goods sold was $10 million. Figure 12.5 shows the breakout of raw materials, work-in-process, and finished goods inventories. The best inventory turnover in the company’s industry is six turns per year. If the company has 52 business weeks per year, how many weeks of supply were held in inventory? What was the inventory turnover? What should the company do?
Two items are omitted from each of the following three lists of cost of goods sold data from a manufacturing company income statement. Determine the amounts of the missing items, identifying them by letter. Finished goods Inventory,June1 $61,600 $46,200 (e) Cost of goods manufactured 329,000 (c ) 484,800 Cost of finished goods available for sales (a) $260,400 $540,000 Finished goods Inventory ,June30 72,800 61,600 (f) Cost of goods sold (b) (d) $513,600
South African rapper, Cassper Nyovest, has launched a business venture manufacturing his very own clothing and shoes. Cassper wishes to ensure the highest levels of customer satisfaction. Argue the importance of accurate demand forecasting as a principle of an inventory management system for Cassper. Note: Provide at least two application points.
As a logistics specialist, you are responsible for meeting customer demand. One of your customers places orders for you to supply four products by the end of October. You have limited capacity for raw material and other facilities. You are required to satisfy customer demand by manufacturing the products and/or buying from a supplier. After consulting with the production department, you obtained the following information. Product A Product B Product C Product D Order quantity 2000 3500 1500 2500 Hours required on machine X per unit 2 4 5 3 Hours required on machine Y per unit 4 3 6 2 Raw material in kilos 5 1 4 6 Time needed for Packaging per unit 36 minutes 30 minutes 45 minutes 24 minutes Available monthly hours per month: 8,000 on machine X, 6000 on machine Y, and 3,000 hours for packaging. Purchased items from your supplier are already packaged. Available raw material per month: 5,000 kilos…
Green Gardens' owner has asked your advice about a possible problem at his business. Over the last 6 months the large-sized lawn and garden inventory (ie, tables, chairs, planters, etc.) has appeared to be short. The inventory records that employees use to determine what is on hand show that more inventory is available than can actually be located. This has cause frustration and mis-trust in the inventory records for the sales employees. The owner realizes that the problem is bigger than just frustrated employees. He is afraid that inventory is being stolen, a problem he didn't think possible given that these are large items that are not easily moved. Requirements: Provide the owner with two internal controls that he could implement to reduce the likelihood of theft of the lawn and garden inventory.
Annin Laboratories uses the weighted-average method to account for its work-in-process inventories. The accounting records show the following information for February: Beginning WIP inventory Direct materials $ 26,553 Conversion costs 8,605 Current period costs Direct materials 159,792 Conversion costs 82,020 Quantity information is obtained from the manufacturing records and includes the following: Beginning inventory 6,000 units (40% complete as to materials, 15% complete as to conversion) Current period units started 45,200 units Ending inventory 23,000 units (75% complete as to materials, 35% complete as to conversion) Required: Compute the equivalent units for the materials and conversion cost calculations. Compute the cost per equivalent unit for direct materials and conversion costs.
Last year, the retailer's weekly variance of demand was 100 units. The variance of orders was 250, 300, 400 and 600 units for the retailer, wholesalers, distributing and manufacturer. respectively (note that the variance of orders equals the variance of demand for that firm's supplier) A. calculate the bullwhip measures for the retailer, wholesales, distributor and manufacturer? B. what is the bullwhip effect for the entire supply chain? C. provide actionable guidelines (with anticipated bullwhip measures of each point on how to reduce bullwhip measures to 2 in the supply chain? All your calculations has to be done on paper and has to be done on excel sheets. Each question you must show the formula used to calculate the answer in excel sheet in order to use excel in exam.
Over the past 12 months, Super Toy Mart has experienced a demand variance of 10,250 units and has produced an order variance of 12,050 units. Part 2 a) The bullwhip measure for Super Toy Mart is ______ (round your response to two decimal places). Part 3 b) If Super Toy Mart had made a perfect forecast of demand over the past 12 months and had decided to order 1/12 of that annual demand each month, the bullwhip measure would have been ______ (round your response to the nearest whole number.)
Hau Lee Furniture, Inc spends 55% of its sales dollars in the supply chain and finds its current profit of $15,000 inadequate. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment Hau would ike to improve the profit line to $20,000 so he can obtain the bank's approval for the loan Current Situation Sales $100,000 $55,000 (55%) $15,000 (15%) Cost of material Production costs Fixed cost $15,000 (15%) Profit $15,000 (15%) a) What percentage improvement is needed in the supply chain strategy for profit to improve to $20,0007 What is the cost of material with a $20,000 profit? A decrease of% in matenial (supply-chain) costs is required to yield a profit of $20,000, for a new material cost of S (Enter your response for the percentage decrease to one decimal place and enter your resporise for the new matenal cost as a whole number.)
ABC Company had the following inventory information: Beginning inventory: 500 units at $10 per unit Purchases: 1,000 units at $12 per unit Sales: 800 units Ending inventory: 700 units Calculate the cost of goods sold for ABC Company.