Question: Please use Excel and provide graphs a like will be given for answers thank you so much. 6. [20pts] The bookstore at State University purchases

Please use Excel and provide graphs a like will be given for answers thank you so much.

Please use Excel and provide graphs a like will

6. [20pts] The bookstore at State University purchases from a vendor sweatshirts emblazoned with school name and logo. The vendor sells the sweatshirts to the store for $38 apiece. The cost to the bookstore for placing an order is $120, and the carrying cost is 25% of the average annual inventory value. The bookstore manager estimates that 2,000 sweatshirts will be sold during the year. The vendor has offered the bookstore the following volume discount schedule: Order size Discount (%) 1299 0 300 -499 2 500 799 4 800 ~ 5 (a) Complete the table that shows the prices and carrying costs of the sweatshirts in different order quantities. Order size Price Carrying Cost 1299 38 300 ~499 500 799 800 ~ (b) Determine the optimal order quantity without discount (c) The total annual costs with the order quantity in (a) (d) The total annual costs with the order quantity of 300. (e) The total annual costs with the order quantity of 500. (f) The total annual costs with the order quantity of 800. (g) Based on the results in (b - e), what is the optimal order quantity given the discount schedule

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!