chandise vertory of $456,000 in January and $530,500 in February. Assume Thiel pays for inventory purchases 40% in the month of the purchase and 60% in the month after purchase. The Accounts Payable balance on December 31 is $98,150. Prepare a schedule of cash payments for purchases for January and February ( a input field is not used in the table leave the input field empty, do not enter a zero) Cash Payments Total merchandise inventory purchases Cash Payments Merchandise Inventory: Dec-Dec. 31 Accounts Payable, paid in Jan. Jan-Jan merchandise inventory purchases paid in Jan. Jan-Jan merchandise inventory purchases paid in Feb. Feb-Feb. merchandise inventory purchases paid in Feb. Total payments for merchandise inventory January January February February

chandise vertory of $456,000 in January and $530,500 in February. Assume Thiel pays for inventory purchases 40% in the month of the purchase and 60% in the month after purchase. The Accounts Payable balance on December 31 is $98,150. Prepare a schedule of cash payments for purchases for January and February ( a input field is not used in the table leave the input field empty, do not enter a zero) Cash Payments Total merchandise inventory purchases Cash Payments Merchandise Inventory: Dec-Dec. 31 Accounts Payable, paid in Jan. Jan-Jan merchandise inventory purchases paid in Jan. Jan-Jan merchandise inventory purchases paid in Feb. Feb-Feb. merchandise inventory purchases paid in Feb. Total payments for merchandise inventory January January February February

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 22M

See similar textbooks

Similar questions

All Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?
Sports Socks has a policy of always paying within the discount period and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 85% of its payments are made in the month of purchase and 15% are made the following month. The direct materials budget provides for purchases of $129,582 in November, $294,872 in December, $239,582 in January, and $234,837 in February. What is the balance in accounts payable for January 31, and February 28?
Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Rivers Company purchases merchandise on account. In general, Rivers pays 50% in the month of purchase and 50% in the following month. All payments in the month of purchase qualify for a 2% cash discount. First quarter budgeted purchases are: January $90,000 February $80,000 March $96,000 A. What are the total cash disbursements expected in February? B. What are the total cash disbursements expected in March? C. Now suppose that there is no cash discount for purchases made in the month of purchase. Now what are the total cash disbursements expected in February? In March?
Torres Company budgets merchandise purchases of $15,800 in January, $17,600 in February, and $22,200 in March. For those purchases, 40% of purchases are paid in the month of purchase and 60% are paid in the month after the purchase. The company purchased $26,000 of merchandise in December. Prepare a schedule of cash payments for merchandise for the months of January, February, and March.
Rivers Company purchases merchandise on account. In general, Rivers pays 50 percent in the month of purchase and 50 percent in the following month. All payments in the month of purchase qualify for a 2 percent cash discount. First quarter budgeted purchases are: January February March $90,000 80,000 96,000 A. What are the total cash disbursements expected in February? $ B. What are the total cash disbursements expected in March? C. Now suppose that there is no cash discount for purchases made in the month of purchase. What are the total cash disbursements expected in February and in March? February cash disbursements March cash disbursements
Marlin Company projects the follwoing sales for the first thre months of the year: $11500 in January; $10100 in February and $10400 in March. the company expects 60% of the sales to be cash and the remainder on accounts. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Account Receivable account has a zero on January. 1. Prepare a schedule of cash receipts for Marlin for January, February and March. What is the balance in Accounts Receivable on March 31? 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 70% in the month of the sale, 20% in the following month of the sale and 10% in the second month of the sale. What is the balance in Accounts Receivable on March 31?
The company pays for its purchases within 10 days of purchase, so assume that one-third of the purchases of any month are due and paid for in the following month. The cost of the merchandise purchased is $10 per case. At the end of each month, it is desired to have an inventory equal in units to 75% of the following month's sales in units. Exclusive of bad debts, total budgeted selling and general administrative expenses for the fiscal year are estimated at$80,600, of which $19,000 is fixed expense (which includes a $5,200 annual depreciation charge). this is incurred fixed expenses uniformly throughout the year. The balance of the selling and general administrative expenses varies with sales. Expenses are paid as incurredRequirementl.
Rooney 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 15 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $82,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 $ Budgeted cost of goods sold Plus: Desired beginning inventory Inventory needed Less: Desired beginning inventory Required purchases (on account) $…