Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10. the following supplier accounts with historical information: Name (Contact), Address Phone/Fax Options, Tax, Account Full Spectrum (Manny Colors) Tel: (716) 662-6682 Terms: 2/15, n/30

10. the following supplier accounts with historical information: Name (Contact), Address Phone/Fax Options, Tax, Account Full Spectrum (Manny Colors) Tel: (716) 662-6682 Terms: 2/15, n/30 (after tax) 189 Indigo Way, Buffalo, New York, USA 14209 Fax: (716) 662-6164 Tax Code: H Web site: www.fullspectrum.com Currency: USD Supplier since 02/01/2015 Medi-Specs (I.N. Spector) Tel: (613) 774-7109 Terms: net 15 (after tax) 512 Monitor Ct., Ottawa, ON K6T 7F3 Fax: (613) 774-7799 Tax Code: H E-mail: Supplier since 03/01/2016 Skin Decals, Inc. (Art) Tel: (905) 526-7191 Terms: 2/5, n/15 (after tax) 899 Creative Way, Oakville, ON L5R 2V7 Tax Code: H Tax ID: 887 210 092 Supplier since 01/01/2013 E-mail: Historical Supplier Invoices and Payments Name Terms Date Invoice/Chq Amount Full Spectrum 2/15, n/30 after tax Mar 15/22 FS-3903 $970 USD (990 CAD) Skin Decals, Inc. 2/5, n/15 (after tax) Mar 25/22 SD-621 $3 800 Mar 27/22 Chq 398 -1 800 Mar 30/22 SD-808 1 510 Balance owing $3 510 Grand Total $4 500

11. the following customer accounts with historical information:

The credit limit for all customers is $5 000. The terms for all customers are 1/15, n/30. The tax code for all customers is H. If information is not provided, leave fields blank. Customer accounts: Name (Contact), Address Phone/Fax Hart Bridal Party (Bonnie Hart) Tel: (647) 762-6712 Preferred Price List Fax: (647) 762-9991 55 Blissful Blvd., Toronto, ON M1P 7D3 Client since 11/01/2017 E-mail: Stan Stoner Tel: (416) 592-9001 110 Abbey Rd., Toronto, ON M8C 9A1 E-mail: Client since 12/01/2017 Historical Customer Invoices and Payments Name Terms Date Invoice/Chq Amount Stan Stoner 1/15, n/30 Mar 28/22 3104 $4 300 Mar 28/22 Chq 32 -1 500 Balance owing $2 800

12. Enter the following employee information: Use the linked payroll accounts. Employer pays medical premiums for employees (user-defined expense and employee benefit). Dyes has her tuition paid as a taxable benefit. Both employees have 100% their paycheques deposited directly to their bank accounts. Painter has just been hired so there is no historical data for her. Personal Magenta Dyes Carmine Painter Address 345 Ochre Blvd. 22 Crimson Ave. Toronto, ON M4H 4R2 Toronto, ON M3C 3W1 (416) 882-6234 (647) 598-7177 SIN# 624 514 774 621 628 999 Birth Date Apr. 15, 1984 Dec. 23, 1980 Date of Hire Feb. 1, 2007 Mar. 23, 2022 Taxes Tax Table Ontario Ontario Federal Claim $11,327 $11,327 Provincial Claim $9,863 $9,863 Federal Index amount $9,500 $5,600 Provincial Index amount $7,950 $3,450 (Entire claim amounts are subject to indexing) Additional Federal Tax $100 Deduct EI & CPP (EI Factor) Yes, Yes (1.4) Yes, Yes (1.4) Historical Income Tax $1 202 Historical EI Contributions $167 Historical CPP Contributions $474 Income Advances Historical Amount $150 Benefits (medical plan) $10 $20 Benefits Historical Amount $130 Vacation 6% retained 3 weeks (0%) Vacation Owed $360.00 Salary (do not use) $2 200 bi-monthly Salary Hours per Period 80 (Salary hours) Regular Wage $18.00/hr (do not use) Hours per Period 35 (Regular hours) Regular Wage Historical Amount $8 190 Overtime wage $27.00/hr (do not use) Overtime Wage Historical Amount $702 Commission (do not use) 1% of revenue No. Clients $5 (do not use) No. Clients Historical Amount $780 Tuition $50 (do not use) Tuition historical amount $650 Pay Periods per Year 52 24 Deductions CSB Deductions per Pay $50.00 $50.00 CSB Historical Contributions $650.00 WSIB and Other Expenses WSIB Rate 2.02% 2.02% Medical per pay (Historical Medical) $10.00 ($130.00) $20.00

