Operating Budget, Comprehensive Analysis Sales budget

$\backslash$table$[[,$January,February,March,Total$],[$Units$],[$Unit selling price,,,,$],[$Sales$,,,,]]$

Production budget

$\backslash$table$[[,$January,February,March,Total$],[$Unit sales,,,,$],[$Desired ending inventory,,,,$],[$Total needed,,,,$],[$Less: Beginning inventory,,,,$],[$Units produced,,,,$]]$

Direct materials purchases budget

$\backslash$table$[[,$January,February,March,Total$],[,$Part K$298,$Part C$30,$Part K$298,$Part C$30,$Part K$298,$Part C$30,$Part K$298,$Part C$30],[$Units produced,,,,,,,,$],[$Dir$.$ mat. per unit,,,,,,,,$],[$Production needs,,,,,,,,$],[$Desired EI$,,,,,,,,],[$Total needed,,,,,,,,$],[$Less: BI$,,,,,,,,],[$Dir$.$ mat. to purchase,,,,,,,,$],[$Cost per unit,$,,$$$,,$$$,,,],[$Total purchase cost,,$$,$$$,,,,,]]$ Direct labor budget. Round your answers to two decimal places, if required.

Overhead budget. Round your answers to two decimal places, if required.

Selling and administrative expense budget. Round your answers to the nearest cent, if required. Ending finished goods inventory budget. Round intermediate calculations to the nearest cent. Round your answers to the nearest cent, if required.

Cost of goods sold budgetCash budget

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

$\backslash$table$[[,$January,February,March,Total$],[$Beginning balance,$$,$$$,$$$,],[$Cash receipts$],[\backslash$table$[[$Total cash$],[$available$]],$$$,$$$,$$$,],[$Disbursements:$],[$Purchases$,$$$,$$$,$$$,$$$],[$DL payroll$],[$Overhead$],[\backslash$table$[[],[$admin$]],,,,],[$Land$],[$Total disbursements,$$,$$$,$$$,$$$],[$Ending balance,$$,$$$,$$$,$$$],[$Financing:$],[$Borrowed$/$repaid$],[$Interest paid,,,,$],[$Ending cash balance,$$,$$$,$$$,$$$]]$

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

a$.$ Finished goods inventory on January $1$ is $900$ units. The desired ending inventory for each month is $20$ percent of the next month's sales.

b$.$ The data on materials used are as follows:

Direct Material Per$-$Unit Usage Unit Cost

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

c$.$ The direct labor used per unit of output is one and one$-$half hours. The average direct labor cost per hour is $$20.$

d$.$ Overhead each month is estimated using a flexible budget formula. $($Activity is measured in direct labor hours.$)$

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

f$.$ The unit selling price of the wiring harness assembly is $$110.$

g$.$ In February, the company plans to purchase land for future expansion. The land costs $$68,000.$

following month, as is the interest due. The interest rate is $12$ percent per annum.