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: 66% (9 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) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .... Mapplebeck Company Ltd. is gathering evidence to support an accrual for legal claims. Three lawsuits are outstanding: Claim 1 is a lawsuit from an employee for $750,000. According to the legal team,... * What difficulties or sensitivities might the gathering and the analysis of such evidence have thrown up? You operate a carwash with one machine. When you charge $10 per wash you expect to have 20,000 customers per year. For every 10c reduction in price you expect to add 250 customers per year. Your... Assume that the City of Coyote has produced its financial statements for December 31, 2020, and the year then ended. The city's general fund was only used to monitor education and parks. Its capital... 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... What mass of steam at 100C must be mixed with 150 g of ice at its melting point, in a thermally insulated container, to produce liquid water at 50C? At 3 1 st March, 2 0 2 3 , AB Ltd , had an Authorized Capital of K 3 5 , 0 0 0 divided into 1 0 , 0 0 0 7 . 5 % noncumulative per share being due on 3 0 th June, 1 9 6 4 . per share paid, the... A Leadership and Workforce Development Perspective. The literature review should discuss the related literature, organized by topic or themes (not a list of sources). A literature review includes... Critical Success Factors (CSF) are elements that are necessary for an organization or a project to attain its objectives. For example, Chief Executive support is a CSF for corporate sustainability... Ultra Ceramic Products presented the following data for its operations for the month of October, 2020: Dept 1 Work in process, July t. 1(Conversion costs, 60%) 7,000 units Transferred to Dept 2 Work... Choose a global organizational leader who demonstrated how a high level of ethical communication via social media technologies have worked best at building trust with virtual stakeholders. Identify a... Flip a fair dice 3 times. (a) What is the probability of o 6 observed". (b) What is the probability of \at least one 6 observed". (c) What is the probability of \exactly one 6 observed". (d) What is... Air pollution generated by a steel mill is an example of a) a positive production externality. b) a negative production externality. c) a public good. d) the free-rider problem. State and local taxes... 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... C0 = 10.648148 b) ( 4 Marks ) As of now, Given the above conditions on the option, what is the intrinsic value of the call option? What is the time value of the call option? interest revenue 19,500 retained earning,end 5,000 selling expenses 145,00 prepaid insurance 20,000 loss and disposal of a business (discountied),net 28,000 income from operation 140,000 unearned... cost that do not extend the acid capacity or it's useful life, but merely maintained the assd, or restore it to working order are recorded as losses True or False Psychotherapy In Private Practice Ingredients Promising Superior Outcomes 1st Edition - ISBN: B0B4HJ2FXR - 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