Tuition per pay (Historical Tuition) $50 ($650.00) Magenta Dyes Carmine Painter Entitlements (Percentage for tracking, maximum days) Sick Leave 2.5%, 15 days max; clear 2.5%, 15 days max; clear Historical Sick Leave days 4 Vacation 6.0%, 25 days max; not cleared Historical Vacation days 0 Direct Deposit (100% of paycheques deposited) Branch No., Institution No. and Account numbers 38648, 223, 45567 16678,221, 2435644 T4 and RL-1 Reporting Historical EI Insurable Earnings $9 672 Historical Pensionable Earnings $10 452

13. Set up a payroll authority.

new supplier record for the Receiver General for Canada as the payroll authority for Income Tax, EI and CPP. Leave the remaining supplier fields blank. Settings -Payroll: Remittance and suppliers-Receiver General for Canada Remitting frequency - Monthly End of remittance period - April 15, 2022.

14. Set up job categories. two job categories named Sales and Other. Persons in the Sales category are salespersons. Persons in the Other category are not salespersons. Assign the employee Painter to the Sales category. Assign the employee Dyes to the Other category. Select Painter as the salesperson for all sales. 15. the following inventory accounts: Variance accounts will not be required. Leave the variance linked account field blank. Allow account classes to change. Customers pay HST on all inks, designs, tattoo services and custom design work. Ink tubes are purchased in lots of 10 tubes per box and stocked and sold as individual tubes. Note: Web pricing is the same as regular pricing. Inventory & Services: Reg (Pref) Opening Linked Accounts Description No. Unit Min Price (Price) Qty Value Asset Rev C.O.G.S. Ink - Permanent Colour 101 10 tubes/box 50 $10 ($8) 80 $320 1440 4020 5060 Ink - Permanent Outline 102 10 tubes/box 20 10 (8) 50 250 1440 4020 5060 Ink - Temporary Colour 201 10 tubes/box 50 8 (7) 60 300 1440 4020 5060 Ink - Temporary Outline 202 10 tubes/box 20 7 (5) 40 160 1440 4020 5060 Design - Small 301 each 10 25 (20) 100 1 400 1420 4020 5060 Design - Medium 302 each 10 60 (50) 100 2 900 1420 4020 5060 Design - Large 303 each 10 100 (90) 100 6 500 1420 4020 5060 Design - Special Order 304 each Custom Pricing 1420 4020 5060 Service No. Unit Reg Price (Pref Price) Tax Rev Expense Tattoo application 501 session $80 ($70) HST 4060 5070 Design Creation 502 each Custom pricing HST 4060 5070 16. two divisions starting April 1, 2022. 1. Sales 2. Services There are no balances forward. Select: 17. Back up your work. Continue with the original working copy, DERMAL.SAI. Finish entering the history. 18. Change the session date to April 8, 2022 Add the shortcuts you need and then enter the following transactions: NOTE: Be sure to use the correct bank account for each transaction. If you have set up the accounts correctly, the default account will be correct. Enter Carmine Painter as the salesperson for all sales. Cheque Purchase Invoice #LG-35887 Dated April 2, 2022 From Lee Gull, $2 373, including HST, for legal fee to draw up legal waiver form for business. Paid by cheque #432. new Group expense account 5240 Legal Expenses. Allocate 20% of expense to Sales Division and 80% to Services. Use Quick Add for the new supplier. Purchase Order #55 Dated April 3, 2022 Shipping Date April 11, 2022 From Skin Decals, Inc. 20 Designs - Small ($13 ea) $260.00 10 Designs - Medium ($27 ea) 270.00 10 Designs - Large ($58 ea) 580.00 Courier Freight Charge 40.00 HST Paid 149.50 Invoice Total $1 299.50 Terms: 1/10, net 30. Edit the default prices and terms. Cash Receipt #356 Dated April 4, 2022 From Stan Stoner, cheque #2773 for $2 757 in full payment of invoice #3104, taking into account 1% sales discount of $43 for early payment. Purchase Invoice #NN-601 Dated April 4, 2022 From Ned's Needles, $250, plus 13% HST for sterilized needles that fit tattoo gun. Invoice total $282.50. Terms: 1/15, net 30. Use Quick Add for new supplier. Payment Cheque #433 Dated April 4, 2022 To Skin Decals, Inc., $3 479.80 in payment of invoices #SD-621 and SD-808, including $30.20 discount for early payment, and $200 as deposit for purchase order #55. Total cheque amount is $3 679.80. Purchase Invoice #FS-4972 Dated April 5, 2022 From Full Spectrum, 4 boxes Ink - Permanent Colour ($40 ea) $160.00 USD 4 boxes Ink - Permanent Outline ($45 ea) 180.00 USD 4 boxes Ink - Temporary Colour ($45 ea) 180.00 USD 4 boxes Ink - Temporary Outline ($40 ea) 160.00 USD HST Paid 88.40 USD Invoice Total $768.40 USD Terms: 2/15, net 30 The exchange rate is 1.001 (the exchange rate difference amount may not be allocated) Edit the default prices. Cheque Copy #119 Dated April 6, 2022 To Full Spectrum, $970 USD in full payment of invoice #FS-3904. The exchange rate is 0.990. Paid from Bank: USD Chequing Account. Sales Quote #32 Dated April 6, 2022 Delivery Date April 15, 2022 To Hart Bridal Party (love knot & heart design tattoos for 10 members of wedding party) 10 Ink - Temporary Colour $7 /tube 10 Ink - Temporary Outline 5 /tube 20 Designs - Small 20 each 10 Tattoo applications 70 /session HST Charged 13 % Terms: 1/15, net 30. Sales Invoice #3110 Dated April 6, 2022 To Wanda Wonder (Use Quick Add for new Regular customer) 15 Ink - Permanent Colour $ 10 /tube 6 Ink - Permanent Outline 6 /tube 2 Designs - Medium 60 each 1 Design - Large 100 each 5 Tattoo applications 80 /session HST Charged 13 % Terms: 1/15, net 30. Allocate 100% of sales to Sales Division and 100% of services to Services Division. Memo #1 Dated April 6, 2022 Bonnie Hart has accepted the sales quote to Hart Bridal Party and is placing an order. Convert Sales Quote #32 to Sales Order #32 using the same shipping date, prices and terms. Cash Receipt #357 Dated April 7, 2022 From Hart Bridal Party, cheque #188 for $400 as deposit #106 to accept sales order #32. Deposit Slip #607 Dated April 7, 2022 Deposit two cheques received in the past week. Total deposit is $3 157. Sales Invoice #3111 Dated April 8, 2022 To One-time customers 12 Ink - Permanent Colour $10 /tube 5 Ink - Permanent Outline 6 /tube 6 Ink - Temporary Colour 8 /tube 2 Ink - Temporary Outline 7 /tube 15 Designs - Small 25 each 15 Tattoo applications 80 /session HST Charged 13 % $2 019.31 received by cheque #354 Allocate 100% of sales to Sales Division and 100% of services to Services Division. Edit the default prices. Memo #2 Dated April 8, 2022 Pay hourly employee, Magenta Dyes for 35 hours regular work. Recover $50 advance. Dyes should be paid for serving 10 clients (No. Clients piece rate pay). Allocate 30% of payroll expenses to Sales and 70% to Service. Issue deposit slip #68.

