Using the detailed formula for ICC and the following information, calculate the annual finished product inventory...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the detailed formula for ICC and the following information, calculate the annual finished product inventory carrying cost for Apple iPads. (put in table, column Y)) Apple stores the tablets that it produces in its only company field warchouse. The warehouse received one tablet shipment each quarter this year. Each shipment contained 125,000 tablets. The warehouse kept a safety stock of 5,000 tablets. Demand was 125,000 tablets per quarter from retailers. Apple sold the tablets to retailers for $750 each. Apple's variable manufacturing (i.e., production) costs were $200 per tablet. Apple's fixed manufacturing costs averaged $125 per tablet. The transport cost from plant to warehouse location was $3,500,000 per year. The handling costs to receive and store shipments for the year was $500,000. The costs just described for transportation and handling, when combined, equal S4,000,000. Cost data collected (as a percent of inventory value): Cost of capital borrowed to finance inventory (7%) Opportunity cost of capital (10%) Taking inventory (cycle counting) in warehouse (4%) Warehouse manager salary (12%) Annual warehouse depreciation (11%) State inventory tax (4%) Insurance on inventory (5%) Inventory relocation (2%) Inventory obsolescence cost (3%) Fire damage of warehouse inventory (2%) Inventory damage in warehouse (6%) Inventory theft in warchouse (4%) Calculation: The current inventory turnover is times per year. Place the annual ICC and inventory turnover calculated for questions 1 and 2 in the Y column of the table below. Using the data provided in question 1 and the table below, fill in the rest of the table by calculating annual ICC and inventory tumover for the other two inventory strategies. Show calculations. Note: the text in question I uses information for column Y on the next page, when you calculate columns X & Z, some of the information used to calculate Annual ICC and Inventory Turns may change, so be careful and read the table! Column Tablet Sales Units per year Safety Stock Units 500,000 500,000 5,000 500,000 5,000 5,000 Shipments per year (of equal size or quantity) Annual Transport Cost Plus Annual Handling Cost 12 $2,000,000 $4,000,000 S10,000,000 Annual ICC S Inventory Turns Principles: As average inventory increases, ICC (increases, decreases, remains constant) and as average inventory decreases, ICC _ (increases, decreases, remains constant). If annual sales remains constant. as inventory turnover increases, ICC (increases, decreases, remains constant) and as inventory turnover decreases, ICC (increases, decreases, remains constant). Annual ICC S = A x B x C A-[12 (order quantity) + safety stocks] B- is product cost'unit + (transportation & handling cost'unit)] Make sure you are using cost per unit. C- [IcC %'s added together] Tips: Select the crazy eight! Your ICC% should not exceed 40% for this case. Y (base scenario described in the case) A-% (OQ of B- $200/tablet + [S4,000,000 per year/ C= + 5000 0Q is amount warehouse orders and has shipped to them? tablets per year] % same for all scenarios Ax BxC- X (left column) A-% (OQ of B- S200/tablet + [(Annual Transport Cost Plus Annual Handling Cost)/ + 5000 OQ is annual amount divided by shipments per year tablets per year) % same for all scenarios C- AXBXC- Z (right column) A- % (OQ of B- $200/tablet + [(Annual Transport Cost Plus Annual Handling Cost)/ + 5000) OQ is amount warehouse orders and has shipped to them? tablets per year) % same for all scenarios AXBXC- Inventory Turns- Annual Demand /[1/2 x (Order Quantity)] Don't include safety stock for this calculation. Using the detailed formula for ICC and the following information, calculate the annual finished product inventory carrying cost for Apple iPads. (put in table, column Y)) Apple stores the tablets that it produces in its only company field warchouse. The warehouse received one tablet shipment each quarter this year. Each shipment contained 125,000 tablets. The warehouse kept a safety stock of 5,000 tablets. Demand was 125,000 tablets per quarter from retailers. Apple sold the tablets to retailers for $750 each. Apple's variable manufacturing (i.e., production) costs were $200 per tablet. Apple's fixed manufacturing costs averaged $125 per tablet. The transport cost from plant to warehouse location was $3,500,000 per year. The handling costs to receive and store shipments for the year was $500,000. The costs just described for transportation and handling, when combined, equal S4,000,000. Cost data collected (as a percent of inventory value): Cost of capital borrowed to finance inventory (7%) Opportunity cost of capital (10%) Taking inventory (cycle counting) in warehouse (4%) Warehouse manager salary (12%) Annual warehouse depreciation (11%) State inventory tax (4%) Insurance on inventory (5%) Inventory relocation (2%) Inventory obsolescence cost (3%) Fire damage of warehouse inventory (2%) Inventory damage in warehouse (6%) Inventory theft in warchouse (4%) Calculation: The current inventory turnover is times per year. Place the annual ICC and inventory turnover calculated for questions 1 and 2 in the Y column of the table below. Using the data provided in question 1 and the table below, fill in the rest of the table by calculating annual ICC and inventory tumover for the other two inventory strategies. Show calculations. Note: the text in question I uses information for column Y on the next page, when you calculate columns X & Z, some of the information used to calculate Annual ICC and Inventory Turns may change, so be careful and read the table! Column Tablet Sales Units per year Safety Stock Units 500,000 500,000 5,000 500,000 5,000 5,000 Shipments per year (of equal size or quantity) Annual Transport Cost Plus Annual Handling Cost 12 $2,000,000 $4,000,000 S10,000,000 Annual ICC S Inventory Turns Principles: As average inventory increases, ICC (increases, decreases, remains constant) and as average inventory decreases, ICC _ (increases, decreases, remains constant). If annual sales remains constant. as inventory turnover increases, ICC (increases, decreases, remains constant) and as inventory turnover decreases, ICC (increases, decreases, remains constant). Annual ICC S = A x B x C A-[12 (order quantity) + safety stocks] B- is product cost'unit + (transportation & handling cost'unit)] Make sure you are using cost per unit. C- [IcC %'s added together] Tips: Select the crazy eight! Your ICC% should not exceed 40% for this case. Y (base scenario described in the case) A-% (OQ of B- $200/tablet + [S4,000,000 per year/ C= + 5000 0Q is amount warehouse orders and has shipped to them? tablets per year] % same for all scenarios Ax BxC- X (left column) A-% (OQ of B- S200/tablet + [(Annual Transport Cost Plus Annual Handling Cost)/ + 5000 OQ is annual amount divided by shipments per year tablets per year) % same for all scenarios C- AXBXC- Z (right column) A- % (OQ of B- $200/tablet + [(Annual Transport Cost Plus Annual Handling Cost)/ + 5000) OQ is amount warehouse orders and has shipped to them? tablets per year) % same for all scenarios AXBXC- Inventory Turns- Annual Demand /[1/2 x (Order Quantity)] Don't include safety stock for this calculation.
Expert Answer:
Related Book For
Introduction to Chemical Engineering Thermodynamics
ISBN: 978-0071247085
7th edition
Authors: J. M. Smith, H. C. Van Ness, M. M. Abbott
Posted Date:
Students also viewed these accounting questions
-
What do you need to be happy in life?
-
What do you need to know to compute a cash flow's present or future value?
-
What do you need to say to Harlow? What are the likely objections or pushback? What would you say next? To whom, and in what sequence? Assume you were the technical advisory partner for Andersen on...
-
client with celiac disease asks for a nutrition plan, what should the trainer recommend? Refer to a dietician 3-day food log to prescribe meal plan A templated meal plan Give a breakdown of...
-
A certain radio station plays songs from the 70's, 80's, and 90's. We know that 20% of the songs on the station are from the 70's; 37% are from the 80's; and 43% of the songs are from the 90's. Let...
-
Crane Housing PLC has a current ratio of 2.5 and total current assets worth 5 million. Crane housing also has some long-term borrowings where the bank has stipulated that the current ratio of the...
-
The time sheet of a factory showed the following sample data (in hours) on the time spent by a worker operating a hydraulic gear lift:...
-
A 1130-kg car is held in place by a light cable on a very smooth (frictionless) ramp, as shown in Fig. 5.45. The cable makes an angle of31.0° above the surface of the ramp, and the ramp itself...
-
1. What are some elements of a code of ethics for criminology/criminal justice research? The code of ethics sets up the rules and the principles of an organization that leads behavior. It could be...
-
Evaluate the matrix elements (or expectation values) given below. If any vanishes, explain why it vanishes using simple symmetry (or other) arguments. [In (a) and (b), |nlm stands for the energy...
-
ABC has revenues of $22 million and expenses of $15 million.XYZ has revenues of $150 million and expenses of $110 million. Can you determine which company is more efficient from these income...
-
1) You're trying to save to buy a vacation home that will cost $455,000. You have $50,000 today that can be invested at your bank. The bank pays 3.8 percent annual interest on its accounts. How long...
-
Assume your firm has transferred you to Zurich Switzerland. You work in the triangular arbitrage division. View the following exchange rates. Is an arbitrage opportunity available? If not,= explain...
-
Credit cards can be powerful financial tools when used responsibly. They offer convenience, flexibility, and various benefits such as rewards programs, cashback offers, and fraud protection. However,...
-
In late 2 0 X 1 , Smart Co . recorded $ 1 0 , 0 0 0 salary of lab technicians who spent 6 0 % of their time in Smart's own R&D projects and 4 0 % of their time in R&D projects that Smart performed...
-
International Bond has a Macaulay Duration of 6.0, modified duration of 6.5, and Convexity of 50.25. If the bond's yield to maturity decreases by 50 bps, how much will be the expected percentage...
-
Under the Weighted Average perpetual inventory system, given the information below, what would be January's Cost of Goods Sold value? Weighted Average Date Description Units Cost per Unit 1/1...
-
Explain the term "Equivalent Units". Why are they calculated in process costing? [4 Marks] [minimum 350 words]
-
Steam enters the turbine of a power plant operating on the Rankine cycle (Fig. 8.3) at 3,300 kPa anti exhausts at 50 kPa. To show the effect of superheating on the performance of the cycle, calculate...
-
The following isomerization reaction occurs in the liquid phase: A B, where A and B are miscible liquids for which: GE/RT = 0.1 xAxB- If Go298 = -1,000 J, what is the equilibrium composition of the...
-
Riedel proposed a third corresponding-states parameter ac, related to the vapor-pressure curve by; For simple fluids, experiment shows that ac (( 5.8; for non-simple fluids, ac increases with...
-
The following information has been extracted from the financial statements and the notes of Champigon Ltd. Required (a) Calculate the following for 2023 to one decimal place: i. current ratio ii....
-
Comparative figures from the statement of financial position for Warder Ltd are shown below. Required (a) Prepare common size statements for the company for both years, and comment on what this...
-
The following information has been extracted from the financial statements and notes thereto of Bass and Dide Ltd, consultants. Required (a) Calculate the following ratios for 2025: i. return on...
Study smarter with the SolutionInn App