(36) It is November 1 of Year 1. Sales for a computer company for November, D December, and January (of Year 2) are forecasted to be as follows: November: $400,000 December: $1,000,000 • January: $200,000 On average, the cost of goods sold is 50% of sales. During this period, the company expects inventory levels to remain constant. This means that inventory purchases are expected to equal the amount of cost of goods sold. 100% of purchases are on credit. Of the credit purchases, 5% are paid during the month of the purchase, 65% in the month following the purchase, and 30% in the second month following the purchase. Sales for September and October of Year 1 were $400,000 and $500,000, respectively. What is the forecasted amount of total cash payments for purchases in January? $230,000 $330,000 O $385,000 O $390,000

(36) It is November 1 of Year 1. Sales for a computer company for November, D December, and January (of Year 2) are forecasted to be as follows: November: $400,000 December: $1,000,000 • January: $200,000 On average, the cost of goods sold is 50% of sales. During this period, the company expects inventory levels to remain constant. This means that inventory purchases are expected to equal the amount of cost of goods sold. 100% of purchases are on credit. Of the credit purchases, 5% are paid during the month of the purchase, 65% in the month following the purchase, and 30% in the second month following the purchase. Sales for September and October of Year 1 were $400,000 and $500,000, respectively. What is the forecasted amount of total cash payments for purchases in January? $230,000 $330,000 O $385,000 O $390,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

Jamaica Co’s sales forecast for the first five months of 2018 are as follows: January February March April May $ 32,000 $ 36,000 $ 48,000 $ 46,000 $ 55,000 Additional information provided is as follows: (i) Sales for November and December of the previous year were $40,000 and $45,000 respectively. (ii) Sixty percent of sales will be for cash; 30% will be collected in the first month following the sale; and the remaining 10% will be collected in the second month following the sale. (iii) Raw material purchases are settled a month after purchase. Each month’s purchases is shown below: December January February March April $22,400 $25,200 $33,600 $32,200 $38,500 (iv) Wages total $4,200 monthly. (v) Other expenses are $1,800 in January but is expected to increase by $550 each month; (vi) Equipment costing $15,000 will be ordered in January. A…
Samuelson has a beginning inventory balance on January 1 of 12,000 units and desires an ending balance of 20% of the next month’s sales. If sales are expected to be 17,000 for January and 20,000 for February, what amount of units does Samuelson have to produce during the month of January?
Thomas & Cooke Corporation has the following sales forecasts for the first three months of the current year: Month Sales January $39,000 February 26,000 March 45,000 85% of sales are collected in the month of the sale and the remainder is collected in the following month. Accounts receivable balance (January 1) $25,800 Cash balance (January 1) 25,000 Minimum cash balance needed 22,000 What is the cash balance at the end of January, assuming that cash is received only from customers and that $50,000 is paid out during January?
KCO, SRL anticipates the following sales in the given months: March 42,000 units April 59,000 units May 49,000 units June 55,000 units July 52,000 units Company policy is to maintain an ending finished goods inventory equal to 50% of the following month's sales. On the basis of this information, how many units would the company plan to produce in May?
J.TOY Inc., was organized on August 1 of the current year. Projected sales for the ا ی و ن ن و ر می و ی و و و و و ی next three months are as follows: -August : $120,000 -September : $200,000 -October : $230,000 The J.TOY expects to sell 40% of its merchandise for cash. Of the sales on account, 25% are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating total cash collections for August, September, and October.
Ind
A company has expected sales for January through April of $9,800, 59, 500, $13, 800, and $9,500, respectively. Assume each month has 30 days and the accounts receivable period is 36 days. How much does the company expect to collect in the month of May?
Vikrambhai
Good Morning Sunshine is a wholesaler of coffee makers. In the current year, actual March sales revenue totaled $200,000. April sales are expected to increase 10% above March sales. May sales are expected to increase 10% above April sales. June sales are expected to decrease 5% below May sales. Prices are set to achieve a 60% gross profit. The company wants to maintain an ending merchandise inventory equal to 15% of the next month’s cost of sales. The ending inventory requirement was met at the end of March. Accounts Payable consist solely of inventory purchases. All invoices from the suppliers are dated as of the end of the month of purchase and carry payment terms 2/10, net 30. Assuming Good Morning Sunshine takes full advantage of purchase discounts offered, what are the company's expected cash disbursements in May to its supplier? A. $87,533.60 B. $94,152.52 C. $131,300.40 D. $86,240.00 E. $89,474.00
Rocker Company expects to sell 7,000 units for $180 each for a total of $1,260,000 in January and 1,500 units for $190 each for a total of $285,000 in February. The company expects cost of goods sold to average 60% of sale revenue, and the company expects to sell 4,300 units in March for $260 each. Rocker's target ending inventory is $15,000 plus 50% of the next month's cost of goods sold Prepare Rocker's inventory, purchases, and cost of goods sold budget for January and February Rocker Company Inventory, Purchases, and Cost of Goods Sold Budget Two months Ended January 31 and February 28 January February Cost of goods soid Plus: Desired ending merchandise inventory Total merchandise inventory required Less: Beginning merchandise inventory Budgeted purchases Your protection has expire Don't leave your devices exposed to virus Uneretested devices are perfect targets for
Raider-X Company forecasts sales of 18,000 units for April. Beginning inventory is 3,000 units. The desired ending inventory is 30% higher than the beginning inventory. How many units should Raider-X purchase in April?
Cherboneau Novelties produces drink coasters (among many other products). During the current year (year 0), the company sold 525,000 units (packages of 6 coasters). In the coming year (year 1), the company expects to sell 550,000 units, and, in year 2, it expects to sell 684,000 units. The target ending finished goods inventory for each month is equal to the next month's sales. However, because of production issues, the ending inventory in the current year (year 0) is expected to be only 14,500 units. Each unit requires 0.5 pound of cork. At the end of the current year (year 0), management expects to have 20,000 pounds of cork in inventory. Management has set a target to have cork on hand equal to one half of next month’s sales requirements during the coming year (year 1). Sales and production take place evenly throughout the year. Required: Compute the total targeted production of the finished coaster for the coming year. Compute the required amount of cork to be purchased for…