$($Do in excel format$)$

Question #$2$

Portable Camping Table Manufacturing Company accumulated the following budget data for the $2023$ year:

Sales: $12,900$ units, unit selling price $$275\mathrm{.}00$

Cost of one unit of finished goods: Direct materials $20$ feet at $$3\mathrm{.}75$ per foot, direct labor $3\mathrm{.}50$ hours at $$22\mathrm{.}00$ per hour, and manufacturing overhead $$3\mathrm{.}00$ per direct labor hour.

Selling and administrative expenses: $$33,790.$

Income taxes: $20\%$ of income before income taxes.

Required:

$($a$)$ Prepare a detailed schedule showing the computation of cost of goods sold for $2023.$

$($b$)$ Prepare a budgeted income statement in proper form for $2023.$