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 May $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 balance sheet.

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 May $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 balance sheet.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 10PB: All Temps has a policy of always paying within the discount period, and each of its suppliers...

See similar textbooks

Similar questions

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?
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?
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?
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?
Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for January using this data: in December through February, it purchased $22,000, $25,000, and $23,000 respectively.
In April, Holderness Incorporated, a merchandising company, had sales of $286,000, selling expenses of $20,500, and administrative expenses of $31,500. The cost of merchandise purchased during the month was $168,000. The beginning balance in the merchandise inventory account was $40,500 and the ending balance was $54,500 Required: Prepare a traditional format income statement for April. Holderness Incorporated For the month of April Traditional Format Income Statement Sales Cost of goods sold Gross margin Selling and administrative expenses Selling expense Administrative expense $ 20,500 31,500 5 286.000 154.000 132.000 52.000 $ 80,000 4
Based on the following production and sales data of Jackson Co. for March of the current year. Product T Product X Estimated inventory, March 1 26,000 units 18,000 units Desired inventory, March 31 32,000 units 15,000 units Expected sales volume: Area I 320,000 units 260,000 units Area II 190,000 units 130,000 units Unit sales price $4 $12 a. Prepare Sales budget. Jackson Co. Sales Budget For Month Ending March 31, 20XX Product and Area Unit Sales Volume Unit Selling Price Total Sales Product T: Area I $ $ Area II Total $ Product X: Area I $ $ Area II Total $ Total revenue from sales $ b. Prepare a production budget. Jackson Co. Production Budget For Month Ending March 31, 20XX Product T (units) Product X (units) Sales Plus desired ending inventory, March 31, 20XX Total Less estimated beginning inventory, March 1, 20XX Total…
Based on the following production and sales data of Jackson Co. for March of the current year. Product T Product X Estimated inventory, March 1 26,000 units 18,000 units Desired inventory, March 31 32,000 units 15,000 units Expected sales volume: Area I 320,000 units 260,000 units Area II 190,000 units 130,000 units Unit sales price $4 $12 a. Prepare Sales budget. Jackson Co.Sales BudgetFor Month Ending March 31, 20XX Product and Area Unit Sales Volume Unit Selling Price Total Sales Product T: Area I fill in the blank fd1fca00100d02d_1 $fill in the blank fd1fca00100d02d_2 $fill in the blank fd1fca00100d02d_3 Area II fill in the blank fd1fca00100d02d_4 fill in the blank fd1fca00100d02d_5 fill in the blank fd1fca00100d02d_6 Total fill in the blank fd1fca00100d02d_7 $fill in the blank fd1fca00100d02d_8 Product X: Area I fill in the blank fd1fca00100d02d_9 $fill in the blank fd1fca00100d02d_10 $fill in the blank…
Based on the following production and sales data of Frixion Co. for March of the current year: Product T Product X Estimated inventory, March 1 28,000 units 20,000 units Desired inventory, March 31 32,000 units 15,000 units Expected sales volume: Area I 320,000 units 260,000 units Area II 190,000 units 130,000 units Unit sales price $6 $14 Question Content Area a. Prepare a sales budget. Frixion Co.Sales BudgetFor the Month Ending March 31 Product and Area Unit Sales Volume Unit Selling Price Total Sales Product T: Area I fill in the blank ca0b7bf7b025f99_1 $fill in the blank ca0b7bf7b025f99_2 $fill in the blank ca0b7bf7b025f99_3 Area II fill in the blank ca0b7bf7b025f99_4 $fill in the blank ca0b7bf7b025f99_5 fill in the blank ca0b7bf7b025f99_6 Total fill in the blank ca0b7bf7b025f99_7 $fill in the blank ca0b7bf7b025f99_8 Product X: Area I fill in the blank ca0b7bf7b025f99_9 $fill in the blank ca0b7bf7b025f99_10…
1. The company, a wholesaler, budgeted sales for the indicated months June July August Sales on account P1,800,000 P1,920,000 P2,010,000 Cash sales 240.000 250.000 260.000 Total sales P2,010,000 P2,170,000 P2,300,000 All merchandise is marked up to sell at its invoice cost plus 25%. Merchandise inventories at the beginning of each month are at 30% of that month's projected cost of goods sold. The cost of goods sold for the month of June is anticipated to be
Jayson Company has the following projected costs for manufacturing and selling and administrative expenses: Prepare a schedule of cash payments for Jayson for January, February, and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31. (If an input field is not used in the table leave the input field empty; do not enter a zero.) March January February Direct materials purchases $3,200 $3,700 $4,200 Direct labor costs 3,400 3,500 3,600 Depreciation on plant 700 700 700 Utilities for plant 450 450 450 Property taxes on plant 250 250 250 Depreciation on office 200 200 200 Utilities for office 550 550 550 Property taxes on office 180 180 180 Office salaries 6,500 6,500 6,500 All costs are paid in month incurred except: direct materials,…