Hints: Use Payroll cheque run. Accept: Payroll Tables are out of date 19. Back up the data files. Continue with the file DERMAL.SAI. Change the session date to April 15, 2022. Enter the following transactions: Purchase Invoice #SD-986 Dated April 11, 2022 To fill Purchase Order #55 From Skin Decals, Inc. 20 Designs - Small ($13 ea) $260.00 10 Designs - Medium ($27 ea) 270.00 10 Designs - Large ($58 ea) 580.00 Courier Freight Charge 40.00 HST Paid 149.50 Invoice Total $1 299.50 Terms: 1/10, net 30 (new payment terms). Allocate 100% of freight expense to Sales Division. Memo #3 Dated April 11, 2022 Several boxes of supplies and inventory were damaged after a prolonged power failure. The following items were not usable and should be written off: Sterilized needles $120 Other supplies $80 Tattoo gun $250 30 tubes Ink - Permanent Colour accept cost price 20 tubes Ink - Temporary Colour accept cost price Allocate 100% of the cost of equipment and supplies to the Services division and 100% of the cost of damaged ink inventory to the Sales division. new General Ledger Group expense account 5210 Damaged Supplies and Equipment. (Hint: two journal entries are required.) Cash Receipt #358 Dated April 11, 2022 From Wanda Wonder, cheque #344 for $901.67 in payment of invoice #3110, taking into account 1% sales discount of $9.11 for early payment. Cash Receipt #359 Dated April 11, 2022 From Stan Stoner, cheque #2789 for $1 000 as deposit #107 in prepayment for tattoo work to be completed over several weeks. Sales Invoice #3112 Dated April 13, 2022 To Stan Stoner 4 Designs - Large $100 each 10 Ink - Permanent Outline 10 /tube 40 Ink - Permanent Colour 10 /tube 20 Tattoo application 80 /session HST Charged 13 % Terms: 1/15, net 30 Allocate 100% of sales to Sales Division and 100% of services to services Division. Accept message.

