D. Tomlinson Retail seeks your assistance in developing cash and other budget information for May, June,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
D. Tomlinson Retail seeks your assistance in developing cash and other budget information for May, June, and July. The store expects to have the following balances at the end of April: $ Cash 102,400 Accounts receivable 984,000 Inventories Accounts payable 690,000 309,626 The firm follows these guidelines in preparing its budgets: • Sales. All sales are on credit with terms of 3/10, n/30. Tomlinson bills customers on the last day of each month. The firm books receivables at gross amounts and collects 60% of the billings within the discount period, 25% by the end of the month, and 9% by the end of the second month. The firm's experience suggests that 6% is likely to be uncollectible and is written off at the end of the third month. • Purchases and expenses. All purchases and expenses are on open account. The firm pays its payables over a 2-month period with 54% paid in the month of purchase. Each month's units of ending inventory should equal 125% of the next month's cost of sales. The cost of each unit of inventory is $40. Selling, general, and administrative (SG&A) expenses, of which $2,900 is depreciation, equal 15% of the current month's sales. Actual and projected sales follow: Month March April May Dollars $ 822,000 840,000 Units Month 13,700 June 14,000 July 828,000 13,800 August Dollars Units $ 798,000 13,300 834,000 13,900 846,000 14,100 Required: 1. Prepare schedules showing budgeted merchandise purchases for May and June. 2. Prepare a schedule showing budgeted cash disbursements during June. 3. Prepare a schedule showing budgeted cash collections during May. 4. Determine gross and net balances of accounts receivable on May 31. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare schedules showing budgeted merchandise purchases for May and June. Cost of Goods Sold Total needed Required 3 Required 4 D. Tomlinson Retail Budgeted Merchandise Purchases May and June May Budgeted merchandise purchases June July Prepare a schedule showing budgeted cash disbursements during June. D. Tomlinson Retail Budgeted Cash Disbursements, June May Total payables Budgeted cash disbursements June Prepare a schedule showing budgeted cash collections during May. D. Tomlinson Retail Cash Collections May Within the discount period After the discount period Total cash collections Determine gross and net balances of accounts receivable on May 31. March May Sales Remaining AR % AR Balance (Gross) Bad-debt allowance AR Balance (Net) % April % % Total D. Tomlinson Retail seeks your assistance in developing cash and other budget information for May, June, and July. The store expects to have the following balances at the end of April: $ Cash 102,400 Accounts receivable 984,000 Inventories Accounts payable 690,000 309,626 The firm follows these guidelines in preparing its budgets: • Sales. All sales are on credit with terms of 3/10, n/30. Tomlinson bills customers on the last day of each month. The firm books receivables at gross amounts and collects 60% of the billings within the discount period, 25% by the end of the month, and 9% by the end of the second month. The firm's experience suggests that 6% is likely to be uncollectible and is written off at the end of the third month. • Purchases and expenses. All purchases and expenses are on open account. The firm pays its payables over a 2-month period with 54% paid in the month of purchase. Each month's units of ending inventory should equal 125% of the next month's cost of sales. The cost of each unit of inventory is $40. Selling, general, and administrative (SG&A) expenses, of which $2,900 is depreciation, equal 15% of the current month's sales. Actual and projected sales follow: Month March April May Dollars $ 822,000 840,000 Units Month 13,700 June 14,000 July 828,000 13,800 August Dollars Units $ 798,000 13,300 834,000 13,900 846,000 14,100 Required: 1. Prepare schedules showing budgeted merchandise purchases for May and June. 2. Prepare a schedule showing budgeted cash disbursements during June. 3. Prepare a schedule showing budgeted cash collections during May. 4. Determine gross and net balances of accounts receivable on May 31. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare schedules showing budgeted merchandise purchases for May and June. Cost of Goods Sold Total needed Required 3 Required 4 D. Tomlinson Retail Budgeted Merchandise Purchases May and June May Budgeted merchandise purchases June July Prepare a schedule showing budgeted cash disbursements during June. D. Tomlinson Retail Budgeted Cash Disbursements, June May Total payables Budgeted cash disbursements June Prepare a schedule showing budgeted cash collections during May. D. Tomlinson Retail Cash Collections May Within the discount period After the discount period Total cash collections Determine gross and net balances of accounts receivable on May 31. March May Sales Remaining AR % AR Balance (Gross) Bad-debt allowance AR Balance (Net) % April % % Total
Expert Answer:
Answer rating: 100% (QA)
To prepare the required schedules for D Tomlinson Retail well go step by step through each of the four parts of the question Required 1 Budgeted Merchandise Purchases for May and June To calculate the ... View the full answer
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
D. Tomlinson Retail seeks your assistance in developing cash and other budget information for May, June, and July. The store expects to have the following balances at the end of April: Cash...
-
Delhi, Inc., seeks your assistance in developing cash and other budget information for August, September, and October. At July 31, the company had cash of $22,000, accounts receivable of $1,748,000,...
-
Hicks Corporation seeks your assistance in developing cash and other budget information for August, September, and October. At July 30, the company had cash of $5,500, accounts receivable of...
-
develop a trial balance, complete with an appropriate three-line heading 1. Bought office equipment from Peckoff Equipment Co. on 30-day credit terms, $1,390. Purchase Invoice #2071. Ledger Entries:...
-
On May 31, O'Hearne Limited had a cash balance per books of $13,126. The bank statement from Community Bank on that date showed a balance of $15,230. A comparison of the bank statement with the...
-
A processor makes two components, A and B, which are then packaged together as the final product (each product sold contains one A and one B). The processor can do only one component at a time:...
-
JIT and cost control Buskin Bolts, Inc. produces 50,000 units each day and the average number of units in work in process is 200,000. The average annual inventory carrying cost percentage is 20% and...
-
Referring to the Texas Lotto situation in Problem 7-20 suppose the investor has changed his attitude about the investment and wishes to give greater emphasis to the risk of the investment, now the...
-
Suppose you have a 2.5 uC point charge. How far in meters from the charge will the potential be 150 V if it is zero at infinity
-
7. 8. 9. An experiment is conducted using a fin as shown below. Temperature readings are collected along the length of the fin, which is made from copper with k-400W/m.K. Tb=50C x1 X L = 0.5m x2 h x3...
-
8) The financial department of a company that manufactures portable MP3 players arrived at the following daily cost equation for manufacturing x MP3 players per day: C(x) = 1500 + 105x +x2. The...
-
Custom Exceptions Objective: Implement a complete system from scratch using two custom Java objects that are self-validating and a driver class to create those objects. Related SLOs: SLO #1: Use an...
-
Computer-aided modeling and manufacturing, robotics and virtual reality applications require precise control of spatial position along a prescribed motion path. In several problems in these fields,...
-
A company want to find out if there is a linear relationship between indirect labor expense (ILE), in dollars, and direct labor hours (DLH). Data for direct labor hours and indirect labor expense for...
-
Answer the following questions using the information below: Schlickau Company manufactures basketball backboards. The following information pertains to the company's normal operations per month:...
-
Reverse osmosis process is used for drinking water production using seawater and brackish water.A small seawater reverse osmosis (SWRO) plant with 200 m membrane area is presented in the following...
-
be If the manager of a grocery store wishes to display the sales trend, the most effective type of graph wil a. A bar chart b. A pie chart c. A histogram d. A line chart The range of a set of data is...
-
On 1 July 2018, Parent Ltd acquired all the shares of Son Ltd, on a cum-div. basis, for $2,057,000. At this date, the equity of Son Ltd consisted of: $ 1,000,000 Share capital 500 000 shares...
-
List four or five important limitations of relevant cost analysis.
-
Boron Chemical Company produces a synthetic resin that is used in the automotive industry. The company uses a standard cost system. For each gallon of output, the following direct manufacturing costs...
-
Comprehensive Medical Care (CMC) is a family medical practice with 6 physicians and a nursing staff of 8 to 10 nurses and an administrative staff that varies from 4 to 7 personnel. Jay Kloger, the...
-
Understanding learning curve tables Foom Corporation's Arcade Electronic Division just completed assembly of 15 Android Invasion video games. The direct labor cost of the 15th unit was $93.38. The...
-
Labor schedule with learning curve Collagum Company has negotiated a contract to construct 8 rocket motors for a utility company. The contract price is for 200 percent of total labor-related cost of...
-
Use of learning curve table and formula A team of six technicians required 150 hours to assemble a new type of radar receiver. By the time they completed assembly of 18 such receivers, they had...
Study smarter with the SolutionInn App