Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Rinaldo arrives in a cheerful mood because he has just received some new sales prospects. You congratulate him and tell him about your Sage 50

Rinaldo arrives in a cheerful mood because he has just received some new sales prospects. You congratulate him and tell him about your Sage 50 experiences. He is pleased with your progress but says that because you are still new to the work, he will continue to mentor and supervise you closely over the next few weeks.

Rinaldo then hands you the following list of transactions that occurred throughout mid May up to yesterday (May 20) and asks you to record them in Sage 50:

Transactions from mid May 2017


May 9Purchased 8 units DK800 desktop computers from Big Telco at $1,100 each, Invoice No. 793.
May 11Made a cash sale to Handys Electronics, Invoice No. 3060 for the following items:
  • 3 units DK800 desktop computers for $1,700 each plus 5% sales tax
  • 3 units Swish Phones for $1,600 each plus 5% sales tax.
Received Check No. 616 for $10,395 from this customer.
May 14Received a sales order from Turbo Tech, Sales Order No. 9675. The following items are required to be shipped by May 23, 2017:
  • 2 units DK800 desktop computers at $1,700 each plus 5% sales tax
  • 4 units Tony ZIO MLP projectors at $2,200 each, plus 5% sales tax.
May 15Issued Check No. 4093 for $7,100 to pay Advanced Property Management for three month's worth of rent in advance.
May 16Purchased 7 units Zii game consoles from Big Telco for a list price of $840 each, Invoice No. 798. Issued Check No. 4094 for the full payment of this purchase.
May 16Ordered 6 units Tony ZIO MLP projectors for $1,420 each, from Mega Tech, Purchase Order No. 871.
May 18Sold merchandise on credit to Radio Hut, Invoice No. 3061. The items sold were:
  • 7 units Swish Phones for $1,600 each plus 5% sales tax
  • 12 units Zii game consoles for $1,300 each plus 5% sales tax.
May 19Received 6 units Tony ZIO MLP projectors, Invoice No. 759. These items were ordered from Mega Tech for $1,420 each, Purchase Order No. 871.

Once you have finished recording the above transactions using Sage 50, Rinaldo instructs you to prepare a bank deposit ticket for any check received during the middle of May so that he can take it to the bank this afternoon.

Rinaldo also asks you to print a more up-to-date trial balance that includes all transactions up until the end of yesterday (May 20, 2017). He wants to compare this trial balance to the one that you made for him earlier. In particular, he is interested to know the impact of the Mid May transactions on the accounts of the business. As usual, he will also ask you to answer several questions about Sage 50.

Instructions

  1. Use Sage 50 to record all of the Mid May transactions for Intermaweb Computer in Sage 50. Note that:
    • For each check received by the business, the check number is to be recorded in the reference field of the Receive Money window.
    • When recording purchase invoices in the Purchases/Receive Inventory window, you must enter the check number of each check issued (at the time of the purchase) in the Reference field of that window.
  2. After all of the above transactions have been entered into Sage 50, use that software to create a bank deposit ticket as of May 21, 2017 (Deposit Ticket ID 2) and include all of the checks received during the middle of May into that deposit ticket.
  3. Print the trial balance for Intermaweb Computer as of May 21, 2017 and transcribe your answers into the trial balance provided below. Note that your printed trial balance must not include accounts with zero balances.
  4. Answer all of the questions that Rinaldo asks you below.

Intermaweb Computer
General Ledger Trial Balance
As of May 21, 2017

Account IDAccount DescriptionDebit AmtCredit Amt
1020Checking Account


1100Accounts Receivable


1150Allowance for Doubtful Account


1200Inventory


1300Office Supplies


1400Prepaid Rent


1500Property and Equipment


1900Accum. Depreciation - Prop&Eqt


2000Accounts Payable


2310Sales Tax Payable


2330Federal Payroll Taxes Payable


2600Short Term Debt


2700Long Term Debt-Noncurrent


3910Retained Earnings


3930Common Stock


4000Sales Income


5000Cost of Goods Sold


6000Salaries Expense


6100Payroll Tax Expense


6150Bad Debt Expense


6400Utilities Expense


6450Office Supplies Expense


6500Telephone Expense


6850Service Charge Expense


6900Purchase Disc-Expense Items


7050Depreciation Expense



Total:00

Questions on Sage 50

(Q=311.F.MMTB.P1.Q1)

After you have recorded the given transactions in Sage 50, Rinaldo asks you to open the Purchase Orders window and identify the fields that are not provided in that window.

To open the Purchase Orders window:

  1. From the Navigation Bar, click Vendors & Purchases
  2. In the Vendors & Purchases Tasks section, click the Purchase Orders icon
  3. Select the New Purchase Order option from the drop-down list that appears next to the Purchase Orders icon.

Select the fields that are not in the Purchase Orders window:


Vendor ID and Ship to

Ship by and Customer PO.

Good thru and PO No.

A/P account and Ship via

(Q=311.F.MMTB.P2.Q1)

Rinaldo then asks you to open the Sales Orders window and identify the fields that are provided in that window.

To open the Sales Orders window:

  1. From the Navigation Bar, click Customers & Sales.
  2. In the Customers & Sales Tasks section, click the Sales Orders icon.
  3. Select the New Sales Order option from the drop-down list that appears next to the Sales Orders icon.

Select the correct option that shows existing fields in the Sales Orders window:


Customer ID and Received

Ship to and Sales tax

Customer ID and Invoice No.

Remit to and Ship by

(Q=311.F.MMTB.P3.Q1)

After you have recorded the given transactions in Sage 50, Rinaldo asks you to open the Sales Orders window and identify the impact of entering a sales order into Sage 50.

To open the Sales Orders window:

  1. From the Navigation Bar, click Customers & Sales
  2. In the Customers & Sales Tasks section, click the Sales Orders icon
  3. Select the New Sales Order option from the drop-down list that appears next to the Sales Orders icon.
  4. In the Sales Orders window, click the Journal toolbar button.

By referring to the Accounting Behind the Screens window that appears after the above steps are performed, which of the following is the consequence of recording a sales order into Sage 50:


G/L accounts are updated as soon as the sales order details are saved in Sage 50.

G/L accounts are updated only when items on the sales order are invoiced.

In the general ledger, the Inventory account is debited and the Accounts Receivable account is credited by the value of the sales order.

None of the above statements are correct.

(Q=212.F.MMTB.P4.Q1)

After you have finished creating the required deposit ticket in Sage 50, Rinaldo asks you to perform the following steps to open the deposit ticket dated May 21, 2017 that you have previously created. Then in the table below, record the running totals that are shown at the bottom of the Select for Deposit window.

1.From the Navigation Bar, select the Banking navigation center.

2.In the Banking Tasks section, click the Bank Deposits icon.

3.Select the View and Edit Bank Deposits option from the drop down list that appears next to the Bank Deposits icon.

4.In the Deposit List window, double click the deposit ticket dated May 21, 2017.

Complete the equation below using the running totals that are presented in the Select for Deposit window that appears after the above steps are performed.

Total Cash
Total Checks
Total Other
Total Deposit

+
+
=

Step by Step Solution

3.40 Rating (169 Votes )

There are 3 Steps involved in it

Step: 1

Select the fields that are not in the purchase Orders Llindow Option C Go... 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

Statistics For Business And Economics

Authors: Paul Newbold, William Carlson, Betty Thorne

8th Edition

0132745658, 978-0132745659

More Books

Students also viewed these Physics questions

Question

What is a moving-average crossover rule?

Answered: 1 week ago

Question

Define Administration?

Answered: 1 week ago