Suppose that sales for a shirt are 900 units per month. It costs $60 to generate...

1) Calculate the optimal lot size to purchase.

2) How frequently should an order be placed throughout the year?

3) Calculate the annual order cost

4) Calculate the annual carrying cost

5) Find the total cost

Solutions

Expert Solution

Monthly demand = 900 units

Annual demand (D) = Monthly demand × 12 months = 900 × 12 = 10800 units

Ordering cost (S) = $60

Holding cost (H) = 8% of unit cost = 8% of $14 = $1.12

1) Optimal order quantity (Q) = √(2DS/H)

= √[(2 × 10800 × 60)/1.12]

= √(1296000/1.12)

= √1157142.8571

= 1075.71 or rounded to 1076 units

2) Number of orders per year = D/Q = 10800/1076 = 10.04

3) Annual ordering cost = (D/Q)S = (10800/1076)60 = $602.23

4) Annual carrying cost = (Q/2)H = (1076/2)1.12 = $602.56

5) Total cost = Annual ordering cost + Annual carrying cost

= $602.23 + $602.56

= $1204.79

keosha answered 2 years ago

Next > < Previous

Related Solutions

Suppose that sales for a shirt are 900 units per month. It costs $60 to generate...

Suppose that sales for a shirt are 900 units per month. It costs $60 to generate an order. The item to be ordered has a unit cost of $14 and the inventory holding ratio is 8%. Find the answers to the following questions. 1. Calculate the optimal lot size to purchase 2. How frequently should an order be placed throughout the year? 3. Calculate the annual order cost. 4. Calculate the annual carrying cost 5. Find the total cost.

It costs Mills, Inc. $9 per unit to manufacture 2,000 units per month of a product...

It costs Mills, Inc. $9 per unit to manufacture 2,000 units per month of a product that it can sell for $38 each. Alternatively, Mills could process the units further into a more complex product, which would cost an additional $22 per unit. Mills could sell the more complex product for $59 each. How would processing the product further affect Mills' profit?. If a decrease, place a –sign in front of your answer. Duncan Inc. has two divisions, Parker and...

A 5-year project is expected to generate annual sales of 9,600 units at a price of $83 per

A 5-year project is expected to generate annual sales of 9,600 units at a price of $83 per unit and a variable cost of $54 per unit. The equipment necessary for the project will cost $373,000 and will be depreciated on a straight-line basis over the life of the project. Fixed costs are $225,000 per year and the tax rate is 22 percent. How sensitive is the operating cash flow to a $1 change in the per unit sales price?

Given Sales in units 10,000 Variable manufacturing costs per unit 5 Variable administrative costs per unit...

Given Sales in units 10,000 Variable manufacturing costs per unit 5 Variable administrative costs per unit 2 Fixed manufacturing costs per unit 2 Fixed administrative costs per unit 1 Variable costs 75% of sales Selling price per unit? $2.22 $9.33 $17.50 $20 Given for XM Company the following data for January 20X1. Direct material purchased and used in production accounted for $ 50000 Units purchased 5000 The standard units 4200 Managers estimate price variance not to exceed +1% of the...

The equilibrium price in this market is _ per shirt, and the equilibrium quantity is _ shirts bought and sold per month.

The equilibrium price in this market is _______ per shirt, and the equilibrium quantity is _______ shirts bought and sold per month. Complete the following table by indicating at each price whether there is a shortage or surplus in the market, the amount of that shortage or surplus, and whether this places upward or downward pressure on prices.

Selling price is $15 per unit Sales by month: April 25,000 units May 50,000 units June...

Selling price is $15 per unit Sales by month: April 25,000 units May 50,000 units June 40,000 units July 30,000 units August 20,000 units Cash Collections 60% collected in month of sale 40% collected in the month after sale Accounts receivable at the end of March is $25,000 and it will be collected in April Production Budget Ending inventory is 25% of next month’s budgeted sales On March 31st there were 5,000 units on hand Direct Materials Budget 5 pounds...

Problem 2 Total Per Unit Percent of Sales Sales (40,000 units) 2,400,000 60 100% Variable expenses...

Problem 2 Total Per Unit Percent of Sales Sales (40,000 units) 2,400,000 60 100% Variable expenses 1,600,000 40 ? % Contribution margin 800,000 ? % Fixed expenses 500,000 Net operating income 300,000 Calculate variable expense ratio. Calculate contribution margin ratio. Calculate break even sales in units (show your work). Calculate break even sales in Dollars. How many units must be sold to make a profit of SAR 200,000. Management is considering increasing quality of its units by spending SAR 3...

CVP Analysis Data Unit sales 20,000 units Selling price per unit $60 per unit Variable...

CVP Analysis Data Unit sales 20,000 units Selling price per unit $60 per unit Variable expenses per unit $45 per unit Fixed expenses $240,000 Enter a formula into each of the cells marked with a ? below Review Problem: CVP Relationships Compute the CM ratio and variable expense ratio Selling price per unit ? per unit Variable expenses per unit ? per unit Contribution margin per unit ? per unit CM ratio ? Variable expense ratio ? Compute the...

The total fixed cost is $60 per month. (a) If the price pervisit is $60,...

The total fixed cost is $60 per month. (a) If the price per visit is $60, at what level of visits will the maximum profit position be? (b) What are the profits at this level?(c) What is the quantity supplied? (d) If the total fixed cost increases to $80 and the price per visit is $60, what is the quantity supplied (assuming maximizing profits)?quantity per visits supplied:1,2,3,4,5,6,total variable cost: 20,50,90,140,210,290

Rickard Enterprises—March Budget FACTS Total Sales per Quarter (sales are even per month) Quarter Units Price/Unit...

Rickard Enterprises—March Budget FACTS Total Sales per Quarter (sales are even per month) Quarter Units Price/Unit Q1 4,200 $18 Q2 6,600. $21 Q3 5,900 $20 Q4 9,700 $22 March Inventory Beginning Desired Ending Raw materials inventory (in lbs.) 1,120 1,760 Raw materials inventory (in $) $8,960 $14,080 Finished goods (FG) inventory (in units) 280 440 Finished goods inventory (in $) $41,500 $34,500 20% (safety stock desired) Other Information: Pounds of materials needed to produce each unit of FG 4...

Subjects