Budgeted Income Statement 2016 for Roxana Smith, assignment help
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.
