this question is originally too big, I already have the first 6 budgets but I need the last ones

Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below.

January	10,000
February	10,500
March	13,000
April	16,000
May	18,500

The following data pertain to production policies and manufacturing specifications followed by Ponderosa:

1. Finished goods inventory on January 1 is 900 units. The desired ending inventory for each month is 20 percent of the next months sales.
2. The data on materials used are as follows:

   Direct Material	Per-Unit Usage	Unit Cost
   Part #K298	2	$4
   Part #C30	3	7

   Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 30 percent of the next months production needs. This is exactly the amount of material on hand on January 1.

3. The direct labor used per unit of output is one and one-half hours. The average direct labor cost per hour is $20.
4. Overhead each month is estimated using a flexible budget formula. (Activity is measured in direct labor hours.)

   	Fixed Cost Component	Variable Cost Component
   Supplies	$	$1.00
   Power		0.20
   Maintenance	12,600	1.10
   Supervision	14,000
   Depreciation	45,000
   Taxes	4,300
   Other	86,000	1.60

5. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Activity is measured in units sold.)

   	Fixed Costs	Variable Costs
   Salaries	$ 88,600
   Commissions		$1.40
   Depreciation	25,000
   Shipping		3.60
   Other	137,000	1.60

6. The unit selling price of the wiring harness assembly is $110.
7. In February, the company plans to purchase land for future expansion. The land costs $68,000.
8. All sales and purchases are for cash. The cash balance on January 1 equals $62,800. The firm wants to have an ending cash balance of at least $25,000. If a cash shortage develops, sufficient cash is borrowed to cover the shortage and provide the desired ending balance. Any cash borrowed must be borrowed in $1,000 increments and is repaid the following month, as is the interest due. The interest rate is 12 percent per annum.

Required:

. Selling and administrative expense budget. Round your answers to the nearest cent, if required.

	January	February	March	Total
Planned sales	fill in the blank 2f7f63f8ef84fc9_1	fill in the blank 2f7f63f8ef84fc9_2	fill in the blank 2f7f63f8ef84fc9_3	fill in the blank 2f7f63f8ef84fc9_4
Variable selling & administrative expense per unit	$fill in the blank 2f7f63f8ef84fc9_5	$fill in the blank 2f7f63f8ef84fc9_6	$fill in the blank 2f7f63f8ef84fc9_7	$fill in the blank 2f7f63f8ef84fc9_8
Total variable expense	$fill in the blank 2f7f63f8ef84fc9_9	$fill in the blank 2f7f63f8ef84fc9_10	$fill in the blank 2f7f63f8ef84fc9_11	$fill in the blank 2f7f63f8ef84fc9_12
Fixed selling & administrative expense:
Salaries	$fill in the blank 2f7f63f8ef84fc9_13	$fill in the blank 2f7f63f8ef84fc9_14	$fill in the blank 2f7f63f8ef84fc9_15	$fill in the blank 2f7f63f8ef84fc9_16
Depreciation	fill in the blank 2f7f63f8ef84fc9_17	fill in the blank 2f7f63f8ef84fc9_18	fill in the blank 2f7f63f8ef84fc9_19	fill in the blank 2f7f63f8ef84fc9_20
Other	fill in the blank 2f7f63f8ef84fc9_21	fill in the blank 2f7f63f8ef84fc9_22	fill in the blank 2f7f63f8ef84fc9_23	fill in the blank 2f7f63f8ef84fc9_24
Total fixed expenses	$fill in the blank 2f7f63f8ef84fc9_25	$fill in the blank 2f7f63f8ef84fc9_26	$fill in the blank 2f7f63f8ef84fc9_27	$fill in the blank 2f7f63f8ef84fc9_28
Total selling & administrative expenses	$fill in the blank 2f7f63f8ef84fc9_29	$fill in the blank 2f7f63f8ef84fc9_30	$fill in the blank 2f7f63f8ef84fc9_31	$fill in the blank 2f7f63f8ef84fc9_32

Feedback

See Cornerstone 8.9.

7. Ending finished goods inventory budget. Round intermediate calculations to the nearest cent. Round your answers to the nearest cent, if required.

