Question: please use excel, show your work...no hand written Your distribution company has an annual demand of 1,400 lawn mowers. The cost of a lawn mower

please use excel, show your work...no hand written

Your distribution company has an annual demand of 1,400 lawn mowers. The cost of a lawn mower is $400. Carrying cost is estimated to be 20% of unit cost, and the ordering cost is $25 per order. If you order in quantities of 330 or more, you can get a 5% discount. Do a complete "EOQ with Discount" calculation and determine the optimal order quantity. Please show all calculations

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!

please use excel, show your work...no hand written Your distribution company has an annual demand of 1,400 lawn mowers. The cost of a lawn mower is $400. Carrying cost is estimated to be 20% of unit...

4. Your distribution company has an annual demand of 1,400 lawn mowers. The cost of a lawn mower to you is $400. Carrying cost is estimated to be 20% of unit cost, and the ordering cost is $25 per...

Your distribution company has an annual demand of 1,400 lawn mowers. The cost of a lawn mower is $400. Carrying cost is estimated to be 20% of unit cost, and the ordering cost is $25 per order. If...

Your distribution company has an annual demand of 1,400 lawn mowers. The cost of lawn mowers to you is $400. Carrying cost is estimated to be 20% of unit cost, and the ordering cost is $25 per order....

Your distribution company has an annual demand of 1,400 lawn mowers. The cost of a lawn is $400. Carrying cost is estimated to be 20% of unit cost, and the ordering cost is $25 per order. If you...

please use excel don't make it too long. Thanks Granboy Ud produces a line of Canadun lawn mowers for both domestic sales and effort to deal with the highly seasonal nature of its demand. Grasshov...

Please use Excel and show formulas for 1,2,& 3 Having been involved with more than a few of these kinds of proposals before, the head of the design team, Matt Robichek, knew that he had better take...

Discussion Questions: (see attachment for information) 1. Develop a forecast to use as a basis for sales and Operations Planning. 2. Develop a S&OP plan by month for fiscal year 2015. Consider the...

PLEASE HELP! As much info as you can give would be great thank you! 1. Review the forecast in Exhibit 3. Does it seem reasonable, based on the past demand and input from the marketing department?...

Question Given: f(x)=(x+2)(x - 6x +9) =x-4x-3x+18 9.1 9.2 9.3 Calculate the coordinates of the turning points of the graph of f Sketch the graph of f. clearly indicating the intercepts with the axes...

What is best represented by each heading on the outside of the punnett squares A). The alleles for one gene in a possible zygote (formed by combining of two gametes) B). The alleles for one gene in...

Question 7 of 4 0 - 2 . 5 View Policies Current Attempt in Progress Which of the following is true of accounting for changes in estimates? Changes in estimates are not carried back to adjust prior...

We are evaluating a project that costs $872,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight- line to zero over the life of the project. Sales are projected...