Question: Please calculate total annual cost step by step by using a formula TC = CD + (D/Q)S + (Q/2)hC for each product Cz = Cm=Ch

Please calculate total annual cost step by step

Please calculate total annual cost step by step by using a formula TC = CD + (D/Q)S + (Q/2)hC for each product

Cz = Cm=Ch = $500; h=0.2 Litepro Medpro Heavypro Demand per year D; 12,000 1,200 120 Fixed cost/order S+s; S=$4,000 $5,000 $5,000 $5,000 Optimal order size 1,095 346 110 548 173 55 Cycle inventory Annual holding cost Order frequency n;" $54,772 $17,321 A $5,477 11.0/year 3.5/year 1.1/year Annual ordering cost $54,772 $17,321 $5,477 Average flow time 2.4 weeks 7.5 weeks 23.7 weeks Annual cost $109,544 $34,642 $10,954

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!

Condo Info Condo Listing Price Today MA Transfer Tax (paid by seller) Closing Fee (paid by both buyer and seller at purchase) Condo Fee (monthly) Property Tax (annual) Maintainness Fee if buy the...

Using your results from Macheys Cameros with Quantity Discounts - templote.xisx as a base, create a copy of your Excel file and name it 'Inventory assignment - xxx ' where ' x ' x ' Is your name....

ALL SHADED BOXES MUST BE FILLED IN USING EXCEL 2 * Note that the decision variable, Annual Number of Joint Orders, should be initialized at 1 for better SOLVER performance. A SOLVER constraint should...

Condo Info Condo Listing Price Today MA Transfer Tax (paid by seller) Closing Fee (paid by both buyer and seller at purchase) Condo Fee (monthly) Property Tax (annual) Maintainness Fee if buy the...

Condo Listing Price Today Condo Info Mortgage Info $320,000 0.456% Down Payment 10% Annual Interest Rate $3,000 Monthly Interest Rate 4.50% 0.36748% $430 Amortization Time (year) 30 $4,200 Your...

A firm can produce its own brand or purchase a generic brand. If they produce, there is a production setup cost of $ 1 5 0 0 and the finished product costs $ 7 0 0 a unit. The production rate is 4 0...

Explain with Excel screenshots! (Thousands ) December 31, 2019 December 31, 2018 500 450 30 20 Costs of goods sold Inventories: Supplies Raw Materials Work in Process Finished Goods 36 45 25 10 15 10...

Suppose that on December 21 the long range weather forecast was released by the weather service and more snow than normal is predicted. As a result, the Marketing Dept raises their forecast for...

52. match the following intrauterine infections with the characteristic clinical picture 1.Intracranial clacification, microcephaly, SNHL a.Parvovirus 2.Cutaneous lesions, limb defect, cortical b.CMV...

Prepare the necessary entries from 1/1/10-2/1/12 for the following events using the fair value method. If no entry is needed, write "No Entry Necessary." 1. On 1/1/10, the stockholders adopted a...

The Probate Process Which of the following does the probate process assume? Check all that apply. Creditors are satisfied. A testator is appointed. Assets are distributed to the appropriate...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...