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.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. May (Actual) June (Budget) July (Budget) August (Budget) 6,000 4,100 $ 900,000 2,400 5,000 $360,000 $750,000 $ 615,000 Sales units Sales dollars. All sales are on credit. Collections are as follows: 24% is collected in the month of the sale, and the remaining 76% is collected in the month following the sale. Merchandise purchases cost $110 per unit. For those purchases, 60% is paid in the month of purchase and the other 40% is paid in the month following purchase. The company has a policy to maintain an ending monthly inventory of 22% of the next month's unit sales. The May 31 actual inventory level of 1,320 units is consistent with this policy. Selling and administrative expenses of $114,000 per month are paid in cash. The company's minimum cash balance at month-end is $140,000. Loans are obtained at the end of any month when the preliminary cash balance is below $140,000. Any preliminary cash…
Bodin Company budgets on an annual basis. The following beginning and ending inventory levels (in units) are plannned for the year 20x1. Five units of raw material are required to produce each unit of finished product. Raw material Work in process Finished goods January 1 December 31 36,000 17,000 98,000 51,000 17,000 62,000 Required: 1. If Bodin Company plans to sell 472,000 units during the year, compute the number of units the firm would have to manufacture during the year. 2. If 509,000 finished units were to be manufactured by Bodin Company during the year, determine the amount of raw material to be purchased. 1. Required production in units 2. Raw material purchases in units cBook Pro 6) U G K C V. N
(The following information applies to the questions displayed below.] Shadee Corporation expects to sell 600 sun shades in May and 800 in June. Each shade sells for $180. Shadee's beginning and ending finished goods inventories for May are 75 and 50 shades, respectively. Ending finished goods inventory for June will be 60 shades. Required: 1. Determine Shadee's budgeted total sales for May and June, 2. Determine Shadee's budgeted production in units for May and June. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Determine Shadee's budgeted total sales for May and June Budgeted Total Sales May Juna
None
Shadee Corporation expects to sell 630 sun shades in May and 320 in June. Each shade sells for $162. Shadee's beginning and ending finished goods inventories for May are 60 and 50 shades, respectively. Ending finished goods inventory for June will be 55 shades. Required: 1. Prepare Shadee's sales budget for May and June. 2. Prepare Shadee's production budget for May and June.
i need the answer quickly
Vibrant Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget: Rumble Thunder Estimated inventory (units), June 1 258 70 Desired inventory (units), June 30 296 61 Expected sales volume (units): North Region 3,250 3,650 South Region 5,200 4,500 Unit sales price $95 $185 a. Prepare a sales budget. Vibrant Inc. Sales Budget For the Month Ending June 30 Unit Unit Total Sales Selling Sales Volume Price Product and Area Model Rumble: North Region South Region Total Model Thunder: North Region South Region Total Total revenue from sales b. Prepare a production budget. Vibrant Inc. Production Budget For the Month Ending June 30 Units Units Model Model Rumble Thunder Expected units to be sold Total units required Total units to be produced
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.