Budgeted Income Statement 2016 for Roxana Smith, assignment help

Roxana Sims is the budget director for Walker House, Inc., a multinational  company based in Maryland. Walker House, Inc., organizes and coordinates art shows and auctions throughout the world.  Budgeted and actual costs and expenses for 2015 are compared in the following schedule.

     2015 Amounts

Expense items                             Budget           Actual

Salaries expense, staging             $480,000       $512,800

Salaries expense, executive          380,000          447,200

Travel costs                                   640,000          652,020

Auctioneer services                       540,000          449,820

Space rental costs                         251,000          246,580

Printing costs                                 192,000           182,500

Advertising expense                      169,000            183,280

Insurance, merchandise                   84,800             77,300

Insurance, liability                             64,000              67,100

Home office costs                           209,200            219,880

Shipping costs                                105,000             112,560

Miscellaneous                                  25,000                25,828

Total expenses                          $3,140,000          $3,176,868

Net sales                                  $6,200,000           $6,369,200

For 2016, the following fixed costs have been budgeted: executive salaries, $440,000; advertising expense, $190,000; merchandise insurance, $80,000; and liability insurance, $68,000.  Additional information follows.

a.  Net sales are expected to be $6,400,000 in 2016.

b.  Salary expenses for staging will increase 20 percent over actual figures for 2015.

c.  Travel costs are expected to be 11 percent of net sales.

d.  Auctioneer services will be billed at 9.5 percent of net sales.

e.  Space rental costs will go up 20 percent from 2015 budgeted amounts.

f.  Printing costs are expected to be $190,000 in 2016.

g.  Shipping costs are expected to rise 20 percent over 2015 budgeted amounts.

h.  Miscellaneous expenses for 2016 will be budgeted at $28,000.

i.  Home office costs are budgeted for $230,000 for 2016.

Required: Questions 

a)  Prepare the company’s budgeted income statement for 2016. 

b)  Should the budget director be worried about the trend in the company’s operations? Be specific.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *