Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
1. use Excel to determine sales by date, by product, by invoice, by customer, or a combination thereof. 2. explain what can be accomplished when
1. use Excel to determine sales by date, by product, by invoice, by customer, or a combination thereof. 2. explain what can be accomplished when analyzing data. Case Scenario: You are working at a startup that-sells university merchandise online. The business selis wholesale to six customers: Atlanta, Dakota, Madrid, Orlando, Phoenix, and Venice companies. It is December 31 , and you must analyze sales on account from this past yejir. Accounts receivable data is captured in the attached excel file. Required: Download spreadsheet CaseAccountsReceivableData-114e10.xisx Analyze the accounts receivable data in the spreadsheet and enter the answers to the questions for a grade. HINT: STEP-BY-STEP WALKTHROUGH 1. How much did Phoenix Company pay on account during the year? 2. What is the total of Madrid's past-due invoices? 3. What is the average amount of all invoices issued in April? 4. How many unpaid invoices does Oriando Company in June, July, and August combined? \begin{tabular}{|c|c|c|c|c|c|} \hline 6211211E & 1324 & Atlanta & 1,720 & & 1,720 \\ \hline 0211211 & 1325 & Phoenix & 810 & & 810 \\ \hline 0211211 & 1326 & Venice & 1,575 & paid & \\ \hline 62112 12 E & 1327 & Atlanta & 1,240 & & 1,240 \\ \hline 621 12 13E & 1328 & Dakota & 720 & & 720 \\ \hline 021 1215 & 1329 & Orlando & 4,320 & & 4,320 \\ \hline .0211217 & 1330 & Madrid & 630 & & 630 \\ \hline 0211219E & 1331 & Dakota & 825 & & 825 \\ \hline 021 12 21E & 1332 & Atlanta & 745 & paid & \\ \hline 02112 21E & 1333 & Atlanta & 720 & & 720 \\ \hline 02112 21E & 1334 & Dakota & 4,840 & & 4,840 \\ \hline .0211223 & 1335 & Orlando & 1,620 & & 1,620 \\ \hline .0211224E & 1336 & Dakota & 1,210 & & 1,210 \\ \hline 0211224E & 1337 & Phoenix & 700 & & 700 \\ \hline 021 1226E & 1338 & Phoenix & 2,325 & & 2,325 \\ \hline 0211226 & 1339 & Dakota & 5,530 & & 5,530 \\ \hline 021 1226E & 1340 & Atlanta & 1,980 & & 1,980 \\ \hline .0211226 & 1341 & Venice & 1,575 & paid & \\ \hline 6211228E & 1342 & Dakota & 1,375 & & 1,375 \\ \hline 0211229 & 1343 & Atlanta & 2,830 & & 2,830 \\ \hline .0211229E & 1344 & Phoenix & 880 & & 880 \\ \hline 02112 30E & 1345 & Venice & 2,170 & & 2,170 \\ \hline 02112 30E & 1346 & Venice & 4,125 & & 4,125 \\ \hline & & & & & \\ \hline \end{tabular} Visw zoom Ada Category Dhat rable Ag no Dats \begin{tabular}{|c|c|c|c|c|c|c|} \hline 2021109 & 1256 & Dakota & 60 & paid & & \\ \hline 021109 & 1257 & Dakota & 1,560 & & & 1,560 \\ \hline 021 10 10E & 1258 & Dakota & 1,225 & paid & & \\ \hline 0211011E & 1259 & Atianta & 1,440 & & & 1,440 \\ \hline 0211011E & 1260 & Phoenix & 775 & paid & & \\ \hline 621 10 12E & 1261 & Venice & 5,280 & paid & & \\ \hline 02110 12E & 1262 & Madrid & 1,720 & paid & & \\ \hline 0211013E & 1263 & Atlanta & 1,530 & paid & & \\ \hline 021 10 13E & 1264 & Dakota & 270 & & & 270 \\ \hline 0211014E & 1265 & Madrid & 2,605 & paid & & \\ \hline 02110 15E & 1266 & Atlanta & 5,070 & & & 5,070 \\ \hline 6211017E & 1267 & Dakota & 480 & paid & & \\ \hline 0211019E & 1268 & Venice & 90 & & & 90 \\ \hline 62110 19E & 1269 & Orlando & 1,135 & paid & & \\ \hline 2.11020E & 1270 & Orlando & 3,325 & paid & & \\ \hline 0211022E & 1271 & Venice & 375 & paid & & \\ \hline 6211022E & 1272 & Dakota & 3,535 & paid & & \\ \hline 6211022E & 1273 & Oriando & 750 & & & 750 \\ \hline 211023E & 1274 & Orlando & 2,170 & paid & & \\ \hline 0211024E & 1275 & Orlando & 1,470 & & & 1,470 \\ \hline 6211026 & 1276 & Madrid & 1,750 & paid & & \\ \hline 62110 28E & 1277 & Venice & 1,960 & paid & & \\ \hline 02110 30E & 1278 & Atlanta & 160 & & & 160 \\ \hline 6211031 & 1279 & Phoenix & 750 & paid & & \\ \hline 021112 & 1280 & Phoenix & 625 & paid & & \\ \hline 021112 & 1281 & Madrid & 1,045 & paid & & \\ \hline 2021113 & 1282 & Madrid & 270 & & 270 & \\ \hline 2021113 & 1283 & pakota & 1,215 & paid & & \\ \hline 021115 & 1284 & tenice & 3,015 & & 3,015 & \\ \hline 021117 & 1285 & Madrid & 750 & & 750 & \\ \hline 021118 & 1286 & Dakota & 1,705 & paid & & \\ \hline 2021119 & 1287 & Dakota & 375 & & 375 & \\ \hline 021119 & 1288 & Atlanta & 1,950 & paid & & \\ \hline 6211111E & 1289 & Orlando & 640 & & 640 & \\ \hline 521 11 12E & 1290 & Orlando & 1,710 & & 1,710 & \\ \hline 52111 13E & 1291 & Dakota & 4,815 & paid & & \\ \hline 211115E & 1292 & Dakota & 1,560 & & 1,560 & \\ \hline 0211115E & 1293 & Phoenix & 4,365 & paid & & \\ \hline 21 11 16E & 1294 & Dakota & 3,325 & & 3,325 & \\ \hline 211117 & 1295 & Dakota & 1,710 & paid & & \\ \hline 2111 18E & 1296 & Phoenix & 880 & paid & & \\ \hline 211120E & 1297 & Madrid & 5,280 & paid & & \\ \hline 211120E & 1298 & Madrid & 2,190 & & 2,190 & \\ \hline & 1299 & Phoenix. & 2580 & oaid. & & \\ \hline \end{tabular} 1. use Excel to determine sales by date, by product, by invoice, by customer, or a combination thereof. 2. explain what can be accomplished when analyzing data. Case Scenario: You are working at a startup that-sells university merchandise online. The business selis wholesale to six customers: Atlanta, Dakota, Madrid, Orlando, Phoenix, and Venice companies. It is December 31 , and you must analyze sales on account from this past yejir. Accounts receivable data is captured in the attached excel file. Required: Download spreadsheet CaseAccountsReceivableData-114e10.xisx Analyze the accounts receivable data in the spreadsheet and enter the answers to the questions for a grade. HINT: STEP-BY-STEP WALKTHROUGH 1. How much did Phoenix Company pay on account during the year? 2. What is the total of Madrid's past-due invoices? 3. What is the average amount of all invoices issued in April? 4. How many unpaid invoices does Oriando Company in June, July, and August combined? \begin{tabular}{|c|c|c|c|c|c|} \hline 6211211E & 1324 & Atlanta & 1,720 & & 1,720 \\ \hline 0211211 & 1325 & Phoenix & 810 & & 810 \\ \hline 0211211 & 1326 & Venice & 1,575 & paid & \\ \hline 62112 12 E & 1327 & Atlanta & 1,240 & & 1,240 \\ \hline 621 12 13E & 1328 & Dakota & 720 & & 720 \\ \hline 021 1215 & 1329 & Orlando & 4,320 & & 4,320 \\ \hline .0211217 & 1330 & Madrid & 630 & & 630 \\ \hline 0211219E & 1331 & Dakota & 825 & & 825 \\ \hline 021 12 21E & 1332 & Atlanta & 745 & paid & \\ \hline 02112 21E & 1333 & Atlanta & 720 & & 720 \\ \hline 02112 21E & 1334 & Dakota & 4,840 & & 4,840 \\ \hline .0211223 & 1335 & Orlando & 1,620 & & 1,620 \\ \hline .0211224E & 1336 & Dakota & 1,210 & & 1,210 \\ \hline 0211224E & 1337 & Phoenix & 700 & & 700 \\ \hline 021 1226E & 1338 & Phoenix & 2,325 & & 2,325 \\ \hline 0211226 & 1339 & Dakota & 5,530 & & 5,530 \\ \hline 021 1226E & 1340 & Atlanta & 1,980 & & 1,980 \\ \hline .0211226 & 1341 & Venice & 1,575 & paid & \\ \hline 6211228E & 1342 & Dakota & 1,375 & & 1,375 \\ \hline 0211229 & 1343 & Atlanta & 2,830 & & 2,830 \\ \hline .0211229E & 1344 & Phoenix & 880 & & 880 \\ \hline 02112 30E & 1345 & Venice & 2,170 & & 2,170 \\ \hline 02112 30E & 1346 & Venice & 4,125 & & 4,125 \\ \hline & & & & & \\ \hline \end{tabular} Visw zoom Ada Category Dhat rable Ag no Dats \begin{tabular}{|c|c|c|c|c|c|c|} \hline 2021109 & 1256 & Dakota & 60 & paid & & \\ \hline 021109 & 1257 & Dakota & 1,560 & & & 1,560 \\ \hline 021 10 10E & 1258 & Dakota & 1,225 & paid & & \\ \hline 0211011E & 1259 & Atianta & 1,440 & & & 1,440 \\ \hline 0211011E & 1260 & Phoenix & 775 & paid & & \\ \hline 621 10 12E & 1261 & Venice & 5,280 & paid & & \\ \hline 02110 12E & 1262 & Madrid & 1,720 & paid & & \\ \hline 0211013E & 1263 & Atlanta & 1,530 & paid & & \\ \hline 021 10 13E & 1264 & Dakota & 270 & & & 270 \\ \hline 0211014E & 1265 & Madrid & 2,605 & paid & & \\ \hline 02110 15E & 1266 & Atlanta & 5,070 & & & 5,070 \\ \hline 6211017E & 1267 & Dakota & 480 & paid & & \\ \hline 0211019E & 1268 & Venice & 90 & & & 90 \\ \hline 62110 19E & 1269 & Orlando & 1,135 & paid & & \\ \hline 2.11020E & 1270 & Orlando & 3,325 & paid & & \\ \hline 0211022E & 1271 & Venice & 375 & paid & & \\ \hline 6211022E & 1272 & Dakota & 3,535 & paid & & \\ \hline 6211022E & 1273 & Oriando & 750 & & & 750 \\ \hline 211023E & 1274 & Orlando & 2,170 & paid & & \\ \hline 0211024E & 1275 & Orlando & 1,470 & & & 1,470 \\ \hline 6211026 & 1276 & Madrid & 1,750 & paid & & \\ \hline 62110 28E & 1277 & Venice & 1,960 & paid & & \\ \hline 02110 30E & 1278 & Atlanta & 160 & & & 160 \\ \hline 6211031 & 1279 & Phoenix & 750 & paid & & \\ \hline 021112 & 1280 & Phoenix & 625 & paid & & \\ \hline 021112 & 1281 & Madrid & 1,045 & paid & & \\ \hline 2021113 & 1282 & Madrid & 270 & & 270 & \\ \hline 2021113 & 1283 & pakota & 1,215 & paid & & \\ \hline 021115 & 1284 & tenice & 3,015 & & 3,015 & \\ \hline 021117 & 1285 & Madrid & 750 & & 750 & \\ \hline 021118 & 1286 & Dakota & 1,705 & paid & & \\ \hline 2021119 & 1287 & Dakota & 375 & & 375 & \\ \hline 021119 & 1288 & Atlanta & 1,950 & paid & & \\ \hline 6211111E & 1289 & Orlando & 640 & & 640 & \\ \hline 521 11 12E & 1290 & Orlando & 1,710 & & 1,710 & \\ \hline 52111 13E & 1291 & Dakota & 4,815 & paid & & \\ \hline 211115E & 1292 & Dakota & 1,560 & & 1,560 & \\ \hline 0211115E & 1293 & Phoenix & 4,365 & paid & & \\ \hline 21 11 16E & 1294 & Dakota & 3,325 & & 3,325 & \\ \hline 211117 & 1295 & Dakota & 1,710 & paid & & \\ \hline 2111 18E & 1296 & Phoenix & 880 & paid & & \\ \hline 211120E & 1297 & Madrid & 5,280 & paid & & \\ \hline 211120E & 1298 & Madrid & 2,190 & & 2,190 & \\ \hline & 1299 & Phoenix. & 2580 & oaid. & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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