Need assistance on how to do the next step on delivery services.
Instructions: We have just opened a bakery, Cornell Cupcakes, that produces cupcakes that customers can customize to their preference. After collecting data from our first successful month, we need to clean up the following worksheets so we can analyze our performance. Please look at the following instructions and use them as a guide to clean up and organize the data. Good luck! On the "July Orders" worksheet, insert a row at the top of the worksheet and add the title "July Cornell Cupcake Orders" in bold by merging Columns A:E. Adjust the column widths, use borders, format prices, and fill in the order numbers in ascending numerical order. Add a custom header by typing your name and company name in the top right corner. Then use the function buttons to insert the date and page number underneath your name and the company name. Using the pricing scheme table on the right, calculate the total cost per order. The cost of topping is calculated per cupcake (e.g. there is a toppings fee of $0.50 per topping per cupcake). Insert formulas to calculate the total amount of cupcakes ordered in Cell B15 and the total cost of all orders in Cell D15. Be sure to use relative references. Italicize B15 and D15. 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
