Question

Please use "Excel" formulas to solve these problems. Annual demand for the notebook binders that Ted’s...

Please use "Excel" formulas to solve these problems.

Annual demand for the notebook binders that Ted’s Stationery Shop sells is 10,000 units. Ted operates his business on a 200-workday year. The unit cost of a binder is $2, and the cost of placing an order with his supplier is $0.40. The cost of carrying a binder in stock for one year is 10 percent of its value

a. What should the EOQ be?
b. How many orders are placed per year?
c. How many working days elapse between reorders?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use...
Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use cell references to the input data. I will change the input data in your problem to check alternate solutions. You will turn in a complete working Excel spreadsheet with your solution. 1)     What is the price of a semiannual $1,000 par value bond with four years left until maturity that pays a coupon of 3.75% and is yielding 5.25%? What would it be yielding...
Chris Froome is a purchasing agent for a firm that sells components for high-performance bicycles. One...
Chris Froome is a purchasing agent for a firm that sells components for high-performance bicycles. One of the most popular components is the TDF bicycle frame which has an annual demand of 1,750 units. The cost of each frame is $675 and the inventory carrying cost is estimated to be 18% of the cost of each frame. Chris has made a study of the costs involved in placing an order for any of the frames the firm stocks, and he...
Solve in ExcelQM Barbara Bright is the purchasing agent for West Valve Company. West Valve sells...
Solve in ExcelQM Barbara Bright is the purchasing agent for West Valve Company. West Valve sells industrial valves and fluid control devices. One of the most popular valves is the Western, which has an annual demand of 4,000 units. The cost of each valve is $90, and the inventory carrying cost is estimated to be 10% of the cost of each valve. Barbara has made a study of the costs involved in placing an order for any of the valves...
*** Please show excel formulas, thanks *** Babaloo leather company produces briefcases from leather, fabric, and...
*** Please show excel formulas, thanks *** Babaloo leather company produces briefcases from leather, fabric, and synthetic materials in a single production department. The basic product is a standard briefcase made from leather and lined with fabric. Babaloo has a good reputation in the market because the standard briefcase is a high-quality item that has been produced for many years. Last year, the company decided to expand its product line and produce specialty briefcases for special orders. These briefcases differ...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...