Reference no: EM132247093
Please Help. Please do NOT use excel. Please do NOT show in excel. Please SHOW ALL WORK INCLUDING FORMULAS. Please keep the problem VERY organized. Do NOT show by handwriting please type it out. For Part B. Please use Maximum Inventory formula and Average inventory formula.
A restaurant purchases paper napkins in packages of 1000. Demand for napkins at this restaurant is about 1,215 packages a year. It costs $10 to order and receive a shipment of napkins, and carrying costs per package are $75 per year.
a. What is the optimal order quantity for packages of napkins, to the nearest whole number?
Economic order quantity bags
b. What is the average number of packages of napkins in inventory, to the nearest whole number?
Average number of bags
c. How times will the restaurant order napkins per year (to the nearest whole number)?
Number of orders per year
d. Compute the total of ordering and carrying costs for napkins. (Round to the nearest whole number, but do not type the dollar sign.)
Total cost $
e. Calculate the change in total annual cost, if per-package holding costs went up by $9 per year. (Round your intermediate calculations to 2 decimal places and final answer to 2 decimal places, but do not type the dollar sign.)
Increase by $