Budgeted Income Statement 2016 for Roxana Smith, assignment help

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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.