Question

In: Accounting

Fiber Technology, Inc., manufactures glass fibers used in the communications industry. The company's materials and parts...

Fiber Technology, Inc., manufactures glass fibers used in the communications industry. The company's materials and parts manager is currently revising the inventory policy for XL-20, one of the chemicals used in the production process. The chemical is purchased in 10-pound canisters for $107 each. The firm uses 6,000 canisters per year. The controller estimates that it costs $162 to place and receive a typical order of XL-20. The annual cost of storing XL-20 is $5.20 per canister.

Required:

  1. Use the EOQ formula to determine the optimal order quantity.

  2. What is the total annual cost of ordering and storing XL-20 at the economic order quantity?

  3. How many orders will be placed per year?

  4. Fiber Technology’s controller, Jay Turnbull, recently attended a seminar on JIT purchasing. Afterward he analyzed the cost of storing XL-20, including the costs of wasted space and inefficiency. He was shocked when he concluded that the real annual holding cost was $31.20 per canister. Turnbull then met with Doug Kaplan, Fiber Technology’s purchasing manager. Together they contacted Reno Industries, the supplier of XL-20, about a JIT purchasing arrangement. After some discussion and negotiation, Kaplan concluded that the cost of placing an order for XL-20 could be reduced to just $32. Using these new cost estimates, Turnbull computed the new EOQ for XL-20 a. Use the equation approach to compute the new EOQ.b. How many orders will be placed per year?

1.Use the EOQ formula to determine the optimal order quantity. (Round your answer to nearest whole number.)

2.What is the total annual cost of ordering and storing XL-20 at the economic order quantity? (Round intermediate calculations and final answer to nearest whole number.)

3.How many orders will be placed per year? (Round intermediate calculations and final answer to nearest whole number.)

4. Fiber Technology’s controller, Jay Turnbull, recently attended a seminar on JIT purchasing. Afterward he analyzed the cost of storing XL-20, including the costs of wasted space and inefficiency. He was shocked when he concluded that the real annual holding cost was $31.20 per canister. Turnbull then met with Doug Kaplan, Fiber Technology’s purchasing manager. Together they contacted Reno Industries, the supplier of XL-20, about a JIT purchasing arrangement. After some discussion and negotiation, Kaplan concluded that the cost of placing an order for XL-20 could be reduced to just $32.00. Using these new cost estimates, Turnbull computed the new EOQ for XL-20.

a. Use the equation approach to compute the new EOQ. (Round your answer to nearest whole number.)
b. How many orders will be placed per year? (Round your answer to nearest whole number.)

Solutions

Expert Solution

As per the demand of the question :-

PURCHASER :- FIBER TECHNOLOGY INC...,

RAW MATERIAL :- XL-20 a chemical.

(1) Determining optimal order quantity :-

EOQ = It is the level of the order with carrying cost and ordering cost at optimum level.

Components to ascertain EOQ are as follows  

Annual Demand (A) = 6000 cisterns ; Delivery cost to receive an order = $162 ; annual cost storing each cistern = $5.2.

EOQ = Square root of { 2x6000x$162 / $5.2 } ;

= square root of { 373846.153846} ;

= 611.429598

= 611 .{ being rounded off to nearest whole number. }

Therefore ,optimal order quantity = 611 cisterns.

(2)  What is the total annual cost of ordering and storing XL-20 at the economic order quantity?

Ans :- Total annual cost of ordering = {Annual demand/EOQ} x delivery cost ;

= {6000/611} X $162

= $ 1590.83469721

= $ 1591. { being rounded off to nearest whole number. }

Total cost of storing = {EOQ/2 } X Annual handling cost per cistern.

= {611/2 } x $ 5.2

= $1680.25

= $1680 { being rounded off to nearest whole number }.

3.How many orders will be placed per year? (Round intermediate calculations and final answer to nearest whole number.)

Ans) Number of orders per annum = Total annual demand of cisterns / Size of each order (here EOQ).

= 6000/611

= 9.81996

= 10 { being rounded off to nearest whole number.}

(4) Calculation of New EOQ i.e revised EOQ.

Annual demand = 6000; ordering cost = $32; carrying cost = $ 5.2.

New EOQ = square root of { annual demand x ordering cost. } / carrying cost ;

= square root of { 6000 x $32 / $ 5.2} ;

= square root of { 36923.076923};

= 192.1537

= 192 cisterns . { being rounded to nearest whole number.}

(4B) How many orders will be placed per year? (Round your answer to nearest whole number.)

Ans:- No.of orders per year = total demand per annum / EOQ;

= 6000 cisterns / 192

= 31.25

