Question: Need an EXCEL FORMLA for the Total discounts given section (G9) B D E F G H K L SHIFT 1, 8AM-10AM 1 2 3

Need an EXCEL FORMLA for the Total discounts given section (G9)

Need an EXCEL FORMLA for the Total discounts

B D E F G H K L SHIFT 1, 8AM-10AM 1 2 3 Group 1 Group 2 Group 3 Group 5 4 5 6 7 Total # of People Avg Ticket Price Total Price Paid Total Discount Given 8 10 12 6 $ 8.00 $ 8.00 $ 6.00 $ 8.00 $ 64.00 $ 80.00 $ 72.00 $ 48.00 8 9 TOTAL GROUP SALES 10 11 12 13 14 15 16 17 18 19 20 21 22 Total # of People 36 AVG Ticket Price $ 7.33 Total Revenue in the Shift $ 264.00 Total Discounts Given

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

(MIS) please help me with the Excel thankyou start with number 2 Assignment Instructions Exp19 Excel Ch09_HOEAssessment TicketSales.xlsx Grader has automatically added your last name to the beginning...

Homework #4 Quantitative Business Analysis (MHR381) 4 Homework number Due date Additional files needed hw04 Data Set 37th Ed.xlsx . Note: This homework was originally designed for you to download the...

AutoSave OFF BESU- Bradford Home Insert Draw Page Layout Formulas Data Review View Tell me Share a Comments X Calibri (Body) Insert 14 AI = = ab Wrap Text General PPA III. ||11 MIT WE 48- 0 DX Delete...

complete only page 1 of the tax form and ecplain the adjustments C-Corporation Tax Return Instructions Purpose: The purpose of this tax return assignment is to apply the tax rules you have learned in...

Voice Sensitivity Editor Styles 5 Font Paragraph Excel 2019 Project Grader - Instructions Exp19_Excel_Ch09_ML1_Expenses Project Description: You carefully tracked your income and expenses for three...

Question 3: The Wall Street Journal CEO Compensation Study analyzed CEO pay from many U.S. companies with a fiscal year 2008 revenue of at least $5 billion filed their proxy statements between...

DOLLAR TREE Overview We are a leading operator or discount variety stores. At February 2, 2018 we operated 14,835 discount variety retail storesOur stores operate under the names of Dollar Tree...

You are the operations manager for a manufacturing plant that produces pudding food products. One of your important responsibilities is to prepare an aggregate plan for the plant. This plan is an...

Prepare a schedule in Excel starting with June 15, 20X1 that rolls forward partners Section 704(b) (capital account ) through December 31, 20X2. Partnership information General Information Tile...

Temel olarak, 3 kamyon iin bir aktarma plan modellemeniz bekleniyor. Baz veriler dahil deildir ve bu verileri toplamak ve/veya tahmin etmek ekibinizin grevidir. Kaynaklarnz iin balant eklemelisiniz....

2. Compute: a) Pr(-3x3) if X-N(u=2, 0=4) b) Pr(2Y10) if Y~N(u=0, 0=4) c) Pr(-1.96W0) if W~N(u=0, 0=1) d) Pr(0U1.6) if U folllows a uniform distribution between 0 and 2 (that is, any number between 0...

Under special case Il in the Routh Hurwitz, we replace the zero row with Coefficients of the derivative of the auxiliary equation Coefficients of the auxiliary equation Arbitrary small numbers Roots...

1 0 . 9 Transaction Exposure. What are the four main types of transactions from which transaction exposure arises?

As CFO of Nile Holdings, a carpet wholesaler, you have the following information as of December 2011: Last year's EBIT, 2011 $175.0 million Expected EBIT 2012 $189.8 million Current portion of...