Question

In: Accounting

A company purchases 86 400 items per year for use in its production process. If the...

A company purchases 86 400 items per year for use in its production process. If the unit cost is $9.25, the holding cost for one unit is 60 cents per month, and the cost of making a purchase is $540, determine the following if no shortages are allowed:

(i) The optimum order quantity.  

(ii) The optimum total yearly cost.

(iii) The number of orders per year.  

(iv) The time between orders.  

(b) Suppose they plan to now allow backorders which they estimate at a cost of 20 cents per unit per month. If all other costs are the same determine:

(i) The optimum order quantity and the maximum inventory level.

(ii) The optimum total yearly cost.

(iii) The maximum shortage that will occur.

(iv) The proportion of time that shortages will occur.

Solutions

Expert Solution

Solution:

Annual Purcahsed Quantity = 86,400 Units

Ordering Cost per order = $540

Carrying Cost per unit per annum = Unit Cost * 60% * 12 = $9.25*60%*12 = $66.60

(i) Optimum Order QUantity = ((Annual Purchased Quantity x 2 x Ordering Cost per order) / Carrying cost per unit per annum)1/2

= ((86,400*2*540)/66.60)1/2

= 1183.67 Units or 1184 Units

(ii) Optimum Total Yearly Cost = Cost of Purcahsed + Total Ordering Cost + Total Carrying Cost

= (86,400*9.25) + (Number of Orders 86,400 / 1184 * 540) + (1/2*1184*66.6)

= $878,033

(iii) Number of Orders Per Year = Total Purcahsed QUantity / Optimum order quantity

= 86,400 / 1184

= 72.97 or 73 orders

(iv) Time between orders

Assumed a year = 365 days

Time between orders = Days in a year / Number of Orders = 365 / 73 = 5 days

Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you

Pls ask separate question for remaining parts.


Related Solutions

A company uses 1,000 electric drills per year in its production process. The ordering cost is...
A company uses 1,000 electric drills per year in its production process. The ordering cost is $100 per order, and the carrying cost is assumed to be 40% of the unit cost. In orders of less than 120, drills cost $78 per unit; for orders of 120 or more, the price drops to $50 per unit. Find the best ordering quantity for this product Please show excel formulas and solver. Thank you.
An investor purchases 400 shares of Company A at $55 per share.Suppose that the investor...
An investor purchases 400 shares of Company A at $55 per share. Suppose that the investor finances $8,500 of their investment with a margin loan at 7% interest. If the price of one share of Company A falls to $50 in a year, what is the investor’s rate of return?(Do not round intermediate calculations.Negative values should be indicated by a minus sign. Round your answer to 2 decimal places.)An investor purchases 400 shares of Company A at $55 per share....
Car Parts Company manufactures a part for use in its production of automobiles. The costs per...
Car Parts Company manufactures a part for use in its production of automobiles. The costs per unit when 10,000 items are produced are: Direct materials $6 Direct manufacturing labour 30 Variable manufacturing overhead 12 Fixed manufacturing overhead 16 Total $64 Auto Company has offered to sell to Car Parts Company 10,000 units of the part for $60. The plant facilities could be used to manufacture another part at a savings of $90,000 if Car Parts accepts the offer. In addition,...
Acct 301B: On 9/2, a company purchases 400 shares of its own stock at $14. It...
Acct 301B: On 9/2, a company purchases 400 shares of its own stock at $14. It resells 200 shares at $15 on 9/3 and purchases an additional 300 shares on 9/4 at $14. On 9/5 the company resells 450 shares at $9. Q.23/ What is the entries made on dates? Q.24/ Assume instead that on 9/2 and 9/4 the company purchased its stock at $15. What is the entry? What would happen to Retained Earnings on 9/5?
Question In a food production process, packaged items are sampled as they come off a production...
Question In a food production process, packaged items are sampled as they come off a production line: a random sample of 5 items from each production batch is checked to see if each is tightly parked. A batch is accepted if all 5 sample items are satisfactory, and rejected if there are 3 or more unsatisfactory packages in it; otherwise a further sample is taken before making a decision. If in fact the packing machine is giving 80% of items...
Mother Hubbard Company purchases 8,000 units of a part that it needs for production of its...
Mother Hubbard Company purchases 8,000 units of a part that it needs for production of its product. Notification has just been received from the supplier that a price increase will take effect shortly, which will bring the price of each part to $25. Mother Hubbard Company is considering using some idle facilities to produce the part. The production costs to produce the needed 8,000 parts are as follows: Direct materials $17,500 Direct labor 30,000 Variable factory overhead 14,000 Fixed factory...
Tyler Company has the following information related to purchases and sales of one of its inventory items.
Inventory Costing MethodsTyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory400 units @ $16Sept. 10Purchase600 units @ $18Sept. 20Sales690 units @ $31Sept. 25Purchase800 units at $19Assume the company uses a perpetual inventory system.Required:Calculate ending inventory and cost of goods sold using the FIFO, LIFO, and average cost methods.FIFOLIFOAvg CostCost of goods sold$fill in the blank 1$fill in the blank 2$fill in the blank 3Ending...
On January 1, 2020, Pele Industries purchased a machine for use in its production process. Its...
On January 1, 2020, Pele Industries purchased a machine for use in its production process. Its cash price was R$35,000. Related expenditures included: sales tax R$2,200, shipping costs R$150, insurance during shipping R$80, installation and testing costs R$70, and R$100 of oil and lubricants to be used with the machinery during its first year of operations. Provide the journal entry to record the purchase of this machine on January 1, 2020.
The company produces one type of product. Its production volumes per year are 24 thousand. pcs....
The company produces one type of product. Its production volumes per year are 24 thousand. pcs. The production department employs four workers, who are paid 6 euros for each product produced. Each worker produces 6 thousand. pcs. products per year. The annual salary of the administration staff consists of 15,000 Eur. The raw materials required for the production of one product cost 5 Eur., And additional materials for one product - 1 Eur. The company uses machines in the production...
The company produces one type of product. Its production volumes per year are 24 thousand. pcs....
The company produces one type of product. Its production volumes per year are 24 thousand. pcs. The production department employs four workers, who are paid 6 euros for each product produced. Each worker produces 6 thousand. pcs. products per year. The annual salary of the administration staff consists of 15,000 Eur. The raw materials required for the production of one product cost 5 Eur., And additional materials for one product - 1 Eur. The company uses machines in the production...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT