The following trial balance was drawn from the records of Jordan Company as of October 1,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following trial balance was drawn from the records of Jordan Company as of October 1, year 2. Cash Accounts receivable Inventory Store equipment Accumulated depreciation Accounts payable Line of credit loan Common stock Retained earnings Totals $ 20,500 69,000 44,500 290,000 $ 78,600 76,500 190,000 59,000 19,900 $ 424,000 $ 424,000 Required a-1. Based on the following information, prepare a sales budget and a schedule of cash receipts for October, November, and December. Sales for October are expected to be $240,000, consisting of $49,000 in cash and $191,000 on credit. The company expects sales to increase at the rate of 10 percent per month. All accounts receivable are collected in the month following the sale. a-2. Based on the following information, prepare a purchases budget and a schedule of cash payments for inventory purchases for October, November, and December. The inventory balance as of October 1 was $44,500. Cost of goods sold for October is expected to be $76,500. Cost of goods sold is expected to increase by 10 percent per month. The company expects to maintain a minimum ending inventory equal to 20 percent of the current month cost of goods sold. Eighty percent of accounts payable is paid in the month that the purchase occurs; the remaining 20 percent is paid in the following month. a-3. Based on the following selling and administrative expenses budgeted for October, prepare a selling and administrative expenses budget for October, November, and December. Sales commissions (10% increase per month) Supplies expense (10% increase per month) Utilities (fixed) Depreciation on store equipment (fixed) Salary expense (fixed) Rent (fixed) Miscellaneous (fixed) $ 7,800 2,300 3,100 2,500 38,500 6,900 1,900 Cash payments for sales commissions and utilities are made in the month following the one in which the expense is incurred. Supplies and other operating expenses are paid in cash in the month in which they are incurred. Complete this question by entering your answers in the tabs below. Req A1 Req A2 Req A3 Based on the following information, prepare a purchases budget and a schedule of cash payments for inventory purchases for October, November, and December. The inventory balance as of October 1 was $44,500. Cost of goods sold for October is expected to be $76,500. Cost of goods sold is expected to increase by 10 percent per month. The company expects to maintain a minimum ending inventory equal to 20 percent of the current month cost of goods sold. Eighty percent of accounts payable is paid in the month that the purchase occurs; the remaining 20 percent is paid in the following month. Note: Round your answers to the nearest whole dollar. Inventory Purchases Budget October November December Inventory needed Required purchases (on account) Schedule of Cash Payments Payment of current months' accounts payable Payment for prior month's accounts payable Total budgeted payments for inventory 0 0 0 $ 0 $ 0 $ 0 0 0 0 Show less The following trial balance was drawn from the records of Jordan Company as of October 1, year 2. Cash Accounts receivable Inventory Store equipment Accumulated depreciation Accounts payable Line of credit loan Common stock Retained earnings Totals $ 20,500 69,000 44,500 290,000 $ 78,600 76,500 190,000 59,000 19,900 $ 424,000 $ 424,000 Required a-1. Based on the following information, prepare a sales budget and a schedule of cash receipts for October, November, and December. Sales for October are expected to be $240,000, consisting of $49,000 in cash and $191,000 on credit. The company expects sales to increase at the rate of 10 percent per month. All accounts receivable are collected in the month following the sale. a-2. Based on the following information, prepare a purchases budget and a schedule of cash payments for inventory purchases for October, November, and December. The inventory balance as of October 1 was $44,500. Cost of goods sold for October is expected to be $76,500. Cost of goods sold is expected to increase by 10 percent per month. The company expects to maintain a minimum ending inventory equal to 20 percent of the current month cost of goods sold. Eighty percent of accounts payable is paid in the month that the purchase occurs; the remaining 20 percent is paid in the following month. a-3. Based on the following selling and administrative expenses budgeted for October, prepare a selling and administrative expenses budget for October, November, and December. Sales commissions (10% increase per month) Supplies expense (10% increase per month) Utilities (fixed) Depreciation on store equipment (fixed) Salary expense (fixed) Rent (fixed) Miscellaneous (fixed) $ 7,800 2,300 3,100 2,500 38,500 6,900 1,900 Cash payments for sales commissions and utilities are made in the month following the one in which the expense is incurred. Supplies and other operating expenses are paid in cash in the month in which they are incurred. Complete this question by entering your answers in the tabs below. Req A1 Req A2 Req A3 Based on the following information, prepare a purchases budget and a schedule of cash payments for inventory purchases for October, November, and December. The inventory balance as of October 1 was $44,500. Cost of goods sold for October is expected to be $76,500. Cost of goods sold is expected to increase by 10 percent per month. The company expects to maintain a minimum ending inventory equal to 20 percent of the current month cost of goods sold. Eighty percent of accounts payable is paid in the month that the purchase occurs; the remaining 20 percent is paid in the following month. Note: Round your answers to the nearest whole dollar. Inventory Purchases Budget October November December Inventory needed Required purchases (on account) Schedule of Cash Payments Payment of current months' accounts payable Payment for prior month's accounts payable Total budgeted payments for inventory 0 0 0 $ 0 $ 0 $ 0 0 0 0 Show less
Expert Answer:
Related Book For
Fundamental Managerial Accounting Concepts
ISBN: 978-1259569197
8th edition
Authors: Thomas Edmonds, Christopher Edmonds, Bor Yi Tsay, Philip Olds
Posted Date:
Students also viewed these accounting questions
-
The following trial balance was drawn from the records of Havel Company as of October 1, 2018: Required a. Divide the class into groups, each with four or five students. Organize the groups into...
-
Requirement 1. Journalize the partners' initial contributions. (Record debits first, then, credits. Select the explanation on the last line of the journal entry table.) Begin by journalizing the...
-
Ryan's preferences for food and gasoline each week can be described by the utility function U(F,G) = FG2,where F is pounds of food and G is gallons of gas. His monthly income is $1,200, the price of...
-
a ballistic pendulum, a bullet with mass of 40.0 g is fired in to the catcher with mass of 600.0 g. The length of pendulum is 60.0 cm. After bullet embedded in to the catcher, total system rises to...
-
Two horizontal, infinite, parallel plates are spaced a distance \(b\) apart. A viscous liquid is contained between the plates. The bottom plate is fixed, and the upper plate moves parallel to the...
-
Hangin Out Night Club maintains an imprest petty cash fund of $100, which is under the control of Sandra Morgan. At March 31, the fund holds $9 cash and petty cash tickets for office supplies, $77,...
-
Power Drive Corporation designs and produces a line of golf equipment and golf apparel. Power Drive has 100,000 shares of common stock outstanding as of the beginning of 2024. Power Drive has the...
-
Implement the LIMIT TEST logic rung shown. Prove the operation by using the data monitor to insert test values (N7:29). Verify that the pilot light PL1 (O:2/0) goes on whenever the test value stored...
-
Medusa Company had: sales of $10,000 sales discounts of $500 sales returns and allowances of $1,500 cost of goods sold of $5,000. Calculate Medusa's gross profit.
-
Explain what arguments the plaintiff (Mr. Henderson) could raise to the court to substantiate his lawsuit against the Condo Corporations. 2. Explain what arguments the defendant (Jefferson Property...
-
What is the definition of planning? What is the meaning of strategic planning? What is the intent of operational planning? Explain and contrast how they differ. 3-4 paragraphs. references
-
What polymer(s) are most common in geocells? Why do you think this is? Some geocells are made of textiles, rather than polymeric sheets. What are the advantages and disadvantages of these geocells...
-
Gobble Goop Corp incorporated in 2008. In their current year (2011), the company has furnished you (a super star accountant) with the following information regarding their financial and tax returns:...
-
Develop what, why, when and how for improvement of Omni-channel for men's wearhouse Resources required Technical requirements Budgeting and feedback requirements
-
How has the globalization of firms affected the diversity of their employees? Why has increased diversity put an additional burden on accounting systems?
-
\(\mathrm{NaK}(56 \% / 44 \%)\), which is an alloy of sodium and potassium, is used to cool fast neutron nuclear reactors. The NaK flows at a rate of \(\dot{m}=0.8 \mathrm{~kg} / \mathrm{s}\) through...
-
Heated air required for a food-drying process is generated by passing ambient air at \(20^{\circ} \mathrm{C}\) through long, circular tubes \((D=50 \mathrm{~mm}, L=5 \mathrm{~m}\) ) housed in a steam...
-
Liquid mercury at \(0.25 \mathrm{~kg} / \mathrm{s}\) is to be heated from 325 to \(375 \mathrm{~K}\) by passing it through a \(25-\mathrm{mm}\)-diameter tube whose surface is maintained at \(400...
Robust Libor Modelling And Pricing Of Derivative Products 1st Edition - ISBN: 158488441X - Free Book
Study smarter with the SolutionInn App