ACC 2234–Final Examination_Q #7 Jacques Inc.
docx
keyboard_arrow_up
School
Algonquin College *
*We aren’t endorsed by this school
Course
2355
Subject
Accounting
Date
Nov 24, 2024
Type
docx
Pages
2
Uploaded by ok1807
The following data pertains to Jacques Inc., a retailer of athletic memorabilia:
Oct Actual
Nov Budget
Dec Budget
Cash sales
$80,000
$100,000
$60,000
Credit sales
240,000
360,000
180,000
Total sales
320,000
460,000
240,000
The company has a gross profit % of 40%.
Management estimates that 5% of credit sales will be uncollectible. Of the credit sales that will be
collected, 60% are collected in the month of sale and the remainder in the month following sale.
Purchases of inventory are expected to be 100% of the following month’s projected total cost of sales. All
purchases are on account and 25% are paid in the month of purchase and are subject to a 1% purchase
discount. The balance is paid in the month following purchase.
1.
Calculate the cash collections for November.
Cash Sales
$100,00
0
Add: Collections from credit sales in Oct
240,000 × 95% =
228,000
Cash collected in Nov
228,000 × 40% = 91,200
91,200
Collections from credit sales in
Nov
360,000 × 95% =
342,000
Cash collected in Nov
342,000 × 60% =
205,200
205,200
Total Cash Collection in Nov
$396,40
0
2.
Calculate the cash disbursements for purchases for November.
Oct
Nov
Dec
Total Sales
320,000
460,000
240,000
Cost of sales ratio
×
60%
×
60%
×
60%
Cost of Sales
$192,000
$276,000
$144,000
Payments for purchases in Oct
Inventory Purchases in Oct
$276,000
% paid in Nov
×
75%
To be paid for purchases in Oct
207,000
Payments for purchases in Nov
Inventory purchases in Nov
$144,000
% paid in Nov
×
25%
To be paid for purchases in Nov
36,000
Less: Discount (36,000*1%)
(360)
To be paid for purchases in Nov, net of discount
35,640
Total cash disbursements for purchases in Nov
$242,640
3.
Calculate the ending balance in accounts receivable on November 30.
Credit sales in Oct
$240,000
Credit sales in Nov
360,000
Total credit sales
$600,000
Less:
Collection From Oct sales
228,000
Collection From Nov sales (342,000 × 60%)
205,200
Total Collections
(433,200)
Ending Balance in A/R in Nov 30
$166,800
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Information pertaining to Yekstop Corp.'s sales revenue is presented below:
November
December
January
Cash sales
$
96,000
$
125,000
$
78,000
Credit sales
288,000
450,000
234,000
Total sales
$
384,000
$
575,000
$
312,000
Management estimates that 4% of credit sales are eventually uncollectible. Of the collectible credit sales, 65% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an inventory equal to 75% of the sales projected for the month. All purchases of inventory are on open account; 30% will be paid in the month of purchase, and the remainder paid in the month following the month of purchase. Purchase costs are approximately 60% of the selling prices.Budgeted cash payments in November for November inventory purchases by Yekstop Corp. are:
arrow_forward
please answer with complete solution
arrow_forward
Information pertaining to Collection Corporation's sales revenue is presented below:
November
December
January
Cash sales
$ 97,000
$ 126,000
$ 79,000
Credit sales
289,000
451,000
235,000
Total sales
$ 386,000
$ 577,000
$ 314,000
Management estimates that 4% of credit sales are eventually uncollectible. Of the collectible credit sales, 60% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an inventory equal to 70% of the sales projected for the month. All purchases of inventory are on open account; 20% will be paid in the month of purchase, and the remainder paid in the month following the month of purchase. Purchase costs are approximately 50% of the selling prices.
Budgeted cash payments in November for November inventory purchases by Collection Corporation are:
arrow_forward
Information pertaining to Collection Corporation's sales revenue is presented below:
November
December
January
Cash sales
$ 99,000
$ 128,000
$ 81,000
Credit sales
291,000
453,000
237,000
Total sales
$ 390,000
$ 581,000
$ 318,000
Management estimates that 3% of credit sales are eventually uncollectible. Of the collectible credit sales, 60% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an inventory equal to 75% of the sales projected for the month. All purchases of inventory are on open account; 20% will be paid in the month of purchase, and the remainder paid in the month following the month of purchase. Purchase costs are approximately 50% of the selling prices.Budgeted cash payments in December for November inventory purchases by Collection Corporation are:
Multiple Choice
$42,075.
$53,325.
$78,000.
$156,000.
$213,300.
Please don't provide answer…
arrow_forward
Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects sales of $16,300,000 and cost of goods sold of $8,965,000. Advertising is a key part of Coral Seas' business strategy, and total marketing expense for the year is budgeted at $2,934,000. Total administrative expenses are expected to be $652,000. Coral Seas has no interest expense. Income taxes are paid at the rate of 40 percent of operating income.
Required:
Question Content Area
1. Construct a budgeted income statement for Coral Seas Jewelry Company for the coming year.
Coral Seas Jewelry CompanyBudgeted Income StatementFor the Coming Year
$Sales
Less: Cost of goods sold
Gross margin
$fill in the blank e744f5f1dfcfffc_5
Less:
$- Select -
- Select -
- Select -
Operating income
$fill in the blank e744f5f1dfcfffc_11
- Select -
$- Select -
Question Content Area
2. What if Coral Seas had interest payments of…
arrow_forward
Page Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are collected in the month of sale, 25% in the month following sale, and 11% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year:
Month
1
2
3
4
Total sales
$74,000
$90,000
$66,000
$44,000
Total cash receipts in Month 4 will be:
Multiple Choice
$36,960.
$64,900.
$50,160.
$48,600.
arrow_forward
Sagar
arrow_forward
The management of Marigold Industries estimates that credit sales for August, September, October, and November will be $550,000, $735,000, $885,000, and $480,000, respectively. Experience has shown that collections are made as follows:
In month of sale
25%
In first month after sale
60%
In second month after sale
10%
Determine the collections from customers in October and November
arrow_forward
Capid Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: Sales are
budgeted at: $360 000 for October $330 000 for November $320 000 for December Collections are
expected to be 60% in the month of sale, 36% in the month following the sale, and 4% uncollectible. The
October beginning balance is the accounts receivable account is $77 000. What ate the expected cash
receipts in November? A. $327 600 B. $310 800 C. $342 000 D. $293 000
arrow_forward
Corning Incorporated sells its product for $24 per unit. Its actual and projected sales follow:
Units
Dollars
January (actual)
18,500
$444,000
February (actual)
23,000
552,000
March (budgeted)
19,800
475,200
April (budgeted)
18,950
454,800
May (budgeted)
22,000
528,000
Here is added information about Corning’s operations:
All sales are on credit. Recent experience show that 35% of sales are collected in the month of the sale, 45% in the month following the sale, 17% in the second month after the sale, and 3% prove to be uncollectible. The product’s purchase price is $15 per unit. All payments are payable within 21 days. Thus 30% of purchases in any given month are paid for in that month, with the remaining 70% paid for in the following month. The company has a policy to maintain an ending inventory of 20% of the next month’s projected sales plus a safety stock of 100 units. The January 31 and February 28…
arrow_forward
Corning Incorporated sells its product for $24 per unit. Its actual and projected sales follow:
Units
Dollars
January (actual)
18,500
$444,000
February (actual)
23,000
552,000
March (budgeted)
19,800
475,200
April (budgeted)
18,950
454,800
May (budgeted)
22,000
528,000
Here is added information about Corning’s operations:
All sales are on credit. Recent experience show that 35% of sales are collected in the month of the sale, 45% in the month following the sale, 17% in the second month after the sale, and 3% prove to be uncollectible. The product’s purchase price is $15 per unit. All payments are payable within 21 days. Thus 30% of purchases in any given month are paid for in that month, with the remaining 70% paid for in the following month. The company has a policy to maintain an ending inventory of 20% of the next month’s projected sales plus a safety stock of 100 units. The January 31 and February 28…
arrow_forward
Corning Incorporated sells its product for $24 per unit. Its actual and projected sales follow:
Units
Dollars
January (actual)
18,500
$444,000
February (actual)
23,000
552,000
March (budgeted)
19,800
475,200
April (budgeted)
18,950
454,800
May (budgeted)
22,000
528,000
Here is added information about Corning’s operations:
All sales are on credit. Recent experience show that 35% of sales are collected in the month of the sale, 45% in the month following the sale, 17% in the second month after the sale, and 3% prove to be uncollectible. The product’s purchase price is $15 per unit. All payments are payable within 21 days. Thus 30% of purchases in any given month are paid for in that month, with the remaining 70% paid for in the following month. The company has a policy to maintain an ending inventory of 20% of the next month’s projected sales plus a safety stock of 100 units. The January 31 and February 28…
arrow_forward
Corning Incorporated sells its product for $24 per unit. Its actual and projected sales follow:
Units
Dollars
January (actual)
18,500
$444,000
February (actual)
23,000
552,000
March (budgeted)
19,800
475,200
April (budgeted)
18,950
454,800
May (budgeted)
22,000
528,000
Here is added information about Corning’s operations:
All sales are on credit. Recent experience show that 35% of sales are collected in the month of the sale, 45% in the month following the sale, 17% in the second month after the sale, and 3% prove to be uncollectible. The product’s purchase price is $15 per unit. All payments are payable within 21 days. Thus 30% of purchases in any given month are paid for in that month, with the remaining 70% paid for in the following month. The company has a policy to maintain an ending inventory of 20% of the next month’s projected sales plus a safety stock of 100 units. The January 31 and February 28…
arrow_forward
Corning Incorporated sells its product for $24 per unit. Its actual and projected sales follow:
Units
Dollars
January (actual)
18,500
$444,000
February (actual)
23,000
552,000
March (budgeted)
19,800
475,200
April (budgeted)
18,950
454,800
May (budgeted)
22,000
528,000
Here is added information about Corning’s operations:
All sales are on credit. Recent experience show that 35% of sales are collected in the month of the sale, 45% in the month following the sale, 17% in the second month after the sale, and 3% prove to be uncollectible. The product’s purchase price is $15 per unit. All payments are payable within 21 days. Thus 30% of purchases in any given month are paid for in that month, with the remaining 70% paid for in the following month. The company has a policy to maintain an ending inventory of 20% of the next month’s projected sales plus a safety stock of 100 units. The January 31 and February 28…
arrow_forward
Corning Incorporated sells its product for $24 per unit. Its actual and projected sales follow:
Units
Dollars
January (actual)
18,500
$444,000
February (actual)
23,000
552,000
March (budgeted)
19,800
475,200
April (budgeted)
18,950
454,800
May (budgeted)
22,000
528,000
Here is added information about Corning’s operations:
All sales are on credit. Recent experience show that 35% of sales are collected in the month of the sale, 45% in the month following the sale, 17% in the second month after the sale, and 3% prove to be uncollectible. The product’s purchase price is $15 per unit. All payments are payable within 21 days. Thus 30% of purchases in any given month are paid for in that month, with the remaining 70% paid for in the following month. The company has a policy to maintain an ending inventory of 20% of the next month’s projected sales plus a safety stock of 100 units. The January 31 and February 28…
arrow_forward
Domestic
arrow_forward
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow
• Sales are budgeted at $300,000 for November, $280,000 for December, and $270,000 for January
Collections are expected to be 65% in the month of sale and 35% in the month following the sale.
• The cost of goods sold is 70% of sales.
The company would like to maintain ending merchandise inventories equal to 60% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase.
. Other monthly expenses to be paid in cash are $23,600.
Monthly depreciation is $14,600.
Ignore taxes.
Assets
Cash
Balance Sheet
October 31
Accounts receivable
Merchandise inventory
Property, plant and equipment, net of $573,600 accumulated depreciation
Total assets
Liabilities and Stockholders' Equity
Accounts payable
Common stock
Retained earnings
Total liabilities and stockholders' equity
The difference between cash receipts and cash disbursements for…
arrow_forward
Do not give answer in image
arrow_forward
The following information is available in the financial records of Tūī Ltd, a large retail shop:
Actual
Sales
Purchases
August
$770,000
$350,000
September
$690,000
$370,000
October
$590,000
$480,000
November
$830,000
$510,000
Budgeted
Sales
Purchases
December
$980,000
$540,000
Receipts from customers are normally 60% in the month of sale, 25% in the month following the sale, and 5% in the second month following the sale. The balance is expected to be uncollectible.
Tūī Ltd pays for purchases in the following month.
Cash payments during December (for expenses other than purchases) are expected to be $288,000.
Any excess cash will be invested in short-term securities – these investments have to be made in multiples of $20,000. Any cash shortage will be borrowed from the Bank of Aotearoa in multiples of $5,000.
Tūī Ltd's cash balance on 1 December was $22,000.
Prepare a cash budget for Tūī Ltd for December. Make sure you…
arrow_forward
Page Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are collected in the month of sale, 20% in the month
following sale, and 17% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current
year:
Month
Total sales
1
2
$70,000 $90,000 $60,000 $40,000
Total cash receipts in Month 4 will be:
arrow_forward
Executive officers of Adams Company are wrestling with their budget for the next year. The following are two different sales estimates provided by two difference sources.
Source of Estimate
First Quarter
Second Quarter
Third Quarter
Fourth Quarter
Sales manager
$
378,000
$
316,000
$
271,000
$
480,000
Marketing consultant
512,000
469,000
403,000
648,000
Adams’s past experience indicates that cost of goods sold is about 60 percent of sales revenue. The company tries to maintain 15 percent of the next quarter’s expected cost of goods sold as the current quarter’s ending inventory. This year’s ending inventory is $30,000. Next year’s ending inventory is budgeted to be $31,000.
Required
Prepare an inventory purchases budget using the sales manager’s estimate.
Prepare an inventory purchases budget using the marketing consultant’s estimate.
arrow_forward
Give me correct answer with explanation..j
arrow_forward
Fatt Choy Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow:
- Sales are budgeted at $360,000 for November, $330,000 for December, and $320,000 for January.
- Cash collections from sales are expected to be 60% in the month of sale and 36% in the month following the sale. 4% of the sales is uncollectible.
- The cost of goods sold is 45% of sales.
- The company purchases 40% of its merchandise in the month prior to the month of sale and 60% in the month of sale. Payment for merchandise is made in the month following the purchase.
- The company’s operating expenses are estimated to be 40% of sales and are paid as incurred.
- The company has to pay a dividend of $100,000 in Nov.
- The November beginning balance in the net accounts receivable account is $250,000, after deduction of uncollectible sales.
- The November beginning balance in the accounts payable account is $271,000.
Fatt Choy has a beginning cash balance of 88,000 at November and…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Related Questions
- Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 96,000 $ 125,000 $ 78,000 Credit sales 288,000 450,000 234,000 Total sales $ 384,000 $ 575,000 $ 312,000 Management estimates that 4% of credit sales are eventually uncollectible. Of the collectible credit sales, 65% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an inventory equal to 75% of the sales projected for the month. All purchases of inventory are on open account; 30% will be paid in the month of purchase, and the remainder paid in the month following the month of purchase. Purchase costs are approximately 60% of the selling prices.Budgeted cash payments in November for November inventory purchases by Yekstop Corp. are:arrow_forwardplease answer with complete solutionarrow_forwardInformation pertaining to Collection Corporation's sales revenue is presented below: November December January Cash sales $ 97,000 $ 126,000 $ 79,000 Credit sales 289,000 451,000 235,000 Total sales $ 386,000 $ 577,000 $ 314,000 Management estimates that 4% of credit sales are eventually uncollectible. Of the collectible credit sales, 60% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an inventory equal to 70% of the sales projected for the month. All purchases of inventory are on open account; 20% will be paid in the month of purchase, and the remainder paid in the month following the month of purchase. Purchase costs are approximately 50% of the selling prices. Budgeted cash payments in November for November inventory purchases by Collection Corporation are:arrow_forward
- Information pertaining to Collection Corporation's sales revenue is presented below: November December January Cash sales $ 99,000 $ 128,000 $ 81,000 Credit sales 291,000 453,000 237,000 Total sales $ 390,000 $ 581,000 $ 318,000 Management estimates that 3% of credit sales are eventually uncollectible. Of the collectible credit sales, 60% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an inventory equal to 75% of the sales projected for the month. All purchases of inventory are on open account; 20% will be paid in the month of purchase, and the remainder paid in the month following the month of purchase. Purchase costs are approximately 50% of the selling prices.Budgeted cash payments in December for November inventory purchases by Collection Corporation are: Multiple Choice $42,075. $53,325. $78,000. $156,000. $213,300. Please don't provide answer…arrow_forwardCoral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects sales of $16,300,000 and cost of goods sold of $8,965,000. Advertising is a key part of Coral Seas' business strategy, and total marketing expense for the year is budgeted at $2,934,000. Total administrative expenses are expected to be $652,000. Coral Seas has no interest expense. Income taxes are paid at the rate of 40 percent of operating income. Required: Question Content Area 1. Construct a budgeted income statement for Coral Seas Jewelry Company for the coming year. Coral Seas Jewelry CompanyBudgeted Income StatementFor the Coming Year $Sales Less: Cost of goods sold Gross margin $fill in the blank e744f5f1dfcfffc_5 Less: $- Select - - Select - - Select - Operating income $fill in the blank e744f5f1dfcfffc_11 - Select - $- Select - Question Content Area 2. What if Coral Seas had interest payments of…arrow_forwardPage Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are collected in the month of sale, 25% in the month following sale, and 11% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month 1 2 3 4 Total sales $74,000 $90,000 $66,000 $44,000 Total cash receipts in Month 4 will be: Multiple Choice $36,960. $64,900. $50,160. $48,600.arrow_forward
- Sagararrow_forwardThe management of Marigold Industries estimates that credit sales for August, September, October, and November will be $550,000, $735,000, $885,000, and $480,000, respectively. Experience has shown that collections are made as follows: In month of sale 25% In first month after sale 60% In second month after sale 10% Determine the collections from customers in October and Novemberarrow_forwardCapid Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: Sales are budgeted at: $360 000 for October $330 000 for November $320 000 for December Collections are expected to be 60% in the month of sale, 36% in the month following the sale, and 4% uncollectible. The October beginning balance is the accounts receivable account is $77 000. What ate the expected cash receipts in November? A. $327 600 B. $310 800 C. $342 000 D. $293 000arrow_forward
- Corning Incorporated sells its product for $24 per unit. Its actual and projected sales follow: Units Dollars January (actual) 18,500 $444,000 February (actual) 23,000 552,000 March (budgeted) 19,800 475,200 April (budgeted) 18,950 454,800 May (budgeted) 22,000 528,000 Here is added information about Corning’s operations: All sales are on credit. Recent experience show that 35% of sales are collected in the month of the sale, 45% in the month following the sale, 17% in the second month after the sale, and 3% prove to be uncollectible. The product’s purchase price is $15 per unit. All payments are payable within 21 days. Thus 30% of purchases in any given month are paid for in that month, with the remaining 70% paid for in the following month. The company has a policy to maintain an ending inventory of 20% of the next month’s projected sales plus a safety stock of 100 units. The January 31 and February 28…arrow_forwardCorning Incorporated sells its product for $24 per unit. Its actual and projected sales follow: Units Dollars January (actual) 18,500 $444,000 February (actual) 23,000 552,000 March (budgeted) 19,800 475,200 April (budgeted) 18,950 454,800 May (budgeted) 22,000 528,000 Here is added information about Corning’s operations: All sales are on credit. Recent experience show that 35% of sales are collected in the month of the sale, 45% in the month following the sale, 17% in the second month after the sale, and 3% prove to be uncollectible. The product’s purchase price is $15 per unit. All payments are payable within 21 days. Thus 30% of purchases in any given month are paid for in that month, with the remaining 70% paid for in the following month. The company has a policy to maintain an ending inventory of 20% of the next month’s projected sales plus a safety stock of 100 units. The January 31 and February 28…arrow_forwardCorning Incorporated sells its product for $24 per unit. Its actual and projected sales follow: Units Dollars January (actual) 18,500 $444,000 February (actual) 23,000 552,000 March (budgeted) 19,800 475,200 April (budgeted) 18,950 454,800 May (budgeted) 22,000 528,000 Here is added information about Corning’s operations: All sales are on credit. Recent experience show that 35% of sales are collected in the month of the sale, 45% in the month following the sale, 17% in the second month after the sale, and 3% prove to be uncollectible. The product’s purchase price is $15 per unit. All payments are payable within 21 days. Thus 30% of purchases in any given month are paid for in that month, with the remaining 70% paid for in the following month. The company has a policy to maintain an ending inventory of 20% of the next month’s projected sales plus a safety stock of 100 units. The January 31 and February 28…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning