Question: 2. The following table contains data about the inventory for 5 items at Jones Corporation. Item 1 2 Beginning Unit Ending Unit Average Unit Annual

2. The following table contains data about the

2. The following table contains data about the inventory for 5 items at Jones Corporation. Item 1 2 Beginning Unit Ending Unit Average Unit Annual Unit Inventory Inventory Inventory Inventory Sales Turnover 250.000 200.000 550.000 34.000 52.000 90.000 87.000 95.000 230,000 320.000 290,000 765.000 40.000 50.000 115,000 3 4 5 Total a. Complete the missing items in the table, including the Total row. Compute inventory turnover using unit sales and unit inventory. Is the total inventory turnover a sum of inventory turnovers for the five items? b. The item unit cost was as follows: Item 1 = $30.00 Item 2 = $55.00 Item 3 = $10.00 Item 4 = $5.00 Item 5 = $3.00 Compute the annual sales $$ value and average inventory $$ value for each item. c. Compute the total inventory turnover using total sales $$ value and average total inventory $$ value. (Note that in part a, total inventory turnover was computed using unit sales and unit inventory, not sales and inventory values.) d. Suppose Jones Corporation determined that its annual inventory holding cost = 22% of inventory value. Compute the average inventory holding cost for each item. e. Suppose Jones Corporation believes that in the upcoming year, the rate of sales expected for each of the 5 items is as follows: Item 1 = 5,500 units per day Item 2 = 2,300 units per day Item 3 = 19,000 units per day Item 4 = 9,600 units per day Item 5 = 4,350 units per day Compute the days of supply for each item. Which unit inventory should you use for days of supply? Why

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!