Question: Part I - Excel basic skills Please answer each question, including calculations, in a separate excel tab All relevant data can be found in tab

Part I - Excel basic skills Please answer each question, including calculations, in a separate excel tab All relevant data can be found in tab "Data", which shows one row per sold product (food box) Explain your answer if necessary 1 How many customers purchased more than 1 product? (Hint: Customer ID stays the same per customer when he/she buys 2 Prepare a chart that shows sold food boxes per weekday (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunda 3 How many products did we sell for 2 people and how many products did we sell for 4 people? (Explain how you got to you 4 Count how many food boxes "Classic - 3 meals per week for 2 people" we sold vie marketing channel "TV / Radio Advertisi 5 Create an additional column in tab Date that shows and references state from tab State (Explain procedure) 6 Which marketing channels worked best in which states (Use tab "State" and prepare an overview: number of sold boxes pe 7 Using tab "Prices', create two additional columns in tab 'Date' that show the gross product margin, and the overall product

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 Finance Questions!

please use excel Download the Applying Excel form below. Follow the tutorial on the first tab using basic Excel functions. After following the tutorial on the first tab, enter formulas in cells that...

Hi Ruchi, I need help with the attached assignment. It's due in about a week. Thanks 1) The paper should be written in APA style Research Paper format. This is the link that explains the research...

Please answer this question fully. Within the next 5 hours. I will give an automatic thumbs up to eh answer and will be greatly appreciated! This assignment is meant to be in excel. Thankyou! You...

CASE III: Control Charts This case has 2 parts to it. The first part requires you to read the case EXCEL Logistics (this case is in your case book) and answer related questions that appear on the...

can anyone help me with question 5b? PART ONE: Conduct statistical analyses using StatCrunch. Part 1 has three research questions. To answer these questions, use the data available in Application...

Please answer this question ASAP with full explanation, thank you!! You work in the corporate controller's office for Sharpe Glassworks, Inc. Sharpe manufactures 12 ounce beer bottles for smaller...

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Smyth Industries operated as a monopolist for the past several years. earning annual profits amounting to $58 million, which it could have maintained if Jones Incorporated did not enter the market....

Which of the following is a step in the bounded rationalitydecision-making process? Boil the problem down to something that is easilyunderstood. Evaluate all the alternatives simultaneously. Pick the...

1 4 An accountant has an immaterial direct financial interest in a nonp Stity. The accountant isIndependent because the financial interest is immaterial . 2 9 , 7 2 2 XNot independent and may not...

In the first month of operations, Moncada Company made three purchases of merchandise in the following sequence: (1) 200 units at $7, (2) 300 units at $8, and (3) 150 units at $9. assuming there are...