Question

Sheffield & Crane Fabricators produces commemorative bricks that organizations use for fundraising projects. Matthew Sheffield, the...

Sheffield & Crane Fabricators produces commemorative bricks that organizations use for fundraising projects. Matthew Sheffield, the company's vice president of marketing, has prepared the following sales forecast for the first six months of the coming year. The company plans to sell the bricks for $22 each.

January

February

March

April

May

June

25,000

28,000

32,000

34,000

26,000

35,000


Sheffield & Hill Fabricators' marketing department has identified the following monthly expenses that will be needed to support the company's sales and administrative functions.

Depreciation

$14,000

Sales staff salaries

$21,000

Advertising

$2,100

Executive salaries

$37,000

Miscellaneous

$1,500


In addition to these monthly expenses, the company will pay a commission to its salespeople equal to 8% of the sales revenue from each brick sold. The company expects bad debt expense to be 2% of sales revenue.

Prepare Sheffield & Hill's selling and administrative expense budget for the first quarter of the coming year.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Swifty & Hill Fabricators produces commemorative bricks that organizations use for fundraising projects. Aaron Swifty, the...
Swifty & Hill Fabricators produces commemorative bricks that organizations use for fundraising projects. Aaron Swifty, the company's vice president of marketing, has prepared the following sales forecast for the first six months of the coming year. The company plans to sell the bricks for $9 each. January February March April May June 11,400   22,230   19,950 29,000 23,000 20,000 January February March April May June 11,400   22,230   Swifty & Hill Fabricators' marketing department has identified the following monthly expenses that will...
Marcy Jones, Bonita & Hill Fabricators' purchasing manager, has just received the company's production budget for...
Marcy Jones, Bonita & Hill Fabricators' purchasing manager, has just received the company's production budget for the first quarter. January February March Quarter Budgeted Production 19,064 34,069 30,189 83,322 Budgeted sales of April is 25,810 and its beginning inventory is 4,646. May month budgeted sales is 20,470. Company policy requires an ending finished goods inventory each month that will meet 18% of the following month’s sales volume. Each brick requires 4.00 pounds of clay, and Marcy expects to pay $0.36...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 35,000 37,000 28,000 33,000 The company’s variable selling and administrative expense per unit is $3.40. Fixed selling and administrative expenses include advertising expenses of $12,000 per quarter, executive salaries of $53,000 per quarter, and depreciation of $34,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in...
McKenzie Company has decided to use a contribution format income statement for internal planning purposes. The...
McKenzie Company has decided to use a contribution format income statement for internal planning purposes. The company has analyzed its expenses and has developed the following cost formulas:   Cost Cost Formula   Cost of goods sold    $31 per unit sold   Advertising expense    $187,000 per quarter   Sales commissions    7% of sales   Administrative salaries    $97,000 per quarter   Shipping expense      ?   Depreciation expense    $67,000 per quarter      Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units...
milden company has an exclusive franchise to purchase a product from the manufacturer and distribut it...
milden company has an exclusive franchise to purchase a product from the manufacturer and distribut it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas: cost                                                   cost formula cost of good sold                             $29 per unit sold advertising expense                        $179,ooo per quarter sales commissions                          8% shipping expenses                           ? administrative...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,500 March 13,000 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each...
(SCROLL LEFT AND RIGHT TO SEE PROBLEM) Marcy Jones, Marigold & Hill Fabricators' purchasing manager, has...
(SCROLL LEFT AND RIGHT TO SEE PROBLEM) Marcy Jones, Marigold & Hill Fabricators' purchasing manager, has just received the company's production budget for the first quarter. January February March Quarter Budgeted Production 16,925   31,455   27,913 76,293 Budgeted sales of April is 23,780 and its beginning inventory is 3,805. May month budgeted sales is 18,860. Company policy requires an ending finished goods inventory each month that will meet 16% of the following month’s sales volume. Each brick requires 4.00 pounds of...
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the...
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the first quarter of 2019. Include a quarterly total column on the right side. Each budget/requirement should be in a separate tab within one spreadsheet. All pages should be in portrait format using the same font. Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures. (Hint) Excel provides functions for...
Prepare, in good form, a Sales Budget, and Production Budget. Please show work. I am just...
Prepare, in good form, a Sales Budget, and Production Budget. Please show work. I am just trying to make sure I have the correct answers. Balance Sheet Bottas Manufacturing, Inc. Balance Sheet December 31, 2018 ASSETS Cash $           25,711.00 Marketable securities                20,000.00 Accounts receivable             565,844.43 Inventories:    Finished goods $           86,385.60    Work in process                          0.00    Direct materials                  7,193.94                93,579.54 Total Current Assets             705,134.97 Property, plant and equipment $         844,200.00    Less: Accumulated...