Not available.
Added by Enrique H.
Step 1
Step 1: Consider the context of the question and what information is being asked for. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 71 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
Akash M.
Determine the Packaging and Loading costs in cell packlist!F3. I need an Excel formula to determine the packaging and loading costs for this item based on its box size and weight. This cost should also include the box price but do not include any surcharges for fragile or high-value items. Copy the formula down the column to calculate this value for each corresponding item. For example - your value will include the box price (from the Box Price row on the boxes worksheet) plus the price based on weight (from the Packing and Loading rows, also on the boxes worksheet). 2. Determine the Handling surcharge for items which are fragile and insurance cost for items which have a high value. (Handling surcharge for fragile items + Insurance for high-value items) I need an Excel formula in cell packlist!G3 to calculate this value for the corresponding item. Handling surcharge and Insurance values are given on sheet handling. Round these charges to the nearest cent. Copy your formula down the column to determine this value for each corresponding item. For example - (Handling surcharge for fragile items * F3 (the Packing & Loading Cost)) + Insurance (no insurance unless it is a High-Value Item) 3. Determine the total Packing & Loading costs for item 1 in cell packlist!H3 - Copy your formula down the column to determine this value for each corresponding item. 4. At the very bottom of the packaging list, calculate the total weight of all boxes, the total packaging and loading costs excluding surcharges, total handling fees, and total packaging and loading costs. Use appropriate formatting for the corresponding columns. 5. In cell boxes!B13, summarize the total weight for all size A boxes. I need the formula so that it can be copied across the row for each corresponding box size. These formulas should automatically update if any of the individual weights are updated on the packaging list. Again format your values in a consistent manner to the data on sheet packlist.
c. Display the value in cell E5 with one decimal place. d. Fill the range E6:E18 with the formula in cell E5. 14. Cello Worldwide offers a discount to customers who have been with the company for at least four years. Determine whether each customer qualifies for a discount as follows: a. In cell H5, enter a formula using the IF function that tests whether the number of years is greater than or equal to 4. If it is, display "Y" in cell H5. If it is not, display "N" in cell H5. b. Fill the range H6:H18 with the formula in cell H5. 15. Kamal plans to offer new, more favorable contracts to business customers who are now receiving a discount and use wireless services. Determine whether each customer should receive a new contract as follows: a. In cell I5, enter a formula using the AND function that tests whether the Wireless value is equal to "Y" and whether the Discount value is equal to "Y". b. Fill the range I6:I18 with the formula in cell I5. 16. Kamal also plans to offer a free mobile phone to customers with businesses in northern Texas using an Unlimited plan. Determine whether each customer should receive a free
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD