Arizona ACT570 Accounting Cost Worksheet

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:

The purchasing lead time is three weeks. Sims Hardware is open 240 days a year (48 weeks for 5 days a week).

Required:

1. Calculate the EOQ for wood pellets.
2. Calculate the number of orders that will be placed each year.
3. 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