5) Prepare a flexible budget for the SGA expenses at the sales levels provided:Sales commissions 9% of salesAd expense 12% of salesMiscellaneous expense $6000 per month plus 2% of salesOffice expense $20,000 per monthCustomer support expense $15,000 per month plus 5% of salesR&D expense $30,000 per month$400,000$600,000$800,000

The objective of this question is to prepare a flexible budget for the Selling, General and…

Answered: 5) Prepare a flexible budget for the…

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

Flexible Budget for Selling and Administrative Expenses for a Service Company
Preparing a Selling and Administrative Expenses Budget Fazel Company makes and sells paper products. In the coming year, Fazel expects total sales of $20,000,000. There is a 3% commission on sales. In addition, fixed expenses of the sales and administrative offices include the following: Salaries $ 960,000 Utilities 365,000 Office space 230,000 Advertising 1,200,000 Required: Prepare a selling and administrative expenses budget for Fazel Company for the coming year. Fazel Company Selling and Administrative Expenses Budget For the Coming Year Variable selling expenses $fill in the blank 1 Fixed expenses: Salaries $fill in the blank 2 Utilities fill in the blank 3 Office space fill in the blank 4 Advertising fill in the blank 5 Total fixed expenses fill in the blank 6 Total selling and administrative expenses $fill in the blank 7
Prepare a monthly flexible selling expense budget for Podism Company for sales volumes of $270,000, $350,000, and $480,000, based on the following data: Sales commissions 7% of sales Sales manager's salary $62,000 per month Advertising expense $70,000 per month Shipping expense 2% of sales Miscellaneous selling expense $2,500 per month plus 1/2% of sales Podism Company Monthly Selling Expense Budget Sales volume $270,000 $350,000 $480,000 Variable expense: Sales commissions х X Shipping expense X Miscellaneous selling expense Total variable expense Fixed expense: Sales manager's salary x $ Advertising expense X Miscellaneous selling expense Total fixed expense %$4 Total selling expense $ X
Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 15% of sales Advertising expense 18% of sales Miscellaneous administrative expense $9,000 per month plus 12% of sales Office salaries expense $29,000 per month Customer support expenses $12,000 per month plus 20% of sales Research and development expense $32,000 per month Prepare a flexible selling and administrative expenses budget for October for sales volumes of $400,000, $500,000, and $600,000. (Use Exhibit 5 as a model.) Digital Solutions Inc. Flexible Selling and Administrative Expenses Budget For the Month Ending October 31 Total sales $400,000 $500,000 $600,000 Variable cost: $ $ $ Total variable cost $ $ $ Fixed cost: $ $ $ Total fixed cost $ $ $ Total selling and administrative…
Flexible Budget for Selling and Administrative Expenses for a Service Company Morningside Technologies Inc. uses flexible budgets that are based on the following data: Sales commissions 6% of sales Advertising expense 20% of sales Miscellaneous administrative expense $1,700 per month plus 1% of sales Office salaries expense $16,000 per month Customer support expenses $2,350 plus 2% of sales Research and development expense 3,150 per month Prepare a flexible selling and administrative expenses budget for April for sales volumes of $105,000, $130,000, and $160,000. Enter all amounts as positive numbers. Morningside Technologies Inc.Flexible Selling and Administrative Expenses BudgetFor the Month Ending April 30 Total sales $105,000 $130,000 $160,000 Variable cost: Sales commissions $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 Advertising expense fill in the blank 4 fill in the blank 5 fill in the blank 6 Miscellaneous administrative…
Weller Company's budgeted unit sales for next year are provided below: Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 15,000 *16,000 14,000. 13,000 The company's variable selling and administrative expense per unit is $2.50. Fixed selling and administrative expenses include advertising expenses of $8,000 per quarter, executive salaries of $35,000 per quarter, and depreciation of $20,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in the third quarter. Finally, property taxes of $8,000 will be paid in the second quarter. Required: Prepare the company's selling and administrative expense budget for next year. Note: Round "Per Unit" answers to 2 decimal places
Budgeted Selling and Administrative Expenses Salary Expense Sales Commissions 5% of Sales Insurance Expense Rent Depreciation on equipment Utilities Total Operating Expenses Schedule of Cash Payments for Selling and Administrative Expenses Salary Expense 100% of Prior Month Sales Commissions Insurance Expense October November December Multiple Choice 30,000 30,500 15,000 15,500 12,000 12,000 14,400 14,400 16,500 16,500 2,100 2,300 90,000 91, 200 ? 15,100 12,000 ? 2,200 ? 30,500 ? 12,000 ? ? ? Rent 100% of Prior Months Utilities Expense Total Payments for Selling and Administrative Expenses The amount of cash paid for Selling and Administrative expenses during the month of November is: 31,000 15,300 12,000 14,400 16,500 2,500 91,700 ? ? 12,000 14,400 ?
Print Item The Operating Budgets: Marketing and Administrative Expense Budgets The marketing expense budget can be prepared in much the same way as the overhead budget. That is, variable expenses and fixed expenses are budgeted and then totaled. Suppose that a company has variable marketing expense consisting of a sales commission equal to 5% of sales revenue. Sales revenue for the first three months of the quarter equals $560,000, $580,000, and $600,000. Fixed marketing expense consists of the following monthly costs: depreciation $3,500, salaries $12,000, and advertising $5,000. Prepare a marketing expense budget for the first quarter, by month and in total. Budgeted sales revenue x Sales commission rate Budgeted variable marketing expense $ Fixed marketing expense: Depreciation Salaries January 560,000 5 X 28,000 3,500 12,000 5,000 February 580,000 20,500 48,500 ✔ 5.2 X 29,000 3,500 12,000 5,000 20,500 49,500 $ $ March 600,000 5.3 X 30,000 3,500 12,000 5,000 20,500 50,500 Total…
Flexible Budget for Selling and Administrative Expenses Fuller Enterprises uses flexible budgets that are based on the following data: Sales commissions 8% of sales Advertising expense 20% of sales Customer support expense $2,150 plus 4% of sales Office salaries expense $14,000 per month Miscellaneous administrative expense $2,600 plus 3% of sales Research and development expense $1,500 per month Prepare a flexible selling and administrative expenses budget for July for sales volumes of $95,000, $120,000, and $145,000. (Use Exhibit 5 as a model.) Enter all amounts as positive numbers. FULLER ENTERPRISES Flexible Selling and Administrative Expenses Budget For the Month Ending July 31 Total sales $95,000 $120,000 $145,000 Variable cost: $fill in the blank 2 $fill in the blank 3 $fill in the blank 4 fill in the blank 6 fill in the blank 7 fill in the blank 8 fill in the blank 10 fill in the blank 11 fill in the blank 12 fill in the blank…
Flexible budget for selling and administrative expenses for a service company Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions Advertising expense Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense 14% of sales 18% of sales $5,500 per month plus 12% of sales $30,000 per month $12,000 per month plus 20% of sales $32,000 per month Prepare a flexible selling and administrative expenses budget for October for sales volumes of $400,000, $500,000, and $600,000. (Use Exhibit 4 as a model.) Digital Solutions Inc. Flexible Selling and Administrative Expenses Budget Line Item Description For the Month Ending October 31 Amount $400,000 Amount Amount $500,000 $600,000 Total sales Variable cost: Sales commissions 56,000 70,000 Advertising expense 72,000 90,000 Miscellaneous administrative expense 48,000 60,000 Customer support expenses 80,000 100,000 Total variable cost 256,000…
Weller Company's budgeted unit sales for next year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 28,000 29,000 21,000 Budgeted unit sales The company's variable selling and administrative expense per unit is $2.70. Fixed selling and administrative expenses include advertising expenses of $13,000 per quarter, executive salaries of $47,000 per quarter, and depreciation of $27,000 per quarter. In addition, the company will make insurance payments of $4,000 in the first quarter and $4,000 in the third quarter. Finally, property taxes of $6,800 will be paid in the second quarter. Required: Prepare the company's selling and administrative expense budget for next year. Note: Round "Per Unit" answers to 2 decimal places. Variable selling and administrative expense per unit Variable selling and administrative expense Fixed selling and administrative expenses: 4th Quarter 26,000 Total fixed selling and administrative expenses Total selling and administrative expenses Weller Company…

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS