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?
-
An experiment was conducted to investigate the survival of diplococcus pneumonia bacteria in chick embryos under relative humidities (RH) of 0%, 25%, 50%, and 100% and under temperatures (Temp) of...
-
The data for this question consist of a sample of 50 persons from the 1967-1980 Evans County Study (Schoenbach et al. 1986). Two basic independent variables are of interest: AGE and chronic disease...
-
When Bernie Marcus and Arthur Blank opened the first Home Depot store in Atlanta in 1979, they forever changed the hardware and home-improvement retailing industry. Marcus and Blank envisioned huge...
-
French Fragrances, Ltd. budgeted for 12,000 bottles of perfume Belle during May. The unit cost of Belle was $20, consisting of direct materials, $7; direct labor, $8; and factory overhead, $5 (fixed,...
-
East Company purchased West Company. East Company paid $ 6 0 0 , 0 0 0 cash and assumed all of West Company s liabilities. West's books showed tangible assets of $ 5 5 0 , 0 0 0 , liabilities of $ 4...
-
DETERMINATION OF IRON CONTENT IN A FERROUS AMMONIUM SULFATE UNKNOWN Obtain an unknown sample from your professor and record the unknown number in your notebook. Weigh out 3-4 samples of between...
-
Which Regional and International Laws does Raza Hussain KC argue the Nationality and Borders Act (2022) contravenes? Identify which is a Regional Law and which is an International Law in your answer.
-
Who made this statement: I still have the audacity to believe that people everywhere can have three meals a day. a) Charles Murray b) William Julius Wilson c) Barbara Bush (mother of President George...
-
Which statement is the most accurate? a) Most poor people receive public assistance (formerly called welfare). b) Public assistance has been discontinued. c) The number of people receiving public...
-
Which statement is false? a) Nearly half of all poor Americans own their own homes. b) A poor person today has roughly the same standard of living as a middle-income person 30 years ago. c) The...
-
Which is the most accurate statement about real median family income? a) It has declined steadily over the last ten years. b) It has fallen during nearly every recession since the 1960s. c) It is...
-
Who would most likely receive food stamps before the age of 20? a) a white person b) a black person c) an Asian American person d) a person who grew up in a two-parent household
-
Adrian (aged 49) earns $140,000 p.a. plus SG. He is considering salary sacrificing $10,000 to superannuation. The tax saved (ignoring Medicare levy) is: ontributions tax on $10,000 salary sacrifice...
-
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...
-
Is leadership synonymous with management, or is leading just one of the many things that a manager does? In what ways are they the same or different?
-
Discuss the results of the Ohio State studies in terms of their significant impact on leadership research.
-
Explain Blake and Moutons Leadership Grid in relationship to previous leadership research.
Study smarter with the SolutionInn App