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

Budgeted income statement and supporting budgets for three months Newport Inc. gathered the following data for use in developing the budgets for the first quarter (June, July, a. Estimated sales at $36 per unit: June 300,000 units July 400,000 units August 500,000 units September 500,000 units b. Estimated finished goods inventories: May 31 16,000 units 5% of next month's sales June 30 July 31 5% of next month's sales 5% of next month's sales c. Work in process inventories are estimated to be insignificant (zero). August 31 d. Estimated direct materials inventories: May 31 35,000 pounds June 30 40,000 pounds July 31 45,000 pounds August 31 50,000 pounds e. Manufacturing costs: Per Unit Direct materials (1.5 Ibs. per unit x $4 per Ib.) $ 6.00 Direct labor (0.4 hr. per unit x $25 per hr.) 10.00 Variable factory overhead ($4 per direct labor hour) 1.60 Fixed factory overhead ($1,200,000 per month allocated using 500,000 units) 2.40 Total per-unit manufacturing costs $20.00 f. Selling…
Cash budgetThe following cash budget is for the third quarter of this year. Solve for the missing numbers on the cash budget, assuming that the accountant has requested a minimum cash balance of $7,000 at the start of each month. All borrowings, repayments, and investments are made in even $1,000 amounts. No borrowings or investments exist at the beginning of July. July August September Total Beginning cash balance $7,400 Cash receipts 16,400 20,200 Total cash available $41,000 $77,800 Cash disbursements Payments on account $7,800 $11,400 Wages expense 10,000 12,400 34,600 Overhead costs 8,000 9,200 26,000 Total disbursements $20,600 $32,600 Cash excess (deficiency) Minimum cash balance (7,000) (7,000) Cash available (needed) $(8,800) $(11,600) Financing Borrowings (repayments) $4,000 $(1,000) Acquire (sell) investments - - Receive…
Forecast Sales Volume and Sales Budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, the following unit sales data were reported for the year: Unit Sales 8" × 10" Frame 12" × 16"Frame East 29,664 14,144 Central 7,272 3,822 West 6,402 2,958 Raphael Frame CompanySales BudgetFor the Year Ending December 31, 20Y6 Product and Area Unit SalesVolume Unit SellingPrice Total Sales 8" × 10" Frame: East 28,800 $20 $576,000 Central 7,200 20 144,000 West 6,600 20 132,000 Total 42,600 $852,000 12" × 16" Frame: East 13,600 $35 $476,000 Central 3,900 35 136,500 West 2,900 35 101,500 Total 20,400 $714,000 Total revenue from sales $1,566,000 For the year ending December 31, 20Y7, unit sales are expected to follow the patterns established during the year ending December 31, 20Y6. The unit selling price for…
Book Hint Print Exer Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts Cash payments $ 521,000 $ 465,600 405,000 478,000 349,600 522,000 Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)
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…
Complete a and b thank you
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…
Question 3
Dd.1