Homework Help is Here – Start Your Trial Now!
Business
Accounting
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 end-of-quarter pro forma balance sheet. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Prepare an inventory purchases budget for April, May, and June. Inventory Purchases Budget April May June Budgeted cost of goods sold $ Plus: Desired ending inventory Inventory needed Less: Beginning inventory 74,000 $ 82,400 156,400 84,000 $ 94,000 84,000 94,000 S 156.400 $ 84,000 $ 94,000

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 end-of-quarter pro forma balance sheet. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Prepare an inventory purchases budget for April, May, and June. Inventory Purchases Budget April May June Budgeted cost of goods sold $ Plus: Desired ending inventory Inventory needed Less: Beginning inventory 74,000 $ 82,400 156,400 84,000 $ 94,000 84,000 94,000 S 156.400 $ 84,000 $ 94,000

Managerial Accounting: The Cornerstone of Business Decision-Making
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter9: Profit Planning And Flexible Budgets
Section: Chapter Questions
Problem 45BEB: Pilsner Inc. purchases raw materials on account for use in production. The direct materials...
See similar textbooks
icon
Related questions
Question
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 end-of-quarter pro forma balance sheet. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Prepare an inventory purchases budget for April, May, and June. Inventory Purchases Budget April May June Budgeted cost of goods sold $ Plus: Desired ending inventory Inventory needed Less: Beginning inventory 74,000 $ 82,400 156,400 84,000 $ 94,000 84,000 94,000 S 156.400 $ 84,000 $ 94,000
Transcribed Image Text: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 end-of-quarter pro forma balance sheet. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Prepare an inventory purchases budget for April, May, and June. Inventory Purchases Budget April May June Budgeted cost of goods sold $ Plus: Desired ending inventory Inventory needed Less: Beginning inventory 74,000 $ 82,400 156,400 84,000 $ 94,000 84,000 94,000 S 156.400 $ 84,000 $ 94,000
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
SEE MORE TEXTBOOKS