Explore BrainMass
Share

# minimum Annual Total Cost

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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.

The problem is in the attached Word document.

Thank you for helping me.

https://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