EX 4-4 Budgeted income statement and supporting budgets for three months Bellaire inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: Administrative expenses (all fixed costs)... $400,000Prepare a sales budget for March.using 40,000 units)Fixed selling expenses.....Variable selling expenses..Prepare the following budgets using one column for each month and a total column for the first quarter,$80selling expenses:$4 per unit$150,000nstructionsas shown for the sales budget:Bellaire Inc.Sales BudgetFor the First Quarter Ending March 31JanuaryFebruaryMarchFirst QuarterEstimated units sold25,00030,00045,000100,000rch isPrepare a production budget for March.Prepare a direct materials purchases budget for March.Prepare a direct labor cost budget for March.borPrepare a factory overhead cost budget for March.Prepare a cost of goods sold budget for March.Prepare a selling and administrative expenses budget for March.98 Estimated sales at $125 per unit:Estimated finished goods inventories:Work in process inventories are estimated to be insignificant (zero).Estimated direct materials inventories:4 BudgetinghapterJanuary...February.25,000 unitsMarch...30,000 unitsApril45,000 units..50,000 unitsb.January 1....January 31..February 28..March 31...2,000 units.. 10% of next month's sales... 10% of next month's sales.. 10% of next month's salesC.d.January 1....January 31.1,000 lbs..... 1,500 lbs.February 28.March 31..Manufacturing costs: Per Unit2,000 lbs..... 2,500 lbs.e.Direct materials (0.8 lb. per unit x $15 per Ib.)Direct labor (2.5 hrs. per unit x $24 per hr.)$1260Variable factory overhead ($1.20 per direct labor hour)Fixed factory overhead ($200,000 per month, allocated using 40,000 units)Total per-unit manufacturing costs3.5.$80f. Selling expenses:Variable selling expenses...$4 per unit$150,000Administrative expenses (all fixed costs).... $400,000Fixed selling expenses....InstructionsPrepare the following budgets using one column for each month and a total column for the first quartas shown for the sales budget:Bellaire Inc.Sales BudgetFor the First Quarter Ending March 31JanuaryFebruaryMarchFirst Quarterated units sold25,00030,00045,000100,000sales budget for March.

Hi student Since there are multiple subparts, we will answer only first three subparts. If you want…

using 40,000 units) selling expenses: Variable selling expenses..... Fixed selling expenses..... $80 Administrative expenses (all fixed costs)... $400,000 $4 per unit $150,000 nstructions Prepare the following budgets using one column for each month and a total column for the first quarter, as shown for the sales budget: Bellaire Inc. Sales Budget For the First Quarter Ending March 31 January 25,000 February March First Quarter Estimated units sold 30,000 45,000 100,000 rch is Prepare a sales budget for March. Prepare a production budget for March. Prepare a direct materials purchases budget for March.

using 40,000 units) selling expenses: Variable selling expenses..... Fixed selling expenses..... $80 Administrative expenses (all fixed costs)... $400,000 $4 per unit $150,000 nstructions Prepare the following budgets using one column for each month and a total column for the first quarter, as shown for the sales budget: Bellaire Inc. Sales Budget For the First Quarter Ending March 31 January 25,000 February March First Quarter Estimated units sold 30,000 45,000 100,000 rch is Prepare a sales budget for March. Prepare a production budget for March. Prepare a direct materials purchases budget for March.

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

