Question

Pop-up Data Table:

SALES MONTH January February (Click on the icon located on the top-right corner of the data table above in order to copy its contents into a spreadsheet.) SALES $17,000 $21,000 MONTH March April (projected) $25,000 $30,000

Answer 1

SEE IMAGE

ACCOUNTS Microsoft Excel Home nert Page Layout Formulas Data Review View dd-Ins as Cut ta copy ▼ Σ AutoSum ー E " ゴWrap Text в 1 프 . Ej- 山, Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Alignment Number Cells Edting BX22 BV BW BX BY B2 CA CB CD CE CF JAN FEB MAR APR MAY UNE SALES 17000 21000 25000 30000 COLLECTION IN THE SAME MONTH (50%)-CASH SALES CREDIT SALES 850010500 12500 15000 850010500 12500 15000 10 COLLECTION IN THE NEXT MONTH (40% OF CREDIT SALES) COLLECTION 2 MONTHS AFTER SALES (60% OF CREDIT SALES) 5000 6300 3400 4200 5100 6000 75009000 12 13 14 15 16 17 18 19 20 21 NS (a) ACCOUNTS RECEIVABLES BALANCE AT THE END OF APRIL 60% CREDIT SALES OF MARCH WILL BE THE PART OF RECEIVABLE IN APRIL CREDIT SALES OF APRIL WILL BE THE PART OF RECEIVABLE IN APRIL 22500 7500 15000 NS (b) TOTAL CASH & COLLECTIONS IN APRIL CASH SALES OF 15000 OF APRIL WILL COME 40% OF CREDIT SALES OF MARCH WILL COME IN APRIL 60% OF CREDIT SALES OF FEB WILL COME IN APRIL 26300 15000 5000 6300 23 24 25 ANY DOUBTS, PLEASE FEEL FREE TO ASK Sheet1 ! CASH BUDGET, bud PAYABLES Ready Circular References 03-05-2018

Go through it, Any doubts, please feel free to ask, Give positive feedback, Thank you