If a problem requires calculations generated from an Excel workbook, copy and paste the answer from Excel as a picture in the Word doc. You’ll need to keep a copy for your own reference.

Using the following information you are to prepare a comprehensive budget for Systems, Inc. The Company assembles a specialized device used in airports to detect certain types of explosives to .

Arrangements have been made for the component parts (bundled in packets, one per unit) to be produced in Indonesia, shipped to Boise, then assembled and sold by River City Micro to the end users.

You have developed the prototypes, established a market, and now you are putting together a budget for the first three months of 2017. The Company will and distribution on January 2, 2017. The purpose of this comprehensive budget is to formalize your expected income, cash flow and balance sheets.

From the following information you are to prepare the following schedules/statements for the months ending January 31, 2017, February 28, 2017and March 31, 2017:

1) Projected units of production
2) Projected raw material requirements
3) Projected raw material purchases in dollars
4) Projected cost of ) Pro-forma income statement
6) Pro-forma cash flow statem
8) Capital lease amortization schedule
9) Depreciation schedule

You should utilize the following assumptions in making your calculations:

a. Projected sales in units are as follows: January = 500, February = 600, March = 600, April and following months = 800. At the start of each month the management plans to have 30 days, (1

month) of direct materials on hand. Each pa