An office supply company is attempting to determine the order quantity for laser printer toner cartridges...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
An office supply company is attempting to determine the order quantity for laser printer toner cartridges which are sold to local Annual demand is 20,000 units and each cartridge costs the store $25. It costs $30 to place an order and the inventory carrying cost rate is 25% of the value of the item. The following spreadsheet has been set up to solve the problem. What formula goes in cell B11 in this problem? 1 3 Annual Demand: 20,000 4 $25 Cost per Unit Ordering Cost Carrying Cost $30 25% 8. Order Quantity 483.73 10 11 Total Cost $502,738.61 =B3'B7+B9/B3'B6+B9'2+B5'B7 -B3'B5+B3/B9 B6+B9/2'B5*B7 O -SQRT(B3'B5+B3/B9 B6+B9/2 B5'B7) -B3'B3+B3/B9+B6*B9/2'B5*B7 An office supply company is attempting to determine the order quantity for laser printer toner cartridges which are sold to local Annual demand is 20,000 units and each cartridge costs the store $25. It costs $30 to place an order and the inventory carrying cost rate is 25% of the value of the item. The following spreadsheet has been set up to solve the problem. What formula goes in cell B11 in this problem? 1 3 Annual Demand: 20,000 4 $25 Cost per Unit Ordering Cost Carrying Cost $30 25% 8. Order Quantity 483.73 10 11 Total Cost $502,738.61 =B3'B7+B9/B3'B6+B9'2+B5'B7 -B3'B5+B3/B9 B6+B9/2'B5*B7 O -SQRT(B3'B5+B3/B9 B6+B9/2 B5'B7) -B3'B3+B3/B9+B6*B9/2'B5*B7
Expert Answer:
Related Book For
Intermediate Accounting
ISBN: 978-1118147290
15th edition
Authors: Donald E. Kieso, Jerry J. Weygandt, and Terry D. Warfield
Posted Date:
Students also viewed these finance questions
-
The controller for Clair Co. is attempting to determine the amount of cash to be reported on its December 31, 2014, balance sheet. The following information is provided. 1. Commercial savings account...
-
The controller for Wallaby plc is attempting to determine the amount of cash and cash equivalents to be reported on its December 31, 2019, statement of financial position. The following information...
-
The production manager of Videotechnics Company is attempting to determine the upcoming 5-month production schedule for video recorders. Past production records indicate that 2,000 recorders can be...
-
Discuss why you would or would not like to work in an organization like this?
-
A rocket coasts in an elliptical orbit around Earth. To attain the greatest amount of KE for escape using a given amount of fuel, should it fire its engines to accelerate forward when it is at the...
-
Based on what you learned in this chapter of Dessler, Human Resource Management, lay out a complete incentive plan (including all long- and short-term incentives) for the Hotel Paris hotel managers.
-
Consider the following cash flow profile and assume MARR is 10 percent/year and the finance rate is 4 percent/ year. a. Determine the MIRR for this project. b. Is this project economically...
-
Sansomite Co. distributes suitcases to retail stores and extends credit terms of 1/10, n/30 to all of its customers. At the end of June, Sansomites inventory consisted of suitcases costing $1,200....
-
How might actions/events in other countries outside the U.S. effect the aggregate supply or aggregate demand in the U.S.? Be sure to explain.
-
Consider the issues of project budget, scope, and project timetable. Discuss the extent to which the CityCenter project reflects survey evidence discussed in the chapter about capital budgeting...
-
Vivian and Leonard exchange real estate in a like-kind exchange. Vivian's basis in the real estate, subject to a $150,000 mortgage, is $220,000 and the fair market value is $300,000. She receives...
-
Birch Limited received cash of $24,000 on November 1 as prepayment for 12 months' rent. The accountant recorded the cash receipt as a debit to cash and a credit to Rent Revenue. What is the year-end...
-
Can you elaborate on how Functionalism accounts for societal dysfunction and conflict, and how these elements contribute to the overall functioning and evolution of society?
-
Discuss on the topic cyber threats and how a company should address these threats from an enterprise risk management perspective. You should include some level of cost/benefit discussion in your post...
-
Ahuna, a manager, indicated that she would like her employees to work 49 hours a week given the busy season at the organization. How does the ESA apply to the hours Ahuna would like her staff to...
-
Industry Code of Practice is assessed 20. NHVR appoints an assessment panel During the publication period the NHVR appoints a panel to assess the Consultation Draft of the ICP. This will consist of...
-
Change the Pokemon class so that it can store images for Pokemon. First, add an instance variable to the Pokemon class to store an image. Then, add a new Constructor, still keeping the old one. This...
-
Find the area of the surface generated by revolving the para- metric curve x = cos 1, y = sin? 1 (0 < I sa/2) about the y-axis.
-
Johnson Co. accepts a note receivable from a customer in exchange for some damaged inventory. The note requires the customer to make 10 semiannual installments of $50,000 each. The first installment...
-
Assume the same information as in E17-19 for Lilly Company. In addition, assume that the investment in the Woods Inc. stock was sold during 2013 for $195,000. At December 31, 2013, the following...
-
HSU Company purchased a machine at a price of $200,000 by signing a note payable, which requires a single payment of $246,420 in 2 years. Assuming annual compounding of interest, what rate of...
-
KK Pty Ltd is a small manufacturing business. For the year ending 30 June 2019, the company achieved sales of $2 772 000 and a gross profit margin of 30%. Although satisfied with this result,...
-
The following actual balance sheet was prepared for Colombo Clocks Ltd as at 31 March 2020. At 31 March you are also provided with the following information. 1. Sales forecasts available for 2020:...
-
Fab and Fast Ltd buys and sells motor vehicle accessories. The firms estimated sales and expenses for the first 4 months of 2020 are shown below. Actual sales for December 2019 were $900 000 and...
Study smarter with the SolutionInn App