14 Sales Invoice #3113 Dated April 15, 2022 To Hart Bridal Party, to fill sales order #32 10 Ink - Temporary Colour $7 /tube 10 Ink - Temporary Outline 5 /tube 20 Designs - Small 20 each 10 Tattoo application 70 /session HST Charged 13 % Terms: 1/15, net 30. Allocate 100% of sales to Sales Division and 100% of services to services Division. Credit Card Sales Invoice #3114 Dated April 15, 2022 To One-time credit card customers 20 Ink - Permanent Colour $10 /tube 9 Ink - Permanent Outline 10 /tube 8 Ink - Temporary Colour 8 /tube 4 Ink - Temporary Outline 7 /tube 10 Designs - Medium 60 each 20 Tattoo application 80 /session HST Charged 13 % Invoice total $2917.66 paid by Wishful. Allocate 100% of sales to Sales Division and 100% of services to Services Division. Edit the default prices. Purchase Order #56 Dated April 15, 2022 Delivery Date: April 28, 2022 From Full Spectrum, one tattoo gun to replace the damaged equipment. The cost of the new gun is $320 plus HST $41.60. Invoice total $361.60 (USD). Terms: 2/15, net 30. The exchange rate is 0.985. Purchase Invoice # MS-903 Dated April 15, 2022 From Medi-Specs, $260 plus $33.80 HST for routine site and equipment inspection. Invoice total $293.80. Terms: net 15. new Group expense account 5250 Licenses and Inspections. Allocate 40% of the expense to Sales Division and 60% to the Services Division. Deposit Slip #608 Dated April 15, 2022 Deposit three cheques received in the past weeks totaling $3,920.98. Total deposit amount was $3 920.98. Memo #4 Dated April 15, 2022 Pay hourly employee, Magenta Dyes for 35 hours regular work. Recover $50 advance. Dyes took one day sick leave during the week. Dyes should be paid for serving 11 clients (No. Clients piece rate pay). Issue deposit slip #69. Allocate 40% of payroll expenses to Sales and 60% to Service. Ignore messages Memo #5 Dated April 15, 2022 Pay salaried employee, Carmine Painter $2 200 her regular bi-monthly salary. Calculate and include sales commission for Painter. Painter took one day sick leave during the pay period (allow negative days to accrue). Issue deposit slip #70. Allocate 30% of payroll expenses to Sales and 70% to Service. Note: Record hours worked per pay period.

Memo #6 Dated April 15, 2022 Transfer $4 000 from Bank: Credit Card to Bank to CAD Chequing Account. Transfer $2 000 USD from Bank: CAD Chequing Account to Bank: USD Chequing to cover upcoming payments. The exchange rate is 1.02. Bank Debit Memo #RCU-4433 Dated April 15, 2022 From Rainbow Credit Union, $600 for loan payment including $100 interest and $500 principal. Total amount withdrawn from CAD Chequing bank account was $600 Allocate 40% of the interest expenses to the Sales Division and 60% to the Services Division. Memo #7 Dated April 15, 2022 Make payroll tax remittance to the Receiver General for the pay periods ending April 15, 2022. Include remittance for income tax, EI and CPP. Issue cheque #434. 20. Bank reconciliation. Set up account 1080 for account reconciliation. Use the following linked accounts. new accounts if necessary. Income: Interest 4280 Revenue from Interest Expense1: Bank Charges 5010 Bank & Credit Card Fees Expense2: NSF fee 5010 Bank & Credit Card Fees Adjustment: 5005 Reconciliation Adjustments Reconcile the account using April 1 start date and April 15 as the statement end date and the reconciliation date. There are two outstanding prior transactions Source Description Date Amount 606 Deposit slip Mar 29 Deposit $2 600 431 Skin Decals, Inc. Mar 30 Payment $1 800 (Hint: after adding the first outstanding transaction, click Insert Outstanding again to access a new transaction line.) Use the following bank statement details to complete the reconciliation. Withdrawals deposits balance Mar. 15 Balance forward 23 330.00 Mar. 29 Deposit 606 2 600.00 Mar. 30 Cheque 431 - 1 800.00 Apr. 1 Interest on account 15.00 Apr. 1 Cheque 432 - 2 373.00 Apr. 4 Cheque 433 - 3 679.80 Apr. 8 Deposit 607 3 157.00 Apr. 8 Payroll transfer Ref #68 468.32 Apr. 15 Deposit 608 3 920.98 Apr. 15 Debit memo - 600.00 Apr. 15 Transfer from 04328-476199 4000.00 Apr. 15 Transfer to 04328-59990 2 040.00 Apr. 15 Payroll transfer Ref #69- 472.01 Apr. 15 Payroll transfer Ref #70- 1626.99 Apr. 15 Service fee 45.00 Apr.

15 Closing Balance 23 917.86 21.

1. Journal Entries for all journals from April 1 to April 15, 2022 - Show division allocations, foreign currency amounts, corrections and additional information.

2. Balance Sheet at April 15, 2022

3.Income Statement from April 1 to April 15, 2022

4. Employee Summary

5. Inventory Summary

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Accounting for Governmental and Nonprofit Entities

Authors: Jacqueline L. Reck, James E. Rooks, Suzanne Lowensohn, Daniel Neely

18th edition

1260190080, 1260190083, 978-1259917059

More Books

Students also viewed these Accounting questions