Which of the following formulas is able to help you calculate the unit price of the remaining items, based on the corresponding year and product, to obtain the same value as shown in cells K4:K12? You are a store manager, and you have received an Excel file similar to the one in the image below. Theprice for each product increased by 25% in 2021, compared to 2020. You need to determine the unit pricefor each product in stock at the end of 2021. In cell range H4:H12, you have the quantity of each productat the end of 2021. Which of the following formulas is able to help you calculate the unit price of theremaining items, based on the corresponding year and product, to obtain the same value as shown in cellsK4:K12?12345678910111213ABYear 2020Product Unit Price$1,000$240$475$114$226$54$107$26$51Product 1Product 2Product 3Product 4сProduct 5Product 6Product 7Product 8Product 9DEYear 2021Product Unit Price$1,250$300$594$143Product 1Product 2Product 3Product 4FProduct 5Product 6Product 7Product 8Product 9$282$68$134$32$64GHQuantity452167829114426828223Year202020212020202120202021202020212020JProductProduct 1Product 2Product 3Product 4Product 5Product 6Product 7Product 8Product 9KUnit Price$1,000$300$475$143$226$68$107$32$51Select the single best answer:A. =SUMIF(B4:B12, J4,C4:C12)+SUMIF(E4:E12, J4, F4:F12)B. =IFS(LEFT(B2,4="2020"), HLOOKUP(J4,B4:C12,2, TRUE),LEFT(E2,4="2021"), HLOOKUP(J4, E4:F12,2, TRUE))C. =VLOOKUP(J4,IF(14<2021,$B$3:$C$12,$E$3:$F$12),2, TRUE)D. IFS(RIGHT(B2,4="2020"), VLOOKUP(J4,B4:C12,2,TRUE),RIGHT(E2,4="2021"), VLOOKUP(J4, E4:F12,2, TRUE))O E. =COUNTIF(B4:B12,J4,C4:C12)+COUNTIF(E4:E12, J4,F4:F12)

Answered: Image /qna-images/answer/9b362bb5-aa4c-4a87-b0bb-28ed5707d7c6.jpg

Answered: Which of the following formulas is able…

Which of the following formulas is able to help you calculate the unit price of the remaining items, based on the corresponding year and product, to obtain the same value as shown in cells K4:K12?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Munabhai
Given scenario A hospital is administering a polio vaccine (“polio drops”) to children under the age of 5 in Mexico. It costs the hospital $2 to purchase one shot, and they charge $3 for administering it to a child. Unused vaccines are destroyed. The hospital management needs to decide the number of vaccines to be ordered. Since the hospital has been administering these shots for the last 6 years (24 quarters), they have been able to compile the demand for the vaccine. Determine the optimal service level and optimal order quantity, for the vaccine. Quarter Demand 1 15 2 18 3 21 4 15 5 17 6 22 7 20 8 16 9 22 10 18 11 25 12 15 13 26 14 29 15 16 16 30 17 17 18 25 19 18 20 16 21 19 22 23 23 20 24 15
Algro Inc. keeps a wide range of parts and materials on hand for use in its production processes. Management has recently had difficulty managing parts inventory as demand for its finished goods has increased; they frequently run out of some critical parts while having an endless supply of others. They would like to classify their parts inventory according to the ABC approach to better control inventory. The following is a list of parts, along with their annual usage and unit value: Item Annual Unit Item Annual Unit Number Usage Cost Number Usage Cost 1 36 $350 2 510 30 3 50 23 4 300 45 5 18 1900 6 500 8 7 710 4 8 80 26 9 344 28 10 67 440 11 510 2 12 682 35 13 1216 95 50 14 10 3 15 820 1 KARAN2222222222 16 60 $610 17 120 20 18 270 15 19 45 50 20 19 3200 21 910 3 12 4750 23 30 2710 24 24 1800 25 870 105 26 244 30 27 750 15 28 45 110 29 46 160 30 165 25 a. Classify the inventory items according to the ABC approach using the dollar value of annual demand. b. Clearly explain why you…
The army is attempting to determine the optimal replacement age for a piece of field equipment. The equipment costs $280,000 to replace. The manufacturer will supply a rebate toward the next purchase that declines at a rate of 20 percent per year. Maintenance costs for the first year are estimated to be $1,000, and they increase roughly at the rate of 18 percent per year. Estimate the number of years that the army should hold the equipment before making a replacement.(Production and Operation Analysis by Steven Nahmias, 7th edition, pg.774 Problem # 24)
Deborah Kellogg buys Breathalyzer test sets for the Winter Park Police Department. The quality of the test sets from her two suppliers is indicated in the following table: For example, the probability of getting a batch of tests that are 1% defective from Winter Park Technology is .70. Because Kellogg orders 10,000 tests per order, this would mean that there is a .70 probability of getting 100 defective tests out of the 10,000 tests if Winter Park Technology is used to fill the order. A defective Breathalyzer test set can be repaired for $0.50. Although the quality of the test sets of the second supplier, Dayton Enterprises, is lower, it will sell an order of 10,000 test sets for $37 less than Winter Park. a) Develop a Decision Treeb) Which supplier should Kellog use? Percent Defective Probability for Winter Park Technology Probability for Dayton Enterprises 1 0.70 0.30 3 0.20 0.30 5 0.10 0.40
5ñ
Compute EMV and EVPI. (Question is in the screenshot)