Question

4. Find the following:

a.

The unit price varies depending on the specified quantity, and your goal is to write a formula in cell B9 that calculates the total price for any amount of items input in a specific cell (in this case, cell B8) 1 Unit Quantity 2 1 to 10 3 11 to 19 4 20 to 49 5 50 to 100 6 Over 100 7 8 Quantity 9 Total Cost Price Per Unit 20.00 28.00 16.00 13.00 12.00 Write a nested IF function based on the above criteria to display the total cost of an order in cell B9 for any given ordered quantity B8 IF(B8>-101, 12, IF(B8 50, 13, IF(B8>-20, 16, IF( B8> 11, 18, IF(B8> 1, 20, ))) OB8 IF(B8>101, 12, IF(B8<50, 13, IF(B8<20, 16, IF( B8<11, 18, IF(B8>1, 20, ) B8 IF(B8-100, 12, IF(B8 50, 13, IF(B8-20, 16, IF B811, 18, IF(B8>-1, 20, ) -B8 IF(B8 100, 12, IF(B8>50, 13, IF(B8>20, 16, IF( B8 11, 18, IF(B8>1, 20, )

b.

For a particular month, the worksheet below shows the inventory of cel phones in stock at the beginning of the month. It also shows the number of cell phones of each type that have been sold during the month. When there are less than 10 phones in the inventory, it is time to replenish the stock. Write a statement for cell D2 to be copied for column D that will display the text, Order if more cell phones need to be ordered, yet leave the cell blank if more cell phones do not need to be ordered 1Smartphone Model 2 Nokia 6500 Classic 3 Samsung SGH-E250 4 LG Shine Quantity in Stock Quantity Sold Order More? 51 52 60 45 37 Apple Iphone 6 LG Viewty HTC Touch 8 Palm Centro 72 51 30 46 Order IF((C2-B2)<= 10, Order) IF(B2-C2)<10, Order, ) -IFIABS(B2-C2) 10,Order, ) IFIABS(B2-C2)<10,Order, )

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)

=B8*if(B8>=101,12,if(B8>=50,13,if(B8>=20,16,if(B8>=11,18,if(B8>=1,20,"")))))

b)

if(abs(B2-C2)<10,"order"," ")

Add a comment
Know the answer?
Add Answer to:
4. Find the following: a. b. The unit price varies depending on the specified quantity, and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please give the formula for these two questions 1 Price Supply Demand 1 2 3 4...

    Please give the formula for these two questions 1 Price Supply Demand 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Quantity At the equilibrium price, total surplus is 11. + Refer to Figure 7-15. a. $150. b. $200. c. $250. d. $300. Figure 7-18 1 Price Supply Demand 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150...

  • 5) Descriptive statistics. a) For each of the following classes, find: • lower class boundary upper...

    5) Descriptive statistics. a) For each of the following classes, find: • lower class boundary upper class boundary class width class mid-point (i) 8-21 (4 marks) (ii) 1.54 - 3.47 (4 marks) b) The number of pizzas sold by a restaurant over the month of June was recorded and the data collected are shown below. 22 54 11 34 18 21 15 33 47 44 46 13 24 40 10 29 27 43 32 23 35 14 52 16 24...

  • if this is considered a natural monopoly and the government sets the price to maximize efficiency,...

    if this is considered a natural monopoly and the government sets the price to maximize efficiency, how many customers will it serve? Price, 21 Costs, 20 Marginal Revenue 18 16 14 13 12 11 10 9 8 7 6 5 4 ATC MC N MR 0 50 100 150 200 250 300 350 + 400 375 Quantity (number of customers)

  • 1) What is the order quantity to minimize total cost or EOQ, given the information in...

    1) What is the order quantity to minimize total cost or EOQ, given the information in the Excel sheet? 2) Graph the problem. B н 1 Quantity Discounts EOQ 2 Categories Feasible Range O to 200 Item Cost, C % Discount 3 100 4 200 to 800 3 97 800 or more 3 94 D= 2025 items/year Co= $/order 60 $/SC/year 8 Cc= 0.3 11 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27

  • * Question Completion Status: 1 Price 110 + 8 Supply 8 8 +- 8 Demand 8...

    * Question Completion Status: 1 Price 110 + 8 Supply 8 8 +- 8 Demand 8 40+ S89 + + - 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 170 Quantity Refer to Figure 7-22. At the equilibrium price, total surplus is a. $3,500 b. $7,000. c. $2,500. d. $1,000 Supply HT + + + + + + + + + Demand + + + + 2 + 3 + 4 +...

  • 16. Consider the following table. Suppose quantity supplied increases by 30 for every price level. Find...

    16. Consider the following table. Suppose quantity supplied increases by 30 for every price level. Find the new equilibrium price. 9:32 Th 6 19 thg 1 @ 88% Times New Roma 14 BIVA. I Price 16. Consider the following table. Suppose quantity supplied increases by 30 for every price level. Find the new equilibrium price. Quantity Quantity Demanded Supplied $10.00 10 100 $8.00 20 $6.00 $4.00 $2.00 $0.00 30 40 50 60 80 60 40 20 0

  • 10. (12 points) The arrays price A, price B and price C given below contain the...

    10. (12 points) The arrays price A, price B and price C given below contain the price in dollars of the three stocks over 10 days. price A = [19, 18, 22, 21, 25, 19, 17, 21, 27, 29] price B = [22, 17, 23, 24, 18, 16, 25, 28, 27, 27] price C = [10, 11, 12, 13, 19, 17, 20, 21, 24, 28] For the stock data, write a MATLAB code to plot the stock price vs. days...

  • mathlab 10. (12 points) The arrays price A, price B and price C given below contain...

    mathlab 10. (12 points) The arrays price A, price B and price C given below contain the price in dollars of the three stocks over 10 days. price A = [19, 18, 22, 21, 25, 19, 17, 21, 27, 29) price B = [22, 17, 23, 24, 18, 16, 25, 28, 27, 27] price C - [10, 11, 12, 13, 19, 17, 20, 21, 24, 28) For the stock data, write a MATLAB code to plot the stock price vs....

  • Refer to Exhibit 3-13. Fill in blanks (A) and (B) respectively with the market quantity demanded...

    Refer to Exhibit 3-13. Fill in blanks (A) and (B) respectively with the market quantity demanded at each given price. Question 23 4 pts Exhibit 3-13 displays Quality Demanded. Assume that Jose, Kaitlyn, Leah, and Maria are the only buyers in this market. Leah Market Price Jose Kaitlyn Maria $5 50 20 25 40 (A) 23 6 45 18 36 (B) 20 7 40 16 32 (C) 8 28 14 17 28 (D) 9 15 12 14 20 (E) 10...

  • In Matlab The arrays price A, price B and price C given below contain the price...

    In Matlab The arrays price A, price B and price C given below contain the price in dollars of the three stocks over 10 days. price A = [19, 18, 22, 21, 25, 19, 17, 21, 27, 29] price B = [22, 17, 23, 24, 18, 16, 25, 28, 27, 27] price C = [10, 11, 12, 13, 19, 17, 20, 21, 24, 28] For the stock data, write a MATLAB code to plot the stock price vs. days graph...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT