solve those questions in the exercise please. and write down the formulas for each cell.

AutoSave Home Insert Draw Page Layout Formulas Data F Review G View Homework Assignment 3 - Omar Hassan Automate Developer Q Tell me No Label v Conditional Formatting Price Per Piece C) Comments Arial v 10 Paste ab Wrap Text v Merge & Center v General Format as Table Insert v Format v Sort & Filter Find & Select Sensitivity e Share v Analyze Data J34 10 11 12 13 14 15 16 17 18 19 24 27 47 49 52 57 62 Exercise 1 - Charlemagne's Etsy Shop Special Over the winter holidays, Charlemagne's family suggested he start an Etsy shop he could use to sell the kinds of woodworking and carpentry projects he's enjoyed learning to make as a hobby over the last several years. There are several different products that Charlemagne wants to list on his shop and each item has a few different customization options that come with different price points. Charlemagne also wants to offer discounts for bulk purchases or for people who by a complete set of all his different products. After assigning prices to each of the different products and their customization options, Charlemagne is concerned that his pricing model will lose him money if someone buys a bulk order of three or more complete sets. He's decided to create a table that tracks all of his price points and customization options and a custom order form that will show his bottom-line profit based on what his customers order. Use the reference data and output tables provided below to complete the following: > Populate the Example Order Form as if more than three complete sets (1 each of a Bowl, Plate, Cup, and Serving Dish) are being purchased by a customer. Make sure at least one product is being engraved, at least one product is getting a wood burn, and at least one product is getting both a wood burn and an engraving. > Determine the sales price per product piece being purchased based on the product type, wood type, and customization options using logical formulas. > Determine how many full sets of product are being purchased. > Populate the Order Profit/Loss table to summarize the economics of the fake order populated in Table #1 using formulas. Use logical formulas to determine whether or not the Bulk and/or Full Set Discounts should be applies. Use formulas and cell referencing to calculate your answers in the output tables provided. This Exercise is worth up to 15 points. Remember! If you are ever confused about what an exercise is asking you to do, don't hesitate to reach out to me with questions! Remember also that we want to make use of the AND/OR functions in this week's Exercise. Product Bowl 1 Dinner Plate 1 cu Servin Dish 1 Wood Oak Ma le Cher Oak Ma le Cher Oak Ma le Cher Oak Ma le Cher Extra Cost 8.00 15.00 15% 5% Sales Price 30.00 32.00 35.00 45.00 48.00 52.00 15.00 17.00 19.00 68.00 70.00 75.00 Materials Cost 20.00 12.00 15.00 30.00 33.00 37.00 8.00 10.00 12.00 40.00 42.00 47.00 out ut Table #1 Exam le Order Product Bowl 1 VWth up to 5 Points Form c Wood Oak Ma le Cher Oak Ma le Cher Oak Ma le Cher Oak Ma le Cher En raved? Wood Burn? Quanti Di nner cu Servin Plate Dish Total Total Total Total Purchased Purchased Purchased Purchased Net Cell Styles nts Add-On Customization En ravin OR Burn En ravin & Burn Bulk Discount 1 Full Set Discount 2+ Full Set Discount Cover Sheet AWies to orders of 10 pieces more out ut Table Order Profit/Loss Product Bowls Dinner Plates cu s Servin Dishes Total Worth up to 5 Points Gross Revenue Materials Discount s Profit/Loss on Order out ut Table #3 Worth to 5 Number of Full Sets Purchased 1 Full Set Discount A lies? Yes/No 2+ Full Set Discount A lies? Yes/No Bulk Discount A lies? Yes/No Exercise Ready t Accessibility: Good to go