Sims Hardware sells wood pellets used in heating stoves and slow-cook grills.
ACT 570 University Arizona Global Campus Accounting Cost Worksheet
EOQ FOR A RETAIL COMPANY: SIMS HARDWARE
Sims Hardware sells wood pellets used in heating stoves and slow-cook grills. The supplier for the pellets pays all incoming freight. Following is detailed data collected regarding pellet inventory needs:
Annual demand for wood pellets
65,000 lbs.
Ordering cost per purchase order
$120
Carrying cost per year
15% of purchase costs
Safety-stock requirements
none
Cost of wood pellets
$4 per 40 lb bag
The purchasing lead time is three weeks. Sims Hardware is open 240 days a year (48 weeks for 5 days a week).
Required:
Calculate the EOQ for wood pellets.
Calculate the number of orders that will be placed each year.
Calculate the reorder point for wood pellets.
Follow the instructions you see on the Data tab of the worksheet. Show all calculations within the cells of the Excel spreadsheet (found in Module 6 or by clicking “Next” at the bottom of this page). This means that you must use formulas and links so that your thought process can be examined.
Review the grading rubric to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.
Submit your downloaded and completed Excel file with your name added to the file name for grading by your instructor to
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
