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

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…
How do I prepare the selling and administrative expense budget for the quarter ended March 31, 20X1?
Schedule of Cash Payments Select Physical Therapy Inc. is planning its cash payments for operations for the third quarter (July-September), 2017. The Accrued Expenses Payable balance on July 1 is $31,700. The budgeted expenses for the next three months are as follows: July August September Salaries $72,900 $88,800 $98,300 Utilities 6,000 6,700 7,900 Other operating expenses 55,400 60,400 66,500 Total $134,300 $155,900 $172,700 Other operating expenses include $4,000 of monthly depreciation expense and $900 of monthly insurance expense that was prepaid for the year on March 1 of the current year. Of the remaining expenses, 75% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on July 1 relates to the expenses incurred in June. Prepare a schedule of cash payments for operations for July, August, and September. Select Physical Therapy Inc. Schedule of Cash Payments for Operations For the Three Months…
Budgeted Income Statement and Balance Sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Regina Soap Co.: Cash $105,900 Accounts Receivable 204,400 Finished Goods 42,900 Work in Process 28,600 Materials 47,000 Prepaid Expenses 3,500 Plant and Equipment 526,300 Accumulated Depreciation—Plant and Equipment $226,300 Accounts Payable 149,100 Common Stock, $10 par 350,000 Retained Earnings 233,200 $958,600 $958,600 Factory output and sales for 20Y9 are expected to total 26,000 units of product, which are to be sold at $90 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating…
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
Budgeted Income Statement and Balance Sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Regina Soap Co.: Cash $102,200 Accounts Receivable 173,700 Finished Goods 36,500 Work in Process 24,300 Materials 40,000 Prepaid Expenses 3,000 Plant and Equipment 470,100 Accumulated Depreciation—Plant and Equipment $202,100 Accounts Payable 116,100 Common Stock, $10 par 350,000 Retained Earnings 181,600 $849,800 $849,800 Factory output and sales for 20Y9 are expected to total 23,000 units of product, which are to be sold at $90 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating…
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…
Perez Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Perez expects sales in January year 1 to total $210,000 and to increase 20 percent per month in February and March. All sales are on account. Perez expects to collect 68 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 8 percent in the second month following the sale. Required Prepare a sales budget for the first quarter of year 1. Determine the amount of sales revenue Perez will report on the year 1 first quarterly pro forma income statement. Prepare a cash receipts schedule for the first quarter of year 1. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Prepare a sales budget for the first quarter of year 1.
Plz solve!!
Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $25,600. The budgeted expenses for the next three months are as follows: January February March Salaries $58,900 $71,700 $79,400 Utilities 4,900 5,400 6,400 Other operating expenses 44,800 48,800 53,800 Total $108,600 $125,900 $139,600 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December.
Schedule of cash payments for a service company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $26,200. The budgeted expenses for the next three months are as follows: January February March Salaries $60,300 $73,400 $81,200 Utilities 5,000 5,500 6,600 Other operating expenses 46,400 50,600 $5,700 Total $111,700 $129,500 $143,500 Other operating expenses include $3,300 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on May 1 of the previous year of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for…
Budgeted Income Statement and Balance Sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Regina Soap Co.: Cash $117,800 Accounts Receivable 208,500 Finished Goods 43,800 Work in Process 29,200 Materials 48,000 Prepaid Expenses 3,500 Plant and Equipment 548,900 Accumulated Depreciation—Plant and Equipment $236,000 Accounts Payable 200,300 Common Stock, $10 par 250,000 Retained Earnings 313,400 $999,700 $999,700 Factory output and sales for 20Y9 are expected to total 27,000 units of product, which are to be sold at $100 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating…