Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have this accounting information systems assignment to do and cannot get MyPurchasesDollars, MyPurchasesUnits, MySalesDollars and MySalesUnits to calculate the formula for cells outputted on
I have this accounting information systems assignment to do and cannot get MyPurchasesDollars, MyPurchasesUnits, MySalesDollars and MySalesUnits to calculate the formula for cells outputted on the Gross Profit Report tab using the GrossProfit macro I created. MySalesUnits should calculate the correct number of sales, MySalesDollars should calculate the correct sales in cash, and so on withMyPurchasesDollars, MyPurchasesUnits. Anyone have a solution? I'm just getting zeros. Attached is instructions. I am up to page 18.
A B C D E 1 Purchase Report 2 Year 2022 3 Date Units Amount 4 Purchase # Product 58217 Pen 01/01/22 25 100.00 5 58226 Pen 06/15/22 40 170.00 6 58220 Pen 02/03/22 50 250.00 7 58219 Marker 01/02/22 15 300.00 8 58218 Paper 01/01/22 33 330.00 9 58222 Pen 04/10/22 50 350.00 10 58223 Marker 04/13/22 20 440.00 11 58228 Paper 09/08/22 37 440.00 12 58221 Pen 03/08/22 75 450.00 13 58225 Pen 05/13/22 60 480.00 14 58231 Paper 12/11/22 40 480.00 15 58224 Paper 05/06/22 35 490.00 16 58230 Marker 12/10/22 40 535.00 17 58227 Marker 07/23/22 25 575.00 18 58229 Marker 11/01/22 30 750.00 19 A B C D E 1 Sales Report 2 Year 2022 3 Product Date Units Amount 4 Invoice # 188243 Paper 01/21/22 20 (500.00) 5 6 188244 Pen 05/05/22 100 (1,500.00) 7 8 188245 Paper 05/06/22 30 (900.00) 9 10 188246 Marker 08/01/22 60 (2,400.00) 11 12 188247 Pen 07/15/22 25 (400.00) 13 14 188248 Paper 09/08/22 40 (1,040.00) 15 16 188249 Marker 12/15/22 40 (1,800.00) 17 18 188250 Paper 12/11/22 5 (125.00) 19 20 188251 Pen 12/14/22 75 (1,125.00) 21 Gross Profit By Product Saturday, June 04, 2016 Gross Profit By Product2016 06 04 15.12.15 Start Report Reference # Product 58219 Marker 58223 Marker 58227 Marker 188246 Marker 58229 Marker 58230 Marker 188249 Marker Date Units 1/2/2022 4/13/2022 7/23/2022 8/1/2022 11/1/2022 12/10/2022 12/15/2022 Sales Cost of Goods Available Ending Inventory Cost of Goods Sold Gross Profit 58218 Paper 188243 Paper 58224 Paper 188245 Paper 58228 Paper 188248 Paper 58231 Paper 188250 Paper 1/1/2022 1/21/2022 5/6/2022 5/6/2022 9/8/2022 9/8/2022 12/11/2022 12/11/2022 Sales Cost of Goods Available Ending Inventory Cost of Goods Sold Gross Profit 58217 Pen 58220 Pen 1/1/2022 2/3/2022 Amount 15 20 25 60 30 40 40 300 440 575 -2400 750 535 -1800 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 33 20 35 30 37 40 40 5 330 -500 490 -900 440 -1040 480 -125 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 25 50 100 250 58221 Pen 58222 Pen 188244 Pen 58225 Pen 58226 Pen 188247 Pen 188251 Pen 3/8/2022 4/10/2022 5/5/2022 5/13/2022 6/15/2022 7/15/2022 12/14/2022 Sales Cost of Goods Available Ending Inventory Cost of Goods Sold Gross Profit 75 50 100 60 40 25 75 450 350 -1500 480 170 -400 -1125 0 0 0 0 #DIV/0! #DIV/0! #DIV/0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started