Question

In: Accounting

Hardy Company’s cost of goods sold is consistently 70% of sales. The company plans ending merchandise...

Hardy Company’s cost of goods sold is consistently 70% of sales. The company plans ending merchandise inventory for each month equal to 30% of the next month’s budgeted cost of goods sold. All merchandise is purchased on credit, and 40% of the purchases made during a month is paid for in that month. Another 45% is paid for during the first month after purchase, and the remaining 15% is paid for during the second month after purchase. Expected sales are: August (actual), $355,000; September (actual), $400,000; October (estimated), $310,000; and November (estimated), $380,000.

Use this information to determine October’s expected cash payments for purchases.

Calculate Monthly Purchases:
August September October November
Budgeted ending inventory
Required available inventory
Required purchases $0 $0 $0
Calculate Payments Made for Inventory:
---------- Purchases paid in ---------------
Purchases August September October After October
August purchases
September purchases
October purchases 0
Determine October’s Expected Cash Payments for Purchases.
October's expected cash payments for purchases

Solutions

Expert Solution


Related Solutions

When the merchandise is sold by the company, what is the cost of goods sold?
Use the following information on the U.S. dollar value of the euro.Spot RateForward Rate forApril 30, 2021 DeliveryOctober 30, 2020$ 1.250$ 1.254December 31, 20201.2581.256April 30, 20211.2601.260On October 30, 2020, a U.S. company forecasts that it will purchase merchandise from an Italian supplier at the end of April 2021, in the amount of €100,000, and will pay the supplier on delivery. On October 30, the company enters a forward contract to buy €100,000 on April 30, 2021 and classifies it as...
Alamo company has sales, cost of goods sold, and average ending inventory for the current year...
Alamo company has sales, cost of goods sold, and average ending inventory for the current year in the following amounts: $650,000, $500,000,and $128,000,respectively. calculate the amount of the company's inventory turnover for the year. what is the company's average number of days to sell inventory
Weighted-average Ending Merchandise Inventory _______________ Cost of Goods Sold ________________ Could you please fill in the...
Weighted-average Ending Merchandise Inventory _______________ Cost of Goods Sold ________________ Could you please fill in the blank? What is the weighted average? Jul. 1 Beginning merchandise inventory 6 units @ $60 each Jul. 8 Purchase 5 units @ $67 each Jul. 15 Purchase 10 units @ $70 each Jul. 26 Purchase 5 units @ $85 each
a. Sold $852,000 of merchandise on account, subject to a sales tax of 7%. The cost of the goods sold was $502,680.
Sales Tax TransactionsJournalize the entries to record the following selected transactions.a. Sold $852,000 of merchandise on account, subject to a sales tax of 7%. The cost of the goods sold was $502,680.If an amount box does not require an entry, leave it blank.Accounts ReceivableSalesSales Tax PayableCost of Goods SoldInventoryb. Paid $45,520 to the state sales tax department for taxes collected.If an amount box does not require an entry, leave it blank.Sales Tax PayableCash
8. If the cost of goods sold is $100,000, sales are $200,000, merchandise purchases are $37,000,...
8. If the cost of goods sold is $100,000, sales are $200,000, merchandise purchases are $37,000, and ending merchandise inventory is $10,000, then the beginning merchandise inventory must be: 9. A merchandiser plans to sell 14,600 units next month at a selling price of $110 per unit. It also gathered the following cost estimates for next month: Cost Cost Formula Cost of goods sold $60 per unit sold Advertising expense $150,000 per month Depreciation expense $70,000 per month Shipping expense...
1. To adjust a company’s LIFO cost of goods sold to FIFO cost of goods sold...
1. To adjust a company’s LIFO cost of goods sold to FIFO cost of goods sold the ending LIFO reserve is added to LIFO cost of goods sold. the ending LIFO reserve is subtracted from LIFO cost of goods sold. an increase in the LIFO reserve is subtracted from LIFO cost of goods sold. a decrease in the LIFO reserve is subtracted from LIFO cost of goods sold. 2. All of the following statements are true regarding the LIFO reserve...
During the current year, merchandise is sold for $8,920,000. The cost of the goods sold is...
During the current year, merchandise is sold for $8,920,000. The cost of the goods sold is $6,065,600. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. What is the amount of the gross profit? Round your answer to the nearest dollar. $   Compute the gross profit percentage (gross profit divided by sales). Round your answer to the nearest whole number. % Will the...
Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
Exercise 6-4A Calculate inventory amounts when costs are rising (LO6-3)During the year, TRC Corporation has the following inventory transactions.DateTransactionNumber of UnitsUnit CostTotal CostJan.1Beginning inventory52$44$2,288Apr.7Purchase132466,072Jul.16Purchase202499,898Oct.6Purchase112505,600498$23,858For the entire year, the company sells 432 units of inventory for $62 each.Exercise 6-4A Part 22. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
Abbott Inc.   Minimum ending cash balance $80,000 Cost of Goods Sold (as a percentage of sales)...
Abbott Inc.   Minimum ending cash balance $80,000 Cost of Goods Sold (as a percentage of sales) 60% Gross margin (as a percentage of sales) 40% Recent and forecast sales : March (Actual) $60,000 April 70,000 May 85,000 June 90,000 July 50,000 Desired ending inventories (percentage of next month's cost of goods sold) 30% Purchases paid as follows: In month of purchase 50% In following month 50% Collection on Sales Cash Sales 20% Credit Sales 80% All payments on credit sales...
From the following, calculate the cost of ending inventory and cost of goods sold for the...
From the following, calculate the cost of ending inventory and cost of goods sold for the weighted-average method, ending inventory is 56 units. (Round your intermediate calculations and final answers to the nearest cent.) Beginning inventory and purchases Units Unit cost January 1 6 $ 2.70 April 10 9 3.20 May 15 13 3.70 July 22 14 3.95 August 19 19 4.70 September 30 19 4.90 November 10 33 5.10 December 15 15 5.50 cost of ending inventory? Cost of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT