i need e,f,g

LOS, 723-0. Eling Master det for a Maturing Organization Challenge Bleo Make Computer Access compending or imported comes. You have been led to develpa qelyadong hot and income mes for rent year. You have to the following inden B.00 125.000 Begoyance Ca Accounts receivable previous quarter's Raw mat Finished goods Accounts payable mat) Domowed unde Desired and clear to balances Faw materials Finished goods Deared end-of-quarterbacances Cash Raw materias portion of the following Qur's production Fred goods as a portion of the following quartersales Marutadhuing couts Standard cost per unit Raw materials Direct bor hostale Variable overheadtabor hour Total standard vanatos 520000 U 0.30 h 630 hou 130.00 5500 175.00 15.00 2.50 continued from previous page Fixed cost per quarter Cash Depreciation Total $110,000 15.000 5125.000 $8.00 $150,000 7.500 $157,500 0.015 0.70 Selling and administrative costs Variable cost per unit Fixed costs por quarter Cash Depreciation Total Interest rate per quarter Portion of sales collected Quarter of sale Subsequent quarter Bad debts. Portion of purchases paid Quarter of purchase Subsequent quarter Unit selling price Sales forecast Quarter Unit sales 0.29 0.01 0.60 0.40 $225.00 First Second 4,600 Third 4,500 Fourth 4.800 4.400 Additional information All cash payments except purchases are made quarterly as incurred. All borrowings occur at the start of a quarter All repayments on borrowings occur at the end of a quarter. At the time the principal is repaid, interest is paid on the portion of principal that is repaid. Borrowings and repayments may be made in any amount. e. A selling and administrative expense budget for each quarter and the year. f. A cash budget for each quarter and the year. 8. A pro forma contribution income statement for each quarter and the year. Required a. A sales budget for each quarter and the year. (Hint: Use of spreadsheet software strongly recom mended 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. 8. A pro forma contribution income statement for each quarter and the year. LO3, 4 P22-42. Developing a Master Budget for a Manufacturing Organization: Challenge Problem Electric Monkey 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 next year. You have obtained the following information: $ 75,000 $245,000 950 kits 1,500 kits $125,000 $ 30,000 1,000 kits 1,600 kits Beginning-of-year balances Cash.... Accounts receivable (previous quarter's sales). Raw materials.. Finished goods Accounts payable (materials) Borrowed funds. Desired end-of-year inventory balances Raw materials Finished goods Desired end-of-quarter balances Cash... Raw materials as a portion of the following quarter's production Finished goods as a portion of the following quarter's sales.. Manufacturing costs Standard cost per unit Raw materials Direct labor hours at rate. Variable overhead labor hour Total standard variable cost $ 30,000 0.20 0.30 Units 1 kit 0.50 hour 0.50 hour Unit price $75.00 $30.00 $ 5.00 Total $75.00 15.00 2.50 $92.50