Gibson, Inc. sells fireworks. The company's marketing director developed the following cost of goods sold budget for April, May, June, and July. Budgeted cost of goods sold Gibson had a beginning inventory balance of $4,100 on April 1 and a beginning balance in accounts payable of $15,500. The company desires to maintain an ending inventory balance equal to 15 percent of the next period's cost of goods sold. Gibson makes all purchases on account. The company pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the month following purchase. Required a. Prepare an inventory purchases budget for April, May, and June. b. Determine the amount of ending inventory Gibson will report on the end-of-quarter pro forma balance sheet c. Prepare a schedule of cash payments for inventory for April, May, and June. d. Determine the balance in accounts payable Gibson will report on the end-of-quarter pro forma balance sheet. April May June $72,000 $82,000 $92,000 Complete this question by entering your answers in the tabs below. July $98,000

Gibson, Inc. sells fireworks. The company's marketing director developed the following cost of goods sold budget for April, May, June, and July. Budgeted cost of goods sold Gibson had a beginning inventory balance of $4,100 on April 1 and a beginning balance in accounts payable of $15,500. The company desires to maintain an ending inventory balance equal to 15 percent of the next period's cost of goods sold. Gibson makes all purchases on account. The company pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the month following purchase. Required a. Prepare an inventory purchases budget for April, May, and June. b. Determine the amount of ending inventory Gibson will report on the end-of-quarter pro forma balance sheet c. Prepare a schedule of cash payments for inventory for April, May, and June. d. Determine the balance in accounts payable Gibson will report on the end-of-quarter pro forma balance sheet. April May June $72,000 $82,000 $92,000 Complete this question by entering your answers in the tabs below. July $98,000

Financial Accounting

15th Edition

ISBN:9781337272124

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter7: Inventories

Section: Chapter Questions

Problem 4CP: Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and...

See similar textbooks

Related questions

Q: Attributes about an entity- Select one. O a. Database O b. Record O c. Field O d. File

A: Attributes about an entity are fields.

Q: Do you have to manually balance a journal entry or does Quickbooks do that for you?

A: QuickBooks: QuickBooks is one form of accounting software. It helps in record keeping, sales…

Q: Explain open accounts and notes.

A: Open account: It is a sale transaction in which the goods are shipped and delivered before payment…

Q: Reports can be directly exported from QBO to __________________. Select all that apply. Select one…

A: Ans. Quick books is a kind of accounting software package. It is mainly used by small and medium…

Q: journal entries required

A: Journal entries are the starting step towards the accounting cycle. It is the initial recording of…

Q: Denzel Brooks opens a Web consulting business called Venture Consultants and completes the following…

A: Record the transactions in the T accounts:

Q: rmn.3 answer must be in table format or i will give down vote

A: Approach to solving the question:I need more context about this. If you give me more information…

Q: Let's start the activities with this simple word hunt. All you have to do is to look for the…

A: Permanent accounts are those accounts that are not closed at the end of the year. Though their…

Q: Go to the previous page in the Help task pane by clicking this button. Select one: a. Task Pane…

A: Help Task Pane - This is the help window that helps the user from the various difficulty of complex…

Q: Which function in excel did you use

A: The concept of time value of money will be used here. The amount needed today will be the sum of…

Q: Annuty FV =((p(1+r/n)t-1))/(r/n) P = payment N= number of compounding per year compounding frequency

A: An annuity is a plan or financial investment that provides lifetime regular payments at regular time…

Q: Describe the purpose of caash receipts journal.

A: The cash receipts journal is a special section of the general journal specifically used to record…

Q: Select whether each of the following accounts normally has a debit balance or a credit balance:

A: Under generally accepted accounting principles, All the assets and expenses accounts has normal…

Q: When can a QuickBooks List be updated?

A: The question is related to updating the quickbooks software. QuickBooks is an user friendly…

Q: that particular year? Take ross income for oil as 22%.

A: Pay as you earn system or tax deduction at source in some countries are the advance tax payment…

