Sales are budgeted at $360,000 for November, $370,000 for December, and $350,000 for January. . Collections are expected to be 40% in the month of sale and 60% in the month following the sale. • The cost of goods sold is 60% of sales. • The company desires an ending merchandise inventory equal to 20% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase. • The November beginning balance in the accounts receivable account is $71,000. • The November beginning balance in the accounts payable account is $258,000. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. Complete this question by entering your answers in the tabs below. Required A Required B Prepare a Schedule of Expected Cash Collections for November and December. Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total cash collections November $ $ December 360,000 $ 370,000 144,000 $ 148,000 144,000 $ 148,000

Sales are budgeted at $360,000 for November, $370,000 for December, and $350,000 for January. . Collections are expected to be 40% in the month of sale and 60% in the month following the sale. • The cost of goods sold is 60% of sales. • The company desires an ending merchandise inventory equal to 20% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase. • The November beginning balance in the accounts receivable account is $71,000. • The November beginning balance in the accounts payable account is $258,000. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. Complete this question by entering your answers in the tabs below. Required A Required B Prepare a Schedule of Expected Cash Collections for November and December. Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total cash collections November $ $ December 360,000 $ 370,000 144,000 $ 148,000 144,000 $ 148,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Center Company makes collections on sales according to the following schedule: 30% in the month of sale 60% in the month following sale 8% in the second month following sale The following sales are expected: Expected Sales January $ 108,000 February $ 144,000 March $ 127,000 Cash collections in March should be budgeted to be:
Tasty Foods expects to have 37,000 units of finished goods inventory on hand on March 31 and reports the following expected sales (in units) for the months of April through July: April 137,000 May 157,000 June 167,000 July 137,000 At the end of each month the company desires its ending finished goods inventory to be 20% of the next month's projected sales (in units). The budgeted production (in units) for Tasty Foods for April should be: Multiple Choice 142.600. 137,000. 144,200. 131,400, 172.600.
page Fraser Company has forecast purchases on account to be $210,000 in March, $270,000 in April, $320,000 in May, and $390,000 in June. Seventy percent of purchases are paid for in the month of purchase, the remaining thirty percent are paid in the following month. What are budgeted cash payments for April? O a. $252,000 O b. $285,000 O c. $126,000 O d. $159,000 irses.open.uwi.edu/mod/quiz/attempt.php?attempt=63242&cmid-99810&page-14 pe here to search S J £ 3 E $ 4 O BI R JU F JU % 5 C T 6 B & H U 8 Time left 0:28:46 W Next page 28°C Mostly
Kent Company has a sales budget for next month of $1,000,000. Cost of goods sold is expected to be 25 percent of sales. All goods are paid for in the month following purchase. The beginning inventory of merchandise is $50,000, and an ending inventory of $64,000 is desired. Beginning accounts payable is $160,000. For Kent Company, the ending accounts payable should be: Select one: O A. $341,000 B. $414,000 C. $264,000 D. $356,000
Kemmerly Company opens in September and plans to purchase wallets for $15 and sell them for $20 per wallet. Kemmerly Company maintains ending inventory of 25% of next months sales. They plan to sell 1,800 units in September, 2,000 in October, and 2,250 in November. What is the budgeted cost of goods sold in November?
Moore Wholesalers is preparing its merchandise purchases budget. Budgeted sales are $440,000 for April and $510,000 for May. Cost of goods sold is expected to be 65% of sales. The company’s desired ending inventory is 24% of the following month’s cost of goods sold.Compute the required purchases for April. Moore WholesalersPurchases Budget For the Month of AprilFor the Quarter EndedFor the Year Ended Beginning InventoryBudgeted Cost of Goods SoldDesired Ending Direct MaterialsDesired Ending InventoryDirect Materials per UnitDirect Materials PurchassRequired Merchandise Purchases for AprilUnits to Be ProducedTotal Inventory Required $ AddLess: Beginning InventoryBudgeted Cost of Goods SoldDesired Ending Direct MaterialsDesired Ending…
Folgerty Enterprises prepared the following sales budget: Month Budgeted Sales March $6,000 April $13,000 May $12,000 June $14,000 The expected gross profit rate is 30% and the inventory at the end of February was $10,000. Desired finished goods inventory levels at the end of the month are 20% of the next month's cost of goods sold. What is the desired beginning finished goods inventory on June 1 (in dollars)? Select one: a. $1,960 b. $840 c. $1,680 d. $9,800 e. $1,860
Seaworthy Company, a merchandising company, has prepared the following sales budget: Month Budgeted Sales March $200,000.00 April 202,000 May June Cost of goods sold is budgeted at 50% of sales, and the inventory at the end of February was $34,000.00. Desired inventory levels at the end of each month are 10% of the next month's cost of goods sold. What is the desired beginning inventory on June 1? 238,000 256,000 O A. $12,800.00 O B. $118,000.00 OC. $11,900.00 O D. $25,600.00
Thornton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Thornton's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $84,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. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January February March Budgeted cost of goods sold $ 59,000 $ 63,000 $ 69,000 Plus: Desired ending inventory 9,450 Inventory needed 68,450 Less: Beginning…
Riverbed Inc. provided the following information: April Projected merchandise purchases $92,500 Calculate budgeted cash disbursements for May. May $82,000 Total budgeted cash disbursements $ June Riverbed pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. General operating expenses are budgeted to be $34,500 per month of which depreciation is $3,400 of this amount. Riverbed pays operating expenses in the month incurred. Riverbed makes loan payments of $5,000 per month of which $550 is interest and the remainder is principal. $69,000
Moore Wholesalers is preparing its merchandise purchases budget. Budgeted sales are $400,000 for April and $480,000 for May. Cost of goods sold is expected to be 65% of sales. The company’s desired ending inventory is 20% of the following month’s cost of goods sold.Compute the required purchases for April. Moore WholesalersPurchases Budget $ : : $
Stuart Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Stuart's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of sold. April's budgeted cost of goods sold is $80,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 quar Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory Required purchases (on account) January February March $ 57,000 $…