V Identify the appropriate special journal to be used for every source document listed below: • Official Receipt issued by the company Answer: • Charge Invoice issued by the company Answer: • Charge Invoice from a supplier Answer: • Official receipt from a supplier as proof of payment of асcount Answer:
Question 6 Flexible Budgeting At the beginning of the period, the Assembly Department budgeted direct labor of $190,900 and property tax of $36,000 for 8,300 hours of production. The department actually completed 10,100 hours of production. Determine the budget for the department, assuming that it uses flexible budgeting.
give detail calculations
7-35 Cash Budget Consider the budgeted income statement for Carlson Company for June 20X4 in Exhibit 7-13. The cash balance, May 31, 20X4, is $15,000. Sales proceeds are colected as follows: 80% the month of sale, 10% the second month, and 10% the third month. Accounts receivable are $44,000 on May 31, 20X4, consisting of $20,000 from April sales and $24,000 from May sales. Accounts payable on May 31, 20X4, are $145,000. Carlson Company pays 25% of purchases during the month of purchase and the remainder during the following month. All operating expenses requiring cash are paid during the month of recognition, except that insur- ance and property taxes are paid annually in December for the forthcoming year. Prepare a cash budget for June. Confine your analysis to the given data. Ignore income taxes. Exhibit 7-13 Sales $290 Carlson Company Budgeted Income Statement for the Month Ended June 30, 20X4 Inventory, May 31 Purchases Available for sale Inventory, June 30 Cost of goods sold…
The management of Zigby Manufacturing prepared the following balance sheet for March 31. Assets ZIGBY MANUFACTURING Balance Sheet March 31 Liabilities and Equity Cash Accounts receivable Raw materials inventory Finished goods inventory Equipment Less: Accumulated depreciation $ 1,680,000 420,000 Total assets $ 112,000 964,320 275,800 Liabilities Accounts payable Loan payable 911,512 Long-term note payable Equity 1,260,000 Common stock Retained earnings $ 3,523,632 Total liabilities and equity To prepare a master budget for April, May, and June, management gathers the following information. $ 562,800 12,000 1,400,000 938,000 610,832 $ 1,974,800 1,548,832 $ 3,523,632 a. Sales for March total 57,400 units. Budgeted sales in units follow: April, 57,400; May, 54,600; June, 56,000; and July, 57,400. The product's selling price is $24.00 per unit and its total product cost is $19.85 per unit. b. Raw materials inventory consists solely of direct materials that cost $20 per pound. Company…
Required: Prepare Shadee's budgeted income statement for the months of May and June. Note: Do not round your intermediate calculations. Round your answers to 2 decimal places. Budgeted Gross Margin SHADEE CORPORATION Budgeted Income Statement Budgeted Net Operating Income May June
Symphony Electronics produces wireless speakers for outdoor use on patios, decks, etc. Their most popular model is the All Weather and requires four separate XL12 components per unit. The company is now planning raw material needs for the second quarter. Sales of the All Weather are the highest in the second quarter of each year as customers prepare for the summer season. The company has the following inventory requirements: a. The finished goods inventory on hand at the end of each month must be equal to 16,400 units plus 10% of the next month's sales. The finished goods inventory on March 31 is budgeted to be 28,700 units. b. The raw materials inventory on hand at the end of each month must be equal to 20% of the following month's production needs for raw materials. The raw materials inventory on March 31 for XL 12 is budgeted to be 98,800 components. c. The company maintains no work in process inventories. A sales budget for the All Weather speaker is as follows: April May June July…
Question 8.1 Sun Company manufacturers beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 30,000 August 70,000 September 50,000 October 20,000 November 10,000 December 10,000 The selling price of the umbrellas is $12 each. All sales are on account. Based on past experience, sales are expected to be collected in the following pattern: 30% In the month of sale 65% In the month following sale 5% uncollectable Sales for June were $300,000 The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June. Each beach umbrella…
Accounting Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 256,167 262,962 282,872 Credit Purchases 97,465 111,565 137,292 Wages, Taxes, and Expenses 26,506 31,621 33,707 Interest 7,239 7,773 8,091 Equipment Purchases 54,832 61,271 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the following month. Credit purchases will be paid in the month following the purchase. In June, credit sales were $138,282, and credit purchases were $102,770 July’s beginning cash is $184,797 If TAP maintains a policy of always keeping a minimum cash balance of $75,000 as a buffer against uncertainty and forecasting errors, what is the cash surplus/deficit at the end of the quarter (i.e., end of…
Subject: acounting
Question 3
Dd.1