Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show how to do this on excel The bookstore at State University purchases from a vendor sweatshirts emblazoned with the school name and logo.
please show how to do this on excel
The bookstore at State University purchases from a vendor sweatshirts emblazoned with the school name and logo. The vendor sells the sweatshirts to the store for $36 aplece. The cost to the bookstore for placing an order is $110, and the carrying cost is 15% of the purchase price. The bookstore manager estimates that 1,340 sweatshirts will be sold during the year. The vendor has offered the bookstore the following volume discount The bookstore manager wants to determine the bookstore's optimal order quantity, given the foregoing quantity discount information. 1. Determine carrying cost as a percentage of purchase price. 2. With Quantity discounts carrying costs will vary with the the change in price if it computed as a percentage of purchase price 3. Calculate EOQ for each discount price 4. Calculate TC for each EOO 5. What is the bookstore's optimal order quantity Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started