Unit cost computation:
Direct materials:
Part K298	$fill in the blank f2a792001044fed_1
Part C30	fill in the blank f2a792001044fed_2
Direct labor	fill in the blank f2a792001044fed_3
Overhead:
Variable	fill in the blank f2a792001044fed_4
Fixed	fill in the blank f2a792001044fed_5
Total unit cost	$fill in the blank f2a792001044fed_6
Number of units	fill in the blank f2a792001044fed_7
Finished goods	$fill in the blank f2a792001044fed_8

Feedback

See Cornerstone 8.6.

8. Cost of goods sold budget

Direct materials used
Part K298	$fill in the blank d165a50a707304d_1
Part C30	fill in the blank d165a50a707304d_2	$fill in the blank d165a50a707304d_3
Direct labor used		fill in the blank d165a50a707304d_4
Overhead		fill in the blank d165a50a707304d_5
Budgeted manufacturing costs		$fill in the blank d165a50a707304d_6
Add: Beginning finished goods		fill in the blank d165a50a707304d_7
Goods available for sale		$fill in the blank d165a50a707304d_8
Less: Ending finished goods		fill in the blank d165a50a707304d_9
Budgeted cost of goods sold		$fill in the blank d165a50a707304d_10

Feedback

See Cornerstone 8.7.

9. Budgeted income statement (ignore income taxes)

Sales	$fill in the blank 2ef9b7ffb06704f_1
Less: Cost of goods sold	fill in the blank 2ef9b7ffb06704f_2
Gross margin	$fill in the blank 2ef9b7ffb06704f_3
Less: Selling and administrative expense	fill in the blank 2ef9b7ffb06704f_4
Income before income taxes	$fill in the blank 2ef9b7ffb06704f_5

Feedback

See Cornerstone 8.10.

10. Cash budget Enter a negative balance as a negative amount, and if an amount is zero enter "0".

	January	February	March	Total
Beginning balance	$fill in the blank 10ef50099010054_1	$fill in the blank 10ef50099010054_2	$fill in the blank 10ef50099010054_3	$fill in the blank 10ef50099010054_4
Cash receipts	fill in the blank 10ef50099010054_5	fill in the blank 10ef50099010054_6	fill in the blank 10ef50099010054_7	fill in the blank 10ef50099010054_8
Total cash available	$fill in the blank 10ef50099010054_9	$fill in the blank 10ef50099010054_10	$fill in the blank 10ef50099010054_11	$fill in the blank 10ef50099010054_12
Disbursements:
Purchases	$fill in the blank 10ef50099010054_13	$fill in the blank 10ef50099010054_14	$fill in the blank 10ef50099010054_15	$fill in the blank 10ef50099010054_16
DL payroll	fill in the blank 10ef50099010054_17	fill in the blank 10ef50099010054_18	fill in the blank 10ef50099010054_19	fill in the blank 10ef50099010054_20
Overhead	fill in the blank 10ef50099010054_21	fill in the blank 10ef50099010054_22	fill in the blank 10ef50099010054_23	fill in the blank 10ef50099010054_24
Marketing & admin	fill in the blank 10ef50099010054_25	fill in the blank 10ef50099010054_26	fill in the blank 10ef50099010054_27	fill in the blank 10ef50099010054_28
Land		fill in the blank 10ef50099010054_29		fill in the blank 10ef50099010054_30
Total disbursements	$fill in the blank 10ef50099010054_31	$fill in the blank 10ef50099010054_32	$fill in the blank 10ef50099010054_33	$fill in the blank 10ef50099010054_34
Ending balance	$fill in the blank 10ef50099010054_35	$fill in the blank 10ef50099010054_36	$fill in the blank 10ef50099010054_37	$fill in the blank 10ef50099010054_38
Financing:
Borrowed/repaid	fill in the blank 10ef50099010054_39	fill in the blank 10ef50099010054_40	fill in the blank 10ef50099010054_41	fill in the blank 10ef50099010054_42
Interest paid	fill in the blank 10ef50099010054_43	fill in the blank 10ef50099010054_44	fill in the blank 10ef50099010054_45	fill in the blank 10ef50099010054_46
Ending cash balance	$fill in the blank 10ef50099010054_47	$fill in the blank 10ef50099010054_48	$fill in the blank 10ef50099010054_49	$fill in the blank 10ef50099010054_50