question archive Tim Madsen is the purchasing agent for Computer Center, a large discount computer store
Subject:StatisticsPrice:2.87 Bought7
Tim Madsen is the purchasing agent for Computer Center, a large discount computer store. He has recently added the hottest new computer, the Power model, to the store's stock of goods. Sales of this model now are running at about 13 per week. Tim purchases these computers directly from the manufacturer at a unit cost of $3,000, where each shipment takes half a week to arrive. Tim routinely uses the basic EOQ model to determine the store's inventory policy for each of its more important products. For this purpose, he estimates that the annual cost of holding items in inventory is 20% of their purchase cost. He also estimates that the administrative cost associated with placing each order is $75. use the analytical version of the Excel template for the basic EOQ model (which applies the square root formula) to find the optimal order quantity. Compare the results (including the various costs) with those obtained in part c.
please use this google drive link to download the answer file.
https://drive.google.com/file/d/1BnpVkLuf78LUtXatN0kCZsPgBx3G3qkH/view?usp=sharing
note: if you have any trouble in viewing/downloading the answer from the given link, please use this below guide to understand the whole process.
https://helpinhomework.org/blog/how-to-obtain-answer-through-google-drive-link