The company?s revenues in the last two quarters have dropped from $4.2 million to $3.9 and $3.4 million respectively. With the current trend they estimate that within the next two quarters their cost of operations will be greater than new revenue. With an operating budget of $2,500.000 per quarter divided as: Cost of raw materials at $1,800,000 Labor $300,000 Operating and maintenance expenses at $400,000 and Plant and facilities had been depreciated to zero value many years before. The company is privately held by the Xavier family and may need to seek financing to support manufacturing facility changes to make the move to manufacturing chewing gum. At present the company employs 24 personnel comprised of both manufacturing and administrative employees. Create a budget and income statement for Xavier Candy Company for the current quarter.

Assignment Unit 6 [MT299:] Associates Capstone in Management Xavier Candies, Inc. Xavier Candy has been experiencing a loss in sales for the last two quarters and their customers have indicated to them that they are buying more products from outside the country through various sources at significant cost savings to them. Even with deep discount offerings/rebates/bundled packaging and other promotional ideas, Xavier has been unable to keep their larger chain accounts. The company's revenues in the last two quarters have dropped from $4.2 million to $3.9 and $3.4 million respectively. With the current trend they estimate that within the next two quarters their cost of operations will be greater than new revenue. With an operating budget of $2,500.000 per quarter divided as: Cost of raw materials at $1,800,000 Labor $300,000 Operating and maintenance expenses at $400,000 and Plant and facilities had been depreciated to zero value many years before. The company is privately held by the Xavier family and may need to seek financing to support manufacturing facility changes to make the move to manufacturing chewing gum. At present the company employs 24 personnel comprised of both manufacturing and administrative employees. Create a budget and income statement for Xavier Candy Company for the current quarter. Refer to the scenario and your research from Unit 4 for additional information. Link for accounting templates: http://www.spreadsheet123.com/ExcelTemplates/break-even-analysis-for-investmentproperty.html Submit these two documents with a Title page in APA format to the Dropbox by the end of this Unit. Include an additional reference page if needed. 1