Question: please use excel and excel functions PROBLEM H2 (Prepare an Excel spreadsheet to solve the problem) The 21,000-seat Air East Arena houses the local professional
PROBLEM H2 (Prepare an Excel spreadsheet to solve the problem) The 21,000-seat Air East Arena houses the local professional ice hockey, basketball, indoor soccer, and arena football teams as well as various trade shows, wrestling and boxing matches, tractor pulls, and circuses. Arena vending annually sells large quantities of soft drinks and beer in plastic cups with the name of the arena and the various team logos on them. The local container cup manufacturer that supplies the cups in boxes of 100 has offered arena management the following discount price schedule for cups: The annual demand for cups is 2,600,000, the annual carrying cost per box of cups is $9.50, and ordering cost is $300. Setup an Excel worksheet and determine the optimal order quantity and the annual inventory cost. Provide a short discussion on your results
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
