Banana Computer Accessories assembles a computer networking device from kits of imported components. You have been asked to develop a quarterly and annual operating budget and pro-forma income statements for 2014. You have obtained the following information: (picture attached)

Required:

a. A sales budget for each quarter and the year. Hint: Use of spreadsheet software strongly recommended for this problem.

b. a production budget for each quarter and the year

c. a purchases budget for each quarter and the year

d. a manufacturing cost budget for each quarter and the year

e. A selling and administrative expense budget for each quarter and the year

f. A cash budget for each quarter and the year

g. A pro-forma contribution income statement for each quarter and the year.

budget and pro-forma Accounts receivable (previous quarters sales). Raw $15,000.00 Finished goods. Accounts payable. Desired inventory balances Raw materials $1000000 Finished goods Desired end-of-quarter balances 200 units. Cash Raw materials as a portion of the following quarter's production $10,000.00 Finished goods as a portion of the following quarters Manufacturing costs 0.15 Standard cost per unit Raw materials Units Unit price Total 1 kit $40.00 $40.00 Direct labor hours at rate 0.8 hour Variable overheadMabor hour... 0.8 hour $10.00 800 Total standard variable cost Fixed cost per quarter Depreciation 10,000.00 Selling and administrative costs Variable cost per unit Fixed costs per quarter $20,000.00 Cash 5.000.00 Total. Interest rate per quarter Portion of sales collected Quarter of sale Subsequent quarter Bad debts Portion of purchases paid Quarter of purchase $115.00 Subsequent quarter. Unit selling price Second Third Fourth Sales forecast 1.500 2.000 3.100 Unit sales