Q: What is receivable management? Explain it?

A: The receivable management is the process of managing and tract the account receivable, especially it…

Q: journalizing?

A: Journalizing is the process followed by businesses in recording their transactions in an orderly…

Q: Describe the elements of an e-mail address.

A: Internet: Internet is the means of communication which connects one smart device with any other…

Q: dger turo

A: Explanation of Concept Ledger Posting : is the step in the process of preparing the books accounts…

Q: Clicking Generate at the bottom of the A/P Create Payment Batch form creates a payment batch. Group…

A: The objective of the question is to verify the functionality of the 'Generate' button in the A/P…

Q: Spring Company's cost structure is dominated by variable costs with a contribution margin ratio of…

A: Break-even analysis is a technique used widely by production management. It helps to determine the…

Q: Please answer D to F in the attached questions. Please label accordingly ( e.g d) instead of step…

A: Answer d) Computation of margin of safety (in units) is as follows: Margin of safety (in…

Q: Please provide the introductory part and answer for question D.

A: Additional paid-up capital refers to money that investors paid above and beyond the par value price…

Q: Any help is appreciated, here is the question.…

A: The whole cost of purchasing, setting up, and readying an asset for usage is referred to as its…

Q: How do you get a report into PDF format? Select an answer: You need to email the report and…

A: First, you need to open the report that you want to convert into a PDF format. This could be a…

Concept explainers

Master Budget

A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.

Sales Budget and Selling

A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.

Question

Answer complete question please, answer in text form please

Gibson, Inc. sells fireworks. The company's marketing director developed the following cost of goods sold budget for April, May, June,
and July
Budgeted cost of goods sold
April
$72,000
Required A Required B
May June
$82,000 $92,000
Gibson had a beginning inventory balance of $4,100 on April 1 and a beginning balance in accounts payable of $15,500. The company
desires to maintain an ending inventory balance equal to 15 percent of the next period's cost of goods sold. Gibson makes all
purchases on account. The company pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in
the month following purchase.
Required
a. Prepare an inventory purchases budget for April, May, and June.
b. Determine the amount of ending inventory Gibson will report on the end-of-quarter pro forma balance sheet.
c. Prepare a schedule of cash payments for inventory for April, May, and June.
d. Determine the balance in accounts payable Gibson will report on the end-of-quarter pro forma balance sheet.
Complete this question by entering your answers in the tabs below.
Required C
Required D
July
$98,000
Prepare an inventory purchases budget for April, May, and June.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Budgeting Explained below -

VIEW

Step 2: Working Notes Prepared for Budgeting Schedules -

VIEW

Step 3: Inventory Purchase Budget Prepared -

VIEW

Step 4: Schedule of Cash Payments for Inventory Purchase -

VIEW

Solution

VIEW

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Click the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a deflationary period, which bar (A, B, or C) represents FIFO costing, which represents LIFO costing, and which represents weighted average? Explain your reasoning. On January 4 following year-end, Rio Enterprises received a shipment of 60 units of product costing 580 each. These units had been ordered by Del in December and had been shipped to him on December 27. They were shipped FOB shipping point. Revise the FIFOLIFO3 worksheet to include this shipment. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as FIFOLIFOT. Using the FIFOLIFO3 file, prepare a 3-D bar (stacked) chart showing the cost of goods sold and ending inventory under each of the four inventory cost flow assumptions. No Chart Data Table is needed. Use the values in the Calculations Section of the worksheet for your chart. Enter your name somewhere on the chart. Save the file again as FIFOLIFO3. Print the chart.
Langstons purchased $3,100 of merchandise during the month, and its monthly income statement shows a cost of goods sold of $3,000. What was the beginning inventory if the ending inventory was $1,250?
Logo Gear purchased $2,250 worth of merchandise during the month, and its monthly income statement shows cost of goods sold of $2,000. What was the beginning inventory if the ending inventory was $1,000?
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?
Communication Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and sales for the year are as follows: Purchases: Sales: The president of the company, Connie Kilmer, has asked for your advice on which inventory cost flow method should be used for the 32,000-unit physical inventory that was taken on December 31. The company plans to expand its product line in the future and uses the periodic inventory system. Write a brief memo to Ms. Kilmer comparing and contrasting the LIFO and FIFO inventory cost flow methods and their potential impacts on the companys financial statements.
Fanning, Incorporated sells fireworks. The company's marketing director developed the following cost of goods sold budget for April, May, June, and July. Budgeted cost of goods sold April $ 74,000 May $ 84,000 June $ 94,000 $ 100,000 July Fanning had a beginning inventory balance of $4,100 on April 1 and a beginning balance in accounts payable of $14,100. The company desires to maintain an ending inventory balance equal to 10 percent of the next period's cost of goods sold. Fanning 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. b. Determine the amount of ending inventory Fanning will report on the end-of-quarter pro forma balance sheet. c. Prepare a schedule of cash payments for inventory for April, May, and June. d. Determine the balance in accounts payable Fanning will report on the…
Baird, Inc. sells fireworks. The company's marketing director developed the following cost of goods sold budget for April, May, June, and July. April $66,000 Мay $76,000 July $92,000 June Budgeted cost of goods sold $86,000 Baird had a beginning inventory balance of $3,600 on April 1 and a beginning balance in accounts payable of $13,900. The company desires to maintain an ending inventory balance equal to 15 percent of the next period's cost of goods sold. Baird 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. b. Determine the amount of ending inventory Baird will report on the end-of-quarter pro forma balance sheet. c. Prepare a schedule of cash payments for inventory for April, May, and June. d. Determine the balance in accounts payable Baird will report on the end-of-quarter pro forma…
Please answer all subparts because i cant post last sunlart separately because it is interlinked thanku
Campbell, Incorporated sells fireworks. The company's marketing director developed the following cost of goods sold budget for April, May, June, and July Budgeted cost of goods sold May June April $ 64,000 $ 74,000 $ 84,000 July $ 90,000 Campbell had a beginning inventory balance of $4,300 on April 1 and a beginning balance in accounts payable of $15,600. The company desires to maintain an ending inventory balance equal to 10 percent of the next period's cost of goods sold. Campbell 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. b. Determine the amount of ending inventory Campbell will report on the end-of-quarter pro forma balance sheet. c. Prepare a schedule of cash payments for inventory for April, May, and June. d. Determine the balance in accounts payable Campbell will report on the…
Rooney, 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 sold $69,000 $79,000 $89,000 $95,000 Rooney had a beginning inventory balance of $3,900 on April 1 and a beginning balance in accounts payable of $14,800. The company desires to maintain an ending inventory balance equal to 15 percent of the next period’s cost of goods sold. Rooney makes all purchases on account. The company pays 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the month following purchase. Required Prepare an inventory purchases budget for April, May, and June. Determine the amount of ending inventory Rooney will report on the end-of-quarter pro forma balance sheet. Prepare a schedule of cash payments for inventory for April, May, and June. Determine the balance in accounts payable Rooney will report on the…
Jordan, Incorporated sells fireworks. The company's marketing director developed the following cost of goods sold budget for April, May, June, and July. Required A Required B Required C Required D April $ 65,000 Budgeted cost of goods sold Jordan had a beginning inventory balance of $4,200 on April 1 and a beginning balance in accounts payable of $14,300. The company desires to maintain an ending inventory balance equal to 15 percent of the next period's cost of goods sold. Jordan makes all purchases on account. The company pays 60 percent of accounts payable in the month of purchase and the remaining 40 percent in the month following purchase. Required a. Prepare an inventory purchases budget for April, May, and June. b. Determine the amount of ending inventory Jordan will report on the end-of-quarter pro forma balance sheet. c. Prepare a schedule of cash payments for inventory for April, May, and June. d. Determine the balance in accounts payable Jordan will report on the…
Do not give image format