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
A book and paper store distributes one specialized monthly magazine. When looking at the sales the last years, they have concluded that the demand for each issue of the magazine will be normally distributed with an expected sale of 250 and a standard deviation of 100. The purchase price for the magazine is $20. and the sales price is $50.The store has an agreement with a second -hand store that buys unsold magazines for $5 each. How many magazines should the store buy of each issue?
1v
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)
Magdeleine James is a sole trader, who sells souvenir T-shirts. She wishes to sell her T-shirts at the Tobago Jazz festival. Each t-shirt cost $165 to produce and sells for $225. After the festival, she reduces the sale price of the T-shirts by 70% in order to sell them off. Experience from previous years has shown that the demand for these T-shirts at the festival is 82, with a standard deviation of 21. How many T-shirts should Magdeleine take to sell at the festival?
In your country, the demand curve of a litre of petrol is given by: P = 124 - 3QD. Due to political unrest coupled with the slow recovery from pandemic, the global price of petrol surged which led to an increase of price per litre of petrol in your country from TK58 to TK88. After the price rise, the employees of the company you work for demanded a pay-raise. Your employer, hence, increased your income from 32954 taka to 42762 taka. The new demand curve at the new income level is P = 139 - 3QD. i. Calculate the income elasticity of demand (YED). ii. Now assume that the increase in income (and the subsequent shift of the demand curve) had occured before the rise in price, then what would the YED be?
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
Question 30, Question 31, Question 32, Question 33, Question 34, Question 35, Question 46, Question 47, Question 48, Question 49, Question 50
An airline company offers four fairs as shown in the table below. The demand distribution for each fare is normal with mean and standard deviation as given in the table. Find an estimate of the protection levels for the classes using the heuristic EMSR-a. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
5ñ