Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started