INPUT SECTION

SALES

$\backslash$table$[[$C$,$D$,$E$,$F$,$G$],[,$Beta Bicycles,,,$],[-,$Budget Project,,,$],[,$Spring $2025,,,],[,,,,],[4$th$,1$st$,2$nd$,3$rd$,4$th$],[$Quarter$,$Quarter,Quarter,Quarter,Quarter$],[2025,2026,2026,2026,2026],[41,000,49,600,34,500,31,000,43,000]]$

$10$

Budgeted Sales in units

$11$ Budgeted Selling Price

$12$

RECEIVABLES

Receivables Collection Schedule

$81\mathrm{.}50\%$ quarter of sale

$16\mathrm{.}00\%$ quarter following sale

$2\mathrm{.}50\%$ uncollectible

$100\mathrm{.}00\%$

$19$ Policy

INVENTORY COSTS

Direct Labor

PROJECT INFORMATION

Sales Budget

Production Budget

DM & DLB$$

Ready in Accessibility: InvestigatoINVENTORY ACCOUNTS

Finished Goods Inventory

Raw Materials Inventory

Planned Ending units on $12/31/2026$

$41,368$ pounds Policy

$25\mathrm{.}00\%$ of next quarters' needs for production is in ending Raw Materials Inventory

Work In Process Inventory

$\backslash$table$[[$Beginning value $\frac{1}{1}\frac{?}{2026},$$$,231,720],[$Planned Ending value on $\frac{12}{31}\frac{?}{2026},$$$,231,720]]$

Payment for Raw Materials

Payment Policy

$85\mathrm{.}00\%$ quarter of purchase

$15\mathrm{.}00\%$ quarter following purchase

OPERATING EXPENSES

Wages and Salaries Payment

PROJECT INFORMATION

Sales Budget

Production Budget

$DM$&DLBtOPERATING EXPENSES

Wages and Salaries Payment

$\backslash$table$[[$Payment Policy,,times monthly on the $15$th and $30$th$],[,$Fully paid each month,$],[,,,],[$Variable Selling & Administrative Exp.,$2\mathrm{.}50\%,$of selling price,,$],[,,,,],[$Fixed Selling & Administrative Exp,,,,$],[$Depreciation$,$$ $55,000,$per quarter,,$],[$Other Selling & Administrative Exp,$ $180,000,$per quarter,,$],[,$What would be the answers$/$formulas to these