Writing Functions for VBA
$10-30 USD
货到付款
Use the methods in the attached pdf to write all the functions as described in the pdf then follow the steps outlined below.
EOQ Formula
Function get_EOQ(demand As Double, fixedCost As Double, holdingCost As Double) As Double
get_EOQ = Sqr((2 * demand * fixedCost) / (holdingCost / 100))
End Function
That is the first part and most important part. With that, you can write all the other functions
1. Create a workbook which will work out ordering plans for a company such as the electronics store described in Winston’s chapter on The Economic Order Quantity. Your spreadsheet should work with any values, not just the ones given in the problem. It should do the following:
a. Display a form that asks the user for the demand, purchase cost, ordering cost, and carrying (holding) cost expressed as a percentage of purchase cost.
b. Produce a worksheet that reports the optimal order quantity and the frequency at which orders must be placed. It should also show the annual ordering cost, the annual purchase cost, the annual ordering cost, and the total annual cost.
c. On the same worksheet, produce a chart, for which the x-axis is the order quantity, that shows the annual ordering cost, the annual holding cost, and the total annual cost for different values of order quantities.
Add comments your lines on VBA to explain what is been done
项目ID: #12109316
关于项目
有12名威客正在参与此工作的竞标,均价$36/小时
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind o 更多
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y 更多
Hello, I have a lot of experience with similar projects. I am proficient with Excel and VBA and I would love to help you with this project. Please contact me for more information.
I have created many macros in Excel. I will be able to do this one also to you exacting requirements. Please message
Hi, I'm interested in the job. I have rich experience of Excel VBA and can help you complete the job quickly with good quality. Feel free to contact me if any. Regards
Hi! I can complete your project less than in an hour! I'm Excel Expert, so it will be easy for me. Let's discuss your project through chat!
We are a 10 Members Big team. Heaving 5+ Years Experience of Doing Data Scraping, Data Mining, Web Analysis, Typing Job, Word To PDF and PDF to Word Conversion since this time. We are able to Complete the task on ti 更多
Sir, with due respect, i would like to state that i have a very good communication skill, worlwide. and i know around3 languages of the world and i am well trained in SAP(system. application products in data procces 更多