2 Year Budget

Question

The following table summarizes historical income statement performance for Company XYZ. Utilizing the historical information provided and the assumptions outlined below, prepare a budget for the upcoming fiscal year and a projection for the following year. In other words, you should have budgets for two years.

Company XYZ Historical Income Statement  
Prior Year 1 ActualPrior Year 2 Actual
     Sales$2,000,000$2,135,000
175,000  166,000  
2,175,000  2,301,000  
     Salaries750,000772,500
187,500193,125
37,50038,438
55,00056,650
125,000125,000
200,000210,000
275,000  280,500  
1,630,000  1,676,213  
545,000  624,788  
185,000  190,000  
360,000  434,788  
108,000  130,436  
$252,000  $304,351  
25.1>#/td###27.2>#/td###
11.6>#/td###13.2>#/td###

Additional Historical Information

  • Total number of FTEs (full-time equivalent) employees was 14.4
  • The Board of Directors approves salary increases each year
  • Fringe benefits have not increased over the past few years; however, information suggests that this is not a trend that will continue
  • Total net fixed assets for the organization were $2,500,000 in prior year 1 and $2,600,000 in prior year 2

Assumptions for Budget Year 1

  • Management has requested an increase in FTEs of 2.5
  • Salary increases will be given at 2.5>#/li###
  • Fringe benefits as a % of total salaries are anticipated to increase 2>#/li###
  • Inflation for all non-salary expenses is projected to be 2.5>#/li###
  • Capital purchases for the budget year are projected to be $300,000
  • Sales are projected to increase 2.5>#/li###
  • Other operating revenue is projected to increase $25,000

Assumptions for Budget Year 2

  • Management has requested an increase in FTEs of 1.5
  • Salary increases will be given at 1.5>#/li###
  • Fringe benefits as a % of total salaries are anticipated to increase 1>#/li###
  • Inflation for all non-salary expenses is projected to be 1.5>#/li###
  • Capital purchases for the budget year are projected to be $150,000
  • Sales are projected to increase 3>#/li###
  • Other operating revenue is projected to increase $25,000  

 

***USE ATTACHMENT TO COMPLETE BUDGET***

Details
Attachments
Purchase An Answer Below

Have a similar question?