= 31 cisterns . { being rounded off to nearest whole number.


Related Solutions

Fiber Technology, Inc., manufactures glass fibers used in the communications industry. The company's materials and parts...
Fiber Technology, Inc., manufactures glass fibers used in the communications industry. The company's materials and parts manager is currently revising the inventory policy for XL-20, one of the chemicals used in the production process. The chemical is purchased in 10-pound canisters for $103 each. The firm uses 5,200 canisters per year. The controller estimates that it costs $158 to place and receive a typical order of XL-20. The annual cost of storing XL-20 is $4.80 per canister. Now also assume...
FIBER REINFORCED CONCRETE Explain the use of the following fibers: a) Steel b) Glass c) Natural...
FIBER REINFORCED CONCRETE Explain the use of the following fibers: a) Steel b) Glass c) Natural d) Polymer e) Asbestos f) Carbon
Maximin Ltd manufactures parts that are used as components by car manufacturers. All of their materials...
Maximin Ltd manufactures parts that are used as components by car manufacturers. All of their materials are imported. The following information from last year is shown below: Budget Actual Units 375,000 350,000 £ ‘000s £ ‘000s Sales 28,125 28,000 Variable Costs Materials 5,625 5,600 Labour 1,875 1,575 Distribution 1,125 1,085 Total Variable Costs            8,625 8,260 Contribution 19,500 19,740 Fixed Costs Quality control          210 170 Premises 4,000 4,120 Administration 2,500 2,400 Total Fixed Costs 6,710 6,690 Operating Profit 12,790 13,050 Required:...
Maximin Ltd manufactures parts that are used as components by car manufacturers. All of their materials...
Maximin Ltd manufactures parts that are used as components by car manufacturers. All of their materials are imported. The following information from last year is shown below: Budget Actual Units 375,000 350,000 £ ‘000s £ ‘000s Sales 28,125 28,000 Variable Costs Materials 5,625 5,600 Labour 1,875 1,575 Distribution 1,125 1,085 Total Variable Costs            8,625 8,260 Contribution 19,500 19,740 Fixed Costs Quality control          210 170 Premises 4,000 4,120 Administration 2,500 2,400 Total Fixed Costs 6,710 6,690 Operating Profit 12,790 13,050 Required:...
Define wearable technology. Identify the major hardware, software and communications components of Google Glass. What are...
Define wearable technology. Identify the major hardware, software and communications components of Google Glass. What are some of the advantages of using Google Glass, and how will they add value to a customer’s life? What are the major risks associated with Google Glass?
Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer and telecommunications industries. At the...
Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer and telecommunications industries. At the request of the company vice president of marketing, the cost management staff has recently completed a customer-profitability study. The following activity-based costing information was the basis for the analysis. Chapter 5 Activity-Based Costing and Management 225hiL6956X_ch05_168-229.indd 225 06/17/16 08:10 PMRequired: 1. Prepare a customer profitability analysis for Trace Telecom and Caltex Computer. (Hint: Refer to Exhibit 5–13 for guidance.) 2. Build a spreadsheet: Construct...
Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer and telecommunication industries. At the...
Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer and telecommunication industries. At the request of the company VP of marketing, the cost management staff has recently completed a customer- profitability study. The following activity-based costing information was the basis for the analysis. Customer - Related Activities Cost Driver Base Cost Driver Rate Sales activity Sales visits $860 Billing and Collection Invoices 160 Order taking Purchase orders 220 Special shipping Shipments 430 Customer - Related Activities Trace Telecom...
Opticom, Inc. a manufacturer of fiber optic communications equipment, uses a job-order costing system. Since the...
Opticom, Inc. a manufacturer of fiber optic communications equipment, uses a job-order costing system. Since the production process is heavily automated, manufacturing overhead is applied on the basis of machine hours using a predetermined overhead rate. The current annual rate of $15 per machine hour is based on budgeted manufacturing overhead costs of $1,200,000 and a budgeted activity level of 80,000 machine hours (the company’s estimated practical capacity). Operations for the year have been completed, and all of the accounting...
Revised Problem 5-65 Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer and telecommunications...
Revised Problem 5-65 Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer and telecommunications industries. At the request of the company VP of marketing, the cost management staff has recently completed a customer profitability study. The following activity-based costing information was the basis for the analysis. Customer - Related Activities Cost Driver Base Cost Driver Rate Sales activity Sales visits $        860 Billing and Collection Invoices 160 Order taking Purchase orders 220 Special shipping Shipments 430 Customer -...
A bill of materials is used in manufacturing and production to show all of the parts...
A bill of materials is used in manufacturing and production to show all of the parts and materials required to manufacture a specific item or for the subassembly of a finished product, such as a motorcycle. The information in the bill of materials is useful for determining product costs, coordinating orders, and managing inventory. It can also show how product costs will be affected by price changes in components or raw materials. This project provides you with an opportunity to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT