Important Note: You must consider the Order of Operations. Use parenthesis to control the order of operations in your formulas. Enter your formula in Column B shaded in Blue. tem 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 NAVIGATION INSTRUCTIONS: Formula is Sales Price - cost x sold Formula is Sales Price - cost x sold Formula is Sales Price - cost x sold Formula is Sales Price - cost x sold Formula is Sales Price - cost x sold Profit on Jackets Enter Formula in Column B Profit on Socks Enter Formula in Column B Profit on Shirts Enter Formula in Column B Profit on Hats Enter Formula in Column B Profit on Pants Enter Formula in Column B Number Correct 0 Percentage Correct 0%
Added by Tammy H.
Close
Step 1
This means we need to 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 98 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.
A clothing retailer gives you 10 points for every $1 spent, and you can trade in 2,550 points for a $15 gift certificate. 1. On an excel spreadsheet, create formulas which compute the cost of each item and the points you get from each item. 2. Compute how many $15 gift certificates you will get from this order and the total value of these gift certificates (so use the INT function). 3. What is the ratio of money spent to the value of the gift certificates? Enter a formula Eddie Bauer Shopping Spree Items Quantity Cost Total Cost Points 1 Polo Shirt 3 $ 50.00 $ 150.00 2 Dress Shirt 4 $ 75.00 $ 300.00 3 Khakis 2 $ 59.99 $ 119.98 4 Merrell Shoes 1 $ 135.00 $ 135.00 5 Snowline Jacket 1 $ 219.00 $ 219.00 6 Belt 1 $ 19.99 $ 19.99 7 Cloud Layer Fleece 2 $ 75.00 $ 150.00 8 Sweater 3 $ 80.00 $ 240.00 9 Full Zip Hoodie 1 $ 70.00 $ 70.00 10 Wrinkle Free Oxford 5 $ 55.00 $ 275.00 Totals: $ 1,678.97 Gift Certificates: Value of Gift Certificates:
Sri K.
Enter a formula in the selected cell to calculate the profit projection for 2017: total sales (cell f4) minus the cost of goods sold (cell f5).
Mauya M.
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