Question: Use the excel file Final_Exam.xlsx, sheet EOQ Model, to answer this question. Alan Wang is responsible for purchasing the paper used in all the copy

Use the excel file Final_Exam.xlsx, sheet "EOQUse the excel file Final_Exam.xlsx, sheet "EOQ

Use the excel file Final_Exam.xlsx, sheet "EOQ Model", to answer this question. Alan Wang is responsible for purchasing the paper used in all the copy machines and laser printers at the corporate headquarters of MetroBank. Alan projects that in the coming year he will need to purchase a total of 24,000 boxes of paper, which will be used at a fairly steady rate throughout the year. Each box of paper costs $50. Alan estimates that it costs $200 each time an order is placed (this includes the cost of placing the order plus the related costs in shipping and receiving). MetroBank assigns a cost of 18% to funds allocated to supplies and inventories because such funds are the lifeline of the bank and could be lent out to credit card customers who are willing to pay this rate on money borrowed from the bank. Alan has been placing paper orders once a quarter, but he wants to determine if another ordering pattern would be better. He wants to determine the most economical order quantity to use in purchasing the paper. Complete sheet "EOQ Model" and find the economic order quantity. Round your answer to the nearest integer. (Hint: add a constraint such that "order quantity" >=1. Starting point: "order quantity"=1)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!