Home* CengageNOWv2 | Online teachin x"takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=falseSchedule of Cash Collections of Accounts ReceivablePet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows:January$210,000February300.000March440,000All sales are on account. 60% of sales are expected to be collected in the month of the sale, 35% in the month following the sale, and the remainder in the second month following the sale.Prepare a schedule indicating cash collections from sales for January, February, and March.Pet Supplies Inc.Schedule of Cash Collections from SalesFor the Three Months Ending March 31January FebruaryMarchJanuary sales on account:Collected in JanuaryCollected in FebruaryCollected in MarchFebruary sales on account:Collected in FebruaryCollected in MarchMarch sales on account:Collected in MarchTotal cash collectedPreviousSubmit Test for GradingAll work saved.11:10 AM44F Mostiy sunnyA O O d 12/14/2021

Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January $210,000 February 300,000 March 440,000 All sales are on account, 60% of sales are expected to be collected in the month of the sale, 35% in the month following the sale, and the remainder in the second month folowing the sale Prepare a schedule indicating cash collections from sales for January, February, and March. Pet Supplies Inc. Schedule of Cash Coliections from Sales For the Three Months Ending March 31 January February March January sales on account: Collected in January Collected in February Collected in March February sales on account: Collected in February Collected in March March sales on account: Collected in March

Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January $210,000 February 300,000 March 440,000 All sales are on account, 60% of sales are expected to be collected in the month of the sale, 35% in the month following the sale, and the remainder in the second month folowing the sale Prepare a schedule indicating cash collections from sales for January, February, and March. Pet Supplies Inc. Schedule of Cash Coliections from Sales For the Three Months Ending March 31 January February March January sales on account: Collected in January Collected in February Collected in March February sales on account: Collected in February Collected in March March sales on account: Collected in March

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter1: Business Transactions (ptrans)

Section: Chapter Questions

Problem 7R

See similar textbooks

Similar questions

