Question

Jackon, Inc. has the following sales budget for next year. Jackson has a gross margin %...

Jackon, Inc. has the following sales budget for next year. Jackson has a gross margin % of 18% and sells everything on credit. Accounts are expected to be collected as follows: 55% in the quarter of the sales; 25% in the quarter following the sale; 20% in the second quarter following the sale.

Quarter 1 Quarter 2 Quarter 3 Quarter 4
Sales Revenue $130,000 $85,000 $105,000 $120,000

A. What is budgeted cost of goods sold for Quarter 2?

B. What is accounts receivable on the balance sheet at the end of Quarter 4?

Homework Answers

Answer #1

a). Jaksong Inc. has gross margin of 18%.
Sales for Quarter 2 = $85000
Budgeted cost of goods sold = Sales - Gross margin = 100% - 18% = 82%
= $85000 *82% = $69,700

b). Calculation of account receivable at the end of Quarter 4:
Payments of Quarter 1 and 2 are going to fully received till Quarter 4, hence Payments are pending only for Quarter 3 and 4.
Payment pending of Quarter 3 = $105000 * 20% = $21000
Payment pending of Quarter 4 = $120000 * 45% (25%+20%) = $54000
Total account receivable at the end of Quarter 4 = 21000+54000 = $75000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The budget director of Heather’s Florist has prepared the following sales budget. The company had $350,000...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $350,000 in accounts receivable on July 1. Heather’s Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required Complete the schedule of cash receipts by filling in the missing amounts. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet. 1. July August September Sales Budget Cash sales $67,000 $67,000...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $370,000...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $370,000 in accounts receivable on July 1. Heather’s Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required Complete the schedule of cash receipts by filling in the missing amounts. July August September Sales Budget Cash sales $72,000 $68,000 $86,000 Sales on account 86,000 107,000 121,600 Total budgeted sales $158,000 $175,000 $207,600 Schedule of Cash Receipts Current cash...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $15,000 $ 70,000 February $18,000 $ 80,000 March $14,000 $160,000 April $26,000 $120,000 May $18,000 $170,000 June $24,000 $105,000 On average, 35% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 10% are collected in the second month following sale, and the remaining 15% is collected three months...
Circle A Company (XXX) is preparing its cash collections budget for the 2nd quarter of 2012.  ...
Circle A Company (XXX) is preparing its cash collections budget for the 2nd quarter of 2012.   Budgeted sales are as follows: Budgeted sales Apr May Jun Cash sales $10,000 $9,000 $7,500 Credit sales 24,000 20,000 16,500 Total sales $34,000 $29,000 $24,000 Accounts receivable at March 31 were $14,000. The budget assumes that 20% of credit sales are collected in the month of sale, and the remaining 80% are collected one month later. Please prepare the cash collections budget. For the...
In the coming year, Game Monster, Inc., will be introducing its first product, a wrist brace...
In the coming year, Game Monster, Inc., will be introducing its first product, a wrist brace that protects serious video gamers from repetitive-motion injuries. The brace will be sold for $17 to retailers throughout the country. All sales will be made on account. An expected 74 percent of sales will be collected within the quarter of the sale, and another 21 percent in the quarter following the sale. The remaining 5 percent of credit sales are expected to be uncollectible....
Bella, Inc. has completed it’s sales budget for the 3rd quarter of 2017. Projected sales for...
Bella, Inc. has completed it’s sales budget for the 3rd quarter of 2017. Projected sales for the 3 months are as follows: July: $30, 000 August: $100,000 September: $50,000 The company’s past records show collection 30% is paid in cash and 70% is paid in credit. Of the sales paid with credit, 10% is collected in the month of the sale and 90% is collected the following month. a. What is the total expected cash collection for August? b. What...
Panora Organization manufactures and sells industrials products. For 2017, Panora has budgeted the following sales: Quarter...
Panora Organization manufactures and sells industrials products. For 2017, Panora has budgeted the following sales: Quarter 1 $4,600,000 Quarter 2 5,100,000 Quarter 3 5,000,000 Quarter 4 7,600,000 In Panora's experience regarding sales on account, 75% are collected in the quarter of sale, and 22% are collected in the quarter following the sales. 3% are never collected. Total sales for the current third quarter is $4,900,000 and for the current fourth quarter is $6,850,000. Construct a cash receipts budget for Panora...
Davies shows the following information for the Sales Budget for next quarter: Month            Units           Sales January    
Davies shows the following information for the Sales Budget for next quarter: Month            Units           Sales January           10,000      $200,000 February        30,000      $600,000 March             40,000      $800,000 Requirement 1: Assume Davies plans to begin January with 2,000 units and requires ending inventory to be equal to 20% of next month's sales. Compute the required number of units to be produced in February. Show your computations. Requirement 2: Assume each unit requires .4 hours of labor costing $15.00 per hour. Compute the Direct Labor...
Lua, Inc. has completed it’s sales budget for the 1st quarter of 2019. Projected sales for...
Lua, Inc. has completed it’s sales budget for the 1st quarter of 2019. Projected sales for the 3 months are as follows: Jan: $30, 000 Feb: $100,000 March: $50,000 The company’s past records show collection 30% is paid in cash and 70% is paid in credit. Of the sales paid with credit, 20% is collected in the month of the sale and 80% is collected the following month. Enter a number (no punctuation or characters). a. What is the total...
27) Corbin Company has prepared the following sales budget: Month                     Cash Sales        &nbsp
27) Corbin Company has prepared the following sales budget: Month                     Cash Sales                    Credit Sales September                    $99,000                         $250,000 October                        225,000                           180,000 November                    310,000                           210,000 December                      94,000                           170,000 Collections of credit sales are 50% in the month of sale, 40% in the month following sale, and 10% two months following sale. No uncollectible accounts are expected. What is the expected balance in Accounts Receivable at November 30? A) $77,500 B) $105,000 C) $123,000 this is the correct answer. Please explain every step of how to get accts receivable D) $210,000