Sheffield Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first quarter of 2022, the following data are developed: 1. 2. 3. Sales: 24,500 units; unit selling price: Variable costs per sales dollar: Sales commissions Delivery expense Advertising Fixed costs per quarter: Sales salaries Office salaries Depreciation Insurance Utilities $30 6% 2% 4% $24,800 18,400 6,000 2,700 1,600

Sheffield Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first quarter of 2022, the following data are developed: 1. 2. 3. Sales: 24,500 units; unit selling price: Variable costs per sales dollar: Sales commissions Delivery expense Advertising Fixed costs per quarter: Sales salaries Office salaries Depreciation Insurance Utilities $30 6% 2% 4% $24,800 18,400 6,000 2,700 1,600

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

Please help me with the functions for this ! Thank you! Jay Corporation has decided to prepare contribution income statements for internal planning. Budgeted information for Quarter 1 of 2024: Sales in units 17,000 Sales price per unit $48.00 After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) $29.00 Sales Commissions (per dollar of sales) 9.50% Administrative Salaries (per quarter) $45,000 Rent Expense (per quarter) $27,000 Depreciation Expense (per quarter) $36,000 Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Total Cost Units Quarter 1 $67,000 12,500 Quarter2 $94,000 21,000 Quarter 3 $89,800 13,800 Quarter 4 $92,600 20,000 2023 Quarter 1 $72,500 13,700 Quarter2 $80,000 14,000 Quarter 3 $84,000 14,300 Quarter…
Samcor Limited manufactures tables. The following information was extracted from the budget June 2022: 1. 2. 3. 4. 5. Total production and sales Selling price per table Variable manufacturing costs per table: Direct material Direct labour Overheads Fixed manufacturing overheads Other costs: Fixed marketing and administrative costs Sales commission 2 400 units year R1 200 R288 R192 R96 R216 960 R144 000 5%
The actual selling expenses incurred in March 2020 by Fallon Company are as follows. Variable Expenses Fixed Expenses Sales commissions $14,228 Sales salaries $35,000 Advertising 10,086 Depreciation 7,200 Travel 8,355 Insurance 1,900 Delivery 3,422 (a) Prepare a flexible budget performance report for March, assuming that March sales were $167,100. Variable costs and their percentage relationship to sales are sales commissions 8%, advertising 6%, traveling 5%, and delivery 2%. Fixed selling expenses will consist of sales salaries $35,000, Depreciation on delivery equipment $7,200, and insurance on delivery equipment $1,900. (List variable costs before fixed costs.)
The followings are the budget for next financial year (1 January 2023 - 31 December 2023), indicating the average selling price and variable costs of each product category. The common fixed manufacturing overhead and the fixed non-manufacturing overhead costs are estimated to be $1,250,000 and $2,778,320 respectively. Table 1: Budget Jan - Dec 2023 Sales Quantity (in units) In $ Unit selling price Unit production cost Unit selling & admin variable costs (5% of selling price) In $ Revenue Variable Production Costs Selling & Admin Variable Costs Model 1 8,400 600 250 30 Folding Bike Model 2 7,500 400 180 20 Model 3 3,500 480 200 24 Electric Bike 800 2,000 850 100 Total 20,200 5,040,000 3,000,000 1,680,000 1,600,000 11,320,000 (2,100,000)| (1,350,000)| (700,000)| (680,000)| (4,830,000) (252,000) (150,000) (84,000) (80,000) (566,000) Q1. Based on the above budgeted information, calculate the expected breakeven units for the Model 2 folding bikes.
Integrated Excel: Preparing a Contribution Format Income Statement Using the High-Low Method Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Budgeted information for Quarter 1 of 2024: Sales in units Sales price per unit After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) Sales Commissions (per dollar of sales). Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2023 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Cost $ 67,000 $ 94,000 $ 89,800 $ 92,600 $ 72,500 $80,000 $ 84,000 $ 100,000 17,000 $ 48.00 Units 12,500 21,000 13,800 20,000 13,700 14,000 14,300 22,500 $29.00 9.50€ $ 45,000 $ 27,000 $ 36,000 Required: Use the data to answer the…
shown below are the totals from 2018 period budgets. Revenue badget P 100,000 Materials usage from production budget 15,000 Labor cost budget 20,000 Manufacturing overhead budget 20,000 General and administrative budget 30,000 Capital Expenditure budget 20,000 Work in progress inventories Beginning of 2018 10,000 End of 2018 5,000 Finished goods inventory Beginning of 2018 15,000 End of 2018 10,000 Tax Rate 40% 1. prepared a forecasts income statement for the year.
The actual selling expenses incurred in March 2020 by Fallon Company are as follows. Variable Expenses Fixed Expenses Sales commissions $10,994 Sales salaries $35,400 Advertising 10,304 Depreciation 7,100 Travel 8,470 Insurance 1,300 Delivery 3,498 (a) Prepare a flexible budget performance report for March, assuming that March sales were $169,400. Variable costs and their percentage relationship to sales are sales commissions 6%, advertising 6%, traveling 5%, and delivery 2%. Fixed selling expenses will consist of sales salaries $35,400, Depreciation on delivery equipment $7,100, and insurance on delivery equipment $1,300. (List variable costs before fixed costs.) (b)Prepare a flexible budget performance report, assuming that March sales were $176,700. (List variable costs before fixed costs.)
Prepare a budgeted income statement using the information shown. Sales (units) Sales price per unit Uncollectible expense Direct material per unit Direct labor per unit (hours) Direct labor rate per hour Manufacturing overhead Variable sales and administration expenses per unit Fixed sales and administration expenses 15,000 2$ 40 1%* 2$ 0.5 $ $15,000 $ 2 $20,000 15%** 20 Таxes *of sales **of income before taxes
The actual selling expenses incurred in March 2020 by Fallon Company are as follows. Variable Expenses Fixed Expenses Sales commissions $11,180 Sales salaries $35,500 Advertising 10,530 Depreciation 7,400 Travel 6,920 Insurance 1,100 Delivery 3,580 (a) Prepare a flexible budget performance report for March, assuming that March sales were $173,000. Variable costs and their percentage relationship to sales are sales commissions 6%, advertising 6%, traveling 4%, and delivery 2%. Fixed selling expenses will consist of sales salaries $35,500, Depreciation on delivery equipment $7,400, and insurance on delivery equipment $1,100. (List variable costs before fixed costs.) FALLON COMPANYSelling Expense Flexible Budget ReportFor the Month Ended March 31, 2020 Difference Budget Actual FavorableUnfavorableNeither Favorablenor Unfavorable Select an opening flexible budget report item…
The actual selling expenses incurred in March 2020 by Fallon Company are as follows. Variable Expenses Fixed Expenses Sales commissions $11,180 Sales salaries $35,500 Advertising 10,530 Depreciation 7,400 Travel 6,920 Insurance 1,100 Delivery 3,580 (b) Prepare a flexible budget performance report, assuming that March sales were $180,500. (List variable costs before fixed costs.) FALLON COMPANYSelling Expense Flexible Budget ReportFor the Month Ended March 31, 2020 Difference Budget Actual FavorableUnfavorableNeither Favorablenor Unfavorable Select an opening flexible budget report item AdvertisingDepreciationDeliveryFixed ExpensesInsuranceSalesSales CommissionsSales SalariesTotal ExpensesTotal Fixed ExpensesTotal Variable ExpensesTravelVariable Expenses $Enter a dollar amount $Enter a dollar amount Select an opening name for…
For 2023, the estimated (budgeted) cost and revenue information of Şam Company is provided below: Sales units = 200000 units, Selling price per unit = 15 dollars, Number of units produced = 220.000 units, DM = $3 per unit, DL = $1 per unit, Var MOH = $2 per unit, Fixed MOH = $440.000, Var Selling and Adm Exp = $4 per unit, Fixed S&A Exp = $60.000. A.) Prepare CVP Income Statement. B.) Calculate BEP in Units and BEP in dollars. C.) What is the margin of safety ratio of Şam Company? D.)Calculate the degree of operating leverage and explain what happens to NI if sales increase 10% and decrease 5%.
The actual selling expenses incurred in March 2022 by Wildhorse Company are as follows. Fixed Expenses Sales salaries $35,300 Depreciation 7,000 Insurance 1,800 Variable Expenses Sales commissions $12,741 Advertising 10,258 6,772 3,446 Travel Delivery (a) Prepare a flexible budget performance report for March, assuming that March sales were $169,300. Variable costs and their percentage relationship to sales are sales commissions 7%, advertising 6%, traveling 4%, and delivery 2%, Fixed selling expenses will consist of sales salaries $35,300, Depreciation on delivery equipment $7,000, and insurance on delivery equipment $1,800, (List variable costs before fixed costs) preto, a delivery du hent 57000 and nuance on de (b) Prepare a flexible budget performance report, assuming that March sales were $176,800 (Lit variable costs before foxed cosE Budget WILDHORSE COMPANY Selling Expense Flexible Budget Report For the Month Ended March 31, 2022 Actual Difference Favorable Unfavorabl Neither…