# minimum Annual Total Cost

I need to model and solve this problem using Excel spreadsheets. I need to be able to understand how to derive the answer. So, I need to see the formulas and the step by step approach so I can see how it was done and learn/understand for future exercises.

It's very important that I'm able to see the work involved so I can learn how this was done. Please take me through the step by step procedures to solve this problem including any math and especially the formulas involved in the spreadsheets.

I was able to figure out the formula and design the spreadsheet for part (a) (attached). That is as far as my level of knowledge takes me.

Please use the attached Excel spreadsheet to solve the problem.

The problem is in the attached Word document.

Thank you for helping me.

© BrainMass Inc. brainmass.com October 9, 2019, 5:40 pm ad1c9bdddfhttps://brainmass.com/economics/production/minimum-annual-total-cost-64109

#### Solution Preview

From the EXCEL spreadsheet, we find that the minimum Annual Total Cost a minimum is $56,370 when lot size is 1000.

Assistance Required: I need to model and solve this problem using Excel spreadsheets. I need to be able to understand how to derive the answer. So, I need to see the formulas and the step by step approach so I can see how it was done and learn/understand for future exercises.

It's very important that I'm able to see the work involved so I can learn how this was done. Please take me through the step by step procedures to solve this problem including and math and especially the formulas involved in the spreadsheets.

I was able to figure out the formula and design the spreadsheet for part (a) (attached). That is as far as my level of knowledge takes me.

Economic Order Quantity

(a) Creating the spreadsheet:

A particular raw material is available to a ...

#### Solution Summary

The expert determines minimum Annual Total Cost.