Important Note: 1. You MUST consider the Order of Operations! 2. Use parenthesis to control the order of operations in your formulas. 3. Enter formula in Column B shaded in Blue. (An 'X' in hint means multiplied by) Item Sales Price Cost Sold Pants $ 49.99 $ 26.34 156 Shirt $ 41.99 $ 16.58 233 Socks $ 6.99 $ 2.13 123 Jacket $ 69.99 $ 28.75 56 Hat $ 9.99 $ 5.25 66 ENTER FORMULA HERE Profit on Jackets Enter Formula in Column B Profit Formula is Sales Price - cost X sold Profit on Socks Enter Formula in Column B Profit Formula is Sales Price - cost X sold Profit on Shirts Enter Formula in Column B Profit Formula is Sales Price - cost X sold Profit on Hats Enter Formula in Column B Profit Formula is Sales Price - cost X sold Profit on Pants Enter Formula in Column B Profit Formula is Sales Price - cost X sold
Added by Stephen J.
Close
Step 1
This means we subtract the cost from the sales price and then multiply the result by the number sold. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 91 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
In cell F14, enter Total as the label. In the range F15:F20, calculate the total cost of each equipment item by entering formulas that return the value of the number of units ordered multiplied by the cost per unit. 12. In cell E22, enter Subtotal as the label, and then in cell F22, use the SUM function to calculate the sum of the values in the range F15:F20. 13. In cell E13, enter Tax Rate as the label, and then in cell F13, enter 3% as the value. 14. In cell E23, enter Est. Tax as the label, and then in cell F23, calculate the estimated tax by entering a formula that multiplies the subtotal.
Akash M.
In cell F2, enter a formula to calculate the daily total in dollars. Multiply the value in the Daily Total (# Sold) column by the current price per box in cell I1. Use an absolute reference where appropriate and copy the formula to cells F3:F31. In cell I3, enter a formula to calculate the average daily sales in dollars. In cell I4, enter a formula to find the lowest daily sales in dollars. In cell I5, enter a formula to find the highest daily sales in dollars. Daily Total (# sold) 531 487 366 510 520 409 375 441 404 120 546 612 460 314 643 279 455 470 388 346 426 480 708 541 678 574 439 367 435 485 Current price per box: $6 Daily sales goal: $1,500 Average daily sales: Lowest daily sales: Highest daily sales:
Danielle F.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD