Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

On the step where it requires me to add an table how would I go about doing this and what functions would I use. Instructional

image text in transcribedimage text in transcribedOn the step where it requires me to add an table how would I go about doing this and what functions would I use. Instructional steps could help.

Cornell Cupcakes is piloting a delivery service. In Cell E15, display how many orders used the delivery service. Finally, add a table below that includes the total costs of all orders, average cost per order, most expensive order, and least expensive order. For the definition of the average cost per order, divide the total costs of all order divided by total number of orders. Title this table "Original July Costs." Your team is trying to decide if Cornell Cupcakes should charge for the delivery service. Create a row below the pricing scheme table to show that delivery will cost an additional 5% of the order total. Add a column to the right of the "July Cornell Cupcake Costs" table labeled "Delivery Cost." Add another column labeled "Total Cost with Delivery." Adjust the formatting of the title. Calculate the delivery cost for each order that used the delivery service. If the delivery service was not used, insert "0." Total the cost of delivery for all orders in Cell F15. Calculate the new total cost of all 12 orders with the applicable delivery cost. Total the cost of all 12 orders with the applicable delivery cost in Cell G15. Underneath "Original July Costs," create another table titled "Adjusted July Costs." Find the total costs of all orders, average per order, most expensive order, and least expensive order using the added delivery service charge. For the definition of the average cost per each order, divide the total costs of all order including the delivery cost divided by total number of orders. Your manager has asked you to make a recommendation on whether Cornell Cupcakes should charge for its delivery service. Create an orange highlighted box under the pricing scheme chart. Determine if you have enough information to make a recommendation on whether Cornell Cupcakes should charge for delivery. Order # Amount of Cupcakes 1001 July Cornell Cupcake Orders Amount of Toppings 200 1002 1003 1004 100 5 Cornell Cupcake Pricing Scheme Item Cost per unit* Cupcake $1.00 Each Topping $0.50 *Cost per unit refers to price per cupcake, per topping choice. Each topping is an additional .50 per cupcake. 26 1005 4 1006 Total Cost of Order Delivery? 5$ 202.50 Yes 6 $ 103.00 No 1 $ 5.50 No 4 $ 28.00 No 3 $ 5.50 No 2 $ 51.00 Yes 1 $ 35.50 Yes 0 $ 76.00 Yes 2 $ 23.00 Yes 4 $ 12.00 No 6 $ 21.00 Yes 1$ 6.50 Yes 50 1007 35 1008 76 1009 22 10 1010 1011 18 1012 6 Total 7 Cornell Cupcakes is piloting a delivery service. In Cell E15, display how many orders used the delivery service. Finally, add a table below that includes the total costs of all orders, average cost per order, most expensive order, and least expensive order. For the definition of the average cost per order, divide the total costs of all order divided by total number of orders. Title this table "Original July Costs." Your team is trying to decide if Cornell Cupcakes should charge for the delivery service. Create a row below the pricing scheme table to show that delivery will cost an additional 5% of the order total. Add a column to the right of the "July Cornell Cupcake Costs" table labeled "Delivery Cost." Add another column labeled "Total Cost with Delivery." Adjust the formatting of the title. Calculate the delivery cost for each order that used the delivery service. If the delivery service was not used, insert "0." Total the cost of delivery for all orders in Cell F15. Calculate the new total cost of all 12 orders with the applicable delivery cost. Total the cost of all 12 orders with the applicable delivery cost in Cell G15. Underneath "Original July Costs," create another table titled "Adjusted July Costs." Find the total costs of all orders, average per order, most expensive order, and least expensive order using the added delivery service charge. For the definition of the average cost per each order, divide the total costs of all order including the delivery cost divided by total number of orders. Your manager has asked you to make a recommendation on whether Cornell Cupcakes should charge for its delivery service. Create an orange highlighted box under the pricing scheme chart. Determine if you have enough information to make a recommendation on whether Cornell Cupcakes should charge for delivery. Order # Amount of Cupcakes 1001 July Cornell Cupcake Orders Amount of Toppings 200 1002 1003 1004 100 5 Cornell Cupcake Pricing Scheme Item Cost per unit* Cupcake $1.00 Each Topping $0.50 *Cost per unit refers to price per cupcake, per topping choice. Each topping is an additional .50 per cupcake. 26 1005 4 1006 Total Cost of Order Delivery? 5$ 202.50 Yes 6 $ 103.00 No 1 $ 5.50 No 4 $ 28.00 No 3 $ 5.50 No 2 $ 51.00 Yes 1 $ 35.50 Yes 0 $ 76.00 Yes 2 $ 23.00 Yes 4 $ 12.00 No 6 $ 21.00 Yes 1$ 6.50 Yes 50 1007 35 1008 76 1009 22 10 1010 1011 18 1012 6 Total 7

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

International Business

Authors: Ricky W. Griffin, Michael W. Pustay

9th Edition

013489877X, 978-0134898773

Students also viewed these Accounting questions

Question

=+ Identify the ethical dilemma in this scenario.

Answered: 1 week ago