Concept explainers
Budgeting for a Merchandising Firm Goldberg Company is a retail sporting goods store that
uses an accrual accounting system. Facts regarding its operations follow:
∙ Sales are budgeted at $250,000 for December and $225,000 for January, terms 1/eom, n/60.
∙ Collections are expected to be 50% in the month of sale and 48% in the month following the sale.
Two percent of sales are expected to be uncollectible and recorded in an allowance account at the
end of the month of sale.
∙ Gross margin is 30% of gross sales.
∙ All
account at the end of the month following the month of sale.
∙ Goldberg desires to have 80% of the merchandise for the following month’s sales on hand at the end
of each month. Payment for merchandise is made in the month following the month of purchase.
∙ Other monthly operating expenses to be paid in cash total $25,000.
∙ Annual
expenses.
Goldberg Company’s
follows:
GOLDBERG COMPANY
Statement of Financial Position
November 30, 2019
Assets
Cash $ 30,000
Accounts receivable (net of $4,000
allowance for doubtful accounts) 76,000
Inventory 132,000
Property, plant, and equipment (net of
$680,000
Total assets $1,108,000
Liabilities and
Accounts payable $ 162,000
Common stock 800,000
Total liabilities and equity $1,108,000
Required
2. How much is the book value of Accounts Receivable at the end of December?
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- Preparing a financial budget—schedule of cash receipts sensitivity analysis Marcel Company projects the following sales for the first three months of the year: $11,200 in January; $512,300 in February; and $11,100 in March. The company expects 60% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January l. Round to the nearest dollar. Requirements . Prepare a schedule of cash receipts for Marcel for January, February and March. What is the balance in Accounts Receivable on March 31? Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31?arrow_forwardRooney Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Rooney's policy is to maintain an ending inventory balance equal to 10 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $77,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.arrow_forwardAlpesharrow_forward
- Montel Company's July sales budget shows sales of $560,000. The company budgets beginning merchandise inventory of $68.00O and ending merchandise inventory of $33,000 for July. Cost of goods sold is 30% of sales. Determine the budgeted cost of merchandise purchases for July. Hint: Use the relation (Beginning Inventory + Purchases - Cost of Goods Sold = Ending Inventory) to solve for purchases. MONTEL COMPANY Budgeted Cost of Merchandise Purchases For Month Ended Julyarrow_forwardCullumber Design provided the following budgeted information for April through July: April May June July Projected sales $133120 $157440 $147200 $168960 Projected merchandise purchases $104960 $117760 $99840 $84480 The cash balance on June 1 is $15360. The company pays 40% of merchandise purchases in the month purchased and 60% in the following month. General operating expenses are budgeted to be $39680 per month of which depreciation is $3840 of this amount. Management pays operating expenses in the month incurred. The company makes loan payments of $5120 per month of which $768 is interest and the remainder is principal. How much are budgeted cash disbursements for June? O $110592. O $151552. O $131584. O $80896.arrow_forwardTimpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: OctoberNovemberDecemberCash sales$ 60,000$ 55,000$ 75,000Credit sales60,00066,00082,500Total$ 120,000$ 121,000$ 157,500 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month following the month of sale. Customers are granted a 1.5% discount for payment within 10 days of billing. Approximately 75% of collectible credit sales take advantage of the cash discount. Inventory purchases each month are 100% of the cost of the following month’s projected sales. (The gross profit rate for Timpco is approximately 30%.) All merchandise purchases are made on credit, with 20% paid in the month of purchase and the remainder paid in the following month. No cash discounts for early payment are…arrow_forward
- Budget Preparation Collins Company is preparing its master budget for April. Use the given estimates to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories A and B estimate sales of 10,000 and 13,000 units, respectively, and the unit selling price is $43? $ b. If the beginning finished goods inventory is an estimated 2,000 units and the desired ending inventory is 3,000 units, how many units should be produced? c. What dollar amount of material should be purchased at $4 per pound if each unit of product requires 3 pounds and beginning and ending materials inventories should be 5,000 and 4,000 pounds, respectively? $ d. How much direct labor cost should be incurred if each unit produced requires 1.5 hours at an hourly rate of $14? e. How much manufacturing overhead should be incurred if fixed manufacturing overhead is $52,000 and variable manufacturing…arrow_forwardssume a merchandising company provides the following information from its master budget for the month of May: Sales $ 126,000 Cost of goods sold $ 91,000 Selling and administrative expenses $ 25,000 Accounts receivable, May 1st $ 17,000 Accounts receivable, May 31st $ 36,500 If all of the company’s sales are on account, what is the amount of cash collections from customers included in the cash budget for May?arrow_forwardPlease help me with show all calculation thankuarrow_forward
- iiiiarrow_forwardplease answer do not image formatarrow_forwardAssume the following budgeted information for a merchandising company: Budgeted sales (all on credit) for November, December, and January are $248,000, $218,000, and $209,000, respectively. • Cash collections related to credit sales are expected to be 70% in the month of sale, 30% in the month following the sale. • The cost of goods sold is 70% of sales. • Each month's ending inventory equals 20% of next month's cost of goods sold. • 30% of each month's merchandise purchases are paid in the current month and the remainder is paid in the following month. • Monthly selling and administrative expenses that are paid in cash in the month incurred total $25,000. • Monthly depreciation expense is $9.000. . The budgeted net operating income for December would be: Multiple Choice $40,400 $25,734 $16,734 $31,400arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education