The plant manager, Murat Kristal, at York Technologies makes Aircraft Navigation Systems. He expècts you, as the new OM analyst, to provide some insight for performance of the plant. High on his list is an understanding of hisinventory turnover based on the financial data provided below.Click the icon to view the additional information on the financial data.a) Based on total inventory, what is the inventory turnover for last year?Inventory turnover for last year is times per year (round your response to two decimal places).b) Based on total inventory, what is the inventory turnover for this year?Inventory turnover for this year isc) Has inventory turnover improvedInventory turnover hastimes per year (round your response to two decimal places).this year?this year. at is the inventory turnover for last year?isat isisovedMore InfoSalesCost of goods soldGross marginOther expensesNet incomeFinished goods inventoryWork-in-process inventoryRaw material inventoryTotal inventory (average for year)Other current assetsOther assetsTotal assetsLAST YEAR$244,000118,000126,000Done51,00075,00002,0009,5004,00015,50090,000.200,000305,500.THIS YEAR$257,000130,000127,00051,00076,0004,50012,0005,50022,000109,000244,000375,000- X

Inventory turnover measures how many times a company's inventory is sold and replaced over a…

Answered: The plant manager, Murat Kristal, at…

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

The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with lost sales, i.e., without backorders. Given this information, what is the number in the cell that says xx?
Tinker's 2020 cost of goods sold was $750,000 and 2019 cost of goods sold was $770,000. The inventory at the end of 2020 was $188,000 and $208,000 at the end of 2019. What was Tinker's inventory turnover during 2020? Group of answer choices A)3.79 b)3.99 C)3.84 D)3.89 E)None of the above
Hau Lee Furniture, Inc., spends 45% 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 like to improve the profit line to $20,000 so he can obtain the bank's approval for the loan. Current Situation Sales Cost of material $100,000 $45,000 (45%) Production costs Fixed cost Profit $25,000 (25%) $15,000 (15%) $15,000 (15%) a) What percentage improvement is needed in the supply chain strategy for profit to improve to $20,000? What is the cost of material with a $20,000 profit? A decrease of 11.1 % in material (supply-chain) costs is required to yield a profit of $20,000, for a new material cost of $40000. (Enter your response for the percentage decrease to one decimal place and enter your response for the new material cost as a whole number.)
The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with backorders. Given this information, what is the number in the cell with the question mark?
Genchev Industries conducts an ABC analysis of its inventory and develops the following table from its findings. Item Annual Usage Unit Cost Dollar Usage 1 9,960 $43.20 $430,272 2 3,362 $22.80 $76,654 3 8,332 $9.90 $82,487 4 3,074 $22.30 $68,550 5 2,968 $8.40 $24,931 6 4,195 $25.00 $104,875 7 4,536 $19.20 $87,091 8 9,538 $65.60 $625,693 9 3,484 $3.20 $11,149 10 10,232 $5.70 $58,322 Which of these items is a C item? a. Item 8 b. Item 6 c. Item 5 d. Item 1
Hau Lee Furniture, Inc., spends 50% of its sales dollars in the supply chain and finds its current profit of $21,000 inadequate. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment. Hau would like to improve the profit line to $26,000 so he can obtain the bank's approval for the loan. Sales Cost of material Production costs Fixed cost Profit Current Situation $140,000 $70,000 (50%) $28,000 (20%) $21,000 (15%) $21,000 (15%) a) What percentage improvement is needed in the supply chain strategy for profit to improve to $26,000? What is the cost of material with a $26,000 profit? A decrease of % in material (supply-chain) costs is required to yield a profit of $26,000, for a new material cost of $ (Enter your response for the percentage decrease to one decimal place and enter your response for the new material cost as a whole number.)
Opertion Management No handwritten solution. Maitain quality and accuracy in your answer
As a Program Manager, you have been asked to evaluate a furniture manufacturer’s cash to cash conversion cycle under the following assumptions: sales of $23.5 million, cost of goods sold of 420.8 million, 50 operating weeks a year, total average on hand inventory of $2,150,000, accounts receivable equal to $2,455,000, and accounts payable of $3,695,000. What do you conclude? What recommendations can you make to improve performance? What would be the impact of reducing the accounts payable from $3,695,000to $2,000,000 and all other data remained the same? Please show in detail these impacts quantitatively in your answers.
Three important points of ASHLEY FURNITURE's planning are as follows: -Use of a suite of software to plan its supply chain operations. -Has a transportation optimization system to decide on the most suitable routes of transportation for delivering its products. -Provide inventories on a weekly basis Explain in each point why they are important.
B15. The restaurant uses 24 bottles of wine to operate and it has 3 bottles in hand. Calculate the Desired Ending Inventory (DEl) if the number of days in the delivery period is 2 and the safety factor is 10%. Using the Periodic Order Method, calculate the number of bottles that the restaurant should order.
9.15 If the annual cost of goods sold is $30,000,000 and the average inventory is $5,000,000: a. What is the inventory turns ratio? b. What would be the reduction in average inventory if, through better materials management, inventory turns were increased to 10 times per year? c. If the cost of carrying inventory is 25% of the average inventory, what is the annual savings?
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.

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