The table below represents company sales for the year 2019

Months	Sales
January	1200
February	1280
March	1310
April	1270
May	1190
June	1290
July	1410
August	1360
September	1430
October	1280
November	1410
December	1390

Required

Calculate 3 and 6 monthly moving averages for the data.

Transcribed Image Text:

1 of 2 CONTINUING PROBLEM Tony Freedman was very happy to see the progress made by using the specialized journals. Effective January 1, 2017, the company obtains an HST number and so begins to charge HST at 13% on all sales made. The company also pays HST from January 1 on all purchases. The special journals used i Tony's company have been modified to include columns for HST, and these can be found in the Study Guide with Working Papers, pages 11-78 to 11-91. The partial January transactions are as follows: 2017 Jan. 3 Received cheque from Carson Engineering Corp. for amount outstanding. 3 Wrote cheque No. 280 to Able Holdings for December, January, and February rent, $1,200 (HST exempt). 3 Bought merchandise on account from Computer Connection (purchase order No. 4016), $2,500, plus HST, terms 3/10, n/30. 3 Paid amount due to Staples (cheque No. 281). 3 Sold $900, plus HST, worth of merchandise to Taylor Golf on credit, sales invoice No. 12690; terms are 2/10, n/30. 3 Charged $5,085, including HST, for cash sales for the week of January 3. 6 Bought merchandise on account from Multi Systems (purchase order No. 4017), $300, plus HST; terms are 3/10, n/30. Bought office supplies on account from Staples (purchase order No. 4018), $200, plus HST; terms are n/30. Issued debit memorandum No. 11 to Computer Connection for merchandise returned from purchase order No. 4016, $300 (remember the HST). 9 Paid City Newspaper amount owing from December 31, cheque No. 282. Received electric bill for January, $250, plus HST. Received from Taylor Golf balance owing as of December 31. Purchased merchandise on account from Computer 6 9 10 10 10 Connection (purchase order No. 4019), $500, plus HST, terms are 1/30, n/60. 10 Paid West Bell Canada December 11 bill, cheque No. 283. 10 Sold $3,500, plus HST, worth of merchandise on account to Digital Prints Co., invoice 12691, terms are 2/10, n/30. 10 Charged $13,560, including HST, for cash sales for the week of January 10. 13 Paid net amount due to Computer Connection (purchase order No. 4016), less discount, cheque No. 284. 13 Paid amount due to CRA re December wages, cheque No. 285. 13 Received January phone bill, $110, plus HST. 13 Paid Multi Systems re January 6 purchase, less discount, cheque No. 286. 1.00 17 Charged $15,820, including HST, for cash sales for the week of January 17. 17 Paid Alpha Office Co the amounting from December, cheque No 287 13 Received January phone bill, $110, plus HST. 13 Paid Multi Systems re January 6 purchase, less discount. cheque No. 286.41.000 17 Charged $15,820, including HST, for cash sales for the week of January 17, 17 Paid Alpha Office Co. the amount owing from December, cheque No. 287. 23 Sold $4,000, plus HST, worth of merchandise on account to Noel Aberhart, sales invoice No. 12692; terms are 4/10, n/30. Charged $13,560, including HST, for cash sales for the week of January 24. 24 27 Issued credit memorandum to Digital Prints Co. for $400 worth of merchandise returned (remember the HST), invoice No. 12691. 27 Charged amount owing (less discount from Noel Aberhart, invoice No. 12692. 30 Sold $1,600, plus HST, worth of merchandise to Anthony Pitale, invoice No. 12693; terms 2/10, n/30. Charged full payment from Digital Prints (remember the credit memorandumi, invoice No. 12691. 30 31 Charged $12,430, including HST, for cash sales for the week of January 31. 31 Wrote cheque No. 288 to Automated Payroll Service for January covering January wages, $8,740.20. Tony has decided to spend his time doing repairs and making sales rather than preparing payroll records like he did in November and December. The company issues cheques to all employees weekly but obtains one cheque monthly from Tony's company for wages, benefits, and its own charges at month-end. Schedule of Accounts Receivable Precision Computer Centre December 31, 2016 Anthony Pitale Taylor Golf Carson Engineering Total Amount Due Schedule of Accounts Payable Precision Computer Centre December 31, 2016 Alpha Office Co. City Newspaper $ 1,600.00 3,200.00 14,990.00 $19,790.00 Staples West Bell Canada Total Amount Payable $ 318.00 855.00 250.00 165.00 $1,588.00 Assignment (See pages 11-78 to 11-91 in your Study Guide with Working Papers.) Journalize the transactions in the appropriate journals (cash receipts, sales, cash payments, purchases, or general journal). Record in the accounts receivable subsidiary ledger and accounts payable subsidiary ledger and post to the general ledger as appropriate. A partial general ledger is included in the Study Guide with Working Papers. accounts Prepare a schedule of accounts receivable, and a schedule of payable as of January 31, 2017. 1 of 2 CONTINUING PROBLEM Tony Freedman was very happy to see the progress made by using the specialized journals. Effective January 1, 2017, the company obtains an HST number and so begins to charge HST at 13% on all sales made. The company also pays HST from January 1 on all purchases. The special journals used i Tony's company have been modified to include columns for HST, and these can be found in the Study Guide with Working Papers, pages 11-78 to 11-91. The partial January transactions are as follows: 2017 Jan. 3 Received cheque from Carson Engineering Corp. for amount outstanding. 3 Wrote cheque No. 280 to Able Holdings for December, January, and February rent, $1,200 (HST exempt). 3 Bought merchandise on account from Computer Connection (purchase order No. 4016), $2,500, plus HST, terms 3/10, n/30. 3 Paid amount due to Staples (cheque No. 281). 3 Sold $900, plus HST, worth of merchandise to Taylor Golf on credit, sales invoice No. 12690; terms are 2/10, n/30. 3 Charged $5,085, including HST, for cash sales for the week of January 3. 6 Bought merchandise on account from Multi Systems (purchase order No. 4017), $300, plus HST; terms are 3/10, n/30. Bought office supplies on account from Staples (purchase order No. 4018), $200, plus HST; terms are n/30. Issued debit memorandum No. 11 to Computer Connection for merchandise returned from purchase order No. 4016, $300 (remember the HST). 9 Paid City Newspaper amount owing from December 31, cheque No. 282. Received electric bill for January, $250, plus HST. Received from Taylor Golf balance owing as of December 31. Purchased merchandise on account from Computer 6 9 10 10 10 Connection (purchase order No. 4019), $500, plus HST, terms are 1/30, n/60. 10 Paid West Bell Canada December 11 bill, cheque No. 283. 10 Sold $3,500, plus HST, worth of merchandise on account to Digital Prints Co., invoice 12691, terms are 2/10, n/30. 10 Charged $13,560, including HST, for cash sales for the week of January 10. 13 Paid net amount due to Computer Connection (purchase order No. 4016), less discount, cheque No. 284. 13 Paid amount due to CRA re December wages, cheque No. 285. 13 Received January phone bill, $110, plus HST. 13 Paid Multi Systems re January 6 purchase, less discount, cheque No. 286. 1.00 17 Charged $15,820, including HST, for cash sales for the week of January 17. 17 Paid Alpha Office Co the amounting from December, cheque No 287 13 Received January phone bill, $110, plus HST. 13 Paid Multi Systems re January 6 purchase, less discount. cheque No. 286.41.000 17 Charged $15,820, including HST, for cash sales for the week of January 17, 17 Paid Alpha Office Co. the amount owing from December, cheque No. 287. 23 Sold $4,000, plus HST, worth of merchandise on account to Noel Aberhart, sales invoice No. 12692; terms are 4/10, n/30. Charged $13,560, including HST, for cash sales for the week of January 24. 24 27 Issued credit memorandum to Digital Prints Co. for $400 worth of merchandise returned (remember the HST), invoice No. 12691. 27 Charged amount owing (less discount from Noel Aberhart, invoice No. 12692. 30 Sold $1,600, plus HST, worth of merchandise to Anthony Pitale, invoice No. 12693; terms 2/10, n/30. Charged full payment from Digital Prints (remember the credit memorandumi, invoice No. 12691. 30 31 Charged $12,430, including HST, for cash sales for the week of January 31. 31 Wrote cheque No. 288 to Automated Payroll Service for January covering January wages, $8,740.20. Tony has decided to spend his time doing repairs and making sales rather than preparing payroll records like he did in November and December. The company issues cheques to all employees weekly but obtains one cheque monthly from Tony's company for wages, benefits, and its own charges at month-end. Schedule of Accounts Receivable Precision Computer Centre December 31, 2016 Anthony Pitale Taylor Golf Carson Engineering Total Amount Due Schedule of Accounts Payable Precision Computer Centre December 31, 2016 Alpha Office Co. City Newspaper $ 1,600.00 3,200.00 14,990.00 $19,790.00 Staples West Bell Canada Total Amount Payable $ 318.00 855.00 250.00 165.00 $1,588.00 Assignment (See pages 11-78 to 11-91 in your Study Guide with Working Papers.) Journalize the transactions in the appropriate journals (cash receipts, sales, cash payments, purchases, or general journal). Record in the accounts receivable subsidiary ledger and accounts payable subsidiary ledger and post to the general ledger as appropriate. A partial general ledger is included in the Study Guide with Working Papers. accounts Prepare a schedule of accounts receivable, and a schedule of payable as of January 31, 2017.

Answer rating: 100% (QA)

1 2 3 4 5 6 7 8 9 10 11 12 13 3 A Months January February March Apr... View the full answer