Accounts Receivable Balance XYZ Corp sells widgets to consumers for $20 each. Its beginning accounts receivable balance was $24,975, and it sold 12,376 widgets throughout the year. The total cash collections for the year amounted to $217,750. Required: Calculate the ending accounts receivable balance.
eBook Show Me How Video Schedule of Cash Collections of Accounts Receivable Fur Family Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $270,000 June 340,000 July 480,000 All sales are on account. Of sales on account, 59% are expected to be collected in the month of the sale, 36% in the first month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May, June, and July. FUR FAMILY INC.Schedule of Collections from SalesFor the Three Months Ending July 31 May June July May sales on account: Collected in May fill in the blank 1 Collected in June fill in the blank 2 Collected in July fill in the blank 3 June sales on account: Collected in June fill in the blank 4 Collected in July fill in the blank 5 July sales on account: Collected…
eBook Show Me How Question Content Area Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $290,000 June 350,000 July 530,000 All sales are on account. 56 percent of sales are expected to be collected in the month of the sale, 34% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May, June, and July. May June July May sales on account: Collected in May fill in the blank 1 Collected in June fill in the blank 2 Collected in July fill in the blank 3 June sales on account: Collected in June fill in the blank 4 Collected in July fill in the blank 5 July sales on account: Collected in July fill in the blank 6 Total cash collected $fill in the…
Lucky House Ltd Trial Balance As at 30 September 2020 Account Debit(£) Credit(£)Cash at Bank 5,850Capital Account 15,000Machine 8,100Raw Materials 2,655Stationery 250Accounts Payable 6,545Rent 950Business Insurance 38Prepayments 1,362Sales Income 17,550Cost of Goods Sold 11,345Accounts Receivable 4,500Drawings 4,000Telephone 45Depreciation 135Accumulated Depreciation 135 Total 39,230 39,230 Prepare a statement of cash flow ?
Please help to solve the whole question please this is 1 question with 3sub parts. InvisiGuard Ltd sells security doors. Majority of its sales are on credit except small amount of cash sales each year. The accounting records at 30 June 2019 reveal the following. Ignore GST. Credit sales (for the year of 2019) $2,100,000 Cash sales (for the year of 2019) 20,000 Credit sales returns and allowances (for the year of 2019) 80,000 Accounts receivable (balance at 30 June 2019) 593,000 Allowance for doubtful debts (credit balance at 30 June 2019) 2,800 The company’s yearly bad debts expense had been estimated at 2.5% of net credit sales revenue in the past. The management of InvisiGuard Ltd has decided to compare the current method with an ageing of accounts receivable method. The following analysis was obtained with respect to the accounts receivable. Balance % of estimated uncollectable Accounts not yet due $351,200 1 Accounts…
eBook Show Me How Print Item Schedule of Cash Collections of Accounts Receivable Bark & Purr Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $184,000 June 192,000 July 201,000 All sales are on account. Sixty percent of sales are expected to be collected in the month of the sale, 35% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May, June, and July. Bark & Purr Supplies Inc. Schedule of Collections from Sales For the Three Months Ending July 31 May June July May sales on account: Collected in May $fill in the blank 1 Collected in June $fill in the blank 2 Collected in July $fill in the blank 3 June sales on account: Collected in June fill in the blank 4 Collected in July fill in the blank 5 July…
Knowledge Check 01Equinox is a local boutique that sells gift cards especially before holidays. At November 30, the company’s Deferred gift card revenue account had a balance of $400. During December, the company sold additional gift cards in the amount of $5,000, customers redeemed $1,000 of gift cards, and unused gift cards in the amount of $300 expired. What is the balance of Deferred gift card revenue that will be reported at December 31?
Selected transactions completed by Kornett Company during its first fiscal year ended Dec. 31, 20Y8, were as follows: 1. Journalize the selected transactions. Assume 360 days per year. If no entry is required, select "No entry required" from the dropdown and leave the amount boxes blank. For a compound transaction, if an amount box does not require an entry, leave it blank. Jan. 3: Issued a check to establish a petty cash fund of $4,500. Description Debit Credit Petty Cash Cash Feb. 26: Replenished the petty cash fund, based on the following summary of petty cash receipts: office supplies, $1,680; miscellaneous selling expense, $570; miscellaneous administrative expense, $880. Description Debit Credit Apr. 14: Purchased $31,300 of merchandise on account, terms, n/30. The perpetual inventory system is used to account for inventory. Description Debit Credit May 13: Paid the invoice of Apr. 14.…
Q1. Record the following transactions in a general journal for Voyageur Sports Ltd. Nov 7 Cash sales slips totalled $3295 plus $197.70 GST. Cash was deposited Issued Sales Invoice 87–B to A. Michaels, terms 3/15, n/30, amount $2000, not subject to PST, GST $120 Nov 8 Received bank credit memo for $215, interest earned by the company Nov 9 Received bank debit memo for $25, plus $1.50 GST, for the annual charge for a safety deposit box. Total $26.50 Nov 15 Received cheque from A. Michaels, $2056.40 for Invoice 87–B, less $63.60 discount. Cheque was deposited
The following data pertain to Valdez & Co. on December 31, 2005:Checkbook balance P10,000,000Bank statement balance 15,000,000Check drawn on Balagtas’ account, payable to supplier, dated and recorded on Dec. 31, 2005, but not mailed until Jan. 15, 2006 : 3,000,000Cash in sinking fund 4,000,000Money market, three months due January 31, 2006 5,000,000On December 31, 2005, how much should be reported as “cash and cash equivalents”? In preparing its bank reconciliation for the month of February, James Company has available the following information:Balance per bank statement, February 28 ................. P18,025Deposit in transit, February 28 ......................... 3,125Outstanding checks, February 28 ......................... 2,875Check erroneously deducted by bank from James' account,February 10 ........................................... 125Bank service charges for February ....................... 25What is the corrected cash balance at February 28? In preparing the bank…
Question 1: Following amounts have been Extracted from the records of Monday Limited. Description 2019 2018 - Rs. In 000- Sales 32,875 31,390 Gross profit 16,880 14,310 Profit for the year 3,300 2,700 Account receivable 3,860 2,510 Account payable 4,660 2,890 Inventory 430 445 Cash at bank 12 37 Bank overdraft 280 40 Monday Limited secured a large new contract to supply goods to a large departmental store across a two year period from 1st July 2019. Monday Limited normally offers wholesale customers 30 days’ credit, but department store would only agree to the contract with 90 days credit terms. The directors of Monday Limited agreed to this as they believed it was worth it to have their products placed with this department store. Monday Limited has an average 45 day credit from its suppliers. The bank overdraft is used to fund working capital and currently has a limit of Rs.300,000.…
The following data pertains to Blessed Trading on April 30:Correct cash balance in a general checking account with Banco de Bro - P322,000Overdraft in a special checking account with General Bank (Blessed Trading does not have another account with General Bank - P20,000Cash accumulated in a special fund that will be used for plant expansion in the following year - P150,000Cash surrender value of life insurance policy - P32,000Cash travel advances in the hands of sales personnel - P12,000Currency and coins in petty cash fund (the company has not replenished the fund to the imprest amount of P10,000) - P2,850How much cash should Blessed Trading report on April 30?