Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exercise 2: The following table displays postal service rates for shipping packages. Packages can be shipped via Express, First Class, Priority, or Standard mail. Express

image text in transcribed

Exercise 2: The following table displays postal service rates for shipping packages. Packages can be shipped via Express, First Class, Priority, or Standard mail. Express and First Class mail may also be certified, which means that the sender can receive verification upon delivery. The postal service charges one rate for the first ounce that a package weighs and another rate for each additional ounce. Enter this table into an Excel spreadsheet. Shipment Type Certification First Ounce Rate Express Yes $1.24 Express No $1.52 First Class Yes $0.83 First Class No $1.52 Priority Yes $0.65 Standard Yes $0.37 Rate After First $0.89 $0.89 $0.67 $0.67 $0.42 $0.23 A business frequently sends out packages that weigh approximately 10 ounces. Calculate the cost of mailing a 10-oz package via each of the means shown in the table. Create a pivot table that displays the minimum cost of sending a 10-oz package via each of the shipment types. The table should also display the overall minimum cost of mailing a 10-oz package. Finally, format your table using a report style of your own creation. Exercise 2: The following table displays postal service rates for shipping packages. Packages can be shipped via Express, First Class, Priority, or Standard mail. Express and First Class mail may also be certified, which means that the sender can receive verification upon delivery. The postal service charges one rate for the first ounce that a package weighs and another rate for each additional ounce. Enter this table into an Excel spreadsheet. Shipment Type Certification First Ounce Rate Express Yes $1.24 Express No $1.52 First Class Yes $0.83 First Class No $1.52 Priority Yes $0.65 Standard Yes $0.37 Rate After First $0.89 $0.89 $0.67 $0.67 $0.42 $0.23 A business frequently sends out packages that weigh approximately 10 ounces. Calculate the cost of mailing a 10-oz package via each of the means shown in the table. Create a pivot table that displays the minimum cost of sending a 10-oz package via each of the shipment types. The table should also display the overall minimum cost of mailing a 10-oz package. Finally, format your table using a report style of your own creation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Finance Book

Authors: Stuart Warner, Si Hussain

1st Edition

1292123648, 978-1292123646

More Books

Students also viewed these Finance questions