Download the file Regional Sales Dataset.xlsx. Using Excel, summarize sales by month, by sales region (regions 1–4), and by both month and region using a pivot table. (This problem may require a review of Excel skills, which you will find in Appendix A at the back of this book.)

Regional Sales Dataset.xlsx

Date	Invoice #	Customer #	SKU	Description	Sales Price	Cost
01-10-25	8001	3006	PED-TPR	TPR Pedals - Windows	497.38	284.93
02-10-25	8002	3022	WHL-T3S	VG T300RS Racing Wheel Servo Base for PS4 and PS3	159.99	92.63
02-10-25	8002	3022	WHL-TGT	T-GT Racing Wheel (PS4/PC)	614.91	354.66
03-10-25	8003	3096	FLI-TMX	TMX Force Feedback Racing Wheel	159.84	87.3
03-10-25	8004	3080	FLI-USB	USB Joystick	21.99	12.06
03-10-25	8005	3055	WHL-T30	T300RS Officially Licensed PS4/PS3 Force Feedback Racing Wheel	319.99	170.61
03-10-25	8006	3076	WHL-TMX	TMX Pro Racing Wheel	249.99	147.62
03-10-25	8007	3066	FLI-16H	T1600M FCS Hotas	97.3	52.53
03-10-25	8007	3066	FLI-HOX	T-Flight Hotas X Flight Stick	39.99	20.53
03-10-25	8008	3095	FLI-16M	T 16000M Space SIM Duo Stick	117.83	69.36
03-10-25	8009	3051	WHL-TGT	T-GT Racing Wheel (PS4/PC)	614.91	354.66
03-10-25	8009	3051	PED-FCS	T16000M FCS	39.19	23.36
03-10-25	8010	3066	FLI-HO1	T-Flight Hotas One	59.99	30.17
03-10-25	8011	3053	WHL-TGT	T-GT Racing Wheel (PS4/PC)	614.91	354.66
03-10-25	8012	3008	FLI-HO4	T-Flight Hotas 4 Flight Stick	34.65	19.76
04-10-25	8013	3013	PED-TPR	TPR Pedals - Windows	497.38	284.93
04-10-25	8013	3013	FLI-16H	T1600M FCS Hotas	97.3	52.53
04-10-25	8013	3013	WHL-TMX	TMX Pro Racing Wheel	249.99	147.62
04-10-25	8014	3014	FLI-TMX	TMX Force Feedback Racing Wheel	159.84	87.3
05-10-25	8015	3029	FLI-16M	T 16000M Space SIM Duo Stick	117.83	69.36
05-10-25	8015	3029	PED-FCS	T16000M FCS	39.19	23.36
05-10-25	8016	3054	FLI-STX	T-Flight Stick X PS3	39.99	21.04
05-10-25	8017	3027	PED-FER	Ferrari Racing Wheel Red Legend Edition	79.99	43.51
05-10-25	8018	3075	FLI-THR	TWCS Throttle	59.99	35.18
06-10-25	8019	3074	WHL-TGT	T-GT Racing Wheel (PS4/PC)	614.91	354.66
06-10-25	8019	3074	PED-T80	T80 Ferrari 488 GTB Edition Racing Wheel PS4	94.99	52.58
06-10-25	8019	3074	PED-T80	T80 Ferrari 488 GTB Edition Racing Wheel PS4	94.99	52.58
06-10-25	8020	3081	PED-TFR	TFRP Rudder	69.99	41.18
07-10-25	8021	3026	FLI-16H	T1600M FCS Hotas	97.3	52.53
07-10-25	8021	3026	FLI-HO1	T-Flight Hotas One	59.99	30.17
07-10-25	8021	3026	FLI-HO1	T-Flight Hotas One	59.99	30.17
07-10-25	8021	3026	COM-FCS	T16000M FCS Flight Pack	172.35	89.15
07-10-25	8021	3026	FLI-STX	T-Flight Stick X PS3	39.99	21.04
07-10-25	8021	3026	PED-T3P	FB T3PA-Pro 3-Pedal Add-On Set	129.99	66.14
07-10-25	8022	3083	PCG-HOW	Hotas Warthog PC	462.81	232.13
07-10-25	8023	3077	PED-FCS	T16000M FCS	39.19	23.36
07-10-25	8024	3046	COM-FCS	T16000M FCS Flight Pack	172.35	89.15
07-10-25	8024	3046	WHL-TMX	TMX Pro Racing Wheel	249.99	147.62
07-10-25	8025	3098	PED-TPR	TPR Pedals - Windows	497.38	284.93
07-10-25	8025	3098	FLI-HO4	T-Flight Hotas 4 Flight Stick	34.65	19.76
07-10-25	8026	3066	WHL-T3S	VG T300RS Racing Wheel Servo Base for PS4 and PS3	159.99	92.63
07-10-25	8027	3013	WHL-TGT	T-GT Racing Wheel (PS4/PC)	614.91	354.66
08-10-25	8028	3062	FLI-HO1	T-Flight Hotas One	59.99	30.17
08-10-25	8029	3056	FLI-16H	T1600M FCS Hotas	97.3	52.53
08-10-25	8030	3049	WHL-T3S	VG T300RS Racing Wheel Servo Base for PS4 and PS3	159.99	92.63
08-10-25	8030	3049	FLI-HO4	T-Flight Hotas 4 Flight Stick	34.65	19.76
08-10-25	8030	3049	FLI-USB	USB Joystick	21.99	12.06
08-10-25	8031	3022	FLI-STX	T-Flight Stick X PS3	39.99	21.04
08-10-25	8032	3035	WHL-TGT	T-GT Racing Wheel (PS4/PC)	614.91	354.66
08-10-25	8033	3021	WHL-T3S	VG T300RS Racing Wheel Servo Base for PS4 and PS3	159.99	92.63
08-10-25	8033	3021	FLI-HO1	T-Flight Hotas One	59.99	30.17
08-10-25	8034	3000	PED-T3A	T3PA Add-On	69.99	36.4
08-10-25	8035	3071	PED-TFR	TFRP Rudder	69.99	41.18
08-10-25	8035	3071	FLI-HO1	T-Flight Hotas One	59.99	30.17
08-10-25	8036	3045	FLI-STX	T-Flight Stick X PS3	39.99	21.04
08-10-25	8037	3061	PED-T3P	FB T3PA-Pro 3-Pedal Add-On Set	129.99	66.14
08-10-25	8038	3074	WHL-T3P	T300RS Racing Wheel	426.41	231.54
08-10-25	8039	3037	FLI-USB	USB Joystick	21.99	12.06
08-10-25	8039	3037	PED-FCS	T16000M FCS	39.19	23.36
08-10-25	8039	3037	FLI-THR	TWCS Throttle	59.99	35.18
08-10-25	8040	3038	FLI-HOX	T-Flight Hotas X Flight Stick	39.99	20.53
08-10-25	8041	3011	PED-FER	Ferrari Racing Wheel Red Legend Edition	79.99	43.51
09-10-25	8042	3077	FLI-16M	T 16000M Space SIM Duo Stick	117.83	69.36
09-10-25	8043	3097	COM-FCS	T16000M FCS Flight Pack	172.35	89.15
09-10-25	8044	3061	FLI-USB	USB Joystick	21.99	12.06
09-10-25	8045	3079	PED-TPR	TPR Pedals - Windows	497.38	284.93
09-10-25	8045	3079	FLI-STX	T-Flight Stick X PS3	39.99	21.04
09-10-25	8046	3075	PED-T3P	FB T3PA-Pro 3-Pedal Add-On Set	129.99	66.14
09-10-25	8046	3075	WHL-T3S	VG T300RS Racing Wheel Servo Base for PS4 and PS3	159.99	92.63
09-10-25	8047	3098	FLI-THR	TWCS Throttle	59.99	35.18
09-10-25	8048	3026	FLI-THR	TWCS Throttle	59.99	35.18
09-10-25	8049	3003	FLI-THR	TWCS Throttle	59.99	35.18
10-10-25	8050	3063	PED-T80	T80 Ferrari 488 GTB Edition Racing Wheel PS4	94.99	52.58
11-10-25	8051	3088	PED-FCS	T16000M FCS	39.19	23.36
11-10-25	8052	3010	WHL-T3S	VG T300RS Racing Wheel Servo Base for PS4 and PS3	159.99	92.63
11-10-25	8053	3044	COM-FCS	T16000M FCS Flight Pack	172.35	89.15
11-10-25	8053	3044	FLI-TMX	TMX Force Feedback Racing Wheel	159.84	87.3
11-10-25	8053	3044	FLI-HOX	T-Flight Hotas X Flight Stick	39.99	20.53
11-10-25	8054	3082	FLI-16H	T1600M FCS Hotas	97.3	52.53
11-10-25	8054	3082	FLI-HO1	T-Flight Hotas One	59.99	30.17
11-10-25	8054	3082	PED-T3A	T3PA Add-On	69.99	36.4
11-10-25	8055	3091	PED-TFR	TFRP Rudder	69.99	41.18
11-10-25	8056	3034	PED-FCS	T16000M FCS	39.19	23.36
11-10-25	8057	3020	WHL-TGT	T-GT Racing Wheel (PS4/PC)	614.91	354.66
11-10-25	8058	3041	COM-FCS	T16000M FCS Flight Pac Fantastic news! We've Found the answer you've been seeking! Answer rating: 62% (8 reviews) ai 488388 aii 487364 aiii bi 1277842 bii 1550113 biii ci 94646 cii 134...View the full answer Answered By Simon kingori I am a tier-one market researcher and content developer who has been in this field for the last six years. I’ve run the freelancing gamut; from market research, data mining and SEO/SMM to copywriting, Content Development, you name it, I’ve done it. I’m extremely motivated, organized and disciplined – you have to be to work from home. My experience in Freelancing is invaluable- but what makes me a cut above the rest is my passion to deliver quality results to all my clients- it’s important to note, I've never had a dissatisfied client. Backed by a Masters degree in Computer Science from MOI university, I have the required skill set and burning passion and desire to deliver the best results for my clients. This is the reason why I am a cut above the rest. Having taken a Bsc. in computer science and statistics, I deal with all round fields in the IT category. It is a field i enjoy working in as it is dynamic and new things present themselves every day for research and exploration. 5.00+ 1+ Reviews 10+ Question Solved Related Book For   Introduction To Business Analytics ISBN: 9781265454340 1st Edition Authors: Vernon Richardson, Marcia Watson See More Books Question Posted: Jul 25, 2023 02:34 AM See More Questions Students also viewed these Business questions In Milestone 1, the controller asks you to prepare a model of the annual master budget for the year 2018. The goal of Milestone 1 is to prepare a master budget for 2018 in the contribution format,... You will find in Chapter 39 that electrons cannot move in definite orbits within atoms, like the planets in our solar system. To see why, let us try to "observe" such an orbiting electron by using a... In Exercise 5, the following scenario was presented: As a promotion, a cereal brand is offering a prize in each box and there are four possible prizes. You would like to collect all four prizes, but... . Suppose that the city of New York issues bonds to raise money to pay for a new tunnel linking New Jersey and Manhattan. An investor named Susan buys one of the bonds on the same day that the city... Gruver Corporation reported the following payroll-related costs for the month of February: Gross pay (wages expense) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .... Two separate capacity constraints are discussed in this chapter: (1) the actual physical capacity of existing plants and equipment, shown as the vertical portion of the short-run AS curve, and (2)... Washington Tennis & Education Foundation, Inc. (WTEF) is a nonprofit organization operating in the District of Columbia that provides athletic and academic programs for children from low-income... Selected transactions completed by Primo Discount Corporation during the current fiscal year are as follows: Jan. 9. Split the common stock 3 for 1 and reduced the par from $75 to $25 per share.... Describe a specific scenario, situation, or application where using a foreign key would be necessary. 2) Explain your reasons, including the characteristics of the data, that necessitate the foreign... Problems 77 86. The purpose of these problems is to keep the material fresh in your mind so that you are better prepared for later sections, a final exam, or subsequent courses such as calculus.... In the Mini Case on Tide PODS in this chapter, you saw how a customer-facing display of data on Amazons website reflects different data types. Based on the data types identified in the Mini Case, it... Describe the concept of realization for tax purposes. 30.0 50.0 N As you will see in FIGURE-1, A man cleaning a floor pulls a vacuum cleaner with a force of magnitude F= 50.0N at an angle of 30.0 with the horizontal. Calculate the work done by the force... A stalled car was pushed to the top of a hill, allowed to roll down the hill and started by releasing the clutch. At which point did the car have the greatest amount of gravitational potential energy. The length of the river span of a bridge is 2783.0 ft . . The total length of the bridge is 7988 ft . Convert the length of the river span of the bridge to meters. High cholesterol in the blood can cause fatty deposits called plaques to form on the walls of blood vessels. Suppose a plaque reduces the effective radius of an artery by 3 0 % . What is the... Which of these is NOT a marketing intermediary? A. Resellers OB. Marketing research firms OC. Suppliers OD. Physical distribution firms OE. Advertising agencies A shipment of 100 pins contains some defectives. To decide whether to accept the shipment, the consumer follows a sampling plan where 15 items are chosen at random from the sample and tested. If the... Using Gauss-Jordan elimination, invert this matrix ONLY 0 0 0 0 1 Use Holt's method to create a model that minimizes the MSE for the data set. Use Solver to determine the optimal values of and a. What are the optimal values of and ? b. What are the forecasts for... Branch banks must keep enough money on hand to satisfy customers' cash demands. Suppose that the daily demand for cash at a branch of University Bank follows a lognormal distribution with means and... Meredith Shomers manages scholarship endowments for a major public university. Presently, she is trying to determine how much scholarship money may be awarded from an endowment with a current balance... For your first assignment you will develop a paper that addresses the following questions. Support your statements with the text book, assigned readings and other valid sources. Be practical, use... At the beginning of the year, BJ's had an outstanding short-term loan of $527. The interest charges for the year were $31 and the annual net cash flow was $211, prior to any payment of principal or... what is an income statement and what it contains. Define the three main components. what other two component is related to the income statement that you find interesting in walmart aside from the... Design And Analysis Of Experiments With SAS 1st Edition - ISBN: 1420060600 - Free Book Study smarter with the SolutionInn App Get In Touch About Us Contact Us Career Jobs FAQ Campus Ambassador Company Info Security Copyrights Privacy Policy Terms & Condition SolutionInn Fee Scholarship Services Sitemap Fun Definitions Become Tutor Study Help Categories Recent Questions Expert Questions Copyright © 2024 SolutionInn All Rights Reserved. Get the SolutionInn - Study Help App