Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

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.

Step by Step Solution

3.47 Rating (160 Votes )

There are 3 Steps involved in it

Step: 1

1 2 3 4 5 6 7 8 9 10 11 12 13 3 A Months January February March Apr... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting A Practical Approach

Authors: Jeffrey Slater, Brian Zwicker

11th Canadian Edition

132564440, 978-0132564441

More Books

Students also viewed these Accounting questions

Question

define job satisfaction and job performance;

Answered: 1 week ago