Peabody, Inc., sells fireworks. The company's marketing director developed the following cost of goods sold budget...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Peabody, Inc., sells fireworks. The company's marketing director developed the following cost of goods sold budget for April, May, June, and July. April May June July Budgeted cost of goods $65,000 $75,000 $85,000 $91,000 sold Peabody had a beginning inventory balance of $3,900 on April 1 and a beginning balance in accounts payable of $14,900. The company desires to maintain an ending inventory balance equal to 15 percent of the next period's cost of goods sold. Peabody makes all purchases on account. The company pays 65 percent of accounts payable in the month of purchase and the remaining 35 percent in the month following purchase. Required a. Prepare an inventory purchases budget for April, May, and June. Inventory Purchases Budget April May June Budgeted cost of goods sold $ 65,000 $ 75,000 $ 85,000 Plus: Desired ending inventory Inventory needed Less: Beginning inventory Required purchases (on account) b. Determine the amount of ending inventory Peabody will report on the end-of-quarter pro forma balance sheet. Ending inventory c. Prepare a schedule of cash payments for inventory for April, May, and June. April May June Schedule of Cash Payments Payment of current accounts payable Payment of previous accounts payable Total budgeted payments for inventory d. Determine the balance in accounts payable Peabody will report on the end-of-quarter pro forma balance sheet. Accounts payable Peabody, Inc., sells fireworks. The company's marketing director developed the following cost of goods sold budget for April, May, June, and July. April May June July Budgeted cost of goods $65,000 $75,000 $85,000 $91,000 sold Peabody had a beginning inventory balance of $3,900 on April 1 and a beginning balance in accounts payable of $14,900. The company desires to maintain an ending inventory balance equal to 15 percent of the next period's cost of goods sold. Peabody makes all purchases on account. The company pays 65 percent of accounts payable in the month of purchase and the remaining 35 percent in the month following purchase. Required a. Prepare an inventory purchases budget for April, May, and June. Inventory Purchases Budget April May June Budgeted cost of goods sold $ 65,000 $ 75,000 $ 85,000 Plus: Desired ending inventory Inventory needed Less: Beginning inventory Required purchases (on account) b. Determine the amount of ending inventory Peabody will report on the end-of-quarter pro forma balance sheet. Ending inventory c. Prepare a schedule of cash payments for inventory for April, May, and June. April May June Schedule of Cash Payments Payment of current accounts payable Payment of previous accounts payable Total budgeted payments for inventory d. Determine the balance in accounts payable Peabody will report on the end-of-quarter pro forma balance sheet. Accounts payable
Expert Answer:
Answer rating: 100% (QA)
Answer Solution a Inventory purchase budget April May June Cost of goods sold 65000 75000 850... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Consider the market for petrol. Which of the following changes would most likely lead to a decrease in supply? Group of answer choices (a) An increase in the price of petrol cars. (b) The cost of oil...
-
Inventory turnover is calculated as cost of goods sold divided by ending inventory . 1. True 2. False
-
In 2013, Macys reported cost of goods sold of $ 16.5 billion, ending inventory for 2013 of $ 5.3 billion, and ending inventory for the previous year (2012) of $ 5.1 billion. Required: If the cost of...
-
Suppose a product can be produced using virgin ore at a marginal cost given by MC 1 = 0. 5q 1 and with recycled materials at a marginal cost given by MC 2 = 5 + 0. 1q 2 . (a) If the inverse demand...
-
Why bond prices and interest rates are inversely related?
-
Find one (1) media story about an economy (US or another country). The story does NOT need to be current, but it does need to be about macroeconomic events (inflation, growth, recession, etc.)....
-
What circumstances in an EDP system may lead to (a) similar and (b) different forms of compliance testing than in a manual system?
-
A firm sells its product in a perfectly competitive market where other firms charge a price of $80 per unit. The firm??s total costs are C(Q) = 40 + 8Q + 2Q2.a. How much output should the firm...
-
While scrolling through your favorite social media site, apicture of Philodendron ?a common houseplant?catchesyour eye. Your friend says about the photo, ?This houseplant and Iare best friends. It?s...
-
For this exercise you don't have to go out and buy a large bag of dice, just open the dice-roller application at random.org and roll 60 virtual dice. Sixty is the most you can roll at once in the...
-
$ 1 0 0 , 0 0 0 in bonds due in 5 years with an interest rate ( stated rate ) of 9 % . Interest is paid at the year - end. Market rate is 1 1 % at date of issuance. What is the present value?
-
Explain how conspiracy differs from complicity.
-
The State of Florida has brought this petition for issuance of a writ of certiorari seeking to quash an order of the trial court determining that the respondent/defendant, Alexander James, is...
-
Is black rage a legitimate excuse defense? Why or why not?
-
How does defense of habitation differ from defense of property?
-
Can an ordinary citizen use force and claim a law enforcement defense? If so, when? What about deadly force?
-
A company needs to upgrade their servers and workstations to support the latest 64-bit applications and deliver better performance. Which two processors will NOT satisfy the company's requirements?...
-
In Exercises evaluate the limit, using LHpitals Rule if necessary. lim 07x cos x X
-
Delaware Dairies is a vertically integrated company that has dairy farms, processing plants, and retail ice cream stores. Dela ware's strategy is to maximize shareholder value by providing...
-
Last year, Triple Cities Corp. adopted a standard cost system. Labor standards were set on the basis of time studies and prevailing wage rates. Materials standards were determined from materials...
-
In cost analysis, what determines which costs should be included in a study?
-
In Exercise 15.3 what sample sizes would be needed to raise power to 0.70, 0.80, and 0.90? Exercise 15.3 In Section 12.3 we looked at a set of data on whether children who are stressed from their...
-
Following on from Exercise 15.3, suppose that my colleagues were tired of having children tell them what they think we want to hear and gave them a heart-to-heart talk on the necessity of accurate...
-
Diagram the situation described in Exercise 15.6 along the lines of Figure 15.2. E xercise 15.6 Following on from Exercise 15.3, suppose that my colleagues were tired of having children tell them...
Study smarter with the SolutionInn App